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
