Multiple sessions for multiple datasources in JBoss?

[gan.gary]

I have a Jboss apps that need to save to 2 databases. It works OK for Hibernate:

If using either one is ok, but use both I will hit error:

2008-06-17 17:21:19,429 WARN [com.arjuna.ats.jta.logging.loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror] [com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror] TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_PROTO for < 131075, 26, 24, 1-acc550a:1308:485781ef:7dacc550a:1308:485781ef:85
2008-06-17 17:21:19,429 ERROR [STDERR] org.jboss.resource.connectionmanager.JBossLocalXAException: Trying to start a new tx when old is not complete! old: < 131075, 26, 24, 1-acc550a:1308:485781ef:40acc550a:1308:485781ef:49
2008-06-17 17:21:19,445 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:886)
2008-06-17 17:21:19,445 ERROR [STDERR] at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:776)

I looked at other forum , it mentioned :
JBoss TS, the new default transaction manager will not let you enlist multiple 1-phase participants in the same transaction.
http://www.jpox.org/servlet/forum/printpost?post=26318

correct?

[jhalliday]

http://wiki.jboss.org/wiki/Multiple1PC

[gan.gary]

Thanks, do you know any simple Hello World example for these?

I found blur for the site you gave.

[marklittle]

Why do you need an example? Simply follow the instructions on the wiki.

[gan.gary]

Why do you need an example? Simply follow the instructions on the wiki.

Are you talking about this one?

In these situations we recommend one of the following approaches:


Wrap the resources in compensating transactions. See the Web Services transactions guides for further details.
Migrate the legacy implementations to two-phase aware equivalents. For DataSources deployed on JBoss Application Server, this is as simple as changing from <local-tx-datasource> to <xa-datasource>. See ConfigDataSources for more information.
Refactor the code to use separate transactions. If you simply need to read from one DataSource and insert processed results into another, you may not want or need 2-phase commit (and thus the above optimization). In an EJB3 session bean, this can be accomplished by simply delegating the read to a separate method and annotating it with @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW). This causes the calling method's Transaction to suspend, wait for the read to complete, and resume.

[marklittle]

I refer to the URL Jonathan added.

[gan.gary]

Thanks. I found it. It's at: http://wiki.jboss.org/wiki/SetUpAMSSQLDatasource