connection error

hi,

i have used hibernate3 with hsqldb(database given by default) and it works fine.but when i tried to use it with mysql4 then i have encountered a problem.

exception:

STACKTRACE:

java.io.EOFException

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java(Compiled Code))

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1539)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2281)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)

at org.hibernate.loader.Loader.doQuery(Loader.java:391)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)

at org.hibernate.loader.Loader.doList(Loader.java:1593)

at org.hibernate.loader.Loader.list(Loader.java:1577)

at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)

at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)

at bean.Products.getHomePageList(Products.java:190)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:67)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java(Compiled Code))

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java(Compiled Code))

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java(Compiled Code))

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java(Compiled Code))

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java(Compiled Code))

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java(Compiled Code))

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java(Compiled Code))

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java(Compiled Code))

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java(Compiled Code))

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java(Compiled Code))

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java(Compiled Code))

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java(Compiled Code))

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java(Compiled Code))

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compiled Code))

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled Code))

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java(Compiled Code))

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java(Compiled Code))

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:567)

** END NESTED EXCEPTION **

[4394 byte] By [portal_behia] at [2007-11-26 15:12:43]
# 1
Hi,Try to post the question in a hibernate forum, and provide som more information when you do that (like when you get the exception, if you always get it etc)Kaj
kajbja at 2007-7-8 9:03:50 > top of Java-index,Java Essentials,New To Java...