XA deployment/recovery errors or warnings for an XA datasource pool using Microsoft SQL Server in JBoss EAP
Issue
- Encountering errors/warnings similar to those below during deployment or XA recovery (on the Periodic Recovery thread). Example:
... javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: "Could not find stored procedure 'master..xp_sqljdbc_xa_init_ex'.", XAException.XAER_RMERR
- Or this warn:
... WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_recover'.
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:647)
- When adding a Microsoft MSSQL Server database, the following error is appearing in the log:
com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_start'
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 5
- 6
- 7
- Microsoft SQL Server
- XA Datasource
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.