After waiting 24 hours, I'm still experiencing the same problem with Oracle and a connection pool (DBCP) in Tomcat. I guess I'll try configuring Oracle's connection pool??
Matt > -----Original Message----- > From: Raible, Matt > Sent: Tuesday, January 21, 2003 8:22 AM > To: 'Struts Users Mailing List' > Subject: RE: db connection pool question > > > Actually, the solution that I had only works for MySQL. I'm > having the same problem with Oracle. Funny - I just posted a > message to the commons-user group asking this same question. > I'll try adding the validationQuery parameter: > > <parameter> > <name>validationQuery</name> > <value>SELECT 'CRAP' FROM DUAL</value> > </parameter> > > Thanks, > > Matt > > > -----Original Message----- > > From: Pani, Gourav [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 7:58 AM > > To: 'Struts Users Mailing List' > > Subject: RE: db connection pool question > > > > > > please look at the thread with subject "Problem with JDBC & Struts > > Connection Pool (possible to recon nect?)". Matt Raible had > > a solution to > > that by setting autoReconnect=true > > > > -----Original Message----- > > From: david chan [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 9:56 AM > > To: Struts Users Mailing List > > Subject: db connection pool question > > > > > > Hi, > > I am using a connection pool from > > org.apache.commons.dbcp.BasicDataSourceFactory and the > > driver is oracle.jdbc.driver.OracleDriver. It works > > great until if the server idle for a few days, then > > the connection object seems broken with this error: > > ==== begin error mesg === > > java.sql.SQLException: Io exception: Software caused > > connection abort: socket wr > > ite error at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) > > at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) > > at > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323) > > at > > oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417) > > at > > oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432) > > at > > > oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedState > > ment.java:182) at > > > oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleCon > > nection.java:602) at > > > oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection > > .java:538) at > > org.apache.commons.dbcp.DelegatingConnection.prepareStatement( > > DelegatingConn > > ection.java:197) > > ... > > ===== end of error mesg ==== > > > > What happen and how can I prevent this? > > Thanks. > > David > > > > > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > http://mailplus.yahoo.com > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>