Spring and Hibernate problem

[Mary Cole]

Hi,

Am trying out a simple example using Spring3.1 and Hibernate 4.x and am getting this exception

java.lang.ClassCastException: org.springframework.orm.hibernate4.SessionHolder cannot be cast to org.springframework.orm.hibernate3.SessionHolder
	at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:287)
	at org.springframework.orm.hibernate3.SessionFactoryUtils.getSession(SessionFactoryUtils.java:233)
	at org.springframework.orm.hibernate3.HibernateTemplate.getSession(HibernateTemplate.java:457)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:393)
	at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
	at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:737)
	at com.demo.dao.UserDAOImpl.saveUser(UserDAOImpl.java:26)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy19.saveUser(Unknown Source)
	at com.demo.junit.UserTest.testCreateData(UserTest.java:50)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
	at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
	at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
	at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

My config files and java code is shown below

<?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:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="
		http://www.springframework.org/schema/beans	http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd">

	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>/hibernate.properties</value>
			</list>
		</property>
	</bean>

	<context:component-scan base-package="com.demo" />
	<import resource="db-config.xml" />
</beans>

<?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"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd
	">
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

		<property name="driverClassName" value="${jdbc.driverClassName}" />
	<property name="url" value="${jdbc.url}" />
	<property name="username" value="${jdbc.username}" />
	<property name="password" value="${jdbc.password}" />
	</bean>
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="packagesToScan" value="com.demo" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">${jdbc.hibernate.dialect}</prop>
				<prop key="hibernate.hbm2ddl.auto">create</prop>
				<!-- uncomment this for first time run-->
				<prop key="hibernate.hbm2ddl.auto">create</prop>
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>
	</bean>
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
		<property name="sessionFactory">
			<ref bean="sessionFactory" />
		</property>
	</bean>
	<tx:annotation-driven />
</beans>

package com.demo.dao;

import java.util.List;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.demo.User;

@Repository("userDAO")
public class UserDAOImpl implements UserDAO {
	
	private HibernateTemplate hibernateTemplate;

	@Autowired
	public void setSessionFactory(SessionFactory sessionFactory) {
		hibernateTemplate = new HibernateTemplate(sessionFactory);
	}

	@Transactional(readOnly = false)
	@Override
	public void saveUser(User user) {
		hibernateTemplate.saveOrUpdate(user);
	}

	
	@SuppressWarnings("unchecked")
	@Override
	public List<User> getAllUser(User user) {
		return (List<User>) hibernateTemplate.find("from "
				+ User.class.getName());
	}

	@Override
	public User selectUserById(String userId) {
		return hibernateTemplate.get(User.class, userId);

	}

	@Transactional(readOnly = false)
	@Override
	public void deleteUser(User user) {
		hibernateTemplate.delete(user);
	}

}

package com.demo.junit;

import java.util.List;

import org.apache.log4j.BasicConfigurator;
import org.apache.log4j.Logger;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.demo.User;
import com.demo.dao.UserDAO;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration( { "/appConfig.xml" })
public class UserTest {
	
	
	private UserDAO userDAO;
	
	
	public UserDAO getUserDAO() {
		return userDAO;
	}
	@Autowired
	public void setUserDAO(UserDAO userDAO) {
		this.userDAO = userDAO;
	}

	private static final Logger LOGGER = Logger.getLogger(UserTest.class);

	   @Before
	   public void init() throws Exception
	   {
	       // Log4J junit configuration.
	       BasicConfigurator.configure();
	   }
	
	@Test
	public void testCreateData() {
		int expectedResult = 1;
		User user = new User();
		user.setAge(23);
		user.setUserName("Jackie");
		user.setRegistered(true);
		userDAO.saveUser(user);
		Assert.assertEquals(expectedResult, userDAO.getAllUser(new User()).size());
	}

