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]>