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

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.