Re: Java-Pooling, restart and exception

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Thu, 07 Dec 2000 17:09:44 GMT
Message-ID: <3A2FC503.68ED021D@rationalconcepts.com>

Hi,
you could trap the exception and close and reopen the connection when it occurs,
then try reprocessing the statement that was supposed to execute.

Attempt it at a maximum number of times and then issue the error to the client.

just one idea,
cindy

Weasel wrote:

> Hi!
> I've got a pooling class for handling connections to an Oracle DB. The
> pooling class is used for servlets. Every night the database is
> shutdown by the sysadm for backup and is restarted again as soon as the
> backup is fdinished.
>
> When I try to use the class the morning after(yes, the vm holds the
> pool class) I get a "java.sql.SQLException: Io exception: Broken pipe".
> In my pool I check if connections are null and con.isClosed() and both
> of them are false.
>
> Any suggestions?
>
> --
> Pop goes the weasel and the weasel goes pop!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 07 2000 - 11:09:44 CST