java.sql.SQLException

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.

  • The spring's context contains JTATransactionManager set up with WebLogic's TM JNDI location, and of course a JNDI datasource. I also use weblogic's XA wrappers around plain Oracle (non-XA) connections. Below is a fragment of a exception's stacktrace I got in weblogic jdbc.log (jdbc debug feature turned on). This exception seems to be swallowed by weblogic itself, as it does not appear in any other logs. I can't say if it affects how weblogic manages connections. Also weblogic connection profiling shows no leaked connections. Classic "dao" approach is to close connection in the same method that it was obtained from datasource, within a "finally" block. And for sure within a transaction scope. Just wondering if it is allowable in J2EE environment to close connections after associated transaction has been finished (commited/rolledback). Here goes an exception: 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) at weblogic.jdbc.wrapper.JTSConnection_oracle_jdbc_driver_OracleConnection.getWarnings(Unknown Source) at net.sf.hibernate.impl.BatcherImpl.closeConnection(BatcherImpl.java:297) at net.sf.hibernate.impl.SessionImpl.disconnect(SessionImpl.java:3352) at net.sf.hibernate.impl.SessionImpl.close(SessionImpl.java:576) at org.springframework.orm.hibernate.SessionFactoryUtils.doClose(SessionFactoryUtils.java:651) at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:640) at org.springframework.orm.hibernate.SessionFactoryUtils.access$300(SessionFactoryUtils.java:86) at org.springframework.orm.hibernate.SessionFactoryUtils$SpringSessionSynchronization.afterCompletion(SessionFactoryUtils.java:804) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:547) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:408) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:242) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143) at org.springframework.aop.interceptor.PerformanceMonitorInterceptor.invoke(PerformanceMonitorInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143) at
    via by Tomasz Wysocki,
  • The spring's context contains JTATransactionManager set up with WebLogic's TM JNDI location, and of course a JNDI datasource. I also use weblogic's XA wrappers around plain Oracle (non-XA) connections. Below is a fragment of a exception's stacktrace I got in weblogic jdbc.log (jdbc debug feature turned on). This exception seems to be swallowed by weblogic itself, as it does not appear in any other logs. I can't say if it affects how weblogic manages connections. Also weblogic connection profiling shows no leaked connections. Classic "dao" approach is to close connection in the same method that it was obtained from datasource, within a "finally" block. And for sure within a transaction scope. Just wondering if it is allowable in J2EE environment to close connections after associated transaction has been finished (commited/rolledback). Here goes an exception: 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) at weblogic.jdbc.wrapper.JTSConnection_oracle_jdbc_driver_OracleConnection.getWarnings(Unknown Source) at net.sf.hibernate.impl.BatcherImpl.closeConnection(BatcherImpl.java:297) at net.sf.hibernate.impl.SessionImpl.disconnect(SessionImpl.java:3352) at net.sf.hibernate.impl.SessionImpl.close(SessionImpl.java:576) at org.springframework.orm.hibernate.SessionFactoryUtils.doClose(SessionFactoryUtils.java:651) at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:640) at org.springframework.orm.hibernate.SessionFactoryUtils.access$300(SessionFactoryUtils.java:86) at org.springframework.orm.hibernate.SessionFactoryUtils$SpringSessionSynchronization.afterCompletion(SessionFactoryUtils.java:804) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:547) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:408) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:242) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143) at org.springframework.aop.interceptor.PerformanceMonitorInterceptor.invoke(PerformanceMonitorInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143) at
    via by Tomasz Wysocki,
  • 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,
    • 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) at weblogic.jdbc.wrapper.JTSConnection_oracle_jdbc_driver_OracleConnection.getWarnings(Unknown Source) at net.sf.hibernate.impl.BatcherImpl.closeConnection(BatcherImpl.java:297) at net.sf.hibernate.impl.SessionImpl.disconnect(SessionImpl.java:3352) at net.sf.hibernate.impl.SessionImpl.close(SessionImpl.java:576) at org.springframework.orm.hibernate.SessionFactoryUtils.doClose(SessionFactoryUtils.java:651) at org.springframework.orm.hibernate.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:640) at org.springframework.orm.hibernate.SessionFactoryUtils.access$300(SessionFactoryUtils.java:86) at org.springframework.orm.hibernate.SessionFactoryUtils$SpringSessionSynchronization.afterCompletion(SessionFactoryUtils.java:804) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:547) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:408) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:242) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143) at org.springframework.aop.interceptor.PerformanceMonitorInterceptor.invoke(PerformanceMonitorInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143)

    Users with the same issue

    WoodenDoors
    1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,