Hibernate Community • View topic - Can hibernate be used for cross database transactions?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Can hibernate be used for cross database transactions?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

sridharrajup

Post subject: Can hibernate be used for cross database transactions?

Posted: Thu Mar 23, 2006 5:54 pm

Newbie

Joined: Wed Oct 12, 2005 11:16 am
Posts: 13

Hi

We are using hibernate2, spring framework, java, oracle10g and tomcat in our application. We want to move some of the tables to SQLServer 2005. So there would be tables related/associated to one another in both oracle and sql server.

Can I use hibernate in this scenario to maintain persistence and transactions across two different databases? If so, please let me know how?

Thanks for any suggestions in advance.

Sri

Top

david

Post subject:

Posted: Thu Mar 23, 2006 6:42 pm

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

HIbernate uses the transaction environment you have setup. So if you are using an XA datasource (in this case two XA db datasources) then both datasources will be managed by the single Transaction.

Top

sridharrajup

Post subject:

Posted: Thu Mar 23, 2006 7:16 pm

Newbie

Joined: Wed Oct 12, 2005 11:16 am
Posts: 13

David

Thank you for your quick response.

Sri

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum