[jboss-user] [JCA/JBoss] - jboss5.0.1 multiple XA datasources: autocommit?

We have application working well in JBOSS 4.0.5GA. After moving to jboss 5.0.1GA, we have to use XA datasources. We setup three mysql XA datasources in our application using hiberhate. Each datasource has the following: <track-connection-by-tx>true</track-connection-by-tx> <new-connection-sql>set autocommit=1</new-connection-sql> <no-tx-separate-pools>true</no-tx-separate-pools> My question is: set automcommit=1, for performing a number of entity updates, are they in one transaction? for autocommit, mysql will commit each update immediately. If <new-connection-sql>set autocommit=1</new-connection-sql> is removed from datasource configuration, we will get the following error: MysqlXAException: XAER_OUTSIDE: Some work is done outside global transaction Thanks for help. Dave View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4228145#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...