Spring + Hibernate No Session found for current thread

[Sergej Smoljanov]

Java based spring mvc configuration

Dispatcher

package com.myspringapp.config.basicconfig;


import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer;



public class WebAppInitializer extends AbstractAnnotationConfigDispatcherServletInitializer  {

	@Override
	protected Class<?>[] getRootConfigClasses() {

		// Return domain beans
		System.out.println("getRootConfigClasses()");
		//return new Class[]{RootConfig.class, DataConfig.class};
		return new Class[]{RootConfig.class};
	}

	@Override
	protected Class<?>[] getServletConfigClasses() {
		// Return web beans
		System.out.println("getServletConfigClasses()");
		return new Class[]{WebConfig.class};
	}

	@Override
	protected String[] getServletMappings() {
		
		// Map servlet to path
		System.out.println("getServletMappings()");
		return new String []{"/"};
	}

}

Web config. ViewResolver bean

package com.myspringapp.config.basicconfig;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.ViewResolver;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;

import org.springframework.web.servlet.view.InternalResourceViewResolver;

@ComponentScan("com.myspringapp.controllers")
@Configuration
@EnableWebMvc
public class WebConfig extends WebMvcConfigurerAdapter{
	@Bean
	public ViewResolver viewResolver(){
		InternalResourceViewResolver resolver = new InternalResourceViewResolver();
		resolver.setPrefix("/WEB-INF/views/");
		resolver.setSuffix(".jsp");
		return resolver;
	}

}

RootConfig. Bean for DataSource , LocalSessionFactoryBean , BeanPostProcessor

package com.myspringapp.config.basicconfig;

import com.mysql.jdbc.Connection;
import java.sql.SQLException;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.config.BeanPostProcessor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor;
import org.springframework.jndi.JndiTemplate;
import org.springframework.orm.hibernate4.HibernateTransactionManager;
import org.springframework.orm.hibernate4.LocalSessionFactoryBean;


@ComponentScan({"com.myspringapp.config.persistance", "com.myspringapp.config.businessobjects"})
@Configuration
class RootConfig {

   
    @Bean
    public DataSource getDataSource() {
        DataSource dataSource = null;
        JndiTemplate jndi = new JndiTemplate();
        try {
            dataSource = jndi.lookup("java:comp/env/jdbc/JCGExampleDB1", DataSource.class);
        } catch (Exception e) {
            e.printStackTrace();
        }
        try (java.sql.Connection con = dataSource.getConnection();) {
            System.out.println("Connection is successful when init bean dataSource");
        } catch (SQLException ex) {
            Logger.getLogger(RootConfig.class.getName()).log(Level.SEVERE, null, ex);
        }

        return dataSource;
    }

    @Bean
    public LocalSessionFactoryBean sessionFactory() {
        LocalSessionFactoryBean localSessionFactoryBean = new LocalSessionFactoryBean();
        localSessionFactoryBean.setDataSource(getDataSource());
        localSessionFactoryBean.setPackagesToScan(new String[]{"com.myspringapp.config.persistance", "com.myspringapp.config.businessobjects"});
        Properties property = new Properties();
        property.setProperty("dialect", "org.hibernate.dialect.MySQL5Dialect");
        localSessionFactoryBean.setHibernateProperties(property);
        System.out.println("insite creation LocalSessionFactoryBean bean");

        return localSessionFactoryBean;
    }
    // for exception handling
    @Bean
    public BeanPostProcessor persistenceTranslation() {
        return new PersistenceExceptionTranslationPostProcessor();
    }
    
 
}

Interface for persistence logic

package com.myspringapp.config.persistance;
import com.myspringapp.config.businessobjects.BusinessObject;
import java.util.List;

/**
 *
 * @author Media
 */
public interface PersistBusinessObject {
    public void saveObject(BusinessObject businessObject);
    
    public List<BusinessObject> getListOfObjects();
    
    public BusinessObject getObjectById(long id);
}

How i try use hibernate to save object

package com.myspringapp.config.persistance;

