XA JTA transactions fails when using 2 JTDS datasources connecting to the same MS SQL server

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In