Hello,

In our production environment, we have 4 Postgre Database Servers totalling to around 80 databases.

On the Application Server side, we have 10 clustered Tomcat Application servers with multiple applications which can access any number of databases during each HTTP web request call. We use low level JDBC operations in our tomcat clustered applications.

We wish to migrate to Hibernate since we see many benefits and we have the following concerns / questions / doubts.

It would be crazy to create and load 80 Session objects on each of the clustered servers. Our applications keep changing and only certian hibernate classes /database structures need to be changed. It may not make sense to stop all the servers and restart them if only a few database structures / classes undergoes changes. Is there a JNDI "like" solution where all sessions can be loaded and saved in a central location from where we can get a Session do our operation and return the Session back?

Is there anyone who have similar deployments like ours who have taken more wiser paths to what I we are trying to do? :-)

Regards
Pat

Can someone please help us with my question. Please help!

Pat