Problemas com mysql hibernetado

Programação Java
#1

oi pessoal, de tempos em tempos, usando hibernate, da um exception:

net.sf.hibernate.JDBCException: SQLException occurred
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3574)
	at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:223)
	at br.com.guj.logic.IndexLogic.getLastFive(IndexLogic.java:52)
	at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.vraptor.logic.LogicInstance.execute(LogicInstance.java:41)
	at org.vraptor.chain.Chain.process(Chain.java:131)
	at org.vraptor.chain.Chain.execute(Chain.java:63)
	at org.vraptor.Raptor.processRequest(Raptor.java:94)
	at org.vraptor.servlet.RaptorServlet.doGet(RaptorServlet.java:34)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at LocaWebValve.invoke(LocaWebValve.java:101)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:466)
	at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:585)
	at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION ** 

java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1455)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1826)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2051)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1496)
	at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
	at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
	at net.sf.hibernate.loader.Loader.list(Loader.java:941)
	at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3571)
	at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:223)
	at br.com.guj.logic.IndexLogic.getLastFive(IndexLogic.java:52)
	at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.vraptor.logic.LogicInstance.execute(LogicInstance.java:41)
	at org.vraptor.chain.Chain.process(Chain.java:131)
	at org.vraptor.chain.Chain.execute(Chain.java:63)
	at org.vraptor.Raptor.processRequest(Raptor.java:94)
	at org.vraptor.servlet.RaptorServlet.doGet(RaptorServlet.java:34)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
	at LocaWebValve.invoke(LocaWebValve.java:101)
	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:466)
	at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:585)
	at java.lang.Thread.run(Thread.java:536)


** END NESTED EXCEPTION **


	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1614)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1826)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2051)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1496)
	at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
	at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:795)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
	at net.sf.hibernate.loader.Loader.list(Loader.java:941)
	at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3571)
	... 43 more

e nao eh sempre, eh uma vez em 50. ja tentei usar dbcp, proxool, c3p0, sem connection pool, mas da tudo na mesma.

alguem ja enfrentou isso?

#2

Cara, eu me lembro dessa exception, mas o problema não foi comigo, e o que aconteceu foi que o cara trocou o driver e funcionou.

eu acho que é pau mesmo no driver, ou na combinação mySQL/driver JDBC. Tenta dar uma atualizada no seu My…

[]s

#3