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(DelegatingConnection.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]>
