hello,

has somebody an example using different database-schemes?
Is it necessary to create one hibernate.cfg.xml per scheme?
How do I handle the two different sessions?

Thank you for your help,
Nino

In case of postgres for example just type the name of the scheme before your table, eg.g scheme1.myTable, scheme2.mytable.
Oracle should work same.

I use it on MySQL, it works just fine.

The way I do is with several singletons that have a sessionfactory configured with the correct schema and O/R mapping classes on each.

I handle the two different sessions independently of eachother by having

public final ThreadLocal<Session> currentSessionHolder = new ThreadLocal<Session>();

defined in each of the singletons.

Since I use Spring to manage my singletons, I use an init() and cleanup() method to configure and close open sessions.

For http request cycle handling I register the singletons as ApplicationListeners and implement

public void onApplicationEvent(ApplicationEvent event) {
if (event instanceof RequestHandledEvent) {
closeCurrentSessionIgnore();
}
}

Voila, sessions are closed after servlets have handled the requests(provided I configure the proper servletfilter).

Henrik

Thanks for your answer.

Is it possible for you to post the code-snippet of your configuration?
You configure the session directly in your code, not in the hibernate.cfg.xml?

Thank you!