"SQLServerException: The function START: failed. No transaction cookie was returned." in JBoss EAP
Issue
- Defined two XA datasource pools referencing a single (the same) database server endpoint (same URL/host/database and user/password)
- XA has been enabled in the database server
-
When both XA datasource pools are used in a single transaction, the SQL Server driver raises
... javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: The function START: failed. No transaction cookie was returned. at com.microsoft//com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:738) at com.microsoft//com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:772) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:263) ...
Environment
- Red Hat JBoss Enterprise Application Platform (EAP) 7
- Microsoft SQL Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.