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
Environment
- Red Hat Enterprise Application Platform (EAP) 5.2.0
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.
