Spring Hibernate - Could not obtain transaction-synchronized Session for current thread

Question

I created an application with spring   hibernate  but I always get this error  This is my first application with hibernate  I read some guides but I can not solve this problem  Where am I doing wrong   This is the code of my application  ott 05  2014 4 03 06 PM org springframework context support ClassPathXmlApplicationContext prepareRefresh Informazioni  Refreshing   org springframework context support ClassPathXmlApplicationContext 1eab16b  startup date   Sun Oct 05 16 03 06 CEST 2014   root of context hierarchy ott 05  2014 4 03 06 PM org springframework beans factory xml XmlBeanDefinitionReader loadBeanDefinitions Informazioni  Loading XML bean definitions from class path resource  springConfig xml  ott 05  2014 4 03 08 PM org hibernate annotations common reflection java JavaReflectionManager  lt clinit gt  INFO  HCANN000001  Hibernate Commons Annotations  4 0 5 Final  ott 05  2014 4 03 08 PM org hibernate Version logVersion INFO  HHH000412  Hibernate Core  4 3 6 Final  ott 05  2014 4 03 08 PM org hibernate cfg Environment  lt clinit gt  INFO  HHH000206  hibernate properties not found ott 05  2014 4 03 08 PM org hibernate cfg Environment buildBytecodeProvider INFO  HHH000021  Bytecode provider name   javassist ott 05  2014 4 03 09 PM org hibernate dialect Dialect  lt init gt  INFO  HHH000400  Using dialect  org hibernate dialect MySQL5Dialect ott 05  2014 4 03 09 PM org hibernate engine transaction internal TransactionFactoryInitiator initiateService INFO  HHH000399  Using default transaction strategy  direct JDBC transactions  ott 05  2014 4 03 09 PM org hibernate hql internal ast ASTQueryTranslatorFactory  lt init gt  INFO  HHH000397  Using ASTQueryTranslatorFactory Exception in thread  main  org hibernate HibernateException  Could not obtain transaction-synchronized Session for current thread at org springframework orm hibernate4 SpringSessionContext currentSession SpringSessionContext java 134  at org hibernate internal SessionFactoryImpl getCurrentSession SessionFactoryImpl java 1014  at coreservlets StudentDAOImpl create StudentDAOImpl java 19  at coreservlets MainApp main MainApp java 14    student java  package coreservlets   public class Student        private Integer id      private String name      private Integer age       public Integer getId   return id    getId      public void setId Integer id  this id id    setId      public String getName   return name    getName      public void setName String name  this name name    setName      public Integer getAge   return age    getAge      public void setAge Integer age  this age age    setAge     Student   studentDAO java  package coreservlets   import org hibernate SessionFactory   public interface StudentDAO        public void setSessionFactory SessionFactory sessionFactory        public void create String name Integer age       StudentDAO   StudentDAOImpl java  package coreservlets   import org hibernate Session  import org hibernate SessionFactory  import org springframework beans factory annotation Autowired  import org springframework stereotype Repository    Repository public class StudentDAOImpl implements StudentDAO        private SessionFactory sessionFactory        Autowired     public void setSessionFactory SessionFactory sessionFactory           this sessionFactory sessionFactory         setSessionFactory      public void create String name Integer age           Session session sessionFactory getCurrentSession            Student student new Student            student setName name           student setAge age           session save student          create     StudentDAOImpl   MainApp java  package coreservlets   import org springframework context ApplicationContext  import org springframework context support ClassPathXmlApplicationContext   public class MainApp        public static void main String   args             ApplicationContext context new ClassPathXmlApplicationContext  springConfig xml             StudentDAOImpl student  StudentDAOImpl  context getBean  studentDAOImpl             student create  Alessandro   new Integer 33             main     MainApp   springConfig xml   lt  xml version  1 0  encoding  UTF-8   gt   lt beans xmlns  http   www springframework org schema beans  xmlns xsi  http   www w3 org 2001 XMLSchema-instance  xmlns context  http   www springframework org schema context  xmlns mvc  http   www springframework org schema mvc  xsi schemaLocation  http   www springframework org schema beans http   www springframework org schema beans spring-beans-4 1 xsd     http   www springframework org schema context http   www springframework org schema context spring-context-4 1 xsd     http   www springframework org schema mvc http   www springframework org schema mvc spring-mvc-4 1 xsd  gt    lt context annotation-config  gt    lt context component-scan base-package  coreservlets   gt    lt bean id  dataSource  class  org apache commons dbcp2 BasicDataSource  gt     lt property name  driverClassName  value  com mysql jdbc Driver   gt     lt property name  url  value  jdbc mysql   localhost 3306 spring hibernate   gt     lt property name  username  value  root   gt     lt property name  password  value  password   gt     lt property name  initialSize  value  5   gt     lt property name  maxTotal  value  10   gt   lt  bean gt    lt bean id  sessionFactory  class  org springframework orm hibernate4 LocalSessionFactoryBean  gt   lt property name  dataSource  ref  dataSource   gt   lt property name  hibernateProperties  gt       lt value gt              hibernate dialect org hibernate dialect MySQLDialect      lt  value gt   lt  property gt    lt  bean gt    lt  beans gt    sql  create table student   id integer not null auto increment  name varchar 20  not null  age integer not null  primary key id

