I'm nearing the end of four days trying to get XA transactions to
work. It's a complicated soup of technologies that have to come
together. I'm using the following.
* JBoss 4.0.5
* Spring 2.0.2
* iBATIS 2.3.0
* Abator 1.0.0 (generates Spring DAOs for iBATIS)
* Oracle 9i and the i-net GATE JDBC driver
* SQL Server 2000 and the JTDS 1.2 JDBC driver
There are just too many parts to get straight!
* spring-beans.xml
* oracle-ds.xml
* sqlserver-ds.xml
* an Abator configuration file for each database
* an iBATIS SqlMapConfig.xml file for each database
* jboss-web.xml
Due to all the variables in tool selection, it's really difficult to
find an example on the web that matches your specific situation.
My code runs fine, but when I purposely throw a RuntimeException to
force a database rollback, it doesn't rollback. The acts as though
it's configured to do an autocommit after every database operation.
I think what I need to see is examples of configuring XA datasources
in JBoss for
* Oracle using the i-net GATE JDBC driver
* SQL Server using the JTDS JDBC driver
I'd really appreciated it if someone could email those to me.
