Transactions in Spring + Hibernate

[Jean Jorge Michel]

Hi guys!

I�m trying using Spring + Hibernate to persist system�s objects (Hibernate) and control transactions (Spring).
But every interaction with DB (MySQL) a new connection is opened, ignoring my pool (c3p0) configuration.

My example is so simple, User and Note objects to persist.
My example is organized in three packages:

Model
There are two classes:
User
Note

These objects are annotated to Hibernate.

DAO
There are three interfaces:
GenericDAOInterface
UserDAOInterface
NoteDAOInterface

And three implementations:
SpringDAO extends HibernateDaoSupport
and implements GenericDAOInterface
UserDAO extends SpringDAO
and implements UserDAOInterface
NoteDAO extends SpringDAO
and implements NoteDAOInterface

These objects are annotated with @Repository.

Facade
There are two interfaces:
UserFacadeInterface
NoteFacadeInterface

And two implementations:
UserFacade implements UserFacadeInterface
NoteFacade implements NoteFacadeInterface

These objects are annotated with @Transactional.

When I use the system this work fine, I can persiste my beans. I look in MySQL and my system start the first operation (login) creating three connections and to every operation with DB (list my notes, view register/view page with correct register data filed, etc) is opened a connection in MySQL.

I tried create a TransactionManager, TransactionInterceptor, etc� into my applicationContext.xml but I cant�t make Spring use my transaction configuration!!! I tried put in dataSource bean a declararion type: <property name="transactionManager"><ref local="transactionManager"/></property> but don�t work or in Hibernate properties: <prop key="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</prop>.

Someone can help me? My config file is:

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans <a href="http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans-2.0.xsd</a>
          <a href="http://www.springframework.org/schema/aop" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop</a> <a href="http://www.springframework.org/schema/aop/spring-aop-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop/spring-aop-2.0.xsd</a>
   <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a> <a href="http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"></a>
 
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:/jdbc.properties"/>
</bean>
 
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${jdbc.driverClassName}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="initialPoolSize" value="3" />
<property name="minPoolSize" value="3"/>
<property name="maxPoolSize" value="5" />
<property name="acquireIncrement" value="1" />
<property name="maxStatements" value="0" />
<property name="maxIdleTime" value="120" />
<property name="checkoutTimeout" value="5000" />
</bean>
 
<bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="properties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
 
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
<property name="hibernateProperties">
<ref bean="hibernateProperties" />
</property>
<property name="annotatedClasses">
<list>
<value>model.User</value>
<value>model.Note</value>
</list>
</property>
<property name="annotatedPackages">
<list>
<value>model</value>
</list>
</property>
</bean>
 
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
 
<!-- Transactions  -->
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory"/>
</bean>
 
<!-- Tentativa -->
<bean class="org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator" />
<!-- fim -->
 
<bean class="org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor">
<property name="transactionInterceptor" ref="txInterceptor"/>
</bean>
 
<bean id="txInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
<property name="transactionManager" ref="transactionManager"/>
<property name="transactionAttributeSource">
<bean class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource"/>
</property>
</bean>
 
<tx:annotation-driven/>
 
<bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>
 
<!-- Beans -->
<bean id="user" class="model.User" scope="session" />
<bean id="note" class="model.Note" scope="session" />
 
<!-- DAOs -->
<bean id="userDAO" class="dao.UserDAO">
<constructor-arg>
<value>model.User</value>
</constructor-arg>
<property name="hibernateTemplate">
<ref bean="hibernateTemplate"/>
</property>
</bean>
 
<bean id="noteDAO" class="dao.NoteDAO">
<constructor-arg>
<value>model.Note</value>
</constructor-arg>
<property name="hibernateTemplate">
<ref bean="hibernateTemplate"/>
</property>
</bean>
 
<!-- Facades -->
<bean id="userFacade" class="facade.UserFacade">
    <property name="userDAO" ref="userDAO" />
</bean>
 
<bean id="noteFacade" class="facade.NoteFacade">
    <property name="noteDAO" ref="noteDAO" />
</bean>
 
</beans>

[Satish Kandagadla]

Are you trying to use transactions driven by annotations?

