Hibernate x different databases

leila.carvalho · **Joined:** Fri Nov 18, 2005 3:15 pm **Posts:** 2

Please, how can I make SELECT involving tables in different databases,
using Hibernate? Thanks!!

emylonas · **Joined:** Thu Aug 04, 2005 2:24 pm **Posts:** 45

Don't believe you can do that, once you can have only one hibernate.cfg.xml per application and only one connection per file...

gavin · **Posted:** Fri Nov 18, 2005 3:28 pm

leila.carvalho wrote:

Please, how can I make SELECT involving tables in different databases,
using Hibernate? Thanks!!

You can only do it if your database supports joins across catalogs (many do).

In which case simply map the classes specifying an explicit catalog name.

gavin · **Posted:** Fri Nov 18, 2005 3:29 pm

emylonas wrote:

Don't believe you can do that, once you can have only one hibernate.cfg.xml per application and only one connection per file...

You can have as many .cfg.xml files (and SessionFactory instances) as you like. But that it is not the solution to the problem.

leila.carvalho · **Joined:** Fri Nov 18, 2005 3:15 pm **Posts:** 2

"You can have as many .cfg.xml files (and SessionFactory instances) as you like. But that it is not the solution to the problem. "
--I know this HB´s feature, but it´s doesn´t solve my problem endeed.

"You can only do it if your database supports joins across catalogs (many do). In which case simply map the classes specifying an explicit catalog name. "
--Could you please be a bit more especific? Do you have a example?

Gracias !!