XA deployment/recovery errors or warnings for an XA datasource pool using Microsoft SQL Server in JBoss EAP

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In