Is XA mode mandatory to access a SQL Server database in read only

Solution Unverified - Updated -

Issue

  • Is XA mode mandatory to access a SQL Server database in read only ?
  • server.log entry similar to
WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: The function RECOVER: failed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR 
  • do we have to enable XA mode on SQL Server?

Environment

  • Red Hat JBoss Data Virtualization 6.3.6
  • <xa-datasource/> as defined in
    • jboss-as-datasources_1_0.xsd
    • jboss-as-datasources_1_1.xsd
    • jboss-as-datasources_1_2.xsd

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In