If yes please try to change the bean <tx:annotation-driven/> to this

<tx:annotation-driven transaction-manager="transactionManager"/>

[Jean Jorge Michel]

Hi,
Is not it, do not work ;(

I am looking in MySQL console (Windows� command prompt) and for all hit is open a new connection
This problem will kill my project, if I do not able to control this problem Spring + Hibernate will be removed from the project and I will be forced to use procedures + JDC (noooooo!!!).

Someone have any idea to help me?

Thanks.

My new attempt is:

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           <a href="http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/aop" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop</a>
                           <a href="http://www.springframework.org/schema/aop/spring-aop-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop/spring-aop-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a>
                           <a href="http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"></a>
 
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:/jdbc.properties"/>
    </bean>
 
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.driverClassName}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialPoolSize" value="3" />
        <property name="minPoolSize" value="3"/>
        <property name="maxPoolSize" value="6" />
        <property name="acquireIncrement" value="1" />
        <property name="maxStatements" value="0" />
        <property name="maxIdleTime" value="120" />
        <property name="checkoutTimeout" value="5000" />
    </bean>
 
    <bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="properties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
 
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"/>
        </property>
        <property name="hibernateProperties">
            <ref bean="hibernateProperties" />
        </property>
        <property name="annotatedClasses">
            <list>
                <value>.model.User</value>
                <value>.model.Note</value>
            </list>
        </property>
        <property name="annotatedPackages">
            <list>
                <value>.model</value>
            </list>
        </property>
    </bean>
 
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
        <property name="sessionFactory">
            <ref bean="sessionFactory" />
        </property>
    </bean>
 
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
 
    <bean class="org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator" />
 
    <bean class="org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor">
        <property name="transactionInterceptor" ref="txInterceptor"/>
    </bean>
 
    <bean id="txInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
        <property name="transactionManager" ref="transactionManager"/>
        <property name="transactionAttributeSource">
            <bean class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource"/>
        </property>
    </bean>
 
    <tx:annotation-driven transaction-manager="transactionManager"/>
    <bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>
 
    <!-- Beans -->
    <bean id="user" class="model.User" scope="session" />
    <bean id="note" class="model.Note" scope="session" />
 
    <!-- DAOs -->
    <bean id="userDAO" class="dao.UserDAO">
        <constructor-arg>
            <value>model.User</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <bean id="noteDAO" class="dao.NoteDAO">
        <constructor-arg>
            <value>model.Note</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <!-- Facades -->
    <bean id="userFacade" class="facade.UserFacade">
        <property name="userDAO" ref="userDAO" />
    </bean>
 
    <bean id="noteFacade" class="facade.NoteFacade">
        <property name="noteDAO" ref="noteDAO" />
    </bean>
</beans>

[Satish Kandagadla]

Originally posted by Jean Jorge Michel:
Hi,
Is not it, do not work ;(

I am looking in MySQL console (Windows� command prompt) and for all hit is open a new connection
This problem will kill my project, if I do not able to control this problem Spring + Hibernate will be removed from the project and I will be forced to use procedures + JDC (noooooo!!!).

Someone have any idea to help me?

Thanks.

My new attempt is:

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           <a href="http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/aop" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop</a>
                           <a href="http://www.springframework.org/schema/aop/spring-aop-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop/spring-aop-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a>
                           <a href="http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"></a>
 
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:/jdbc.properties"/>
    </bean>
 
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.driverClassName}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialPoolSize" value="3" />
        <property name="minPoolSize" value="3"/>
        <property name="maxPoolSize" value="6" />
        <property name="acquireIncrement" value="1" />
        <property name="maxStatements" value="0" />
        <property name="maxIdleTime" value="120" />
        <property name="checkoutTimeout" value="5000" />
    </bean>
 
    <bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="properties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
 
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"/>
        </property>
        <property name="hibernateProperties">
            <ref bean="hibernateProperties" />
        </property>
        <property name="annotatedClasses">
            <list>
                <value>.model.User</value>
                <value>.model.Note</value>
            </list>
        </property>
        <property name="annotatedPackages">
            <list>
                <value>.model</value>
            </list>
        </property>
    </bean>
 
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
        <property name="sessionFactory">
            <ref bean="sessionFactory" />
        </property>
    </bean>
 
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
 
    <bean class="org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator" />
 
    <bean class="org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor">
        <property name="transactionInterceptor" ref="txInterceptor"/>
    </bean>
 
    <bean id="txInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
        <property name="transactionManager" ref="transactionManager"/>
        <property name="transactionAttributeSource">
            <bean class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource"/>
        </property>
    </bean>
 
    <tx:annotation-driven transaction-manager="transactionManager"/>
    <bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>
 
    <!-- Beans -->
    <bean id="user" class="model.User" scope="session" />
    <bean id="note" class="model.Note" scope="session" />
 
    <!-- DAOs -->
    <bean id="userDAO" class="dao.UserDAO">
        <constructor-arg>
            <value>model.User</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <bean id="noteDAO" class="dao.NoteDAO">
        <constructor-arg>
            <value>model.Note</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <!-- Facades -->
    <bean id="userFacade" class="facade.UserFacade">
        <property name="userDAO" ref="userDAO" />
    </bean>
 
    <bean id="noteFacade" class="facade.NoteFacade">
        <property name="noteDAO" ref="noteDAO" />
    </bean>
