Connect two or more databases dynamically

Question

I am using mysql as my datasource. Databases are created dynamically and the details saved in a main database table. A user can log in to the system and connect to any database. The requirement is to connect to any of this databases at application level using hibernate. At any one time we don't know the number or names of databases except fetch them from the main scheme and pass the value to create a new connection like this.

Connection conn=connectDatabase(db1);
Connection conn=connectDatabase(db2);

I know it can be done but I don't how. The problem is how to do this using hibernate.

Can refer http://stackoverflow.com/q/9315593/366964, http://stackoverflow.com/q/5104185/366964 & http://stackoverflow.com/q/4292969/366964 — Nayan Wadekar, Mar 16 '12 at 06:29

score 0 · Answer 1 · answered Mar 16 '12 at 06:37

You can use the jndi-naming look up in hibernate. Configure your database in server.xml of your Tomcat(may be)...

You can access it in code this way...

Context initialCntx = new InitialContext();
SessionFactory sessionFactory = (SessionFactory)initialCntx
     .lookup("java:comp/env/hibernate/SampleSessionFactory");
Session hibernateSess = sessionFactory.getCurrentSession();

Connect two or more databases dynamically

1 Answers1