On Tuesday, January 21, 2003, 9:56:09 AM, david wrote:
dc> Hi, I am using a connection pool from
dc> org.apache.commons.dbcp.BasicDataSourceFactory and the driver is
dc> oracle.jdbc.driver.OracleDriver. It works great until if the
dc> server idle for a few days, then the connection object seems
dc> broken with this error: ==== begin error mesg ===
dc> java.sql.SQLException: Io exception: Software caused connection
dc> abort: socket wr ite error at
I believe I had similar problems here as well but it usually only
happened when the DBA would for some reason decide to kill connections
that were open. I went with configuring the pooling with whatever
comes packaged with Tomcat and configuring it in the server.xml
making sure to add the extra overhead of performing a validation query
<parameter>
<name>validationQuery</name>
<value>SELECT 'CRAP' FROM DUAL</value>
</parameter>
Not sure what app server you are running but maybe somewhere you can
set up a similar parameter to make sure it is handing out a valid
connection from the pool. I'm pretty clueless when it comes to this
stuff and just followed some examples I saw. Until I added the above
validationQuery I believe I got similar errors to what you
experienced.
--
Rick
mailto:[EMAIL PROTECTED]
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
