Transaction exception XAER_RMERR, same code works in BEA

[aarti]

I am using Jboss 3.04 and MSSQL server. I get the following exception when I execute two updates in different methods in the same transaction. The same code however works with BEA Weblogic 8.1

make a connection
execute update
make another connection in new method
execute update


When I execute two updates in the same method through one connection. everything works fine.

21:47:16,711 WARN [tm.TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=XXXXX//21,
BranchQual=] errorCode=XAER_RMERR
javax.transaction.xa.XAException: [XXX][SQLServer JDBC Driver][SQLServer]xa_start (240000) retu
rns -8

[davidjencks]

I recommend using 3.0.7 or 3.2 with xa jdbc drivers. In these versions you can use the track-connections-by-tx flag to make sure all work in one transaction on one resource manager uses the same connection. I think this will solve the problem.

[aarti]

Where do I set this flag?

[davidjencks]

Here's a snip from the oracle xa example:

<xa-datasource>
<jndi-name>XAOracleDS</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
...

[aarti]

I am using 3.07 with the ...-service.xml files. Is this attribute available in 3.07.

I also found another user who seems to have similar code http://www.mail-archive.com/jboss-user%40lists.sourceforge.net/msg28606.html and is getting messages about open connections. My code also has nested queries. I am using JDBC XA drivers from data direct , Microsoft DTC and SQLServer.

[aarti]

I am using 3.07 with the ...-service.xml files. Is this attribute available in 3.07.

I also found another user who seems to have similar code http://www.mail-archive.com/jboss-user%40lists.sourceforge.net/msg28606.html and is getting messages about open connections. My code also has nested queries. I am using JDBC XA drivers from data direct , Microsoft DTC and SQLServer.

[aarti]

I am using 3.07 with the ...-service.xml files. Is this attribute available in 3.07.

I also found another user who seems to have similar code http://www.mail-archive.com/jboss-user%40lists.sourceforge.net/msg28606.html and is getting messages about open connections. My code also has nested queries. I am using JDBC XA drivers from data direct , Microsoft DTC and SQLServer.