Problema de conexão com o mysql

e ai galera,

to usando o hibernate numa aplicação web aqui usando aquele esquema do openSessionInView, só que estou recebendo a seguinte exception:

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:2739) 
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650) 
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581) 
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) 
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004) 
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128) 
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222) 
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) 
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) 
at org.hibernate.loader.Loader.doQuery(Loader.java:662) 
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) 
at org.hibernate.loader.Loader.doList(Loader.java:2145) 
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) 
at org.hibernate.loader.Loader.list(Loader.java:2024) 
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392) 
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333) 
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) 
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114) 
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) 
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756) 
at helpframework.persistencia.hibernate.impl.HibernateGenericDAO.getUniqueResultByQuery( HibernateGenericDAO.java:412) 
at br.com.easycm.dao.AbstractDefaultUserDAO.logar(AbstractDefaultUserDAO.java:94) 
at br.com.easycm.web.LoginFilter.doFilter(LoginFilter.java:87) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:585) 
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243) 
at java.security.AccessController.doPrivileged(Native Method) 
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) 
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275) 
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:217) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha in.java:197) 
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.jav a:50) 
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156 ) 
at java.security.AccessController.doPrivileged(Native Method) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 152) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) 
at br.com.locaweb.tomcat.LocaWebValve.invoke(LocaWebValve.java:101) 
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 ** 

Alguem sabe o motivo?

Alberto

:arrow: O MySQL , esta rodando em outra maquina ?,
:arrow: se tiver o usuário esta liberado para essa maquina ?
:arrow: e tambem a maquina que acessa o servidor do Mysql esta liberada tbm ?

O drive JDBC esta na lib ??
acho que nao ajudei muito hehe

Acho que não , se não estivesse ele soltava a Exception NoClassFound…

[quote=tutan_khamon]O drive JDBC esta na lib ??
acho que nao ajudei muito hehe [/quote]

Humm verdade…

pode ser problema de Firewall como vc tinha falado ou algum bloqueio
tenta instalar o Mysql local para ver se resolver

valeu ae ramilani12 erro meu aqui hehehe

Abraços

Por acaso vc nao tem o norton instalado na maquina , ele bloqueia a porta de conexao…