Banco de Talentos

Wiki

Ajuda

Repositório

Participe

Membros

Nenhum(a)

Ver todos(as)

Banco de Talentos > Histórico de Fóruns > Banco de Talentos Suporte > java.net.SocketException

Histórico de Fóruns

Voltar a Banco de Tal...

Depois de penar um pouco no início, sonegui colocar o banco de Talentos para funcionar num servidor Linux/RHEL5. Estava tudo ok, acessei ambos os módulos, fiz busca, alterei dados... tudo beleza!

Liberei o sistema para o setor responsável explorá-lo e analisar sua utilidade na nossa autarquia e... Parou de funcionar... :-(

A tela de logon informa que "ocorreu um erro tentando autenticar o usuário". Dando uma olhada no log do tomcat achei estranho alguns trechos como esses:

Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

java.net.SocketException

MESSAGE: Broken pipe

Quem puder ajudar, grato,

Emerson

Segue log completo:

Hibernate: select usuariosis0_.ideUsuario as ideUsuario0_, usuariosis0_.nomUsuario as nomUsuario0_, usuariosis0_.desLogin as desLogin0_, usuariosis0_.numSenhaHash as numSenha4_0_, usuariosis0_.indExpiracaoSenha as indExpir5_0_, usuariosis0_.datAtualizacaoSenha as datAtual6_0_, usuariosis0_.datValidade as datValid7_0_, usuariosis0_.datDesligamento as datDesli8_0_, usuariosis0_.codGrupo as codGrupo0_ from UsuarioSistema usuariosis0_ where upper(usuariosis0_.desLogin)='M10001' 19/06/2009 08:32:38,205 | | WARN | JDBCExceptionReporter (logExceptions:77) | SQL Error: 0, SQLState: 08S01 19/06/2009 08:32:38,205 | | ERROR | JDBCExceptionReporter (logExceptions:78) | Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Broken pipe STACKTRACE: java.net.SocketException: Broken pipe 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:2616) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2376) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at br.gov.camara.negocio.DAO.obter(DAO.java:254) at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304) at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119) at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63) at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241) at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:636) ** END NESTED EXCEPTION ** 19/06/2009 08:32:38,206 | | ERROR | CDException (gerarLog:182) | 417770 | ST: br.gov.camara.negocio.DAO.obter(DAO.java:258) 19/06/2009 08:32:38,206 | | ERROR | CDException (gerarLog:182) | 417770 | ST: br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304) 19/06/2009 08:32:38,207 | | ERROR | CDException (gerarLog:182) | 417770 | ST: br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119) 19/06/2009 08:32:38,207 | | ERROR | CDException (gerarLog:182) | 417770 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63) 19/06/2009 08:32:38,208 | | ERROR | CDException (gerarLog:182) | 417770 | ST: br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241) 19/06/2009 08:32:38,208 | | ERROR | CDException (gerarLog:182) | 417770 | ST: br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122) 19/06/2009 08:32:38,208 | | ERROR | CDException (gerarLog:186) | 417770 | GM: (...) could not execute query | class br.gov.camara.negocio.exception.DAOException 19/06/2009 08:32:38,209 | | INFO | Mensagem (obterMensagem:67) | Erro desconhecido -> Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Broken pipe STACKTRACE: java.net.SocketException: Broken pipe 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:2616) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2376) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at br.gov.camara.negocio.DAO.obter(DAO.java:254) at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304) at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119) at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63) at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241) at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:636) ** END NESTED EXCEPTION ** 19/06/2009 08:32:38,210 | | ERROR | UnidadeAutenticadoraBT (autenticarUsuario:102) | autenticarUsuario(String strLoginUsuario = M10001, String strSenhaUsuario = dasdasdasd) - catch br.gov.camara.negocio.exception.DAOException: could not execute query at br.gov.camara.negocio.DAO.obter(DAO.java:258) at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304) at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119) at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63) at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241) at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:636) Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2216) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at br.gov.camara.negocio.DAO.obter(DAO.java:254) ... 37 more Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Broken pipe STACKTRACE: java.net.SocketException: Broken pipe 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:2616) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2376) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at br.gov.camara.negocio.DAO.obter(DAO.java:254) at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304) at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119) at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63) at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241) at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:636) ** END NESTED EXCEPTION ** at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2634) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2376) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) ... 45 more 19/06/2009 08:32:38,211 | | INFO | AutenticacaoSequencia (validarLogonEfetuarLogon:271) | Logon invÃ¡lido | M10001

