Conexão com mysql

2 respostas
R

Bom dia,
Estou montando uma aplicação quese conecta com o banco, a estrutura é + ou - assim:
ManagedBean -> Service -> DAO -> entidade -> banco de dados

Fiz a codificação do banco de dados até o service e criei uma classe de teste, funcionou, conectou corretamente com o banco, mas ao fazer a chamada do banco utilizando o xhtml ele me apresenta um erro “SQL Error: 0, SQLState: 08001”, alguem pode me dar uma dica?
Valeu

2 Respostas

zoren

Esse é o erro completo??

R
12:31:50,375 ERROR [STDERR] 22/04/2009 12:31:50 com.sun.facelets.FaceletViewHandler handleRenderException

SEVERE: Error Rendering View[/index.xhtml]

javax.el.ELException: Error reading topo on type br.com.adm.bean.TopoMB

at javax.el.BeanELResolver.getValue(BeanELResolver.java:66)

at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)

at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)

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

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

at com.sun.facelets.el.ELText$ELTextVariable.toString(ELText.java:174)

at com.sun.facelets.el.ELText$ELTextComposite.toString(ELText.java:115)

at com.sun.facelets.compiler.CommentInstruction.write(CommentInstruction.java:38)

at com.sun.facelets.compiler.UIInstructions.encodeBegin(UIInstructions.java:39)

at com.sun.facelets.compiler.UILeaf.encodeAll(UILeaf.java:149)

at javax.faces.component.UIComponent.encodeAll(UIComponent.java:942)

at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:578)

at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:100)

at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:176)

at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:109)

at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)

at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)

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

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

at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)

at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)

at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:390)

at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:517)

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

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

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

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

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

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

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

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)

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

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

at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)

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

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

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)

at java.lang.Thread.run(Unknown Source)

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Cannot open connection

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)

at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:99)

at br.com.adm.dao.TopoDAO.buscaTopo(TopoDAO.java:43)

at br.com.adm.service.TopoService.buscaTopo(TopoService.java:16)

at br.com.adm.bean.TopoMB.getTopo(TopoMB.java:14)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)

 41 more

Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)

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

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

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

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

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 org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:80)

 49 more

Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/ferramenta

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)

 63 more

12:31:50,390 INFO  [STDOUT] <<<<<<<<<<<<<<entrou no get

12:31:50,390 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 08001

12:31:50,390 ERROR [JDBCExceptionReporter] No suitable driver found for jdbc:mysql://localhost/ferramenta

lembrando que se eu executar por um teste eu consigo me conectar mas, pelo xhtml eu não consigo!

Criado 22 de abril de 2009
Ultima resposta 22 de abr. de 2009
Respostas 2
Participantes 2