Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

java.sql.SQLException: Communication link failure from Resin MySQL Servlet

1 view
Skip to first unread message

Krazykuo

unread,
Jul 6, 2001, 1:24:17 PM7/6/01
to
I'm (my hosting company) running Resin with MySQL. The servlet/JSP
works fine accessing the database when first started. After a few days
of running, database access results in the following error.
Restarting Resin solves the problem.

java.sql.SQLException: Communication link failure: java.io.IOException
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java)
at stevekuo.webtrack.Session.allocateSessionId(Session.java:90)
at stevekuo.webtrack.Session.<init>(Session.java:59)
at stevekuo.webtrack.Track.<init>(Track.java:73)
at _jsp._www__stevekuo__com._80_0._index__jsp._jspService(_index__jsp.java:29)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:407)
at com.caucho.server.http.Invocation.service(Invocation.java:319)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:333)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:266)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

Any ideas why this is happending? I don't have this problem when I
run the app locally using Tomcat.

Thanks in advance,

Krazykuo

Krazykuo

unread,
Jul 8, 2001, 3:42:27 PM7/8/01
to
I found the problem. I was getting a database connection when the
program starts, later the database would be rebooted (by someone else)
and thus my old connection was broken.
0 new messages