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

[javatwo]

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#4228145

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4228145