2 Replies Latest reply on Jun 3, 2015 10:45 PM by jaikiran pai

    xa-datasource and

    D P Apprentice

      While converting existing standalone.xml data sources to xa-datasource I am getting following exception,

       

      2015-06-02 13:16:22,131 WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (MSC service thread 1-16) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@44b5f55e[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2bb9603f connection handles=0 lastUse=1433265382084 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@289d5048 mcp=SemaphoreArrayListManagedConnectionPool@49a2f099[pool=NedssDS] xaResource=XAResourceWrapperImpl@143a0b20[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2bb9603f pad=false overrideRmValue=null productName=Microsoft SQL Server productVersion=12.00.2000 jndiName=java:jboss/datasources/NedssDataSource] txSync=null]: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_start'.

        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:631) [sqljdbc4.jar:]

        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:663) [sqljdbc4.jar:]

        at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)

       

      How to create xa-datasource in stanalone.xml so that it won't throw above exceptions.

       

      Thanks