commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phil Steitz (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DBCP-243) Oracle 10G loadbalanced DB - ERROR
Date Sun, 07 Oct 2007 16:07:51 GMT

     [ 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.


Mime
View raw message