Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Java-Pooling, restart and exception
You could also create a daemon thread that closes the connection after a specified period of activity (probably a good idea, anyway.)
brian
-- Brian Krahmer - brian@krahmer.com - http://www.krahmer.com Sr. Engineer - Symantec Corporation - http://www.symantec.com "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote in message news:3A2FC503.68ED021D_at_rationalconcepts.com...Received on Sat Dec 09 2000 - 19:17:44 CST
> 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.
>