at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)错误如何解决

[tudousiyan]

大家好！我最近做网站tomcat会报下面的错误信息
** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at com.zycy.db.DbTrans.executeQuery(DbTrans.java:127)
at org.apache.jsp.deal_jsp._jspService(deal_jsp.java:106)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

每次重启tomcat后就好了，重启mysql数据库不行，重启后白天一天项目运行正常，但是第二天早上又会报同样的错误，
我在网上查了很多信息但是还是无法解决请高手帮忙，不胜感激！

我做的是网站前台，前台用的技术是jsp+Tomcat+mysql 后台用的是struts+hibernate+spring 后台没有问题
前台显示没有问题，但是前台有个用户登陆系统，就是这个系统进入时总是出现上面报的错误，前台用的都是一个数据库，这是什么原因呢？请高手指点！急！谢谢了！

[AoYuanSE]

关注中。。。也想要解决这个问题呢。
自己做的新网站http://www.maidatongkai.com经常报这个错误，楼主知道解决办法的话给公布一下，多谢多谢！！！

[netsocket]

mark

[ultraedit55]

mark

[AoYuanSE]

忘了问楼主了 你的数据库链接怎么写的？
加?autoReconnect=true了吗？

[tudousiyan]

是的，加autoReconnect=true了，谢谢各位的帮助，后来用了一种比较笨的方法将mysql的默认链接时间修改的更长就好了。

[WHW1984]

如果修改mysql的默认链接时间呢？

[liuerming2009]

.....

[yjiany]

hibernate.cfg.xml中加入如下内容：
<!-- 当数据库连接异常中断时，是否自动重新连接 -->
<property name="connection.autoReconnect">true</property>

<!-- 是否使用针对数据库连接池的重连策略 -->
<property name="connection.autoReconnectForPools">true</property>

<property name="connection.is-connection-validation-required">true</property>