Exception with Java-MySQL connection

Question

I want to connect to DB with Java and MySQL but I´m having problems. I have a class in a package to connect with MySQL so I only have to create an object of this class in jsp file and this package is in Source Packages. I have added the MySQL Java connector to my Project Libraries too. But when I run the project and try to connect with DB I get an exception and I don't know what is the problem. Can you help me please? Thanks!

The exception in NetBeans console:

*Grave: null

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1714)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at DataBase.Model_DB.connectToDB(Model_DB.java:41)
at DataBase.Model_DB.executeSelect(Model_DB.java:57)
at org.apache.jsp._004_002dLogin.registrar_jsp._jspService(registrar_jsp.java:81)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
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:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
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:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)*

And the page with the lines that have the problem:

private Connection connectToDB(){
    try {
        //1-Cargar driver
        Class.forName(driver);
        Connection cn = DriverManager.getConnection(direc,usuario,password);
        return cn;
    } catch (ClassNotFoundException ex) {
        Logger.getLogger(Model_DB.class.getName()).log(Level.SEVERE, null, ex);
        return null;
    } catch (SQLException ex) {
        Logger.getLogger(Model_DB.class.getName()).log(Level.SEVERE, null, ex);
        return null;
    }
}

//Funciones públicas
//Función sólo para sentencias select
public ResultSet executeSelect(String sql){
    //1-Conectamos
    Connection cn = this.connectToDB();
    try {
        //2-Realizar sentencia
        Statement st = cn.createStatement();
        return st.executeQuery(sql);
    } catch (SQLException ex) {
        Logger.getLogger(Model_DB.class.getName()).log(Level.SEVERE, null, ex);
        return null;
    }
}

Answer 1

Looks like you are missing my sql connector in your classpath. You ca download it from here