Any good Hibernate second level cache provider?

jaikiran · **Joined:** Wed Jul 27, 2005 2:33 am **Posts:** 118

Hi,
We have a J2EE application on JBoss-3.2.3 with Hibernate-2.1.3 deployed as a MBean. We have enabled second-level cache on the hibernate object and are using JBossCache1.2 for the same. The cache-usage is "transactional". Currently, we are facing a lot of issues in case of multi user scenario related to JBossCache(pessimistic locking issues).

So, can anyone suggest any other cache provider(that can be used as "transactional") that can be used with Hibernate, in production environment?

Thank you.

emmanuel · **Posted:** Wed Jan 04, 2006 11:54 am

JBossCache and Hibernate integration has been enhanced in Hibernate 3(.1). Did you give it a try?

jaikiran · **Joined:** Wed Jul 27, 2005 2:33 am **Posts:** 118

I havent tried it out with Hibernate3. Our current requirements force us to stick to Hibernate2.1.3. JBossCache seems to work fine in a single user scenario, but when it comes to multiple user access(which is the case when the application goes into production) we are encountering a lot of issues, mainly related to cache locking

jaikiran · **Joined:** Wed Jul 27, 2005 2:33 am **Posts:** 118

Also, the application works fine in case of multi user, if i disable the second level cache(obviously, the application gets slower, though). So its not that there is some problem with the application or the way Hibernate is used in the application. Only when we enable the second level cache we start facing these issues. Disabling the second level cache also does not seem to be a option for us currently, as per the requirements.

emmanuel · **Posted:** Thu Jan 05, 2006 5:59 am

Yes but the caching strategy has been enhanced in H3 to better support pessimist clustered Tx cache

jaikiran · **Joined:** Wed Jul 27, 2005 2:33 am **Posts:** 118

Thanks. Will try that out.