Autor: Emerson Coimbra

1818 comentários

Eduardo Santos(usuário não autenticado)
19 de Junho de 2009, 10:05

Olá Emerson,
Isso me parece um erro do JDBC. Como está o seu ambiente de comunicação de dados no momento?
- Emerson Coimbra(usuário não autenticado)
  
  19 de Junho de 2009, 11:41
  
  Oi Eduardo,Desculpe, mas não entendi sua pergunta, que tipo de niformação você que que eu te passe? Olha, como falei num tópico dias atrás, sou totalmente leigo em Java e nenhum dos analistas/desenvolvedores aqui da casa trabalham com Java, portanto estou perdidaço... :-( O que posso te adiantar é que eu aprontei a máquina e comuniquei o fato ao meu chefe, ele resolveu testar antes de enviar ao setor que fará uso da ferramenta e acabou vendo o erro. Desde que eu deixei o sistema funcionando, não toquei mais na máquina. Os serviços do Apache, Tomcat e MySql estão todos no ar. Firewal e SeLinux estão desabilitados e simplesmente parou de funcionar.Tentei restartar os serviços e nada.Pesquisando no Google, encontrei essa discussão: http://forums.mysql.com/read.php?39,16257,16257Tem algo a ver com o meu caso?Obrigado,Emerson
  - Eduardo Santos(usuário não autenticado)
    
    25 de Junho de 2009, 16:39
    
    Olá Émerson,
    Quando perguntei do seu ambiente é para saber como o banco de dados se comunica com a sua aplicação. Quais as versões que estão instaladas, principalmente do JDBC, esse tipo de coisa. Isso pode fornecer mais informações para resolver o problema.
    
    Emerson Coimbra(usuário não autenticado)
    
    26 de Junho de 2009, 11:36
    
    Olha Eduardo, aqui usamos Red Hat Enterprise 5. Então o que eu fiz foi o seguinte: mandei instalar o Tomcat 5 e deixei ele mesmo resolver as dependências. Ficou assim: yum install tomcat5Installing: tomcat5 i386 5.5.23-0jpp.7.el5_2.1 rhel-i386-server-5 335 kInstalling for dependencies: ant i386 1.6.5-2jpp.2 rhel-i386-server-5 2.0 M antlr i386 2.7.6-4jpp.2 rhel-i386-server-5 978 k axis i386 1.2.1-2jpp.6 rhel-i386-server-5 2.2 M bcel i386 5.1-8jpp.1 rhel-i386-server-5 983 k classpathx-jaf i386 1.0-9jpp.1 rhel-i386-server-5 101 k classpathx-mail i386 1.1.1-4jpp.2 rhel-i386-server-5 1.1 M eclipse-ecj i386 1:3.2.1-19.el5 rhel-i386-server-5 7.9 M geronimo-specs i386 1.0-0.M2.2jpp.12 rhel-i386-server-5 230 k geronimo-specs-compat i386 1.0-0.M2.2jpp.12 rhel-i386-server-5 5.5 k giflib i386 4.1.3-7.1.el5_3.1 rhel-i386-server-5 39 k gjdoc i386 0.7.7-12.el5 rhel-i386-server-5 793 k jakarta-commons-beanutils i386 1.7.0-5jpp.1 rhel-i386-server-5 526 k jakarta-commons-collections i386 3.2-2jpp.3 rhel-i386-server-5 1.0 M jakarta-commons-daemon i386 1:1.0.1-6jpp.1 rhel-i386-server-5 44 k jakarta-commons-dbcp i386 1.2.1-7jpp.1 rhel-i386-server-5 243 k jakarta-commons-digester i386 1.7-5jpp.1 rhel-i386-server-5 314 k jakarta-commons-discovery i386 1:0.3-4jpp.1 rhel-i386-server-5 134 k jakarta-commons-el i386 1.0-7jpp.1 rhel-i386-server-5 240 k jakarta-commons-fileupload i386 1:1.0-6jpp.1 rhel-i386-server-5 48 k jakarta-commons-httpclient i386 1:3.0-7jpp.1 rhel-i386-server-5 514 k jakarta-commons-launcher i386 0.9-6jpp.1 rhel-i386-server-5 88 k jakarta-commons-logging i386 1.0.4-6jpp.1 rhel-i386-server-5 106 k jakarta-commons-modeler i386 1.1-8jpp.3.el5 rhel-i386-server-5 230 k jakarta-commons-pool i386 1.3-5jpp.1 rhel-i386-server-5 128 k java-1.4.2-gcj-compat i386 1.4.2.0-40jpp.115 rhel-i386-server-5 29 k java-1.6.0-openjdk i386 1:1.6.0.0-0.30.b09.el5 rhel-i386-server-5 28 M java-1.6.0-openjdk-devel i386 1:1.6.0.0-0.30.b09.el5 rhel-i386-server-5 9.2 M jpackage-utils noarch 1.7.3-1jpp.2.el5 rhel-i386-server-5 61 k ldapjdk i386 4.18-2jpp.3.el5 rhel-i386-server-5 783 k libgcj i386 4.1.2-44.el5 rhel-i386-server-5 17 M log4j i386 1.2.13-3jpp.2 rhel-i386-server-5 637 k mx4j i386 1:3.0.1-6jpp.4 rhel-i386-server-5 2.5 M regexp i386 1.4-2jpp.2 rhel-i386-server-5 91 k tomcat5-common-lib i386 5.5.23-0jpp.7.el5_2.1 rhel-i386-server-5 197 k tomcat5-jasper i386 5.5.23-0jpp.7.el5_2.1 rhel-i386-server-5 980 k tomcat5-jsp-2.0-api i386 5.5.23-0jpp.7.el5_2.1 rhel-i386-server-5 94 k tomcat5-server-lib i386 5.5.23-0jpp.7.el5_2.1 rhel-i386-server-5 3.6 M tomcat5-servlet-2.4-api i386 5.5.23-0jpp.7.el5_2.1 rhel-i386-server-5 151 k wsdl4j i386 1.5.2-4jpp.1 rhel-i386-server-5 388 k xalan-j2 i386 2.7.0-6jpp.1 rhel-i386-server-5 2.7 M xerces-j2 i386 2.7.1-7jpp.2 rhel-i386-server-5 1.9 M xml-commons i386 1.3.02-0.b2.7jpp.10 rhel-i386-server-5 19 k xml-commons-apis i386 1.3.02-0.b2.7jpp.10 rhel-i386-server-5 335 k xml-commons-resolver i386 1.1-1jpp.12 rhel-i386-server-5 148 k Não existe no servidor nenhum pacote com a palavra JDBC, então não sei te precisar a versãoq ue estou usando. O JDBC costuma vir empacotado com o Tomcat ou com o Java?
    
    Luciano Dias(usuário não autenticado)
    
    26 de Junho de 2009, 12:02
    
    Emerson,
    Minha experiência é com o ambiente Windows.
    Para o ambiente de produção sugiro que você remova a biblioteca "mysql-connector-java.jar" de dentro da pasta "lib" da aplicação e mova para a pasta "TOMCAT_HOME/common/lib".
    Ainda: exclua todos os arquivos da pasta APLIC_HOME/WEB-INF/lib que existem dentro de "TOMCAT_HOME/common/lib".
    Obs: APLIC_HOME é a pasta onde o Tomcat "descompactou" a aplicação
    Um abraço,
    Luciano.
    
    Emerson Coimbra(usuário não autenticado)
    
    30 de Junho de 2009, 8:35
    
    Luciano, segui sua dica, testei e funcionou perfeitamente, muito obrigado.Passei pro meu chefe novamente ele testou e... voltou a apresentar o mesmo erro! Fui comprovar e realmente, parou de funcionar.Eu coloco o sistema pra funcionar, testo, testo, testo. Ok, está funcionando. Fulano, por favor teste também. Quando ele tenta, nem consegue se logar no sistema e a partir daí nem eu.Boto de novo pra funcionar. Testo, testo, testo, está ok novamente. O mesmo fulano tenta entrar e novamente não consegue se logar... ninguém mais consegue. Mesma mensagem de erro java.net.SocketException. Como pode uma coisa dessas?
    
    Halailton Rodrigues(usuário não autenticado)
    
    10 de Fevereiro de 2011, 15:20
    
    Emerson,
    
    você conseguiu solucionar o problema de queda do sistema?
    Se sim, pode me passar a resolução encontrada?
    Agradeço sua atenção.
Emerson Coimbra(usuário não autenticado)
25 de Junho de 2009, 16:22

Continuo na mesma, não consigo resolver esse problema. Várias pesquisas na internet e sempre sem sucesso. Alguém com alguma sugestão? Obrigado,Emerson
Mateus Belluzzo(usuário não autenticado)
29 de Janeiro de 2010, 8:53

HAHAHA!!!
Que beleza....acabo de passar pelo mesmo vexame!!! Ontem 17:30 tava OK...agendei a apresentação para hoje cedo e....nada de funcionar. Erro de Broken pipe.
Começo a perder a confiança no sistema...se eu entendesse de Java poderia contribuir com a comunidade mas sou leigo.
Att.

Mateus Belluzzo
Prefeitura de Telêmaco Borba
- Halailton Rodrigues(usuário não autenticado)
  
  8 de Fevereiro de 2011, 10:11
  
  Estou passando pelo mesmo problema.
  Aparentemente, quando o sistema fica inativo por um tempo, ele prende a conexão.
  Abri um novo topico tentando solucionar esse problema e até agora não obtive respostas.
  Estou tentando por fora resolver esse problema com um analista JAVA aqui da Prefeitura de Santos, ele me falou algo referente à forma de conexão, que deveria existir um arquivo CONTEXT.XML, porém não encontrei esse arquivo na estrutura da aplicação.
  Caso alguém tenha algum avanço nessa etapa, estou apenas dependendo disso para colocar o sistema em produção.
  Caso tenham interesse eu tenho os arquivos de Criação e Carga de Dados corrigidos com Upper Case para a Base em MySQL, evitando o problema de chamadas erradas nas conexões do sistema, fazendo com que o administrador do Banco de Dados não seja obrigado a desligar o Case Sensitive do Banco.
Eduardo Santos(usuário não autenticado)
8 de Fevereiro de 2011, 10:35

Pessoal,Andei dando uma pesquisada por aí e me parece que o erro pode estar relacionado ao fato de as conexões abertas não serem fechadas. Deem uma olhada: http://www.mombu.com/programming/java/t-system-or-internal-error-javanetsocketexception-socket-closed-1496488.htmlTem que dar uma olhada mais profunda no código pra saber se o problema pode ser esse, mas alguém que tem o ambiente em produção pode testar mandando fechar as conexões onde elas são abertas pra ver se o problema é resolvido.
- Halailton Rodrigues(usuário não autenticado)
  
  8 de Fevereiro de 2011, 10:42
  
  Como fazemos para fechar essas conexões?
  - Eduardo Santos(usuário não autenticado)
    
    8 de Fevereiro de 2011, 10:48
    
    Halailton,Como o Luciano apontou na outra thread, isso aqui deve resolver o seu problema: http://www.softwarepublico.gov.br/dotlrn/clubs/bancodetalentos/forums/message-view?message_id=15307020Basta implementar o pool de conexões no hibernate e o erro deve sumir.
    
    Halailton Rodrigues(usuário não autenticado)
    
    8 de Fevereiro de 2011, 10:53
    
    Devo substituir a linha:
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    por essa linha?
    <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
    
    Halailton Rodrigues(usuário não autenticado)
    
    10 de Fevereiro de 2011, 15:19
    
    Eduardo essa solução não funciona.
    Tem como corrigir a aplicação, sem ter que mexer em configurações do Servidor.
Eduardo Santos(usuário não autenticado)
10 de Fevereiro de 2011, 15:29

Halailton,Precisava saber um pouco mais sobre os erros que estão acontecendo pra poder te ajudar. Tem como você mostrar pra gente o log da aplicação na hora que ela caiu? Aí podemos ter uma ideia melhor do que pode estar acontecendo.
- Halailton Rodrigues(usuário não autenticado)
  
  11 de Fevereiro de 2011, 10:15
  
  Eduardo,
  segue abaixo o LOG extraído do CATALINA.
  ---------------------------------------------------
  
  11/02/2011 10:11:31,894 | | WARN | JDBCExceptionReporter (logExceptions:77) | SQL Error: 0, SQLState: 08S01
  11/02/2011 10:11:31,895 | | ERROR | JDBCExceptionReporter (logExceptions:78) | Communications link failure due to underlying exception:
  ** BEGIN NESTED EXCEPTION **
  java.net.SocketException
  MESSAGE: Broken pipe
  STACKTRACE:
  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:2616)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      at org.hibernate.loader.Loader.doQuery(Loader.java:674)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      at org.hibernate.loader.Loader.doList(Loader.java:2213)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      at org.hibernate.loader.Loader.list(Loader.java:2099)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at br.gov.camara.negocio.DAO.obter(DAO.java:254)
      at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
      at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
      at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
      at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
      at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
  ** END NESTED EXCEPTION **
  11/02/2011 10:11:31,896 | | ERROR | CDException (gerarLog:182) | 631614 | ST: br.gov.camara.negocio.DAO.obter(DAO.java:258)
  11/02/2011 10:11:31,897 | | ERROR | CDException (gerarLog:182) | 631614 | ST: br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
  11/02/2011 10:11:31,898 | | ERROR | CDException (gerarLog:182) | 631614 | ST: br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
  11/02/2011 10:11:31,898 | | ERROR | CDException (gerarLog:182) | 631614 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
  11/02/2011 10:11:31,899 | | ERROR | CDException (gerarLog:182) | 631614 | ST: br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
  11/02/2011 10:11:31,900 | | ERROR | CDException (gerarLog:182) | 631614 | ST: br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
  11/02/2011 10:11:31,901 | | ERROR | CDException (gerarLog:186) | 631614 | GM: (...) could not execute query | class br.gov.camara.negocio.exception.DAOException
  11/02/2011 10:11:31,901 | | INFO | Mensagem (obterMensagem:67) | Erro desconhecido -> Communications link failure due to underlying exception:
  ** BEGIN NESTED EXCEPTION **
  java.net.SocketException
  MESSAGE: Broken pipe
  STACKTRACE:
  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:2616)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      at org.hibernate.loader.Loader.doQuery(Loader.java:674)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      at org.hibernate.loader.Loader.doList(Loader.java:2213)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      at org.hibernate.loader.Loader.list(Loader.java:2099)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at br.gov.camara.negocio.DAO.obter(DAO.java:254)
      at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
      at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
      at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
      at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
      at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
  ** END NESTED EXCEPTION **
  11/02/2011 10:11:31,904 | | ERROR | UnidadeAutenticadoraBT (autenticarUsuario:102) | autenticarUsuario(String strLoginUsuario = G001, String strSenhaUsuario = Senha) - catch
  br.gov.camara.negocio.exception.DAOException: could not execute query
      at br.gov.camara.negocio.DAO.obter(DAO.java:258)
      at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
      at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
      at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
      at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
      at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
  Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2216)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      at org.hibernate.loader.Loader.list(Loader.java:2099)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at br.gov.camara.negocio.DAO.obter(DAO.java:254)
      ... 39 more
  Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
  ** BEGIN NESTED EXCEPTION **
  java.net.SocketException
  MESSAGE: Broken pipe
  STACKTRACE:
  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:2616)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      at org.hibernate.loader.Loader.doQuery(Loader.java:674)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      at org.hibernate.loader.Loader.doList(Loader.java:2213)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      at org.hibernate.loader.Loader.list(Loader.java:2099)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at br.gov.camara.negocio.DAO.obter(DAO.java:254)
      at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
      at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
      at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
      at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
      at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
      at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
      at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
  ** END NESTED EXCEPTION **
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2634)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      at org.hibernate.loader.Loader.doQuery(Loader.java:674)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      at org.hibernate.loader.Loader.doList(Loader.java:2213)
      ... 47 more
  11/02/2011 10:11:31,907 | | INFO | AutenticacaoSequencia (validarLogonEfetuarLogon:271) | Logon inválido | G001
  - Halailton Rodrigues(usuário não autenticado)
    
    14 de Fevereiro de 2011, 17:46
    
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    ** END NESTED EXCEPTION **
    14/02/2011 16:44:08,254 | | ERROR | CDException (gerarLog:182) | 035441 | ST: br.gov.camara.negocio.DAO.obter(DAO.java:258)
    14/02/2011 16:44:08,255 | | ERROR | CDException (gerarLog:182) | 035441 | ST: br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
    14/02/2011 16:44:08,255 | | ERROR | CDException (gerarLog:182) | 035441 | ST: br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
    14/02/2011 16:44:08,256 | | ERROR | CDException (gerarLog:182) | 035441 | ST: br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
    14/02/2011 16:44:08,257 | | ERROR | CDException (gerarLog:182) | 035441 | ST: br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
    14/02/2011 16:44:08,258 | | ERROR | CDException (gerarLog:182) | 035441 | ST: br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
    14/02/2011 16:44:08,259 | | ERROR | CDException (gerarLog:186) | 035441 | GM: (...) could not execute query | class br.gov.camara.negocio.exception.DAOException
    14/02/2011 16:44:08,271 | | INFO | Mensagem (obterMensagem:67) | Erro desconhecido -> Communications link failure due to underlying exception:
    ** BEGIN NESTED EXCEPTION **
    java.net.SocketException
    MESSAGE: Broken pipe
    STACKTRACE:
    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:2616)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2213)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    at br.gov.camara.negocio.DAO.obter(DAO.java:254)
    at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
    at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
    at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
    at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
    at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    ** END NESTED EXCEPTION **
    14/02/2011 16:44:08,278 | | ERROR | UnidadeAutenticadoraBT (autenticarUsuario:102) | autenticarUsuario(String strLoginUsuario = S001, String strSenhaUsuario = Senha) - catch
    br.gov.camara.negocio.exception.DAOException: could not execute query
    at br.gov.camara.negocio.DAO.obter(DAO.java:258)
    at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
    at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
    at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
    at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
    at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:2216)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    at br.gov.camara.negocio.DAO.obter(DAO.java:254)
    ... 39 more
    Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
    ** BEGIN NESTED EXCEPTION **
    java.net.SocketException
    MESSAGE: Broken pipe
    STACKTRACE:
    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:2616)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2213)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    at br.gov.camara.negocio.DAO.obter(DAO.java:254)
    at br.gov.camara.negocio.autenticacaoperfil.dao.UsuarioSistemaDAO.obterPeloLogin(UsuarioSistemaDAO.java:304)
    at br.gov.camara.negocio.autenticacaoperfil.facade.UsuarioSistemaFacade.obterPeloLogin(UsuarioSistemaFacade.java:119)
    at br.gov.camara.seguranca.implementacaobt.UnidadeAutenticadoraBT.autenticarUsuario(UnidadeAutenticadoraBT.java:63)
    at br.gov.camara.visao.autenticacao.sequencia.AutenticacaoSequencia.validarLogonEfetuarLogon(AutenticacaoSequencia.java:241)
    at br.gov.camara.visao.autenticacao.action.AutenticacaoAction.execute(AutenticacaoAction.java:122)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at sigesp.comum.util.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:59)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at br.gov.camara.util.log4j.RequestInfoMDCFilter.doFilter(RequestInfoMDCFilter.java:83)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:595)
    ** END NESTED EXCEPTION **
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2634)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2547)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2213)
    ... 47 more
    14/02/2011 16:44:08,282 | | INFO | AutenticacaoSequencia (validarLogonEfetuarLogon:271) | Logon inválido | S001

Discussões
Blog
Feed do Repositório

Essa comunidade não possui posts nesse blog