MSSQL2000 XaDatasource properties
noel.rocher Oct 31, 2002 12:46 PM
Hi all,
with the latest mssql2000 driver and jboss3.0.3-jetty
I configured my xa datasource as this :
============================
<config-property name="XADataSourceProperties" type="java.lang.String">ServerName=MY_IP_ADDRESS;PortNumber=MY_IP_PORT;selectMethod=cursor;ProgramName=JBoss;User=MY_USER;Password=MY_PASSWORD</config-property>
<config-property name="XADataSourceClass" type="java.lang.String">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</config-property>
<config-property name="UserName" type="java.lang.String">MY_USER</config-property>
<config-property name="Password" type="java.lang.String">MY_PASSWORD</config-property>
================================
note : I replaced values by capital letter dummies
When Datasource is created : no problems :
================================
17:31:08,554 INFO [MainDeployer] Starting deployment of package: file:/D:/java/jboss-3.0.3/server/default/deploy/mssql-xa-service.xml
17:31:08,754 WARN [ServiceController] jboss.jca:service=XATxDS,name=jdbc.mssql2000 does not implement any Service methods
17:31:08,794 INFO [JBossManagedConnectionPool] Creating
17:31:08,804 INFO [JBossManagedConnectionPool] Created
17:31:08,804 INFO [JBossManagedConnectionPool] Starting
17:31:08,804 INFO [JBossManagedConnectionPool] Started
=================================
When my EJB CMP2.0 are deployed I have this :
===================================
17:31:16,095 INFO [EjbModule] Starting
17:31:17,697 WARN [XAManagedConnectionFactory] No setter method for attribute selectMethod (value=cursor).
17:31:17,897 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=ejb20/directory/LocationType,service=EJB
org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (java.sql.SQLException: Unable to get Connection: javax.resource.ResourceException: Unable to create DB XAConnection: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]JTA is not support when selectMethod=direct. Switch to selectMethod=cursor.)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:67)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:103)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:397)
====================================
What do I missed ? Any idea ?
Thanks,
Noel