</beans>

Your transaction beans are so confusing. Are you using all the beans in the configuration that you pasted above? I would first clean up the unused beans and give it a try.

[Jean Jorge Michel]

Satish, thanks for your attention.

I am new Spring�s user (of course hahaha), and this configuration is the result of hours and hours fighting with Spring and search on Google a silver bullet to save me.

Today on morning (now in Rio de Janeiro/Brazil is 10: 50AM) I tried:

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
                           <a href="http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/aop" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop</a> 
                           <a href="http://www.springframework.org/schema/aop/spring-aop-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop/spring-aop-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a> 
                           <a href="http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"></a>
 
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:/jdbc.properties"/>
    </bean>
 
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.driverClassName}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialPoolSize" value="3" />
        <property name="minPoolSize" value="3"/>
        <property name="maxPoolSize" value="6" />
        <property name="acquireIncrement" value="1" />
        <property name="maxStatements" value="0" />
        <property name="maxIdleTime" value="120" />
        <property name="checkoutTimeout" value="5000" />
    </bean>
 
    <bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="properties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.hbm2ddl.delimiter">type=InnoDB</prop>
            </props>
        </property>
    </bean>
 
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"/>
        </property>
        <property name="hibernateProperties">
            <ref bean="hibernateProperties" />
        </property>
        <property name="annotatedClasses">
            <list>
                <value>model.User</value>
                <value>model.Note</value>
            </list>
        </property>
        <property name="annotatedPackages">
            <list>
                <value>model</value>
            </list>
        </property>
    </bean>
 
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
        <property name="sessionFactory">
            <ref bean="sessionFactory" />
        </property>
    </bean>
 
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
 
    <tx:annotation-driven transaction-manager="transactionManager"/>
 
    <bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>
 
    <!-- Beans -->
    <bean id="user" class="model.User" scope="session" />
    <bean id="note" class="model.Note" scope="session" />
 
    <!-- DAOs -->
    <bean id="userDAO" class="dao.UserDAO">
        <constructor-arg>
            <value>model.User</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <bean id="noteDAO" class="dao.NoteDAO">
        <constructor-arg>
            <value>model.Note</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <!-- Facades -->
    <bean id="userFacade" class="facade.UserFacade">
        <property name="userDAO" ref="userDAO" />
    </bean>
 
    <bean id="noteFacade" class="facade.NoteFacade">
        <property name="noteDAO" ref="noteDAO" />
    </bean>
</beans>

And the problem is the same.

Let me show �all problem�.

I Start MySQL DB and log in, is created 2 connections.
When I start my Tomcat and do login my pool is initialized and is created three new connections.
After login my JSF navigation rule redirect the browser to home, this page search on DB my notes and show it in a table. In this point is created more three connections. Now I have 8 connections with MySQL.

My transaction management is ignored or my pool is crazy =)

Here is my codes.

First login flow.

Login backbean:
 
ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");
 
