Hi,

How do you get instances of SessionFactory's that are associated to different datasources?

I see how you can give a SessionFactory a JNDI name. Then you could have multiple <session-factory> elements in your hibernate.cfg.xml, one for each datasource.

However, in this specific scenario I'm using TomCat which has a read-only InitialContext.

Is there another commonly used method for being able to get SessionFactory instances for different datasources?

By the way, I did read about one way using custom ResourceFactorys in TomCat. But this seemed overly complicated for what you would think is a very common scenario. I'm looking for any alternatives.

thanks,
matt

You need multiple hibernate.cfg.xml files and load them accordingly, one .xml can only have one <session-factory>.

The "Usual Solution" at http://www.hibernate.org/114.html should be what you want, add some Factory Pattern magic on top or have a look at the Spring framwork. It is not neccessary to use a complicated design for this stuff, you just need some kind of Registry. You can also try the filesystem-based JNDI context from Sun.