Thank you,
but still having the same problem. My keep-alive statement does not
seem to be being executed (I can put nonsense in there and no exception
is thrown). I'll attach my configuration file and a section of my
servers log. I'm using the Excalibur 4.0 distribution.
Charles
==================================================================
<circ-conf>
<jdbc logger="jdbc">
<pool-controller min="2" max="4">
<keep-alive>SELECT 1 FROM DUAL</keep-alive>
</pool-controller>
<driver>oracle.jdbc.driver.OracleDriver</driver>
<dburl>jdbc:oracle:thin:@***.****.****:****:****</dburl>
<user>****</user>
<password>*****</password>
</jdbc>
<listener logger="listener">
<server-port>9999</server-port>
<stop-port>9998</stop-port>
</listener>
<source logger="source"/>
<response logger="response"/>
<worker logger="worker"/>
</circ-conf>
======================================================================
DEBUG Jan 09 2002 11:43:01.229 jdbc: Retrieving a
org.apache.avalon.excalibur.datasource.JdbcConnection from the pool
ERROR Jan 09 2002 11:43:01.230 source: java.sql.SQLException: Io
exception: Broken pipe
java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:445)
at
oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:477)
at
oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:386)
at
org.apache.avalon.excalibur.datasource.JdbcConnection.createStatement(Unknown Source)
at
edu.stanford.medlane.circserver.DataSourceImpl.getBibID(DataSourceImpl.java:156)
at
edu.stanford.medlane.circserver.DataSourceImpl.getStatus(DataSourceImpl.java:65)
at
edu.stanford.medlane.circserver.WorkerThreadImpl.run(WorkerThreadImpl.java:84)
at java.lang.Thread.run(Thread.java:498)
DEBUG Jan 09 2002 11:43:01.236 jdbc: Returning a
org.apache.avalon.excalibur.datasource.JdbcConnection to the pool
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
