Are you sure that your database server is not restarted. In that case, the
connection has to be dropped and recreated. That's why validating the
session using a simple query before using it becomes more important.
Vivek
> -----Original Message-----
> From: Rahul G [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 10, 2000 3:46 PM
> To: [EMAIL PROTECTED]
> Subject: Re: SQLException: communication link failure, broken pipe
>
>
> Yes, we also face the same problem some times and as Geeta
> said, we also
> restart the JRun and the things work fine.
>
> Rahul
>
> On Thu, 10 Aug 2000 11:58:42 -0400, A mailing list for
> discussion about Sun
> Microsystem's Java
> Servlet API Technology. wrote:
>
> > Hi Michael, I have come across this problem before (though
> we use the
> Oracle
> > driver, but i am guessing your problem should be
> related..) and at least
> in my
> > case it meant that there was something wrong with the database
> connection.
> > "Stale" or something like that.. (I am not up on database
> terms, sorry!)
> When
> > we restarted JRun, then things were fine; which i believe
> is what you are
> > seeing..
> > Geeta
> >
> > Michael Lu wrote:
> >
> > > hi everyone!
> > >
> > > my servlets normally run fine, however, once in a while i get the
> following
> > > message:
> > >
> > > SQLException:
> > > Message: Error during query: Communication link
> failure: Broken pipe
> > > SQLState: S1000
> > > ErrorCode: 0
> > >
> > > but if i just recompile the code it runs fine.
> > >
> > > does anyone know what exactly causes this? is there a
> recommended way
> to
> > > handle the exception? or is there a place where i can
> look up all the
> > > types of SQLExceptions?
> > >
> > > This problem occurs for all our servlets...
> > > we run Jserv on Apache and use the following driver for JDBC:
> > > "org.gjt.mm.mysql.Driver"
> > >
> > > Thanks!
> > > Michael
> > >
> > >
> ______________________________________________________________
> _____________
> > > To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the
> body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives:
> http://archives.java.sun.com/archives/servlet-> interest.html
> >
> > Resources:
> http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> >
> ______________________________________________________________
> _____________
> > To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives:
> http://archives.java.sun.com/archives/servlet-> interest.html
> >
> Resources:
> http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
>
>
>
> _______________________________________________________
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
>
> ______________________________________________________________
> _____________
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
> http://java.sun.com/products/servlet/external-> resources.html
>
> LISTSERV Help:
> http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