User · Answer

My configuration was like this  I had a QuartzJob   a Service Bean   and Dao   as usual it was configured with LocalSessionFactoryBean  for hibernate    and SchedulerFactoryBean for Quartz framework   while writing the Quartz job   I by mistake annotated it with  Service   I should not have done that because I was using another strategy to wire the QuartzBean using AutowiringSpringBeanJobFactory extending SpringBeanJobFactory    So what actually was happening is that due to Quartz Autowire   TX was getting injected to the Job Bean and at the same time Tx Context was set by virtue of  Service annotation and hence the TX was falling out of sync       I hope it help to those for whom above solutions really didn t solved the issue   I was using Spring 4 2 5 and Hibernate 4 0 1     I see that in this thread there is a unnecessary suggestion to add  Transactional annotation to the DAO  Repository    that is a useless suggestion cause  Repository has all what it needs to have don t have to specially set that  transactional on DAOs   as the DAOs are called from the services which have already being injected by  Trasancational   I hope this might be helpful people who are using Quartz   Spring and Hibernate together

User · Answer

I have had the same issue  but in a class that was not a part of the service layer  In my case  the transaction manager was simply obtained from the context by the getBean   method  and the class belonged to the view layer - my project utilizes OpenSessionInView technique   The sessionFactory getCurrentSession   method  has been causing the same exception as the author s  The solution for me was rather simple   Session session   try       session   sessionFactory getCurrentSession      catch  HibernateException e        session   sessionFactory openSession        If the getCurrentSession   method fails  the openSession   should do the trick

User · Answer

Add transaction-manager to your  lt annotation-driven  gt  in spring-servlet xml    lt tx annotation-driven transaction-manager  yourTransactionBeanID   gt

User · Answer

I had this error too because in the file where I used  Transactional  annotation  I was importing the wrong class  import javax transaction Transactional     Instead of javax  use  import org springframework transaction annotation Transactional

User · Answer

Add the annotation  Transactional of spring in the class service

User · Answer

Check your dao class  It must be like this    Session session   getCurrentSession    Query query   session createQuery GET ALL     And annotations    Transactional  Repository

User · Answer

I added these configuration in web xml and it works well for me    lt filter gt       lt filter-name gt OpenSessionInViewFilter lt  filter-name gt       lt filter-class gt org springframework orm hibernate5 support OpenSessionInViewFilter lt  filter-class gt       lt init-param gt           lt param-name gt sessionFactoryBeanName lt  param-name gt           lt param-value gt sessionFactory lt  param-value gt       lt  init-param gt       lt init-param gt           lt param-name gt flushMode lt  param-name gt           lt param-value gt AUTO lt  param-value gt       lt  init-param gt   lt  filter gt   lt filter-mapping gt       lt filter-name gt OpenSessionInViewFilter lt  filter-name gt       lt url-pattern gt    lt  url-pattern gt   lt  filter-mapping gt    Additionally  the most ranked answer give me clues to prevent application from panic at the first run

