Trouble converting a Spring JDBC application for Spring with Hibernate

[Ray Clark]

Hi, I have a Spring application working with Spring JDBC and I'm trying to convert it to use Hibernate but I can't seem to get the Spring configuration right.

My application context file has the configuration for Hibernate connecting to a MySQL database. I want to use full annotations so my beans are not defined. Here is the config 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"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:jdbc="http://www.springframework.org/schema/jdbc"
       xmlns:tx="http://www.springframework.org/schema/tx"
       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
        http://www.springframework.org/schema/jdbc
        http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
    ">

    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    
    <tx:annotation-driven />
        
    <context:component-scan base-package="com.home.dvdtracker" />

    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="packagesToScan" value="com.home.dvdtracker.domain" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
        
    <bean id="propertyConfigurer"
            class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
            p:location="/WEB-INF/jdbc.properties" />

    <bean id="dataSource"
            class="org.springframework.jdbc.datasource.DriverManagerDataSource"
            p:driverClassName="${jdbc.driverClassName}"
            p:url="${jdbc.url}"
            p:username="${jdbc.username}"
            p:password="${jdbc.password}" />
</beans>

Here is my data access class:

imports excluded

@Repository("dvdHibernate")
@Transactional
public class DvdHibernate {

    private SessionFactory sessionFactory;

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }
    @Resource(name = "sessionFactory")
    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
    
    public List<Dvd> getDvdList() {
        Session currentSession = this.sessionFactory.getCurrentSession();
        Query query = currentSession.createQuery("select d from dvd d");
        return query.list();
    }
...

If I run the code like this I get the following error on the getCurrentSession() line:
No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here

I've done much searching on the internet and trying various examples. I found suggestions adding the following property.
<prop key="hibernate.current_session_context_class">thread</prop>

When I do that I get the following error on the createQuery line:
createQuery is not valid without active transaction

Any suggestions as to what is wrong with my configuration?

Many Thanks,
Ray

[Bear Bibeault]

Please do not post the same question more than once.