Type Exception Report
Message could not execute query
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.hibernate.exception.JDBCConnectionException: could not execute query org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) org.hibernate.loader.Loader.doList(Loader.java:2545) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) org.hibernate.loader.Loader.list(Loader.java:2271) org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) db.ManageCds.getByCodice(ManageCds.java:19) windows.Index.<init>(Index.java:90) sun.reflect.GeneratedConstructorAccessor1083.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) java.lang.Class.newInstance(Class.java:442) org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.newInstance(ComponentDefinitionImpl.java:331) org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.newInstance(ComponentDefinitionImpl.java:314) org.zkoss.zk.ui.metainfo.ComponentInfo.newInstance(ComponentInfo.java:627) org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:126) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:908) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:877) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:748) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:822) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:771) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:709) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:452) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:358) org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:217) org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) javax.servlet.http.HttpServlet.service(HttpServlet.java:624) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 145,010,405 milliseconds ago. The last packet sent successfully to the server was 145,010,406 milliseconds ago. 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. sun.reflect.GeneratedConstructorAccessor131.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) com.mysql.jdbc.Util.handleNewInstance(Util.java:425) com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912) com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020) org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) org.hibernate.loader.Loader.getResultSet(Loader.java:1953) org.hibernate.loader.Loader.doQuery(Loader.java:802) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) org.hibernate.loader.Loader.doList(Loader.java:2542) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) org.hibernate.loader.Loader.list(Loader.java:2271) org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) db.ManageCds.getByCodice(ManageCds.java:19) windows.Index.<init>(Index.java:90) sun.reflect.GeneratedConstructorAccessor1083.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) java.lang.Class.newInstance(Class.java:442) org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.newInstance(ComponentDefinitionImpl.java:331) org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.newInstance(ComponentDefinitionImpl.java:314) org.zkoss.zk.ui.metainfo.ComponentInfo.newInstance(ComponentInfo.java:627) org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:126) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:908) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:877) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:748) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:822) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:771) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:709) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:452) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:358) org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:217) org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) javax.servlet.http.HttpServlet.service(HttpServlet.java:624) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause
java.net.SocketException: Broken pipe (Write failed) java.net.SocketOutputStream.socketWrite0(Native Method) java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) java.net.SocketOutputStream.write(SocketOutputStream.java:155) java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3688) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912) com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020) org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) org.hibernate.loader.Loader.getResultSet(Loader.java:1953) org.hibernate.loader.Loader.doQuery(Loader.java:802) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) org.hibernate.loader.Loader.doList(Loader.java:2542) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) org.hibernate.loader.Loader.list(Loader.java:2271) org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) db.ManageCds.getByCodice(ManageCds.java:19) windows.Index.<init>(Index.java:90) sun.reflect.GeneratedConstructorAccessor1083.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) java.lang.Class.newInstance(Class.java:442) org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.newInstance(ComponentDefinitionImpl.java:331) org.zkoss.zk.ui.metainfo.impl.ComponentDefinitionImpl.newInstance(ComponentDefinitionImpl.java:314) org.zkoss.zk.ui.metainfo.ComponentInfo.newInstance(ComponentInfo.java:627) org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:126) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:908) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:877) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:748) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:822) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:771) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:709) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:452) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:358) org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:217) org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) javax.servlet.http.HttpServlet.service(HttpServlet.java:624) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Note The full stack trace of the root cause is available in the server logs.