db server connection timeout -> error

[reggedueser_01]

Hi!

I have a servlet which holds a db connection (specifically to a Mysql
db).

Every time doGet() is called, it checks whether the connection is
alive using conn.isClosed(). If it's closed, it tries to re-open it.
Re-opening (but not opening) when isCloses()==true his throws the
following exception:

Communication link failure: java.io.EOFException, underlying cause:
null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE:
java.io.EOFException at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1388) at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272) at
com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at
com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at
NaptaarServlets.ViewMonthly.doGet(ViewMonthly.java:45) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534) ** END NESTED EXCEPTION **

Any help would be appreciated!