ClassNotFoundException...

I have been working for hours trying to get rid of this error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

And yes, I do have the build path configured in my IDE (eclipse), I also have copied the connector.jar file into just about every conceivable folder in my project. At a complete loss here.. Please note, Im trying to write to the database from a servlet. Anyone know whats goin' down?

The code that generates the error is below, if you need further code samples I'll be more than happy to post 'em:

Code:

---

String dbName = "testdb";
        String url = "jdbc:mysql://localhost:3306/";
        String username = "...";
        String password = "...";
        Connection con = null;
        String driver = "com.mysql.jdbc.Driver";
        Class.forName(driver).newInstance();

---

Yes. you haven't properly configured the "execution path". I.E. Add the jar as a reference/library, do not just add it to the "build path" (which is wrong anyway since the "build path" describes what should be compiled in eclipse, not where to find the libraries) and the jar is not needed for compilation anyway, as no where in your code do you directly reference one of the classes in it. You have a String containing a classname in it, and a lot of references to interfaces defined in the standard language, so you do not need the jar during compilation, only during execution.

Thanks, that was indeed part of the problem. I also had to add the .jar to the tomcat/lib folder.