sql 2000 + jboss 3.0
tlin5043 Aug 26, 2004 10:27 AM
--------------------------------------------------------------------------------
1, index.jsp
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:/ testdb ");
Connection con = ds.getConnection();
String sql = "select top 5 * from tbnewsphoto ";
2, mssql-xa-service.xml
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
MSSQLXaDS
<!--real attributes-->
<config-property name="XADataSourceProperties" type="java.lang.String">ServerName= localhost ;DatabaseName= MyData ;SelectMethod=cursor</config-property>
<config-property name="XADataSourceClass" type="java.lang.String">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</config-property>
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter
3, mssql-service.xml
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
testdb
<config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver:// localhost :1433;DatabaseName= MyData </config-property>
<config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
<!--set these only if you want only default logins, not through JAAS-->
<config-property name="UserName" type="java.lang.String"> sa </config-property>
<config-property name="Password" type="java.lang.String"></config-property>
4. when i run jboss 3.0
Incompletely deployed packages:
[org.jboss.deployment.DeploymentInfo@e978ec45 { url=file:/C:/JBOSS/server/defaul
t/deploy/mssql-service.xml }
deployer: org.jboss.deployment.SARDeployer@fe748f
status: null
state: FAILED
watch: file:/C:/JBOSS/server/default/deploy/mssql-service.xml
lastDeployed: 1093518248968
lastModified: 1093518248921
mbeans:
, org.jboss.deployment.DeploymentInfo@514fbd09 { url=file:/C:/JBOSS/server/defau
lt/deploy/mssql-xa-service.xml }
deployer: org.jboss.deployment.SARDeployer@fe748f
status: null
state: FAILED
watch: file:/C:/JBOSS/server/default/deploy/mssql-xa-service.xml
lastDeployed: 1093518249046
lastModified: 1093518249031
mbeans:
]MBeans waiting for classes:
MBeans waiting for other MBeans:
19:04:11,765 INFO [URLDeploymentScanner] Started
19:04:11,765 INFO [MainDeployer] Deployed package: file:/C:/JBOSS/server/defaul
t/conf/jboss-service.xml
19:04:11,765 INFO [Server] JBoss (MX MicroKernel) [3.0.8 (CVSTag=JBoss_3_0_8 Da
te=200306050849)] Started in 0m:8s:719ms
5, browser looks like this
HTTP ERROR: 500 testdb not bound