Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
2.1.6

Name and version of the database you are using:
Oracle 9i

Hi,
This is concerning a web application that is internationalized running on WAS 5.1.
We have a case where the database for specific locales are different.
We intend to pick up the jndi lookup name configured for each database dynamically depending on the locale of the user.

The jndi lookup name is now configured in the hibernate.cfg.xml
as <property name="connection.datasource">jdbc/A_JNDI</property>.

Is there a way to override the jndi lookup after hibernate configuration and after the sessionfactory is loaded?

Any help would be appreciated.

Thnx,
Sunil

Ai! You want to dynamically switch the database Hibernate is using based on user locales?! That is, to put it mildly, not scalable beyond 1 user.

A far better solution would be to run different app servers, each on those localized databases, and have Apache direct the user to the correct one based on locale. Or better yet, come up with a better solution for i18n than duplicating your database.

No. You can dynamically change the Configuration, but you have to recreate the session factory.

HTH
Ernst

I am not sure but does Configuration allows to change the database settings at runtime?

Yes it does. But as I've written in the previous post you have to recreate the session factory in order this is taken into effect.

HTH
Ernst