Caro amigos do GUJ, venho mais uma vez recorrer a ajuda de vocês, sou iniciante em aplicações WEB mas, acredito que o erro que esta dando em meu código nem é tanto por causa desse minimo detalhe (INICIANTE). O problema é que estou tendo um erro no DRIVER do mysql, gostaria de saber se alguém poderia me ajudar, estou colocando o problema para analizarem.
CLASSE RESPONSAVEL EM FAZER A PERSISTENCIA NO BD:
package br.com.WEBProject.DAO;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import br.com.WEBProject.MODELO.Contato;
public class AdicionaContatoDAO {
private Connection connection = null;
private PreparedStatement stmt = null;
private String URL_BANCO = "jdbc:mysql://localhost/webproject";
private String USER_BANCO = "root";
private String SENHA_BANCO = "123456";
private String DRIVER_BANCO = "com.mysql.jdbc.Driver";
public void adicionaContato(Contato contato){
String sql = "insert into contato(nome, endereco, email, dataNascimento) values(?, ?, ?, ?)";
try {
Class.forName(DRIVER_BANCO);
connection = DriverManager.getConnection(URL_BANCO, USER_BANCO, SENHA_BANCO);
stmt = connection.prepareStatement(sql);
stmt.setString(1, contato.getNome());
stmt.setString(2, contato.getEndereco());
stmt.setString(3, contato.getEmail());
stmt.setDate(4, new Date(contato.getDataNascimento().getTimeInMillis()));
stmt.execute();
stmt.close();
} catch (Exception e) {
e.printStackTrace();
}
finally{
try {
connection.close();
stmt.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
}
PROBLEMA GERADO:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1533)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at br.com.WEBProject.DAO.AdicionaContatoDAO.adicionaContato(AdicionaContatoDAO.java:23)
at br.com.WEBProject.BO_NEGOCIO.ContatoBO.inserirContato(ContatoBO.java:22)
at br.com.WEBProject.SERVLET.AdicionaContatoServlet.service(AdicionaContatoServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
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:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
java.lang.NullPointerException
at br.com.WEBProject.DAO.AdicionaContatoDAO.adicionaContato(AdicionaContatoDAO.java:37)
at br.com.WEBProject.BO_NEGOCIO.ContatoBO.inserirContato(ContatoBO.java:22)
at br.com.WEBProject.SERVLET.AdicionaContatoServlet.service(AdicionaContatoServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
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:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)