"Sven Duzont" <[EMAIL PROTECTED]> writes:
> I use Jserv1.0b2 running on Apache web Server 1.3.3 on linux redhat
> and i have encountered a problem. I have one servlet that use a
> JavaBean that use a connection pooling in order to access a MySQL
> database. The problem is that it works the monday perfectly and
> the tuesday Jserv send me this error :
>
> Java.sql.SQLException: Error during query: Communication link failure:
> Broken pipe
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:801)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:733)
> at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:155)
> at SQLBeans.SelectSQLBean.execute(SelectSQLBean.java)
> at IncidentClient.Incidents.select(Incidents.java:179)
> at IncidentClient.Incidents.performTask(Incidents.java:70)
> at IncidentClient.Incidents.doGet(Incidents.java:53)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
> at org.apache.jserv.JServConnection.run(JServConnection.java:359)
> at java.lang.Thread.run(Thread.java)
I'm reasonably certain this isn't a problem with JServ, but I would
recommend upgrading to Jserv1.0b5 so that you don't have to deal with
bugs that have been fixed.
I'm not certain but it sounds like the client lost connection with the
database server. Possibly the database server was restarted. It
might be easier to debug the connection problem if you create a small
test program that calls IncidentClient.Incidents.performTask() with
the same input as the servlet, then run it from the command line.
You also might find more helpful information in the mailing list
archive for the JDBC driver or MySQL.
Good luck,
Paul
-- --------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
READ THE FAQ!!!! <http://java.apache.org/faq/>
Archives and Other: <http://java.apache.org/main/mail.html/>
Problems?: [EMAIL PROTECTED]
