Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0

Are there any examples on how to query against multiple databases?


Thank you

Each database has different SessionFactory configured.

DB1 - SF1
DB2 - SF2

SF1.getCurrenSession().createQuery(...)

SF2.getCurrenSession().createQuery(...)

If you need transaction support plan to use JTA

Pls rate if you are satisfied with the answer!

^ i'm pretty sure that's not what he's trying to do. i think he wants to write one query and do selects from different databases in the same statement.

i had to do this once, the solution i came up with was to make another database containing only views on the tables from the 3 other databases that i needed. that way i could do some pretty powerful queries.

I was going on the same path as you suggested. What is still troubling me is that our database is not normalized at all. Doing an insert or update may require updating different tables possibly in different datasource. How would you handle this?

Thanks