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