User userDB = ((UserFacadeInterface) appContext.getBean("userFacade")).searchByUsername(this.username);
 
Facade:
 
@Transactional
public class UserFacade implements UserFacadeInterface {
public User searchByUsername(final String username) {
return this.userDAO.searchByUsername(username);
}
}
 
DAO:
 
@Repository
public class UserDAO<T, PK extends Serializable> extends SpringDAO<T, PK> implements UserDAOInterface<T, PK> {
public User searchByUsername(String username) {
List<T> found = null;
DetachedCriteria criteria = DetachedCriteria.forClass(this.type);
criteria.add(Restrictions.eq("username", username));
found = getHibernateTemplate().findByCriteria(criteria);
return found.isEmpty() ? null : (User)found.get(0);
}
}

Second home flow:

Home backbean:
 
public void setNotes() {
ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");
this.notes = ((NoteFacadeInterface)appContext.getBean("noteFacade")).searchByOwner((User)this.facesContext.getExternalContext().getSessionMap().get("user"));
}
 
Facade:
 
@Transactional
public class NoteFacade implements NoteFacadeInterface {
public List<Note> searchByOwner(final User user) {
return this.noteDAO.searchByOwner(user);
}
}
 
DAO:
 
@Repository
public class NoteDAO<T, PK extends Serializable> extends SpringDAO<T, PK> implements NoteDAOInterface<T, PK> {
public List<T> searchByOwner(final User user) {
List<T> found = null;
DetachedCriteria criteria = DetachedCriteria.forClass(this.type);
criteria.add(Restrictions.eq("user", user));
criteria.addOrder(Order.asc("startDate"));
found = getHibernateTemplate().findByCriteria(criteria);
return found;
}
}

Some idea?

Thanks for all help.

[Satish Kandagadla]

Originally posted by Jean Jorge Michel:
Satish, thanks for your attention.

I am new Spring�s user (of course hahaha), and this configuration is the result of hours and hours fighting with Spring and search on Google a silver bullet to save me.

Today on morning (now in Rio de Janeiro/Brazil is 10: 50AM) I tried:

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
                           <a href="http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/beans/spring-beans-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/aop" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop</a> 
                           <a href="http://www.springframework.org/schema/aop/spring-aop-2.0.xsd" target="_blank" rel="nofollow">http://www.springframework.org/schema/aop/spring-aop-2.0.xsd</a>
                           <a href="http://www.springframework.org/schema/tx" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx</a> 
                           <a href="http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">" target="_blank" rel="nofollow">http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"></a>
 
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:/jdbc.properties"/>
    </bean>
 
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="${jdbc.driverClassName}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialPoolSize" value="3" />
        <property name="minPoolSize" value="3"/>
        <property name="maxPoolSize" value="6" />
        <property name="acquireIncrement" value="1" />
        <property name="maxStatements" value="0" />
        <property name="maxIdleTime" value="120" />
        <property name="checkoutTimeout" value="5000" />
    </bean>
 
    <bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="properties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.hbm2ddl.delimiter">type=InnoDB</prop>
            </props>
        </property>
    </bean>
 
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"/>
        </property>
        <property name="hibernateProperties">
            <ref bean="hibernateProperties" />
        </property>
        <property name="annotatedClasses">
            <list>
                <value>model.User</value>
                <value>model.Note</value>
            </list>
        </property>
        <property name="annotatedPackages">
            <list>
                <value>model</value>
            </list>
        </property>
    </bean>
 
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
        <property name="sessionFactory">
            <ref bean="sessionFactory" />
        </property>
    </bean>
 
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
 
    <tx:annotation-driven transaction-manager="transactionManager"/>
 
    <bean class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>
 
    <!-- Beans -->
    <bean id="user" class="model.User" scope="session" />
    <bean id="note" class="model.Note" scope="session" />
 
    <!-- DAOs -->
    <bean id="userDAO" class="dao.UserDAO">
        <constructor-arg>
            <value>model.User</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <bean id="noteDAO" class="dao.NoteDAO">
        <constructor-arg>
            <value>model.Note</value>
        </constructor-arg>
        <property name="hibernateTemplate">
            <ref bean="hibernateTemplate"/>
        </property>
    </bean>
 
    <!-- Facades -->
    <bean id="userFacade" class="facade.UserFacade">
        <property name="userDAO" ref="userDAO" />
    </bean>
 
    <bean id="noteFacade" class="facade.NoteFacade">
        <property name="noteDAO" ref="noteDAO" />
    </bean>
