Discussoes de Programacao e Tecnologia

Hibernate + mysql + jboss

4 respostas
P
pm1

tenho um ambiente com jboss+hibernate+mysql

a aplicacao funciona blz… so que apos umas 12 horas a aplicação não consegue mais conectar com o banco.

segue a exceção

2005-04-25 09:36:15,630 INFO  [STDOUT] Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
2005-04-25 09:36:15,630 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2005-04-25 09:36:16,630 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
	at java.net.SocketInputStream.socketRead0(Native Method)
	at java.net.SocketInputStream.read(SocketInputStream.java:129)
	at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:75)
	at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:94)
	at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:122)
Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

4 Respostas

P
pm1

com o mysql client eu acesso normalmente…

T
thingol

Aham, será que alguma coisa está deixando sockets abertos? (como conexões mal-fechadas etc.)
dê um netstat -an e veja se há muitas conexões em ESTABLISHED ou TIME_WAIT com a porta que o MySQL está usando para responder a requisições. Só um palpite - não sou um MySQL-man.

rubinelli
rubinelli

Isso tem cara de conexão com banco sendo largada aberta… você pode checar quantos usuários estão pendurados no banco usando o MySQL Administrator.

Se for isso mesmo, aí o negócio é caçar as sessions largadas no seu código. Aí eu não posso ajudar, que em Hibernate eu sou café com leite. :slight_smile:

P
pm1

vlw....
vou dar uma olha nisso pela manha

to enviando mais alguns detalhes do que esta acontecendo

segue o log gerado pelo tomcat 
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#selma]
LOGIN >> : selma
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#selma]
LOGIN >> : selma
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#selma]
LOGIN >> : selma
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#selma]
LOGIN >> : selma
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#selma]
LOGIN >> : selma
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#selma]
LOGIN >> : Administrator
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
LOGIN >> : Administrator
Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
[EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
log no jboss 
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.SQL] select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
2005-04-26 00:14:32,077 INFO  [STDOUT] Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
	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:66)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2620)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2638)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)
2005-04-26 00:14:32,077 WARN  [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 08S01
2005-04-26 00:14:32,077 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
	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:66)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2620)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
	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:66)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2620)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2638)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)
2005-04-26 00:14:32,077 WARN  [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 08S01
2005-04-26 00:14:32,077 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
	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:66)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2620)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


2005-04-26 00:14:32,077 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
	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:66)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2620)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2638)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1512)
	at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
	at com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
	at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
	at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911)
	at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
	at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
	at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:419)
	at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
	at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991)
	at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
	at br.com.ideal.agendaLight.dao.hibernate.UsuarioSistemaHibernate.getDescricaoPerfil(UsuarioSistemaHibernate.java:46)
	at br.com.ideal.agendaLight.action.util.BemVindoAction.execute(BemVindoAction.java:45)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	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:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:162)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:534)
2005-04-26 00:14:32,077 INFO  [STDOUT] [EXCEPTION PerfilHibernate.getDescricaoPerfil()]could not load: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.impl.SessionImpl] closing session
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.impl.SessionImpl] disconnecting session
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.connection.DriverManagerConnectionProvider] returning connection to pool, pool size: 1
2005-04-26 00:14:32,077 DEBUG [net.sf.hibernate.impl.SessionImpl] transaction completion
2005-04-26 00:14:44,515 INFO  [STDOUT] LOGIN >> : Administrator
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.impl.SessionImpl] opened session
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.impl.SessionImpl] object not resolved in any cache [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.persister.EntityPersister] Materializing entity: [br.com.ideal.agendaLight.bean.UsuarioSistemaBean#Administrator]
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 2 open PreparedStatements, 0 open ResultSets
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.connection.DriverManagerConnectionProvider] total checked-out connections: 0
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.connection.DriverManagerConnectionProvider] using pooled JDBC connection, pool size: 0
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.SQL] select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
2005-04-26 00:14:44,515 INFO  [STDOUT] Hibernate: select usuariosis0_.login as login1_, usuariosis0_.nome as nome1_, usuariosis0_.perfil as perfil1_, perfilbean1_.id as id0_, perfilbean1_.descricao as descricao0_, perfilbean1_.ativo as ativo0_ from SYS_USUARIO usuariosis0_ left outer join SYS_PERFIL perfilbean1_ on usuariosis0_.perfil=perfilbean1_.id where usuariosis0_.login=?
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2005-04-26 00:14:44,515 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
	at java.net.SocketOutputStream.socketWrite0(Native Method)
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

o hibernate.cfg

[code]

"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">





net.sf.hibernate.dialect.MySQLDialect
root
xxxxxxxx
jdbc:mysql://localhost:3306/DB_XXXXX
com.mysql.jdbc.Driver
true
true
net.sf.hibernate.transaction.JDBCTransactionFactory
1
false
true
true
true










[/]

Criado 27 de abril de 2005
Ultima resposta 28 de abr. de 2005
Respostas 4
Participantes 3

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura O que são algoritmos e lógica de programação e como aprender? Entenda o que são algoritmos e lógica de programação e qual é a importância desses conceitos para começar a programar
Casa do Codigo Desbravando SOLID: Praticas avancadas para codigos de... Por Alexandre Aquiles — Casa do Codigo