Boa noite amigos, estou estudando a apostila fj-21 e estou no capitulo 5.9 no exercicio criando funcionalidade para grava contatos
o problema é que quando testo a aplicação aparece essa página de erro:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3006/fj21?user=root&password=kaue161187
br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:12)
br.com.caelum.jdbc.ContatoDAO.(ContatoDAO.java:18)
br.com.caelum.servlet.AdicionaContatoServlet.service(AdicionaContatoServlet.java:49)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3006/fj21?user=root&password=kaue161187
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:10)
br.com.caelum.jdbc.ContatoDAO.(ContatoDAO.java:18)
br.com.caelum.servlet.AdicionaContatoServlet.service(AdicionaContatoServlet.java:49)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.21 logs.
Apache Tomcat/7.0.21
e no log do eclipse me da esse erro
Conectando ao banco
29/09/2011 20:14:10 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [AdicionaContato] in context with path [/fj21-agenda] threw exception
java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3006/fj21?user=root&password=kaue161187
at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:12)
at br.com.caelum.jdbc.ContatoDAO.<init>(ContatoDAO.java:18)
at br.com.caelum.servlet.AdicionaContatoServlet.service(AdicionaContatoServlet.java:49)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3006/fj21?user=root&password=kaue161187
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at br.com.caelum.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:10)
... 19 more
Não sei aonde pode estar o erro, pois quando testo só a classe de conexão funciona, se alguem puder ajudar agradeço, o jdbc do mysql ja esta no buildpath e tb na pasta libs do tomcat
Atenciosamente Igor Dutra!
