No Hibernate Session bound to thread and configuration does not allow creation of non-transactional one here

Question

I am getting this exception when I call a DAO method which uses SessionFactory getCurrentSession     The DAO class is annotated with  Transactional and I also have  lt tx annotation-driven  gt  declared in the application context configuration file   I can call my DAO methods which perform HQL queries  but whenever I call a DAO method which first gets the Hibernate session then I run into this exception   SEVERE  Failed to save the object  org hibernate HibernateException  No Hibernate Session bound to thread  and configuration does not allow creation of non-transactional one here     at org springframework orm hibernate3 SpringSessionContext currentSession SpringSessionContext java 63      at org hibernate impl SessionFactoryImpl getCurrentSession SessionFactoryImpl java 622      at gov noaa ncdc cmb persistence dao GenericDaoHibernateImpl getCurrentSession GenericDaoHibernateImpl java 56      at gov noaa ncdc cmb persistence dao GenericDaoHibernateImpl saveOrUpdate GenericDaoHibernateImpl java 187    I have the following application context configuration file    lt  xml version  1 0  encoding  UTF-8   gt   lt beans xmlns  http   www springframework org schema beans         xmlns aop  http   www springframework org schema aop         xmlns flex  http   www springframework org schema flex         xmlns tx  http   www springframework org schema tx         xmlns xsi  http   www w3 org 2001 XMLSchema-instance         xsi schemaLocation  http   www springframework org schema beans                            http   www springframework org schema beans spring-beans-2 5 xsd                            http   www springframework org schema flex                            http   www springframework org schema flex spring-flex-1 0 xsd                            http   www springframework org schema tx                            http   www springframework org schema tx spring-tx-2 0 xsd  gt        lt  --                                        -- gt       lt  --  load values used for bean properties  -- gt       lt  --                                        -- gt       lt bean class  org springframework beans factory config PropertyPlaceholderConfigurer  gt           lt property name  locations  gt               lt value gt applicationContext properties lt  value gt           lt  property gt       lt  bean gt         lt  --                                              -- gt       lt  --  DataSource where objects will be persisted  -- gt       lt  --                                              -- gt       lt bean id  dataSource  class  org springframework jdbc datasource DriverManagerDataSource  gt           lt property name  username  value    datasource username     gt           lt property name  password  value    datasource password     gt           lt property name  url  value    datasource url     gt           lt property name  driverClassName  value    datasource driver     gt       lt  bean gt         lt  --                                     -- gt       lt  -- Factory bean for Hibernate Sessions -- gt       lt  --                                     -- gt       lt bean id  hibernateSessionFactory  class  org springframework orm hibernate3 annotation AnnotationSessionFactoryBean  gt           lt property name  dataSource  ref  dataSource    gt           lt property name  annotatedClasses  gt               lt list gt                   lt value gt gov noaa ncdc cmb esrl domain entity EsrlDailyAvg lt  value gt                   lt value gt gov noaa ncdc cmb esrl domain entity EsrlObservations lt  value gt                   lt value gt gov noaa ncdc cmb esrl domain entity EsrlStation lt  value gt               lt  list gt           lt  property gt           lt property name  hibernateProperties  gt               lt props gt                   lt prop key  hibernate dialect  gt   hibernate dialect  lt  prop gt                   lt prop key  hibernate show sql  gt false lt  prop gt                   lt prop key  hibernate format sql  gt true lt  prop gt                   lt prop key  hibernate use sql comments  gt true lt  prop gt                   lt prop key  hibernate jdbc batch size  gt 50 lt  prop gt                   lt prop key  hibernate query substitutions  gt true 1  false 0 lt  prop gt                   lt prop key  hibernate max fetch depth  gt 6 lt  prop gt                   lt prop key  hibernate hbm2ddl auto  gt   hibernate hbm2ddlauto  lt  prop gt                   lt prop key  hibernate cache use second level cache  gt   hibernate use second level cache  lt  prop gt               lt  props gt           lt  property gt       lt  bean gt         lt  --                            -- gt       lt  --  Transaction Manager bean  -- gt       lt  --                            -- gt       lt bean id  transactionManager  class  org springframework orm hibernate3 HibernateTransactionManager  gt           lt property name  sessionFactory  ref  hibernateSessionFactory    gt       lt  bean gt         lt  --                                                                           -- gt       lt  --  enable the configuration of transactional behavior based on annotations  -- gt       lt  --                                                                           -- gt       lt tx annotation-driven transaction-manager  transactionManager    gt         lt  --                                -- gt       lt  --  DAO for ESRL Station objects  -- gt       lt  --                                -- gt       lt bean id  esrlStationDao  class  gov noaa ncdc cmb esrl domain dao EsrlStationDaoHibernateImpl  gt           lt property name  sessionFactory  ref  hibernateSessionFactory    gt           lt property name  persistentClass  value  gov noaa ncdc cmb esrl domain entity EsrlStation    gt       lt  bean gt         lt  --                                     -- gt       lt  --  DAO for ESRL Observations objects  -- gt       lt  --                                     -- gt       lt bean id  esrlObservationsDao  class  gov noaa ncdc cmb esrl domain dao EsrlObservationsDaoHibernateImpl  gt           lt property name  sessionFactory  ref  hibernateSessionFactory    gt           lt property name  persistentClass  value  gov noaa ncdc cmb esrl domain entity EsrlObservations    gt       lt  bean gt         lt  --                                      -- gt       lt  --  DAO for ESRL daily average objects  -- gt       lt  --                                      -- gt       lt bean id  esrlDailyAvgDao  class  gov noaa ncdc cmb esrl domain dao EsrlDailyAvgDaoHibernateImpl  gt           lt property name  sessionFactory  ref  hibernateSessionFactory    gt           lt property name  persistentClass  value  gov noaa ncdc cmb esrl domain entity EsrlDailyAvg    gt       lt  bean gt     lt  beans gt     The generic DAO class  from which the DAO being used in my program is extended  looks like this   package gov noaa ncdc cmb persistence dao   import gov noaa ncdc cmb persistence entity PersistentEntity  import java io Serializable  import java util Collection  import java util Date  import java util List  import org apache commons logging Log  import org apache commons logging LogFactory  import org hibernate Criteria  import org hibernate Session  import org hibernate SessionFactory  import org hibernate criterion Criterion  import org hibernate criterion Example          This class is an implementation of GenericDao lt T  PK gt  using Hibernate      public class GenericDaoHibernateImpl lt T extends PersistentEntity lt PK gt   PK extends Serializable gt      implements GenericDao lt T  PK gt        private SessionFactory sessionFactory       static private Log log   LogFactory getLog GenericDaoHibernateImpl class        private Class lt T gt  persistentClass                  Can be used within subclasses as a convenience method                  param criterionList the criteria to find by         return the list of elements that match the specified criteria             protected List lt T gt  findByCriteria final List lt Criterion gt  criterionList                Criteria criteria   getCurrentSession   createCriteria persistentClass           for  Criterion criterion   criterionList                        criteria add criterion                     return criteria list               protected String getCanonicalPersistentClassName                 return persistentClass getCanonicalName                          Gets the current Hibernate Session object                  return             protected Session getCurrentSession                 return sessionFactory getCurrentSession                         This method only provided for interface compatibility   Not recommended for use with large batches          this is an inefficient implementation  and it s somewhat difficult to perform batch operations with Hibernate                   non-Javadoc          see gov noaa ncdc cmb persistence dao GenericDao batchInsert java util Collection               Override     public int   batchInsert final Collection lt T gt  entityCollection                int   updateCounts   new int entityCollection size             int i   0          for  T entity   entityCollection                        try                               saveOrUpdate entity                   updateCounts i    1                  i                              catch  Exception ex                                clear                    throw new RuntimeException ex                                   flush            clear             return updateCounts                       This method only provided for interface compatibility   Not recommended for use with large batches          this is an inefficient implementation  and it s somewhat difficult to perform batch operations with Hibernate                   non-Javadoc          see gov noaa ncdc cmb persistence dao GenericDao batchUpdate java util Collection               Override     public int   batchUpdate final Collection lt T gt  entityCollection                return batchInsert entityCollection                         Completely clear the session  Evict all loaded instances and cancel all pending saves  updates and deletions  Do        not close open iterators or instances of ScrollableResults              public void clear                 getCurrentSession   clear                          non-Javadoc          see gov noaa ncdc cmb persistence dao GenericDao delete gov noaa ncdc cmb persistence entity PersistentEntity               Override     public void delete final T persistentObject                getCurrentSession   delete persistentObject                         non-Javadoc          see gov noaa ncdc cmb persistence dao GenericDao findAll                Override     public List lt T gt  findAll                 return getCurrentSession   createQuery  from     persistentClass getName    list                          Finds a collection of entity objects which match to the example instance  minus any specified properties which should be excluded from the matching                  param exampleInstance         param excludeProperty         return             public List lt T gt  findByExample final T exampleInstance                                   final String   excludeProperty                Criteria criteria   getCurrentSession   createCriteria persistentClass           Example example   Example create exampleInstance           if  excludeProperty    null                        for  String exclude   excludeProperty                                example excludeProperty exclude                                   criteria add example           return criteria list                          non-Javadoc          see com sun cloud lifecycle core persistence dao GenericDao findById java io Serializable               Override     public T findById final PK id                return  T  getCurrentSession   load persistentClass  id                         Force this session to flush  Must be called at the end of a unit of work  before commiting the transaction and        closing the session  depending on flush-mode  Transaction commit   calls this method                  Flushing is the process of synchronizing the underlying persistent store with persistable state held in memory              public void flush                 getCurrentSession   flush                          non-Javadoc          see gov noaa ncdc cmb persistence dao GenericDao saveOrUpdate gov noaa ncdc cmb persistence entity PersistentEntity               Override     public T saveOrUpdate final T entity                try                       entity setUpdatedDate new Date                 getCurrentSession   saveOrUpdate entity               return entity                    catch  Exception ex                        String errorMessage    Failed to save the object                log error errorMessage  ex               throw new RuntimeException errorMessage  ex                                   Setter for the persistentClass property                  param persistentClass             public void setPersistentClass final Class lt T gt  persistentClass                this persistentClass   persistentClass                        Property setter                  param sessionFactory             public void setSessionFactory final SessionFactory sessionFactory                this sessionFactory   sessionFactory             My application gets the DAO from the application context      load the Spring application context  get the DAOs ApplicationContext applicationContext   new ClassPathXmlApplicationContext new String      dailyAveragingApplicationContext xml      esrlDailyAvgDao    EsrlDailyAvgDao  applicationContext getBean  esrlDailyAvgDao    esrlObservationsDao    EsrlObservationsDao  applicationContext getBean  esrlObservationsDao      And the exception is encountered when I try to save an entity   esrlDailyAvgDao saveOrUpdate esrlDailyAvg     The DAO class itself uses the Transactional annotation    Transactional public class EsrlDailyAvgDaoHibernateImpl     extends GenericDaoHibernateImpl lt EsrlDailyAvg  Long gt      implements EsrlDailyAvgDao   The exception stack trace looks like this   SEVERE  Failed to save the object  org hibernate HibernateException  No Hibernate Session bound to thread  and configuration does not allow creation of non-transactional one here     at org springframework orm hibernate3 SpringSessionContext currentSession SpringSessionContext java 63      at org hibernate impl SessionFactoryImpl getCurrentSession SessionFactoryImpl java 622      at gov noaa ncdc cmb persistence dao GenericDaoHibernateImpl getCurrentSession GenericDaoHibernateImpl java 56      at gov noaa ncdc cmb persistence dao GenericDaoHibernateImpl saveOrUpdate GenericDaoHibernateImpl java 187      at sun reflect NativeMethodAccessorImpl invoke0 Native Method      at sun reflect NativeMethodAccessorImpl invoke Unknown Source      at sun reflect DelegatingMethodAccessorImpl invoke Unknown Source      at java lang reflect Method invoke Unknown Source      at org springframework aop support AopUtils invokeJoinpointUsingReflection AopUtils java 309      at org springframework aop framework JdkDynamicAopProxy invoke JdkDynamicAopProxy java 196      at  Proxy19 saveOrUpdate Unknown Source      at gov noaa ncdc cmb esrl ingest EsrlDailyAvgProcessor main EsrlDailyAvgProcessor java 469

