You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Phil Steitz (JIRA)" <ji...@apache.org> on 2007/10/07 18:07:51 UTC
[jira] Updated: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
[ https://issues.apache.org/jira/browse/DBCP-243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phil Steitz updated DBCP-243:
-----------------------------
Affects Version/s: 1.2.1
>From stack trace line numbers, looks like tomcat-bundled 1.2.1source.
> Oracle 10G loadbalanced DB - ERROR
> ----------------------------------
>
> Key: DBCP-243
> URL: https://issues.apache.org/jira/browse/DBCP-243
> Project: Commons Dbcp
> Issue Type: Bug
> Affects Versions: 1.2.1
> 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.