hello,

i wanna make a research about 'Integration of Heterogeneous Databases
based on Hibernate' ,but i just have only a little information about it ,do you guys have any ideas or information about this topic?

we can share our knowledge and information ,

Thanks a lot

I do. I use the spring framework to solve this. For every database I create a separate DataSource + SessionFactory. Spring enables you to connect these to your business objects in a transparent way.

If you are not using Spring, but any J2EE server, a solution will be to create a SessionFactory for each Data Source and store it in JNDI.

Each time you do a request to the database, you retrieve the SessionFactory object from JNDI.

A thing you must note is that you cannot share the same mapping for 2 sessions factories. So you cannot make any HQL linking 2 Heterogeneous databases. (Same thing as in JDBC.)

Etienne.