Hi,
I think you can do
1 change the time out variable in the mysql configuration scripts (may be!)
2 or do something like this in your code
try
{
stuff................
if(conn.isClosed())
throw new SQLException();
}
catch(SQLException ex)
{
try
{
conn.close();
//create new conn
}
catch(SQLException ex)
{
System.out.println("merde");
}
}
On Thu, 10 Aug 2000, you 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
