Sven Duzont wrote:
> Hello,
> 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)
>
> Can anybody help me to solve this problem??
> thanx,
> Sven
>
> P.S : Sorry for the poor english ;o)
>
One problem that can cause this symptom is if your MySQL server breaks the
connection that your connection pool has set up -- either because the MySQL
server is restarted, or because of a timeout. In such a case, you need to make
sure your connection pool re-establishes its connections periodically.
Craig McClanahan
-- --------------------------------------------------------------
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]
