avalon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Yates <cya...@lanelib.stanford.edu>
Subject Re: JdbcDataSource question
Date Wed, 09 Jan 2002 21:03:52 GMT
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:avalon-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:avalon-dev-help@jakarta.apache.org>


Mime
View raw message