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 stackoverflow.com/q/9315593/366964, stackoverflow.com/q/5104185/366964 & stackoverflow.com/q/4292969/366964 — Nayan Wadekar
– Nayan Wadekar, Commented Mar 16, 2012 at 6:29

Shashank Kadne · Accepted Answer · 2012-03-16 06:37:47Z

0

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();

answered Mar 16, 2012 at 6:37

Shashank Kadne

8,1017 gold badges43 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect two or more databases dynamically

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related