Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Java-Pooling, restart and exception

Re: Java-Pooling, restart and exception

From: Brian Krahmer <brian_at_krahmer.com>
Date: Sat, 9 Dec 2000 18:17:44 -0700
Message-ID: <0RAY5.3200$iZ5.470642@news.uswest.net>

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...

> 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 Sat Dec 09 2000 - 19:17:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US