2 Replies Latest reply on Apr 3, 2007 11:06 AM by youngm

    JBossCache Transaction Isolation Level

    youngm

      I'm using hibernate with a database at READ_COMMITTED isolation level. Does anyone see a problem with using JBossCache PESSIMISTIC at READ_COMMITTED with hibernate? Is there a particular reason why REPEATABLE_READ is the default isolation level?

      Mike

        • 1. Re: JBossCache Transaction Isolation Level
          manik

          Depending on how your application is written, READ_COMMITTED does make sense when used with Hibernate. Assuming that your DB uses R_C as well, I suspect your app won't have any issues with the cache running with an isolation level of R_C. :-)

          REPEATABLE_READ is the cache default as it offers a stronger isolation level for a very small penalty if used in a read-mostly situation.

          • 2. Re: JBossCache Transaction Isolation Level
            youngm

            Thanks for the insight. Just wanted to make sure I wasn't missing anything.

            Mike