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

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content