1 Reply Latest reply on Dec 13, 2003 3:03 PM by Eric Molitor

    Error connecting to mssql XA Data Source

    mdavid0129 Newbie

      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

        • 1. Re: Error connecting to mssql XA Data Source
          Eric Molitor Newbie

          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