Oracle Requirements for XA in RAC Environment

Issue

• A WARN log statement that prevents an XA Transaction

<DATE> <TIME> WARN  [org.jboss.resource.connectionmanager.TxConnectionManager] (main) Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@7acd4643[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@3ac017b1 handles=0 lastUse=1386874442730 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@6994bab7 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@19538399 xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@3ac017b1 txSync=null]
oracle.jdbc.xa.OracleXAException
    at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
    at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
    at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)

• Enabling trace in Oracle driver gives more context

SEVERE [oracle.jdbc.driver] (main) 7907F614 Throwing SQLException: ORA-55712: XA transactions on RAC are not supported with GLOBAL_TXN_PROCESSES set to 0