	@Test
	public void testRetrieveData() {
		List<User> userList = userDAO.getAllUser(new User());
		Assert.assertEquals(1, userList.size());
		User userExpected = userList.get(0);
		User userResult = userDAO.selectUserById(userExpected.getUserId());
		Assert.assertEquals(userExpected.getUserId(), userResult.getUserId());
	}

	@Test
	public void testUpdateData() {
		List<User> userList = userDAO.getAllUser(new User());
		Assert.assertEquals(1, userList.size());
		User userExpected = userList.get(0);
		userExpected.setUserName("Jackie John");
		userDAO.saveUser(userExpected);
		User userResult = userDAO.selectUserById(userExpected.getUserId());
		Assert.assertEquals(userExpected.getUserName(), userResult
				.getUserName());
	}

	@Test
	public void testDeleteData() {
		/*List<User> userList = userDAO.getAllUser(new User());
		Assert.assertEquals(1, userList.size());
		User userExpected = userList.get(0);
		userDAO.deleteUser(userExpected);
		User userResult = userDAO.selectUserById(userExpected.getUserId());
		Assert.assertEquals(userResult, null); */
	}

}

Can anybody help me where am wrong?

Thanks

[Prasad Krishnegowda]

Its a issue with Jar Files. Looks like you are having 2 versions of spring containing the SessionHolder class.
Can you post the list of jars from your WEB-INF/lib?

[Mary Cole]

<classpath>
        <classpathentry kind="src" path="src"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/hibernate-core-4.0.1.Final.jar"/>
        <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.6"/>
        <classpathentry kind="lib" path="/Users/mary/workspace-sts/HibernateProj/config/hibernate-core-4.0.1.Final.jar"/>
        <classpathentry kind="lib" path="config"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.jdbc-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/jpa/hibernate-entitymanager-4.0.1.Final.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/hibernate-commons-annotations-4.0.1.Final.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/jboss-logging-3.1.0.CR2.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/javassist-3.15.0-GA.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/hibernate-jpa-2.0-api-1.0.1.Final.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/jboss-transaction-api_1.1_spec-1.0.0.Final.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/commons-collections-3.2.1.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/antlr-2.7.7.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/required/dom4j-1.6.1.jar"/>
        <classpathentry kind="lib" path="/Users/mary/workspace/DNSP6.4/lib/spring-framework/cglib-2.2.jar"/>
        <classpathentry kind="lib" path="/Users/mary/workspace/DNSP6.4/lib/spring-framework/asm-all-3.2.jar"/>
        <classpathentry kind="lib" path="/Users/mary/workspace/DNSP6.4/lib/spring-framework/aopalliance-1.0.jar"/>
        <classpathentry kind="con" path="org.eclipse.jdt.junit.JUNIT_CONTAINER/4"/>
        <classpathentry kind="lib" path="/Users/mary/workspace/DNSP6.4/lib/commons-logging-1.1.jar"/>
        <classpathentry kind="lib" path="/Users/mary/hibernate-release-4.0.1.Final/lib/envers/hibernate-envers-4.0.1.Final.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.web.struts-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.web.servlet-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.web.portlet-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.web-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.transaction-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.test-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.oxm-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.orm-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.jms-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.instrument.tomcat-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.instrument-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.expression-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.core-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.context.support-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.context-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.beans-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.aspects-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.asm-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/spring-framework-3.1.0.RELEASE/dist/org.springframework.aop-3.1.0.RELEASE.jar"/>
        <classpathentry kind="lib" path="/Users/mary/Downloads/mysql-connector-java-5.1.18/mysql-connector-java-5.1.18-bin.jar"/>
        <classpathentry kind="output" path="bin"/>
</classpath>

This is how .classpath in my STS proj looks

[Prasad Krishnegowda]

Jar Files looks OK. But, i can see in the XML you use hibernate4 classes like org.springframework.orm.hibernate4.HibernateTransactionManager and org.springframework.orm.hibernate4.LocalSessionFactoryBean, but you import hibernate3 classes in your Java code as org.springframework.orm.hibernate3.HibernateTemplate.

Can you make them consistent and try once?