import com.myspringapp.config.businessobjects.BusinessObject;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.context.annotation.Primary;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;


@Primary
@Repository
public class HebernatePersist implements PersistBusinessObject {

    public HebernatePersist() {
    }
    private SessionFactory sessionFactory;

    @Autowired
    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
        System.out.println("Session factory succcessful seted inside HebernatePersist");
    }

    
    @Override
    public void saveObject(BusinessObject businessObject) {

        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        session.save(businessObject);
        session.getTransaction().commit();
    }

   
    @Override
    public List<BusinessObject> getListOfObjects() {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        List<BusinessObject> list = session.createQuery("from BusinessObject").list();
        // in hibernate 5 must be changed to session.createQuery("from Student").getResultList()
        session.getTransaction().commit();
        return list;
    }

   
    @Override
    public BusinessObject getObjectById(long id) {
        
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        BusinessObject businessObject = (BusinessObject) session.get(BusinessObject.class, (Long) id);
        session.getTransaction().commit();
        return businessObject;
    }
    

}

Controller:

package com.myspringapp.controllers;

import com.myspringapp.config.businessobjects.BusinessObject;
import com.myspringapp.config.persistance.PersistBusinessObject;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import static org.springframework.web.bind.annotation.RequestMethod.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.Model;

@Controller
public class SympleViewController {
    @Autowired
    PersistBusinessObject persistBusinessObject;
            
    @RequestMapping(value = "/", method = GET)
    public String home() {
        System.out.println("inside home() method of SympleViewController.class");
        return "home";
    }

    // create business object view
    @RequestMapping(value = "/createBusinessObject", method = GET)
    public String createBusinessObject(Model model) {
        System.out.println("inside home() method of createBusinessObject.class");
        BusinessObject bo = new BusinessObject();
        model.addAttribute(bo);
        return "createBusinessObject";
    }

    // list business object view
    
    @RequestMapping(value = "/listBusinessObject", method = GET)
    public String listBusinessObject( Model model) {
        System.out.println("inside home() method of createBusinessObject.class");
        model.addAttribute("listOfObjects", persistBusinessObject.getListOfObjects());
        return "listBusinessObject";
    }
    
   
    // create business object view
    @RequestMapping(value = "/createBusinessObject", method = POST)
    public String createBusinessObjectSaving(BusinessObject businessObject, Model model) {
        System.out.println("inside home() method of createBusinessObject.class");
        persistBusinessObject.saveObject(businessObject);
        model.addAttribute("message", "previous object was saved");
        return "redirect:/createBusinessObject";
    }
}

Object that i want for save:

package com.myspringapp.config.businessobjects;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;


@Entity
@Table(name = "mybusinessobjects")
public class BusinessObject {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "myId")
    private long id;
    
    @Column(name = "mynameOfObject")
    private String nameOfObject;
    
    @Column(name = "mytypeOfObject")
    private String typeOfObject;
    
    @Column(name = "mydescriptionOfObject")
    private String descriptionOfObject;

    public BusinessObject(String nameOfObject, String typeOfObject, String descriptionOfObject) {
        this.nameOfObject = nameOfObject;
        this.typeOfObject = typeOfObject;
        this.descriptionOfObject = descriptionOfObject;
    }
    
    //default constructor for spring bean instantiation
    public BusinessObject(){}

    /**
     * @return the id
     */
    public long getId() {
        return id;
    }

    /**
     * @param id the id to set
     */
    public void setId(long id) {
        this.id = id;
    }

    /**
     * @return the nameOfObject
     */
    public String getNameOfObject() {
        return nameOfObject;
    }

    /**
     * @param nameOfObject the nameOfObject to set
     */
    public void setNameOfObject(String nameOfObject) {
        this.nameOfObject = nameOfObject;
    }

    /**
     * @return the typeOfObject
     */
    public String getTypeOfObject() {
        return typeOfObject;
    }

    /**
     * @param typeOfObject the typeOfObject to set
     */
    public void setTypeOfObject(String typeOfObject) {
        this.typeOfObject = typeOfObject;
    }

    /**
     * @return the descriptionOfObject
     */
    public String getDescriptionOfObject() {
        return descriptionOfObject;
    }

    /**
     * @param descriptionOfObject the descriptionOfObject to set
     */
    public void setDescriptionOfObject(String descriptionOfObject) {
        this.descriptionOfObject = descriptionOfObject;
    }
    
    
}