</beans>

And the problem is the same.

Let me show �all problem�.

I Start MySQL DB and log in, is created 2 connections.
When I start my Tomcat and do login my pool is initialized and is created three new connections.
After login my JSF navigation rule redirect the browser to home, this page search on DB my notes and show it in a table. In this point is created more three connections. Now I have 8 connections with MySQL.

My transaction management is ignored or my pool is crazy =)

Here is my codes.

First login flow.

Login backbean:
 
ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");
 
User userDB = ((UserFacadeInterface) appContext.getBean("userFacade")).searchByUsername(this.username);
 
Facade:
 
@Transactional
public class UserFacade implements UserFacadeInterface {
public User searchByUsername(final String username) {
return this.userDAO.searchByUsername(username);
}
}
 
DAO:
 
@Repository
public class UserDAO<T, PK extends Serializable> extends SpringDAO<T, PK> implements UserDAOInterface<T, PK> {
public User searchByUsername(String username) {
List<T> found = null;
DetachedCriteria criteria = DetachedCriteria.forClass(this.type);
criteria.add(Restrictions.eq("username", username));
found = getHibernateTemplate().findByCriteria(criteria);
return found.isEmpty() ? null : (User)found.get(0);
}
}

Second home flow:

Home backbean:
 
public void setNotes() {
ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");
this.notes = ((NoteFacadeInterface)appContext.getBean("noteFacade")).searchByOwner((User)this.facesContext.getExternalContext().getSessionMap().get("user"));
}
 
Facade:
 
@Transactional
public class NoteFacade implements NoteFacadeInterface {
public List<Note> searchByOwner(final User user) {
return this.noteDAO.searchByOwner(user);
}
}
 
DAO:
 
@Repository
public class NoteDAO<T, PK extends Serializable> extends SpringDAO<T, PK> implements NoteDAOInterface<T, PK> {
public List<T> searchByOwner(final User user) {
List<T> found = null;
DetachedCriteria criteria = DetachedCriteria.forClass(this.type);
criteria.add(Restrictions.eq("user", user));
criteria.addOrder(Order.asc("startDate"));
found = getHibernateTemplate().findByCriteria(criteria);
return found;
}
}

Some idea?

Thanks for all help.

I do not see anything wrong with the transaction beans. How are you saying that the transaction attributes are not working? What are you expecting from the annotations given in your application?

[Jean Jorge Michel]

Guys, I resolved this error.

In a Brazilian JUG e-mail list (RSJUG) one participant named Julio told me that I should start Spring`s context together my application and not instantiate in every backbean`s method an ApplicationContext object. It was my error, creating always a new instance of my pool, etc�

Searching in Google I found how make it and now all it is working fine

My web.xml:

<context-param> 
    <param-name>contextConfigLocation</param-name> 
    <param-value>/WEB-INF/classes/applicationContext.xml</param-value>
</context-param>
 
<listener>
    <listener-lass>
        org.springframework.web.context.ContextLoaderListener 
    </listener-class> 
</listener>

In faces-config.xml I defined that the backbean receive a facade.

<managed-bean> 
    <managed-bean-name>login</managed-bean-name> 
    <managed-bean-class>backbeans.Login</managed-bean-class> 
    <managed-bean-scope>request</managed-bean-scope> 
    <managed-property> 
        <property-name>userFacade</property-name> 
        <value>#{userFacade}</value> 
    </managed-property> 
</managed-bean>

Set how resolves this EL expression

In faces-config.xml too:

      <!-- Allows you to inject Spring beans into JSF managed beans --> 
      <variable-resolver> 
            org.springframework.web.jsf.DelegatingVariableResolver 
      </variable-resolver>

In login backbean have an attribute named userFacade, getters and setters to this and none instantiate code of ApplicationContext object, Spring inject it to me.

Thanks for all answers.