Hibernate, Multi DB?

[JonAustin1905]

I've got a prototype app running, which management are very eager to deploy..

Which is unsurprising, as it tramples on the original version.

However it's using Spring/Hibernate, and the connection object is instatiated at server initialization, based on the settings in the Hibernate properties file.

In the prototype, it connects from the DEV platform, to the DEV DB.. All's well..

However when deployed, we log in from the QA platform, to a number of QA, or Production DB's..

Does anyone know how we can go about making this dynamic?

Thanks,

~ Jon

 

[byam]

You can have different SessionFactory instances, once for each database, created from different hibernate configuration file set with different database URL.

e.g.

SessionFactory sessionFactoryDB1 = new Configuration().configure("db1.cfg.xml").buildSessionFactory();

SessionFactory sessionFactoryDB2 = new Configuration().configure("db2.cfg.xml").buildSessionFactory();

SessionFactory sessionFactoryDB3 = new Configuration().configure("db3.cfg.xml").buildSessionFactory();

// etc.  use appropiate session factory for desire database.