Problems with Session and transaction handling?

JSF-Version: 1.1
Spring-Version: 1.2.8
spring-aop.ar Spring-Version: 1.2.4
Hibernate-version: 3.1.3
weblogic 8i

We are handling transaction By custom interceptor (TransactionInterceptor) while creating transaction we are getting following Exception

org.springframework.transaction.CannotCreateTransactionException
: Could not open Hibernate Session for transaction; nested exception is org.hibernate.SessionException: Session is closed!

In production it is erratic behavior . If we try second time it will not give Exception .We tried to reproduce with our full effort but once our twice it comes. What could be the reason.

Thanks in Advance

Hi ,
We have faced the same problem. But when we did the root cause anaysis we found that the following.

In business object method we are opening a session and before returning we r closing the session.
But In one method we have made a call to one more method. So the secong method closed the session but the remaining part of the first method still using the session.

It may help You.

hi vrsreenath,

Thanks for reply,

In your case you will get every time this exception. In My case This is first method which start in transaction and hibernate starts creating transaction while creating transaction its get this exception (some time).Other method we have used same session. As I told we have used Interceptor .Even method is not called .It gets exception before method call

Our Hibernate Setting is

<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="JNDI" />
</bean>

<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mappingResources">
<list><value>XYZ.hbm.xml</value></list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
<prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
<prop key="hibernate.connection.release_mode">auto </prop>
<prop key="hibernate.transaction.auto_close_session">false</prop>
<prop key="hibernate.show_sql">true</prop><prop key="hibernate.connection.autocommit">false</prop>
</props>
</property>
</bean>
<bean id="txManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>

and we are getting session by factory.getCurrentSession() in interceptor

That might help you guys to help me.

Hi,
Guys ,Hibernate Team .It is production issue. we are not able to reproduce in locally.Any suggestion that might help

Hi all,

Just want to close that issue .It was due to threadlocal by Hibernate Util class pattern with in cluster env with TransactionInterceptor (Spring) .Because TransactionInterceptor also use threadlocal .So removing Hibernate Util from code had solved our problem.