Hi,

what is the standard practice when working with two or more databases? I am reading the documentation but working with more than one database is more of a footnote than a center topic in the hibernate referance.

My question is how do you deal "cleanly" with multiple databases, I am very satisfied with the DAO approach found here
http://www.hibernate.org/328.html are there any examples for multiple databases?

The problem is this there will be some entities in our HRM database and some entities in the Finance database but the application need to use both of this resources, does that mean I will have to have seperate HibernateUtils? Seperate DAOFactories? There will be then 2 distinct sessions(one for HRM Database and one for Finance)?

the getCurrentSession() of the HRM SessionFactory will not interfiere with getCurrentSession() of the Finance SessionFactory?

You would certainly need 2 sessions, and thus 2 config files.

You'd likely also have to do some magic of your own to map records in one database to records in the other (if needed) as there'd be no database entity storing those relationships.

I am new to hibernate and Spring. I have worked with multiple databases using two hibernate.cfg.xml and writing two separate methods to get the session factory object for the different database. Is it the wright way? Or is there any better way of doing this? If you'll need to do different joins between these two databases then I would go for a more permanent solution.