Mapping multiple database with Hibernate

asked 2011-10-02 08:19:04 +0800

Hi all!
I wrote a workaround to map multiple database with hibernate.
My modified HibernateUtil class uses a map to store all the SessionFactories, using the hibernate configuration filename as key.
The hibernate configuration filenames are set in zk.xml, as follows:

	
<preference>
 	<name>HibernateUtil.config</name>
 	<value>hibernate.cfg.xml,other.cfg.xml</value>
 </preference>

My HibernateUtil.currentSession() get the hibernate session related to first hibernate configuration file, and I provide a new HibernateUtil.currentSession(String configFile) method that gets an hibernate session related to the hibernate configuration filename "configFile".
For example, to get a session related to other.cfg.xml in the example above, you have to code something like this:

HibernateUtil.currentSession("other.cfg.xml");

Sources are here: org.alessi.zk.hibernate.zip and contains a modified version of:

HibernateSessionFactoryListener
HibernateUtil
OpenSessionInViewListener

All seems to work fine for me.

Any suggestion? Can you test it?

delete flag offensive retag edit

7 Replies

Sort by » oldest newest

answered 2012-11-14 18:26:31 +0800

gaucho
6

Hi nikoligno,

Thanks! I will try it and I will let you know.

Cheers,

Luis

link publish delete flag offensive edit

answered 2012-11-15 17:05:29 +0800

gaucho
6

Hi nikoligno,

It works! Clean and simple, thank you very much!

Cheers,

Luis

link publish delete flag offensive edit

answered 2014-11-03 12:04:06 +0800

KeithK
15

Hi, Firstly, my apologies for posting on an old thread, but I have just been asked to add exactly this functionality to an existing application. The link in the above post is now out of date so can I ask if anyone has the sources provided could they please post a new link or maybe send them to me.

Many thanks, Keith