Can hibernate support multiple data source?

gaokai · **Joined:** Fri Aug 29, 2003 11:15 am **Posts:** 5

Hi,

My project need to handle one oracle and one DB2, it is easy to config two data source in WAS, but I don't know how to config in hibernate, and does hibernate support this function?

Regards,
Gao Kai

gavin · **Posted:** Fri Aug 29, 2003 4:10 pm

just create two SessionFactorys.

gaokai · **Joined:** Fri Aug 29, 2003 11:15 am **Posts:** 5

So, how to handle the transaction between these two data source (SessionFactory)?

Regards,
Gao Kao

gavin · **Posted:** Sat Aug 30, 2003 12:33 am

It is you appservers responsibility to handle transactions accross two datasources. JTA does this.

foxding · **Joined:** Sun Aug 31, 2003 1:19 pm **Posts:** 3

hi gao kai:

Are you Chinese? Our team use hibernate in a big case, maybe we have the same problems concerned, welcome discuss with us. :)

vickeen · **Joined:** Fri Aug 29, 2003 3:58 am **Posts:** 4

I am Chinese too!

Welcome discuss !

E-MAIL,MSN:crpp88@hotmail.com

scesbron · **Joined:** Thu Sep 04, 2003 8:23 am **Posts:** 368

gavin wrote:

just create two SessionFactorys.

And is it possible to define links between objects managed by two different session factories ?

steve · **Posted:** Thu Sep 04, 2003 10:46 am

I don't think so...

Another option I have used before is to define links between the two databases in the database itself (assuming your database supports this). In Oracle this is called a DATABASE LINK, oddly enough. Sybase/SQLServer do support this, also, but I can't remember what they call it.