User · Answer

In this class above  Repository just placed one more annotation  Transactional it will work  If it works reply back Y N     Repository  Transactional public class StudentDAOImpl implements StudentDAO

User · Answer

My Database table has mismatch column name with the Java Object   Entity  which leads to throw the above exception  By updating the table with appropriate column name resolves this issue

User · Answer

My solution was  using Spring  putting the method that fails inside another method that creates and commits the transaction   To do that I first injected the following    Autowired private PlatformTransactionManager transactionManager    And finally did this   public void newMethod         DefaultTransactionDefinition definition   new DefaultTransactionDefinition        TransactionStatus transaction   transactionManager getTransaction definition        oldMethod         transactionManager commit transaction

User · Answer

I had the same issue  I resolved it doing the following    Add the this line to the dispatcher-servlet file        lt tx annotation-driven  gt     Check above  lt beans gt  section in the same file  These two lines must be present       xmlns tx  http   www springframework org schema tx  xsi schemaLocation   http   www springframework org schema tx http   www springframework org schema tx spring-tx xsd    Also make sure you added  Repository and  Transactional where you are using sessionFactory     Repository  Transactional public class ItemDaoImpl implements ItemDao        Autowired     private SessionFactory sessionFactory

User · Answer

Thanks for comment of mannedear  I use springmvc and in my case I have to use as   Repository  Transactional  EnableTransactionManagement public class UserDao           and I also add spring-context to pom xml and it works

User · Answer

In your xyz DAOImpl java  Do the following steps        Step-1  Set session factory    Resource name  sessionFactory   private SessionFactory sessionFactory   public void setSessionFactory SessionFactory sf        this sessionFactory   sf             Step-2  Try to get the current session  and catch the HibernateException exception                 Step-3  If there are any HibernateException exception  then true to get openSession      try          Step-2  Implementation     session   sessionFactory getCurrentSession       catch  HibernateException e           Step-3  Implementation     session   sessionFactory openSession

User · Answer

I encountered the same problem and finally found out that the  lt tx annotaion-driven   gt  was not defined within the  dispatcher -servlet xml where component-scan element enabled  service annotated class    Simply put  lt tx annotaion-driven   gt  with component-scan element together  the problem disappeared

User · Answer

You must enable the transaction support   lt tx annotation-driven gt  or  EnableTransactionManagement  and declare the transactionManager and it should work through the SessionFactory   You must add  Transactional into your  Repository  With  Transactional in your  Repository Spring is able to apply transactional support into your repository   Your Student class has no the  javax persistence   annotations how  Entity  I am assuming the Mapping Configuration for that class has been defined through XML

User · Answer

You need to allow transaction to your DAO method  Add    Transactional readOnly   true  propagation Propagation NOT SUPPORTED    over your dao methods  And  Transactional should be from the package   org springframework transaction annotation Transactional

User · Answer

My similar issue got fixed with below 2 approaches   1  Through manually handling transactions   Session session   sessionFactory getCurrentSession    Transaction tx   session beginTransaction    UserInfo user    UserInfo  session get UserInfo class  1   tx commit      2  Tell Spring to open and manage transactions for you in your web xml filters and Ensure to use  Repository  Transactional    lt filter gt     lt filter-name gt hibernateFilter lt  filter-name gt     lt filter-class gt org springframework orm hibernate5 support OpenSessionInViewFilter lt  filter-class gt     lt init-param gt       lt param-name gt sessionFactory lt  param-name gt       lt param-value gt session factory lt  param-value gt     lt  init-param gt   lt  filter gt   lt filter-mapping gt     lt filter-name gt hibernateFilter lt  filter-name gt     lt url-pattern gt    lt  url-pattern gt   lt  filter-mapping gt

User · Answer

Transactional  javax transaction Transactional  Put it just beside  Repository

[spring] Spring Hibernate - Could not obtain transaction-synchronized Session for current thread

Examples related to spring

Examples related to hibernate

Examples related to spring-mvc

Examples related to spring-orm