RE: Enhydra digest, Vol 1 #454 - 4 msgs

> If you use directly DBConnection objects, you must always explicitly
> call the DBConnection.handleException(SQLException) method when an
> SQLException to inform the DatabaseManager. Depending on the reason of
> the exception, the DatabaseManager will drop the connection from the
> pool (a SQL syntax error will not drop it, a network error will...).
> Note : If you have to restart the database server, every DBConnection
> previously in the pool will be invalid, so an SQL exception will occur
> for each DBConnection, until every DBConnection is dropped.
>
>--
>Frederic Garzon  <Frederic.Garzon@xxxxxxxx>

Hi,

The handleException() method is already being called in the existing code.
The exception I'm getting does not appear to be an SQLException, but a
SocketException:

com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException:
Connection reset by peer: socket write error



Cheers,

Richard Edwards

Software Developer
Softtech NZ Ltd
Ph: +649 414 6940
Fax: +649 414 6941