Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / October 2007

Tip: Looking for answers? Try searching our database.

Strange problem with Hibernate pool connection

Thread view: 
CarloC - 19 Oct 2007 14:48 GMT
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 - 21 Oct 2007 03:23 GMT
> Hi,
> when run my application, after randomic time, I get this Hibernate
> exception
What is randomic :-)

(Sorry, not a Hibernate expert)
Signature

Daniel Pitts' Tech Blog: <http://virtualinfinity.net/wordpress/>



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.