这个问题搞的我头痛！！请高手指点！！！

Question

Hibernate: select hotelmessa0_.minjl as col_0_0_ from hotelmessage hotelmessa0_ where hotelmessa0_.hotelName=?
2008-04-28 15:16:47  WARN [http-80-Processor17] (JDBCExceptionReporter.java:71) - SQL Error: 0, SQLState: 08S01
2008-04-28 15:16:47 ERROR [http-80-Processor17] (JDBCExceptionReporter.java:72) - Communications link failureLast packet sent to the server was 0 ms ago.
2008-04-28 15:16:47 ERROR [http-80-Processor17] (StandardWrapperValve.java:253) - Servlet.service() for servlet jsp threw exception
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1958)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2372)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2871)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1556)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at dao.DBHelper.getxx(DBHelper.java:407)
at org.apache.jsp.view_jsp._jspService(view_jsp.java:1295)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)

Answer 1

看起来像mysql数据库的问题
建议换个版本，或者换个驱动试试

Answer 2

开始还好的，用一段时间就不行了，然后重起tomcat就好了  然后在用一段时间就又不行了！

Answer 3

那要怎么释放？
我是在页面里点的连接，比如http://www.aaa.com.cn/asd.jsp?bookid=xxxx
这样子传的参数，然后在后面的网页直接调用DBHelper里的方法,
那我这样怎么释放啊？
一没有Action,二没有直接在页面里使用jdbc的连接，那现在要怎么释放？？？？

Answer 4

我这得可能有两个问题引起这个错误:
1、你的连接包有可能损坏
2、你的资源没有释放，释放方法可以在方法中判断:try {if (conn!=null) conn.close();} catch (Exception ex) {}