JDBC Problem - com.mysql.jdbc.Driver

[icu222much]

I am trying to connect to my MySQL DB with JDBC but I am having a problem with my servlet. I have my Data Access Object class which is able to establish a connection with the db. In my servlet init() function, I try to establish a connection using my DAO class but I keep getting the error message "com.mysql.jdbc.Driver". I do not understand what is happening as this worked fine in the DAO class.


Servlet.java

private Dao dao = new Dao();

public void init() {
 	dao.connectToDB();   	
}

Dao.java

public  void connectToDB() {
    try {
        Class.forName ("com.mysql.jdbc.Driver").newInstance ();
        conn = DriverManager.getConnection (databaseURL, userName, password);
        System.out.println ("Database connection established");           
    } catch (Exception e) {
        System.err.println ("Cannot connect to database server");
        System.err.println ("Error message: " + e.getMessage());
    }  finally  {
        if (conn != null) {
            try {
                conn.close ();
                System.out.println ("Database connection terminated");
            } catch (Exception e) { }
        }
    }
}

[masijade]

Always produce a complete stacktrace, even if only to a logfile. That is a "ClassNotFoundException". You do not have the dirver jarfile on your classpath.

[icu222much]

How do I do a complete trace stack?

Can you further elaborate on "You do not have the dirver jarfile on your classpath"? Dao class worked by itself, and it is in the same project as my Servlet class.

[icu222much]

Problem is solved. Didn't realize that for a servlet you need to put the JAR file inside the web-inf/lib/ folder.

I solved the problem.
java - MySQL jdbc driver and Eclipse: ClassNotFoundexception com.mysql.jdbc.Driver - Stack Overflow

[masijade]

ClassNotFound is ClassNotFound. I have no idea what you did to come out with the statement "Dao class worked by itself", so I can only assume that whatever it was has nothing to do with the current situation. Also, "driver not on your classpath" is fairly self explanatory to me. See the documentation for your web container as to where you need to place jarfiles (sometimes a different place for driver jarfiles) and place it there.

[icu222much]

Sorry, I am still fairly new at this so I wasn't exactly sure what "ClassNotFound" exactly meant.

What I meant by "Dao class worked by itself" was that when I ran the connectToDB() method from Dao.java (which is placed in the same project as Servlet.java), I did not get any error. That is what confused me.

Thank you for your help though