Hello,

We have sucessfully integrated hibernate into our project. Now the expectation is for hibernate to work in a clustered environment.

Being a early bird in enterprise java development using hibernate, there were a few questions that ran in my mind on the issues / questions that i might have to relook into:

1: In each clustered environment, it may not make sense to create a new connection pool everytime, as this will lead to degradation of database performance.

In such a case, is there a way by which we can create a clustered connection pool of say 25 connections, for all instances of hibernate running to access, instead of 4 clusters creating 25 connections each which will effectively mean 100 connections to the database?

Would this mean I need to look at something like a JNDI based connection pooling? Any suggestions and guidance would be of great help.

2: Can anyone share their experiences on how has 2nd level caching that supports clustering like JBossCache / EHCache etc worked? Are there anything that I need to consider in addition to the hibernate documentation.

Anything other to what I have mentioned needs to be considered?

Thanks in advance
Gyanesh

Can someone please guide us with the last question? It would be much appriciated.

Gyanesh & Rahul