[jbosscache-dev] READ_COMMITTED should be enforced for Hibernate 2nd level caching?

[Jason T. Greene]

Manik Surtani wrote:
> Have a look at this thread:
> 
> http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4218569 
> <http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4218569>
> 
> Does it make sense to enforce READ_COMMITTED for the Hibernate 2nd Level 
> Cache provider for JBC3, if MVCC is used?

I would agree that REPEATABLE_READ does not make sense for a second 
level cache.

However, this sounds like a problem with PFER. If someone calls PFER, I 
think the original transaction should resync the node snapshot. In other 
words, the application has already attempted to write a new value (in 
the same thread and source tx even), so RR isolation is not only 
unnecessary, it is inconsistent with expectations.

-- 
Jason T. Greene
JBoss, a division of Red Hat