I had several problems with XA, namely:
1. JDBC commit() calls failed with 'use XA commit instead' exceptions in Oracle 9i
OCI drivers.
2. After clicking around in a few apps we would get (cannot remember the exact message)
'unable to reuse connection, transaction outstanding' on a pooled connection.
None of these problems occur in in 4.0.5 (or modified 4.2.0) when using local
transactions. The code base is clean: we never get JBoss 'cleanup your
connections' messages, bespoke commt()/rollback() are always called in
'finally' blocks and we use the plain JDBC API for things - plus much of this code
has been running OK since JBoss 3.
After googling etc I came across a JBoss forum post that indicated that the JBossTS
transaction service only supports one local-x datasource. Trying to confirm this has been
difficult so I have assumed it is true and have disabled JBossTS.
Dave
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4049588#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...