Prava Prava - 2 months ago 8
Java Question

Can't find opensession() exception for Hibernatetemplatein hibernate5.1 and spring 4.1.6 integration

I am using

hibernate 5.1.0
and
spring 4.1.6
jars. For
Hibernate 3.6
jar, it's working fine, but i don't want to downgrade my hibernate jar. So what is the solution for
hibernate 5.1
and
spring 4.1.6
integration?

Exception in thread "main" java.lang.NoSuchMethodError: org.hibernate.SessionFactory.openSession()Lorg/hibernate/classic/Session;


My applicationcontext.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/test"></property>
<property name="username" value="root"></property>
<property name="password" value="admin"></property>
</bean>

<bean id="hibernateSessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>

<property name="mappingResources">
<list>
<value>author.hbm.xml</value>
</list>
</property>

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="current_session_context_class">thread</prop>
<prop key="cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
<prop key="connection.pool_size">1</prop>

</props>
</property>
</bean>

<bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate">
<property name="sessionFactory" ref="hibernateSessionFactory"></property>
</bean>

<bean id="authorDAO" class="com.dao.AuthorDAO">
<property name="template" ref="hibernateTemplate"></property>
</bean>


My entity class:

package com.vo;

import java.io.Serializable;

public class Author implements Serializable {

private Integer authorID;

private String authorName;

public Integer getAuthorID() {
return authorID;
}

public void setAuthorID(Integer authorID) {
this.authorID = authorID;
}

public String getAuthorName() {
return authorName;
}

public void setAuthorName(String authorName) {
this.authorName = authorName;
}


}

My author.hbm.xml :

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="com.hex.vo.Author" table="AUTHOR31668">
<id name="authorID">
<generator class="assigned"></generator>
</id>

<property name="authorName"></property>
</class>

</hibernate-mapping>


My DAO Class:

package com.dao;

import java.util.ArrayList;

import java.util.List;

import org.springframework.orm.hibernate4.HibernateTemplate;

import com.hex.vo.Author;

public class AuthorDAO {

HibernateTemplate template;

public void setTemplate(HibernateTemplate template) {
this.template = template;
}
public HibernateTemplate getTemplate() {
return template;
}

//method to save Author
public void saveEmployee(Author e){
template.save(e);
}
//method to update Author
public void updateEmployee(Author e){
template.update(e);
}
//method to delete Author
public void deleteEmployee(Author e){
template.delete(e);
}
//method to return one Author of given id
public Author getById(int id){
Author e=(Author)template.get(Author.class,id);
return e;
}
//method to return all employees
public List<Author> getEmployees(){
List<Author> list=new ArrayList<Author>();
list=template.loadAll(Author.class);
return list;
}


}

My Testclient Class:

package com.test;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.dao.AuthorDAO;

import com.vo.Author;




public class TestClient {

public static void main(String[] arg){

Author author= new Author();
author.setAuthorID(123);
author.setAuthorName("Prava");

ApplicationContext context =
new ClassPathXmlApplicationContext("applicationContext.xml");

AuthorDAO dao=(AuthorDAO)context.getBean("authorDAO");

dao.saveEmployee(author);
System.out.println("Saved successfully..");



}
}

Answer

You are using HibernateTemplate of version 3 with hibernate 5. this is incompatible.

Also HibernateTemplate is deprecated. you should consider changing to sth else.

Please have a look at this article

Comments