1 Reply Latest reply on Jul 27, 2009 3:18 PM by Zo Ge

    Loosing MySQL connection

    mario neal Newbie

      hello to all. i've finished my application but i'm loosing somehow the mysql connection after a while.. i've no idea where to fix this problem.. I've copied the log file info from tomcat.
      after restarting the tomcat everything works fine again.
      does somebody know a solution?
      thx for reading!!


      24.07.2009 09:48:52 com.sun.faces.application.ActionListenerImpl processAction
      SCHWERWIEGEND: org.hibernate.exception.JDBCConnectionException: could not execute query
      javax.faces.el.EvaluationException: org.hibernate.exception.JDBCConnectionException: could not execute query
              at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
              at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
              at javax.faces.component.UICommand.broadcast(UICommand.java:387)
              at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
              at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)
              at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)
              at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)
              at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)
              at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
              at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
              at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
              at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
              at org.jboss.seam.web.RewriteFilter.doFilter(RewriteFilter.java:63)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
              at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
              at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:390)
              at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:517)
              at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
              at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
              at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
              at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
              at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
              at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
              at java.lang.Thread.run(Thread.java:619)
      Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
              at org.hibernate.loader.Loader.doList(Loader.java:2231)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
              at org.hibernate.loader.Loader.list(Loader.java:2120)
              at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
              at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
              at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
              at ch.resimmo.service.objlist.ImmoListServiceImpl.getIndexPageObjects(ImmoListServiceImpl.java:39)
              at sun.reflect.GeneratedMethodAccessor615.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at ch.homegate.service.core.Service$1.proceed(Service.java:63)
              at ch.homegate.service.core.Interceptors$1.invoke(Interceptors.java:21)
              at ch.homegate.service.core.Service.invoke(Service.java:57)
              at ch.homegate.service.core.Invoker$2$1.proceed(Invoker.java:91)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:99)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:48)
              at ch.homegate.service.transaction.TransactionInterceptor.newTransaction(TransactionInterceptor.java:64)
              at ch.homegate.service.transaction.TransactionInterceptor.access$100(TransactionInterceptor.java:53)
              at ch.homegate.service.transaction.TransactionInterceptor$1.invoke(TransactionInterceptor.java:97)
              at ch.homegate.service.core.Interceptors$2.proceed(Interceptors.java:64)
              at ch.homegate.service.core.ThreadLocalInterceptor.invoke(ThreadLocalInterceptor.java:53)
              at ch.homegate.service.core.ThreadLocalInterceptor.invoke(ThreadLocalInterceptor.java:30)
              at ch.homegate.service.hibernate.HibernateSessionInterceptor$1.invoke(HibernateSessionInterceptor.java:63)
              at ch.homegate.service.core.Interceptors$2.proceed(Interceptors.java:64)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:99)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:48)
              at ch.homegate.service.hibernate.SessionInterceptor.newSession(SessionInterceptor.java:28)
              at ch.homegate.service.hibernate.SessionInterceptor.access$100(SessionInterceptor.java:17)
              at ch.homegate.service.hibernate.SessionInterceptor$1.invoke(SessionInterceptor.java:57)
              at ch.homegate.service.core.Interceptors$2.proceed(Interceptors.java:64)
              at ch.homegate.service.core.Interceptors.invoke(Interceptors.java:93)
              at ch.homegate.service.hibernate.HibernateSessionInterceptor.invoke(HibernateSessionInterceptor.java:58)
              at ch.homegate.service.core.Invoker$2.invoke(Invoker.java:87)
              at $Proxy61.getIndexPageObjects(Unknown Source)
              at ch.spectromedia.db.Loader.oderObjectsOfIndexPage(Loader.java:83)
              at sun.reflect.GeneratedMethodAccessor659.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
              at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
              at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.core.SynchronizationInterceptor.aroundInvoke(SynchronizationInterceptor.java:32)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
              at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
              at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
              at ch.spectromedia.db.Loader_$$_javassist_3.oderObjectsOfIndexPage(Loader_$$_javassist_3.java)
              at sun.reflect.GeneratedMethodAccessor795.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
              at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
              at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
              at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
              at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
              at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
              at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
              ... 50 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
      
      
      ** BEGIN NESTED EXCEPTION ** 
      
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
      MESSAGE: The last packet successfully received from the server was65155 seconds ago.The last packet sent successfully to the server was 65155 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
      
      STACKTRACE:
      
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was65155 seconds ago.The last packet sent successfully to the server was 65155 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
              at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
              at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
              at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
              at org.hibernate.loader.Loader.doQuery(Loader.java:697)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
              at org.hibernate.loader.Loader.doList(Loader.java:2228)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
              at org.hibernate.loader.Loader.list(Loader.java:2120)
              at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
              at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
              at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
              at ch.resimmo.service.objlist.ImmoListServiceImpl.getIndexPageObjects(ImmoListServiceImpl.java:39)
              at sun.reflect.GeneratedMethodAccessor615.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at ch.homegate.service.core.Service$1.proceed(Service.java:63)
              at ch.homegate.service.core.Interceptors$1.invoke(Interceptors.java:21)
              at ch.homegate.service.core.Service.invoke(Service.java:57)
              at ch.homegate.service.core.Invoker$2$1.proceed(Invoker.java:91)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:99)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:48)
              at ch.homegate.service.transaction.TransactionInterceptor.newTransaction(TransactionInterceptor.java:64)
              at ch.homegate.service.transaction.TransactionInterceptor.access$100(TransactionInterceptor.java:53)
              at ch.homegate.service.transaction.TransactionInterceptor$1.invoke(TransactionInterceptor.java:97)
              at ch.homegate.service.core.Interceptors$2.proceed(Interceptors.java:64)
              at ch.homegate.service.core.ThreadLocalInterceptor.invoke(ThreadLocalInterceptor.java:53)
              at ch.homegate.service.core.ThreadLocalInterceptor.invoke(ThreadLocalInterceptor.java:30)
              at ch.homegate.service.hibernate.HibernateSessionInterceptor$1.invoke(HibernateSessionInterceptor.java:63)
              at ch.homegate.service.core.Interceptors$2.proceed(Interceptors.java:64)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:99)
              at ch.homegate.service.core.ContextInterceptor.invoke(ContextInterceptor.java:48)
              at ch.homegate.service.hibernate.SessionInterceptor.newSession(SessionInterceptor.java:28)
              at ch.homegate.service.hibernate.SessionInterceptor.access$100(SessionInterceptor.java:17)
              at ch.homegate.service.hibernate.SessionInterceptor$1.invoke(SessionInterceptor.java:57)
              at ch.homegate.service.core.Interceptors$2.proceed(Interceptors.java:64)
              at ch.homegate.service.core.Interceptors.invoke(Interceptors.java:93)
              at ch.homegate.service.hibernate.HibernateSessionInterceptor.invoke(HibernateSessionInterceptor.java:58)
              at ch.homegate.service.core.Invoker$2.invoke(Invoker.java:87)
              at $Proxy61.getIndexPageObjects(Unknown Source)
              at ch.spectromedia.db.Loader.oderObjectsOfIndexPage(Loader.java:83)
              at sun.reflect.GeneratedMethodAccessor659.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
              at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
              at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.core.SynchronizationInterceptor.aroundInvoke(SynchronizationInterceptor.java:32)
              at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
              at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
              at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
              at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
              at ch.spectromedia.db.Loader_$$_javassist_3.oderObjectsOfIndexPage(Loader_$$_javassist_3.java)
              at sun.reflect.GeneratedMethodAccessor795.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
              at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
              at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
              at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
              at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
              at org.jboss.seam.core.Expressions$2.invoke(Expressions.java:175)
              at org.jboss.seam.navigation.Page.preRender(Page.java:293)
              at org.jboss.seam.navigation.Pages.preRender(Pages.java:366)
              at org.jboss.seam.jsf.SeamPhaseListener.preRenderPage(SeamPhaseListener.java:562)
              at org.jboss.seam.jsf.SeamPhaseListener.beforeRenderResponse(SeamPhaseListener.java:473)
              at org.jboss.seam.jsf.SeamPhaseListener.beforeServletPhase(SeamPhaseListener.java:146)
              at org.jboss.seam.jsf.SeamPhaseListener.beforePhase(SeamPhaseListener.java:116)
              at com.sun.faces.lifecycle.Phase.handleBeforePhase(Phase.java:214)
              at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:96)
              at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
              at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
              at org.jboss.seam.web.RewriteFilter.doFilter(RewriteFilter.java:63)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
              at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
              at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:390)
              at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:517)
              at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
              at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
              at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
              at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
              at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
              at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
              at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
              at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
              at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
              at java.lang.Thread.run(Thread.java:619)
      Caused by: java.net.SocketException: Broken pipe
              at java.net.SocketOutputStream.socketWrite0(Native Method)
              at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
              at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
              at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
              at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
              at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3227)
              ... 120 more
      
      
      ** END NESTED EXCEPTION **
      
      
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
              at com.mysql.jdbc.Util.getInstance(Util.java:381)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
              at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098)
              at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4076)
              at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4042)
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
              at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
              at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
              at org.hibernate.loader.Loader.doQuery(Loader.java:696)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
              at org.hibernate.loader.Loader.doList(Loader.java:2228)
              ... 112 more