View
JSP where i place form for saving object

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">
<%@ taglib prefix="c" 
           uri="http://java.sun.com/jsp/jstl/core" %>
<%@taglib uri = "http://www.springframework.org/tags/form" prefix = "sf" %>
<html>
    <head>
        <link rel="shortcut icon" href="https://spring.io/img/favicon-ca31b78daf0dd9a106bbf3c6d87d4ec7.png"> 
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>createBusinessObject</title>
    </head>

    <body>
        <h1>On this page you can create new business object</h1>
        <div>
            <!-- link for home page -->
            <a href ="<c:url value = "/"/>">Home</a>
        </div>
        ${message}
        <div>
            <!-- form for creating business object -->
            <sf:form commandName="businessObject">
                id  <sf:input path ="id"/></br>
                nameOfObject <sf:input path ="nameOfObject"/></br>
                typeOfObject <sf:input path ="typeOfObject"/></br>
                descriptionOfObject <sf:input path ="descriptionOfObject"/></br>
                 <input type ="submit" value ="Register"/> <br></br>
            </sf:form>
        </div>
    </body>
</html>

finally when i try save object i get:

org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcher] in context with path [/Spring_Demo_Aplication] threw exception [Request processing failed; nested exception is org.springframework.orm.hibernate4.HibernateSystemException: No Session found for current thread; nested exception is org.hibernate.HibernateException: No Session found for current thread] with root cause
org.hibernate.HibernateException: No Session found for current thread
at org.springframework.orm.hibernate4.SpringSessionContext.currentSession(SpringSessionContext.java:106)
at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:1013)
at com.myspringapp.config.persistance.HebernatePersist.saveObject(HebernatePersist.java:44)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)

And cant figure where error i made. How can i solve this problem?

[Sergej Smoljanov]

My solution was
add
@EnableTransactionManagement to class RootConfig
also add next bean to this class

    @Bean
    public PlatformTransactionManager getPlatformTransactionManager(@Autowired SessionFactory sessionFactory) {
        PlatformTransactionManager tm = new HibernateTransactionManager(sessionFactory);
        return tm;
    }

also i change HibernatePersist this way and this will work for me

package com.myspringapp.config.persistance;

import com.myspringapp.config.businessobjects.BusinessObject;
import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.context.annotation.Primary;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;


@Primary
@Repository
public class HibernatePersist implements PersistBusinessObject {

    public HibernatePersist() {
    }
    private SessionFactory sessionFactory;

    @Autowired
    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
        System.out.println("Session factory succcessful seted inside HebernatePersist");
        sessionFactory.openSession();
    }

    @Transactional
    @Override
    public void saveObject(BusinessObject businessObject) {

        Session session = sessionFactory.getCurrentSession();

        //   session.beginTransaction();
        session.save(businessObject);
        //   session.getTransaction().commit();
    }

    @Transactional
    @Override
    public List<BusinessObject> getListOfObjects() {
        Session session = sessionFactory.getCurrentSession();
        //    session.beginTransaction();
        List<BusinessObject> list = session.createQuery("from BusinessObject").list();
        // in hibernate 5 must be changed to session.createQuery("from Student").getResultList()
        //   session.getTransaction().commit();
        return list;
    }

    @Transactional
    @Override
    public BusinessObject getObjectById(long id) {

        Session session = sessionFactory.getCurrentSession();
        //   session.beginTransaction();
        BusinessObject businessObject = (BusinessObject) session.get(BusinessObject.class, (Long) id);
        //  session.getTransaction().commit();
        return businessObject;
    }

}