Connecting Multiple database using Hibernate

[Pushkal Sharma]

I am making insurance management system and i am using struts and hibernate capabilities but I am facing a problem with connecting multiple database using hibernate in myeclipse.Can anybody tell me how to connect multiple database using hibernate?Please


Thanks in advance!!

[Cameron Wallace McKenzie]

Howdy Greenhorn!

You can set up multiple session factories and give them a different hibernate config file. So, you might have hibernate_ora.xml and hibernate_db2.xml.

Then, each session will give a connection to a different database.

If more complex associations are needed, there is a Hibernate project called Shards that is designed just for this purpose. You can fine out more about it at hibernate.org.

-Cameron McKenzie