Error connecting to mssql XA Data Source

[mdavid0129]

I am using JBOSS 3.2.1.

I have a system that is successfully using a local transaction data source to an mssql database.

I need to create an XA datasource because I need better transaction control.

I created the datasource and it deploys. When my test code tries to establish a connection, I get the following exception:

2003-12-08 09:50:31,414 INFO [STDOUT] Caught SQL exception: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.))
2003-12-08 09:50:31,414 INFO [STDOUT] Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.))


Any ideas about the cause of this would be greatly appreciated.

Thanks,

Mike David

[ericmolitor]

Sounds like you're using the Microsoft JDBC driver for SQL Server 2000 which requires you to load an extended stored procedure before using XA Datasources.

From the READ.ME

"If you want to use JDBC distributed transactions through JTA, you must
install JDBC XA Procedures. See "SQL Server 2000 Driver for JDBC," in
the SQL SERVER 2000 DRIVER FOR JDBC USER'S GUIDE AND REFERENCE for details."

Also sugest you take a look at microsofts site and grab SP2 of the driver and read the docs on XAConnection.recover().

Cheers,
Eric