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

Spring JIRA | Shauli Baror | 1 decade ago
  1. 0

    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>

    Spring JIRA | 1 decade ago | Shauli Baror
    java.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.
  2. 0

    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>

    Spring JIRA | 1 decade ago | Shauli Baror
    java.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.
  3. 0

    Exception: Attempt to access a harvested connection - weblogic jdbc connection pool

    Stack Overflow | 2 years ago | Unreal user
    java.sql.SQLException: Attempt to access a harvested connection[[
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JConnect5.5 & WebLogic8.1SP3

    narkive.com | 1 year ago
    java.sql.SQLException: Connection has already been closed. at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:63)
  6. 0

    Connection pool returning non-active connection ?

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: The transaction is no longer active (status = Committed). No further JDBC access is allowed within this transaction.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. weblogic.jdbc.wrapper
      Connection.preInvocationHandler
      1. weblogic.jdbc.wrapper.JTSConnection.checkIfRolledBack(JTSConnection.java:118)
      2. weblogic.jdbc.wrapper.JTSConnection.checkConnection(JTSConnection.java:127)
      3. weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:70)
      3 frames