You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Rama Krishna (JIRA)" <ji...@apache.org> on 2007/10/03 15:49:51 UTC
[jira] Created: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
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.
[jira] Closed: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DBCP-243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phil Steitz closed DBCP-243.
----------------------------
Resolution: Fixed
See last comment. If there is evidence that Oracle is not closing the connections, pls reopen.
> 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.
[jira] Updated: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DBCP-243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532981 ]
Phil Steitz commented on DBCP-243:
----------------------------------
>From the stack traces, it looks like the underlying physical connection is being closed without DBCP
initiating the close (unless this is in fact a DBCP bug). According to the docs here:
http://download-uk.oracle.com/docs/cd/B14117_01/java.101/b10979/fastconnfail.htm#CIHGGBBJ
this can happen if the database is failing over.
> 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.