Strange problem with Hibernate pool connection

[CarloC]

Hi,
when run my application, after randomic time, I get this Hibernate
exception

---------------------------------------------------------------------------­-------------------------------------------------------
WARNING: SQL Error: 0, SQLState: 08S01
Oct 8, 2007 8:53:08 AM org.hibernate.util.JDBCExceptionReporter
logExceptions
SEVERE: 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:1319)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1463)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1854)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2090)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1496)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:
236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:
94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at
workcity.data.hibernate.TlWcParamitersHome.findByExample(TlWcParamitersHome..java:
121)
at workcity.servlet.WorkcityInfo.doPost(WorkcityInfo.java:17)
at workcity.servlet.WorkcityInfo.doGet(WorkcityInfo.java:32)
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:
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(Thread.java:595)


** END NESTED EXCEPTION **
-----------------------------------------------------------------------------------------------------------------



This is my hibernate configuration in hibernate.cfg.xml file

<property name="hibernate.bytecode.use_reflection_optimizer">false</
property>
<property
name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</
property>
<property name="hibernate.cache.use_minimal_puts">false</ property>
<property name="hibernate.cache.use_query_cache">false</ property>
<property name="hibernate.connection.autoReconnect">true</ property>
<property name="hibernate.connection.autoReconnectForPools">true</
property>
<property name="hibernate.connection.autocommit">true</ property>
<property
name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</
property>
<property name="hibernate.connection.is-connection-validation-
required">true</property>
<property name="hibernate.connection.password">admin</ property>
<property name="hibernate.connection.pool_size">1</property>
<property name="hibernate.connection.url">jdbc:mysql:// localhost/
workcity</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.current_session_context_class">thread</
property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</
property>
<property name="hibernate.format_sql">true</property>
<property name="hibernate.max_fetch_depth">3</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.use_sql_comments">true</property>


Can you help my to find the problem ?


Thanks,
Carlo

 

[Daniel Pitts]

Hi,
when run my application, after randomic time, I get this Hibernate
exception

What is randomic

(Sorry, not a Hibernate expert)