Erro ao acessar projeto JSF, de um dia pro Outro

3 respostas Resolvido
jsfjava
B

Bom dia.
Todo dia, quando acesso pela primeira vez a aplicação, da a seguinte exceção, eu aperto pra atualizar e entra normalmente, já pesquisei em vários lugares e não encontrei nada a respeito…

Muito Obrigado pela atenção e pela ajuda de todos!

Mensagem: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

StackTrace: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)

at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)

at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:560)

at br.com.inditecUtil.persistencia.DAO.contaTodos(DAO.java:212)

at br.com.inditec.revistaEletronica.mb.LoginBean.(LoginBean.java:34)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at java.lang.Class.newInstance(Class.java:442)

at com.sun.faces.mgbean.BeanBuilder.newBeanInstance(Unknown Source)

at com.sun.faces.mgbean.BeanBuilder.build(Unknown Source)

at com.sun.faces.mgbean.BeanManager.createAndPush(Unknown Source)

at com.sun.faces.mgbean.BeanManager.create(Unknown Source)

at com.sun.faces.el.ManagedBeanELResolver.resolveBean(Unknown Source)

at com.sun.faces.el.ManagedBeanELResolver.getValue(Unknown Source)

at com.sun.faces.el.DemuxCompositeELResolver._getValue(Unknown Source)

at com.sun.faces.el.DemuxCompositeELResolver.getValue(Unknown Source)

at org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:94)

at org.apache.el.parser.AstValue.getValue(AstValue.java:137)

at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:184)

at com.sun.faces.facelets.el.TagValueExpression.getValue(Unknown Source)

at javax.faces.component.ComponentStateHelper.eval(Unknown Source)

at javax.faces.component.ComponentStateHelper.eval(Unknown Source)

at javax.faces.component.UIOutput.getValue(Unknown Source)

at javax.faces.component.UIInput.getValue(Unknown Source)

at org.primefaces.util.ComponentUtils.getValueToRender(ComponentUtils.java:94)

at org.primefaces.util.ComponentUtils.getValueToRender(ComponentUtils.java:58)

at org.primefaces.component.inputtext.InputTextRenderer.encodeMarkup(InputTextRenderer.java:71)

at org.primefaces.component.inputtext.InputTextRenderer.encodeEnd(InputTextRenderer.java:52)

at javax.faces.component.UIComponentBase.encodeEnd(Unknown Source)

at javax.faces.component.UIComponent.encodeAll(Unknown Source)

at javax.faces.render.Renderer.encodeChildren(Unknown Source)

at javax.faces.component.UIComponentBase.encodeChildren(Unknown Source)

at javax.faces.component.UIComponent.encodeAll(Unknown Source)

at javax.faces.component.UIComponent.encodeAll(Unknown Source)

at javax.faces.component.UIComponent.encodeAll(Unknown Source)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(Unknown Source)

at com.sun.faces.application.view.MultiViewHandler.renderView(Unknown Source)

at javax.faces.application.ViewHandlerWrapper.renderView(Unknown Source)

at com.sun.faces.lifecycle.RenderResponsePhase.execute(Unknown Source)

at com.sun.faces.lifecycle.Phase.doPhase(Unknown Source)

at com.sun.faces.lifecycle.LifecycleImpl.render(Unknown Source)

at javax.faces.webapp.FacesServlet.service(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:720)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:466)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:391)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:318)

at br.com.inditec.revistaEletronica.listerner.LoginFilter.doFilter(LoginFilter.java:30)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:87)

at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:109)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)

at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1927)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)

at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874)

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

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

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

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

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)

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

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)

at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339)

at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)

at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)

at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529)

 69 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 252,671,129 milliseconds ago. The last packet sent successfully to the server was 252,671,130 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.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3739)

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4842)

at org.hibernate.engine.jdbc.connections.internal.PooledConnections.poll(PooledConnections.java:76)

at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:187)

at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:386)

at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:84)

 90 more

Caused by: java.net.SocketException: Connection timed out

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)

at java.net.SocketOutputStream.write(SocketOutputStream.java:153)

at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)

at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3721)

 98 more

3 Respostas

P
Solucao aceita

olha ai a stack trace da exception dizendo como vc resolve as paradas…

B

Obrigado, passou despercebido!

M

Pra mim isso nao resolveu.

Criado 17 de outubro de 2016
Ultima resposta 5 de abr. de 2017
Respostas 3
Participantes 3