XA JTA transactions fails when using 2 JTDS datasources connecting to the same MS SQL server
Issue
- XA JTA transactions fails when using 2 JTDS datasources connecting to the same MS SQL server
- Using JTDS, Fuse fails to connect to 2 MS SQL datasources that use the same server
transaction. - When use XA to 2 different datasources this exception happens:
| WARN | n(3)-10.10.21.17 | Transaction | 117 - org.apache.aries.transaction.manager - 1.0.1.redhat-610394 | Unable to enlist XAResource ..., errorCode: -5
javax.transaction.xa.XAException: XAER_INVAL: Invalid arguments were given....
net.sourceforge.jtds.jdbc.XASupport.xa_start(XASupport.java:198)
...
org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:197)
...
org.apache.aries.jpa.container.tx.impl.XADatasourceEnlistingWrapper.getConnection(XADatasourceEnlistingWrapper.java:74)
Environment
- Red Hat JBoss Fuse
- 6.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.