Wednesday, April 11, 2012

Spring JPA Hibernate: Support for custom Isolation Level

While working on deadlock issues in our application, i figured that we need to set custom isolation levels on transactions to avoid the deadlocks. Every thing was good until I encountered a weird behavior of Spring JPA dialect.The story in short is, JPA does not support the custom isolation level for individual transactions. So if you want to set isolation level of transactions individually in @Transactions you get the error from Spring saying:

"Standard JPA does not support custom isolation levels - use a special JpaDialect for your JPA implementation"

The full exception message would look something like:

org.springframework.transaction.InvalidIsolationLevelException: Standard JPA does not support custom isolation levels - use a special JpaDialect for your JPA implementation
 at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(
 at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(
 at org.springframework.orm.jpa.JpaTransactionManager.doBegin(
 at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(

I googled the problem and found the workaround to this problem here on Stackoverflow and on the Amit's Tech Blog but neither of them account for the cleanup stuff.

Then i delve into the sources of spring and HibernateJpaTemplate to look for the proper cleanup strategy and come up with the solution for cleanup stuff.

Following are the steps to acheive the Custom transaction level support in your application:

  1. Annotate the @Transactional with isolation level you wish to go for i.e. @Transactional(isolation=Isolation.READ_COMMITTED)
  2. Write custom JpaDialect to plugin the transaction's isolation level glue code
  3. Integrate/Inject the custom JpaDialect into the EntityManager using spring context configuration of you application.
Code listing 1: Annotate with custom isolation level
 public void customIsolationTransaction(){"Do something use full") ;

Code listing 2: Customized JpaDialect implementation to support the transaction isolation levels
package com.smughal.spring.orm.jpa;

import java.sql.Connection;
import java.sql.SQLException;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceException;

import org.hibernate.Session;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.jdbc.datasource.DataSourceUtils;
import org.springframework.orm.jpa.vendor.HibernateJpaDialect;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionException;

public class IsolationSupportHibernateJpaDialect extends HibernateJpaDialect {

 private Logger logger = LoggerFactory.getLogger(IsolationSupportHibernateJpaDialect.class);

  * This method is overridden to set custom isolation levels on the
  * connection
  * @param entityManager
  * @param definition
  * @return
  * @throws PersistenceException
  * @throws SQLException
  * @throws TransactionException
 public Object beginTransaction(final EntityManager entityManager, final TransactionDefinition definition) throws PersistenceException, SQLException, TransactionException {
  boolean infoEnabled = false ;
  boolean debugEnabled = false ;
  Session session = (Session) entityManager.getDelegate();
  if (definition.getTimeout() != TransactionDefinition.TIMEOUT_DEFAULT) {

  Connection connection = session.connection();
  infoEnabled = logger.isInfoEnabled() ;
  debugEnabled = logger.isDebugEnabled() ;
  if(infoEnabled){"Connection Info: isolationlevel={} , instance={} ", connection.getTransactionIsolation() , connection);"Transaction Info: IsolationLevel={} , PropagationBehavior={} , Timeout={} , Name={}", new Object[]{definition.getIsolationLevel() ,definition.getPropagationBehavior() , definition.getTimeout() , definition.getName()});
   logger.debug("The isolation level of the connection is {} and the isolation level set on the transaction is {}", connection.getTransactionIsolation(), definition.getIsolationLevel());
  Integer previousIsolationLevel = DataSourceUtils.prepareConnectionForTransaction(connection, definition);
  if(infoEnabled){"The previousIsolationLevel {}", previousIsolationLevel);

   logger.debug("Transaction started");

  Object transactionDataFromHibernateJpaTemplate = prepareTransaction(entityManager, definition.isReadOnly(), definition.getName());
  return new IsolationSupportSessionTransactionData(transactionDataFromHibernateJpaTemplate, previousIsolationLevel ,connection) ;

 /* (non-Javadoc)
  * @see org.springframework.orm.jpa.vendor.HibernateJpaDialect#cleanupTransaction(java.lang.Object)
 public void cleanupTransaction(Object transactionData) {
  super.cleanupTransaction(((IsolationSupportSessionTransactionData) transactionData).getSessionTransactionDataFromHibernateTemplate());
  ((IsolationSupportSessionTransactionData) transactionData).resetIsolationLevel() ;
 private static class IsolationSupportSessionTransactionData {

  private final Object sessionTransactionDataFromHibernateJpaTemplate;
  private final Integer previousIsolationLevel;
  private final Connection connection;

  public IsolationSupportSessionTransactionData(Object sessionTransactionDataFromHibernateJpaTemplate, Integer previousIsolationLevel , Connection connection) {
   this.sessionTransactionDataFromHibernateJpaTemplate = sessionTransactionDataFromHibernateJpaTemplate;
   this.previousIsolationLevel = previousIsolationLevel;
   this.connection = connection ;

  public void resetIsolationLevel() {
   if (this.previousIsolationLevel != null) {
    DataSourceUtils.resetConnectionAfterTransaction(connection, previousIsolationLevel) ;
  public Object getSessionTransactionDataFromHibernateTemplate(){
   return this.sessionTransactionDataFromHibernateJpaTemplate ;


Here i would like to highlight the cleanup stuff that I introduced to gracefully restore the connection isolation level that was actually when we received it.

In beginTransaction method before returning store the connection and the previous isolation level in the same way as it is done in the super class i.e. HibernateJpaTemplate the only difference is, it's  a wrapper over HibernateJpaTemplate transaction's data in to our own class that cares for both the hibernate transaction data plus the connection and isolation level.

Finally in cleanupTransaction I simply call the super to do the cleanup stuff required by HibarnateJpaDialect and then reset the connection isolation level.

As we are using the hibernate and doWork(Work work) came in hibernate 3.3 so I have used the session.connection()instead.

Code listing 3: EntityManager integration using spring configuration.