User · Answer

I got the following error   org hibernate HibernateException  No Hibernate Session bound to thread  and configuration does not allow creation of non-transactional one here     at org springframework orm hibernate3 SpringSessionContext currentSession SpringSessionContext java 63    I fixed this by changing my hibernate properties file  hibernate current session context class thread   My code and configuration file as follows  session    getHibernateTemplate   getSessionFactory   getCurrentSession     session beginTransaction     session createQuery Qry  executeUpdate     session getTransaction   commit      on properties file  hibernate dialect org hibernate dialect MySQLDialect  hibernate show sql true  hibernate query factory class org hibernate hql ast ASTQueryTranslatorFactory  hibernate current session context class thread   on cofiguration file   lt properties gt   lt property name  hibernateProperties  gt   lt props gt   lt prop key  hibernate dialect  gt   hibernate dialect  lt  prop gt   lt prop key  hibernate show sql  gt   hibernate show sql  lt  prop gt            lt prop key  hibernate query factory class  gt   hibernate query factory class  lt  prop gt          lt prop key  hibernate generate statistics  gt true lt  prop gt   lt prop key  hibernate current session context class  gt   hibernate current session context class  lt  prop gt   lt  props gt   lt  property gt   lt  properties gt    Thanks  Ashok

User · Answer

