Separate databases

breako · **Joined:** Mon Jul 24, 2006 8:43 am **Posts:** 160

Hi,
How is hibernate configured to talk to two different databases?
Suppose in my architecture I have some information in one database and some in another? and I can also have rel's going from one database to another?
and I also need transactions to cover updates to both at the same time?
how does hibernate support this?
Any links to relevant tutorials and advice would be appreciated.
Thanks

marlon · **Posted:** Wed Aug 16, 2006 7:26 am

breako wrote:

Hi,
How is hibernate configured to talk to two different databases?

hi,

IMHO it is necessary to create one sessionfactory for each database

breako wrote:

Suppose in my architecture I have some information in one database and some in another? and I can also have rel's going from one database to another?

do you mean the hole relation ? in your application you handle with objects. so where is the problem to load the objects from a database and save/move it to another db.

breako wrote:

and I also need transactions to cover updates to both at the same time?
how does hibernate support this?

the magic word is two phase commitment.

regards

marlon