Transaction across different DBs

yxw84 Mar 27, 2006 5:48 PM

Is it possible to have JBoss transactions span across multiple databases? Here is the scenario:

Session Bean A is reading from database A.
Session Bean B reads/writes from database B, then calls a method from session bean A. If this method fails, what happens right now is that the changes to database B are permanent instead of being rolled back.

I'm not using manually demarcated transactions, relying instead on container support to handle all the transactions for me. What is a workaround for this problem?

I'm using JBoss 4.0.2 and EJB3 session/entity beans.

Please advise, thank you!

1. Re: Transaction across different DBs

yxw84 Mar 27, 2006 6:16 PM (in response to yxw84)

Update: I just noticed this warning -- "Prepare called on a local tx. Use of lo cal transactions on a jta transaction with more than one branch may result in in consistent data in some cases of failure."

What does it mean?
Actions
2. Re: Transaction across different DBs

sriramp_here Mar 30, 2006 7:10 AM (in response to yxw84)

Regarding your scenario, you have to use XA-transactions, as well as configure your datasource as XA datasource. Please have a look at jboss wiki for further inforamation.
Hope this helps,
Regards
Sriram.
Actions
3. Re: Transaction across different DBs

yxw84 Mar 30, 2006 3:29 PM (in response to yxw84)

It does, thank you for pointing me in the right direction!
Actions

Go to original post