Have you got org springframework orm hibernate3 support OpenSessionInViewFilter  configured in webapp s web xml  assuming your application is a webapp   or wrapping calls accordingly

User · Answer

I had the same issue today While searching here for solution I have did silly mistake that is instead of importing   import org springframework transaction annotation Transactional    unknowingly i have imported   import javax transaction Transactional    Afer changing it everything worked fine   So thought of sharing If somebody does same mistake

User · Answer

I resolved this by adding  Transactional to the base generic Hibernate DAO implementation class  the parent class which implements the saveOrUpdate   method inherited by the DAO I use in the main program   i e  the  Transactional needs to be specified on the actual class which implements the method   My assumption was instead that if I declared  Transactional on the child class then it included all of the methods that were inherited by the child class   However it seems that the  Transactional annotation only applies to methods implemented within a class and not to methods inherited by a class

User · Answer

You can have the  Transactional in the child class  but you have to override each of the methods and call the super method in order to get it to work   Example    Transactional readOnly   true  public class Bob lt SomeClass gt        Override    public SomeClass getValue            return super getValue             This allows it to set it up for each of the methods it s needed for

User · Answer

after I add the property    lt prop key  hibernate current session context class  gt thread lt  prop gt  I get the exception like   org hibernate HibernateException  createQuery is not valid without active transaction org hibernate HibernateException  save is not valid without active transaction    so I think setting that property is not a good solution   finally I solve  No Hibernate Session bound to thread  problem    1  lt  --  lt prop key  hibernate current session context class  gt thread lt  prop gt  -- gt  2 add  lt tx annotation-driven   gt  to servlet-context xml or dispatcher-servlet xml 3 add  Transactional after  Service and  Repository

User · Answer

You are missing  lt context annotation-config   gt  from your spring context so the annotations are not being scanned

User · Answer

Whenever you will face below error just follow it      org hibernate HibernateException  No Hibernate Session bound to thread  and configuration does not allow creation of non-transactional one here       at org springframework orm hibernate3 SpringSessionContext currentSession SpringSessionContext java 63    Put a  Transactional annotation for each method of implementing classes

User · Answer

I was getting the same the error inside a shared function  but it was only happening for some calls to this shared function  I eventually realized that one of classes calling the shared function wasn t wrapping it inside of a Unit of Work  Once I updated this classes functions with a Unit of Work everything worked as expected   So just posting this for any future visitors who run into this same error  but for whom the accepted answer doesn t apply

[java] No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here

Examples related to java

Examples related to hibernate

Examples related to spring