Return-Path: Delivered-To: apmail-commons-issues-archive@locus.apache.org Received: (qmail 63940 invoked from network); 3 Oct 2007 13:50:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Oct 2007 13:50:45 -0000 Received: (qmail 16349 invoked by uid 500); 3 Oct 2007 13:50:32 -0000 Delivered-To: apmail-commons-issues-archive@commons.apache.org Received: (qmail 16047 invoked by uid 500); 3 Oct 2007 13:50:31 -0000 Mailing-List: contact issues-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: issues@commons.apache.org Delivered-To: mailing list issues@commons.apache.org Received: (qmail 16037 invoked by uid 99); 3 Oct 2007 13:50:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Oct 2007 06:50:31 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Oct 2007 13:50:41 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 4A01F71403E for ; Wed, 3 Oct 2007 06:49:51 -0700 (PDT) Message-ID: <2449328.1191419391293.JavaMail.jira@brutus> Date: Wed, 3 Oct 2007 06:49:51 -0700 (PDT) From: "Rama Krishna (JIRA)" To: issues@commons.apache.org Subject: [jira] Created: (DBCP-243) Oracle 10G loadbalanced DB - ERROR MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Oracle 10G loadbalanced DB - ERROR ---------------------------------- Key: DBCP-243 URL: https://issues.apache.org/jira/browse/DBCP-243 Project: Commons Dbcp Issue Type: Bug Environment: unix Reporter: Rama Krishna Hi, We have changed the my db from Oracle 9i to Oracle 10G loadbalanced DB now. After changing to Oracle 10G we are getting the following error some times this is not happning in Oracle 9i. Oct 3, 2007 9:15:52 AM net.sf.hibernate.transaction.JDBCTransaction commit SEVERE: Commit failed java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1112) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:63) at com.hp.ocs.shared.filter.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at com.hp.websat.timber.transaction.TransactionLoggingFilter.doFilter(TransactionLoggingFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.jk.server.JkCoyoteHandler.invoke(Unknown Source) at org.apache.jk.common.HandlerRequest.invoke(Unknown Source) at org.apache.jk.common.ChannelSocket.invoke(Unknown Source) at org.apache.jk.common.ChannelSocket.processConnection(Unknown Source) at org.apache.jk.common.SocketConnection.runIt(Unknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Thread.java:595) Oct 3, 2007 9:15:52 AM net.sf.hibernate.transaction.JDBCTransaction toggleAutoCommit SEVERE: Could not toggle autocommit java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:1038) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293) at net.sf.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:104) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:74) at com.hp.ocs.shared.filter.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at com.hp.websat.timber.transaction.TransactionLoggingFilter.doFilter(TransactionLoggingFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.jk.server.JkCoyoteHandler.invoke(Unknown Source) at org.apache.jk.common.HandlerRequest.invoke(Unknown Source) at org.apache.jk.common.ChannelSocket.invoke(Unknown Source) at org.apache.jk.common.ChannelSocket.processConnection(Unknown Source) at org.apache.jk.common.SocketConnection.runIt(Unknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Thread.java:595) 03.10.2007 09:15:52 *ERROR* [TP-Processor24] Filter: [498C0A304CA8FD8C28071ACF4B24C21B.g3u1109c, [None] ] Something goes wrong in a servlet !net.sf.hibernate.TransactionException: Commit failed with SQL exception: at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:71) at com.hp.ocs.shared.filter.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at com.hp.websat.timber.transaction.TransactionLoggingFilter.doFilter(TransactionLoggingFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source) at org.apache.jk.server.JkCoyoteHandler.invoke(Unknown Source) at org.apache.jk.common.HandlerRequest.invoke(Unknown Source) at org.apache.jk.common.ChannelSocket.invoke(Unknown Source) at org.apache.jk.common.ChannelSocket.processConnection(Unknown Source) at org.apache.jk.common.SocketConnection.runIt(Unknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1112) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:63) ... 22 more (OcsLogger.java, line 124) Oct 3, 2007 9:15:52 AM net.sf.hibernate.util.JDBCExceptionReporter logExceptions Here is my contax.xml: Please advise. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.