Hibernate using multiple databases

hibernate spring multiple-databases
newbie picture newbie · Oct 25, 2010 · Viewed 7.6k times · Source

I need to have multiple databases for different customers. How can I handle multiple databases with Hibernate? Are there any good examples how to do this?

I could create Configuration object and then build SessionFactory, but that would create always a new session factory which wouldn't be very wise.

EDIT:

Now I can get hibernate Configuration object when user logs in, but how can I create/get session factory with that object so that there would be only one session factory for one database (of course if multiple databases are used at the same time, then there can be more than one session factory)?

Answer

Bhushan picture Bhushan · May 12, 2011

I had the same problem. I solved it like this:

First of all, there should be different cfg.xml files for different databases. Then simply use Configuration object of the Hibernate whenever you want to connect to your second database. 

Configuration config = new Configuration().configure("<complete path to your cfg.xml file>");
SessionFactory sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
session.beginTransaction();

I found this here : http://www.coderanch.com/t/468821/ORM/java/If-hibernate-cfg-xml-has

I am pretty sure that this can be extended to more than 2 databases. Hope this helps.

Related questions

Spring: HibernateTransactionManager handling multiple datasources

In the following piece of code (Spring 3): @Transactional("txManager") public class DaoHolder { @Transactional(value="txManager", readOnly=false, propagation=Propagation.REQUIRES_NEW, rollbackFor={Exception.class}) private void runTransactionalMethod() throws Exception { dao1.insertRow(); dao2.insertRow(); //throw new Exception(); } //... } dao1 uses a session …

Read More
Spring + Hibernate + JPA + multiple databases

I have a Spring + Hibernate + JPA app. The user, when logging in, can choose from a list of DB's to connect to (these are the requirements). All the DB's have the same schema, so the same entities and DAO's will …

Read More
How to solve the “failed to lazily initialize a collection of role” Hibernate exception

I have this problem: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: mvc3.model.Topic.comments, no session or session was closed Here is the model: @Entity @Table(name = "T_TOPIC") public class Topic { @Id @GeneratedValue(strategy=…

Read More