Is XA mode mandatory to access a SQL Server database in read only
Issue
- Is XA mode mandatory to access a SQL Server database in read only ?
server.logentry 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 injboss-as-datasources_1_0.xsdjboss-as-datasources_1_1.xsdjboss-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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
