Challenge ! Hibernate, Spring and the Transactions...

[Benett Corp]

Hello @ all !

I'm facing a problem with Hibernate, Spring and the transactions : "[save|createQuery] is not valid without active transaction". I'm using a datasource configured with Tomcat, and I want to use the AOP for the transaction management :

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
 <property name="mappingResources">
  <list>
   <!--[all my mappings]-->
  </list>
 </property>
 <property name="hibernateProperties">
  <value>
   hibernate.connection.datasource=java:comp/env/jdbc/myapp
   hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
   hibernate.current_session_context_class=thread
   hibernate.transaction.factory_class=org.springframework.orm.hibernate3.SpringTransactionFactory
   hibernate.show_sql=true
  </value>
 </property>
</bean>
 
<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
 <property name="sessionFactory" ref="sessionFactory" />
</bean>
 
<tx:advice id="txAdvice" transaction-manager="txManager">
 <tx:attributes>
  <tx:method name="get*" read-only="true" />
  <tx:method name="*" isolation="READ_COMMITTED" rollback-for="com.myapp.framework.exception.ManagerException" />
 </tx:attributes>
</tx:advice>
 
<aop:config>
 <aop  :-P	  ointcut id="pcManager1" expression="execution(public * com.myapp.framework.dao.manager..*(..))" />
 <aop  :-P	  ointcut id="pcManager2" expression="execution(public * com.myapp.dao.manager..*(..))"/>
 <aop:advisor advice-ref="txAdvice" pointcut-ref="pcManager1" />
 <aop:advisor advice-ref="txAdvice" pointcut-ref="pcManager2" />
</aop:config>

All things seems to be good in the log :

opened session at timestamp: 12306501743
2008-12-30 16:16:14,344 - DEBUG [org.hibernate.jdbc.ConnectionManager] (ConnectionManager.java:415) - opening JDBC connection
2008-12-30 16:16:14,344 - DEBUG [org.hibernate.transaction.JDBCTransaction] (JDBCTransaction.java:54) - begin
2008-12-30 16:16:14,344 - DEBUG [org.hibernate.transaction.JDBCTransaction] (JDBCTransaction.java:59) - current autocommit status: true
2008-12-30 16:16:14,344 - DEBUG [org.hibernate.transaction.JDBCTransaction] (JDBCTransaction.java:62) - disabling autocommit
2008-12-30 16:16:14,344 - DEBUG [org.hibernate.impl.SessionImpl] (SessionImpl.java:220) - opened session at timestamp: 12306501743

and if I call an update method on the session, I get an exception :

session = ((SessionFactory) MyBeanFactoryFromSpring.getInstance().getBean(BeanConstants.SESSION_FACTORY)).getCurrentSession();
session.save(myObject);

.. results in ..

org.hibernate.HibernateException: save is not valid without active transaction
 at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:297)
...

Moreover, the transaction that seemed to be opened before just rollbacks !!

2008-12-30 16:16:14,376 - DEBUG [org.hibernate.transaction.JDBCTransaction] (JDBCTransaction.java:152) - rollback
2008-12-30 16:16:14,376 - DEBUG [org.hibernate.transaction.JDBCTransaction] (JDBCTransaction.java:193) - re-enabling autocommit
2008-12-30 16:16:14,376 - DEBUG [org.hibernate.transaction.JDBCTransaction] (JDBCTransaction.java:163) - rolled back JDBC Connection
2008-12-30 16:16:14,376 - DEBUG [org.hibernate.jdbc.ConnectionManager] (ConnectionManager.java:296) - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2008-12-30 16:16:14,376 - DEBUG [org.hibernate.jdbc.ConnectionManager] (ConnectionManager.java:435) - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]

Any idea on this "double transaction" ?
[ December 30, 2008: Message edited by: Benett Corp ]

[Benett Corp]

Sorry for the smileys in the previous codes

By the way, when I replace the "save" call by a "throw new UnsupportedOperationException()", the rollbak seems to be processed...

Something important : when I use "session.beginTransaction()" and "session.getTransaction.commit()", everything works. owever, this is not the way i want to use transactions...

Anyone has already done some jobs about these transactions (spring + hibernate) ?
[ December 30, 2008: Message edited by: Benett Corp ]