java.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I have the same problem exsactly as described in issue 'SPR-501': java.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.preInvocationHandler(Connection.java:70) . . . I am not using hibernate.properties as I use registry.xml in the following way, as you can see I trued to specify a WebLogic-specific TransactionManagerLookup as you said but probably incorrectly.... Can you please advice what is wrong: my registry.xml file: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="jndiTransactionManager" class="org.springframework.transaction.jta.WebLogicServerTransactionManagerFactoryBean"> </bean> <!-- Jta platform tm --> <bean id="transactionManager" class="org.springframework.transaction.jta.WebLogicJtaTransactionManager"> <property name="transactionManager"> <ref local="jndiTransactionManager"/> </property> </bean> <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName"> <value>TangoOracleDS</value> </property> </bean> <!-- Hibernate SessionFactory --> <bean id="hb8SessionFactory" class="com.bmc.idm.ctsa.common.inbound.config.CTSALocalSessionFactoryBean" destroy-method="destroy"> <property name="dataSource"> <ref local="dataSource"/> </property> <property name="jtaTransactionManager"> <ref local="jndiTransactionManager"/> </property> <property name="hibernateProperties"> <props> <!--<prop key="query.substitutions">true 1, false 0, yes 'Y', no 'N'</prop>--> <prop key="hibernate.dialect">net.sf.hibernate.dialect.OracleDialect</prop> <prop key="jdbc.batch_size">0</prop> <prop key="jdbc.use_streams_for_binary">true</prop> <prop key="max_fetch_depth">3</prop> <!-- <prop key="cache.provider_class">net.sf.hibernate.cache.EhCacheProvider</prop>--> <!-- <prop key="cache.use_query_cache">true</prop>--> <prop key="show_sql">true</prop> </props> </property> </bean> </beans>
    via by Shauli Baror,
  • I have the same problem exsactly as described in issue 'SPR-501': java.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.preInvocationHandler(Connection.java:70) . . . I am not using hibernate.properties as I use registry.xml in the following way, as you can see I trued to specify a WebLogic-specific TransactionManagerLookup as you said but probably incorrectly.... Can you please advice what is wrong: my registry.xml file: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="jndiTransactionManager" class="org.springframework.transaction.jta.WebLogicServerTransactionManagerFactoryBean"> </bean> <!-- Jta platform tm --> <bean id="transactionManager" class="org.springframework.transaction.jta.WebLogicJtaTransactionManager"> <property name="transactionManager"> <ref local="jndiTransactionManager"/> </property> </bean> <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName"> <value>TangoOracleDS</value> </property> </bean> <!-- Hibernate SessionFactory --> <bean id="hb8SessionFactory" class="com.bmc.idm.ctsa.common.inbound.config.CTSALocalSessionFactoryBean" destroy-method="destroy"> <property name="dataSource"> <ref local="dataSource"/> </property> <property name="jtaTransactionManager"> <ref local="jndiTransactionManager"/> </property> <property name="hibernateProperties"> <props> <!--<prop key="query.substitutions">true 1, false 0, yes 'Y', no 'N'</prop>--> <prop key="hibernate.dialect">net.sf.hibernate.dialect.OracleDialect</prop> <prop key="jdbc.batch_size">0</prop> <prop key="jdbc.use_streams_for_binary">true</prop> <prop key="max_fetch_depth">3</prop> <!-- <prop key="cache.provider_class">net.sf.hibernate.cache.EhCacheProvider</prop>--> <!-- <prop key="cache.use_query_cache">true</prop>--> <prop key="show_sql">true</prop> </props> </property> </bean> </beans>
    via by Shauli Baror,
  • JConnect5.5 & WebLogic8.1SP3
    via by Unknown author,
    • java.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.preInvocationHandler(Connection.java:70)

    Users with the same issue

    Unknown visitor1 times, last one,
    WoodenDoors
    WoodenDoors1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,