One transaction cover two connections databases different

Alejandro77 · **Joined:** Sun Sep 07, 2008 12:39 pm **Posts:** 3

Good morning.
I have two databases.
First delete records of a table of the first database and after, these records deleted, i want insert it in a table of the second database.
I need these two operations are handled by a single transaction, because if a error occurs, i want to do a rollback over those two databases.
At first, i had a session and a transaction for the first database and another session and transaction for the second database. Then, i opened the two transactions simultaneously, but the operations worked bad. Maybe you can not open two transactions simultaneously:

Code:

Session session1 = HibernateUtil.getSession1();
Transaction tx1 = session1.beginTransaction();
Session session2 = HibernateUtil.getSession2();
Transaction tx2 = session2.beginTransaction();
.....
.....
operations....
.....
.....

Can anyone help me?

Sounie · **Posted:** Sun Feb 22, 2009 3:53 pm

Have you considered using JTA for managing the transactions?

--
Stephen Souness

Alejandro77 · **Joined:** Sun Sep 07, 2008 12:39 pm **Posts:** 3

Can not hibernate handle it alone?

littypreethkr · **Posted:** Mon Feb 23, 2009 2:23 am

I did a google on this and what I could find is that Hibernate's transaction API is for single DB. But if you want cross-DB transaction you can plug-in JTA to hibernate.

Alejandro77 · **Joined:** Sun Sep 07, 2008 12:39 pm **Posts:** 3

Is there something that explains how to do that?

littypreethkr · **Posted:** Mon Feb 23, 2009 9:49 am

May be this will help you in making hibernate to use JTA transactions instead of its native transaction api:
http://www.hibernate.org/42.html

If you search the web u ll find tutorials on JTA for JTA how to.