Can somebody help me with this I am getting this strange error . I am using Hibernate 3.0 with Weblogic 8.1, Oracle 9 database with 10g driver

ava.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.
at weblogic.jdbc.wrapper.JTSConnection.checkIfRolledBack(JTSConnection.java:118)
at weblogic.jdbc.wrapper.JTSConnection.checkConnection(JTSConnection.java:127)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:316)
at weblogic.jdbc.wrapper.JTSConnection.prepareStatement(JTSConnection.java:425)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:356)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:307)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1065)
at org.hibernate.loader.Loader.doQuery(Loader.java:356)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:199)
at org.hibernate.loader.Loader.doList(Loader.java:1417)
at org.hibernate.loader.Loader.list(Loader.java:1400)
at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:876)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:831)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at com.wos.dao.AdminDAO.getGroupListForUser(AdminDAO.java:978)
at com.wos.bean.AdminBean.getGroupListForUser(AdminBean.java:233)
at com.wos.bean.WOSAdmin_whklez_EOImpl.getGroupListForUser(WOSAdmin_whklez_EOImpl.java:1342)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


HIbernate cfg


<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory >

<!-- local connection properties start -->

<property name="hibernate.connection.url">
jdbc:oracle:thin:@mname1:1521:dev
</property>

<property name="hibernate.connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>

<!-- local connection properties end -->

<!-- datasource connection properties -->

<property name="connection.datasource">orchestration-client-Pool</property>
<property name="hibernate.jndi.url">t3://mname:7001</property>
<property name="hibernate.jndi.class">weblogic.jndi.WLInitialContextFactory</property>
<!-- <property name="hibernate.connection.username">root</property> -->

<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.jdbc.batch_size">25</property>
<property name="hibernate.use_outer_join">true</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.transaction.factory_class">
org.hibernate.transaction.JTATransactionFactory
</property>
<!--<property name="hibernate.jdbc.batch_versioned_data">true</property>-->

<property name="hibernate.transaction.manager_lookup_class">
org.hibernate.transaction.WeblogicTransactionManagerLookup
</property>
<!--<property name="hibernate.jdbc.use_streams_for_binary">true</property>-->
<!-- <property name="SetBigStringTryClob">true</property>
-->
<property name="hibernate.cglib.use_reflection_optimizer">false</property>


<property name="jta.UserTransaction">java:comp/UserTransaction</property>

<property name="hibernate.show_sql">true</property>
<mapping resource="ProcessLogs.hbm" />
<mapping resource="ProcessInstances.hbm" />
<mapping resource="ServiceInstances.hbm" />
<mapping resource="ProcessModels.hbm" />
<mapping resource="PmUser.hbm" />
<mapping resource="PmGroupUser.hbm" />
<mapping resource="ServiceRoles.hbm" />
<mapping resource="SystemServices.hbm" />
<mapping resource="ProcessServices.hbm" />
<mapping resource="PmGroup.hbm" />
</session-factory>


</hibernate-configuration>

Hi

Did you get any response for this. Incidently we also have the issue and wondering whether you resolved it.

Thanks

Ditto - I have the same issue as well. Any help here would be greatly appreciated. Thanks.

Hi All,
The problem seems to go away if you explicitly close the session. but this is not the intended behaviour.

in case any body has any other suggestion, please do help.

Thanks
Warm regards
Kiran