commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rama Krishna (JIRA)" <j...@apache.org>
Subject [jira] Created: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
Date Wed, 03 Oct 2007 13:49:51 GMT
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:

<Context path="/MY_WEB"  allowLinking="true">
       <Resource name="jdbc/MYWEB_Oracle"
                        auth="Container"
                        type="javax.sql.DataSource"
                        factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
                        username="ocsweb"
                        password="dsa432"
                        driverClassName="oracle.jdbc.driver.OracleDriver"
                        url="jdbc:oracle:thin:@(DESCRIPTION= (FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=XXX)(PORT=1525))(ADDRESS=(PROTOCOL=TCP)(HOST=XXXX)(PORT=1525)))(CONNECT_DATA=(SERVER=DEDICATED)
(SERVICE_NAME=MYD)))"
                        maxWait="1000"
                        removeAbandoned="true"
                        maxActive="20"
                        maxIdle="6"
                        removeAbandonedTimeout="60"
                        logAbandoned="true"/>
		<!-- Allow the following of the symbolic link -->		
		<Resources className="org.apache.naming.resources.FileDirContext" allowLinking="true"
 />
</Context>

Please advise.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message