MySQL jdbc driver ClassNotFoundException: com.mysql.jdbc.Driver

Question

After googling a lot and seeing the answers here on SO of similar questions, I am still getting this error of ClassNotFoundException.

I tried the method here and here.

My apache tomcat webapps directory is C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps. I also uploaded the mysql-connector-java-5.1.22-bin.jar file in C:\Program Files\Java\jre7\lib as mentioned in some of answers here in SO.

In my webapps/jsp folder I created an index.jsp file but it shows an error in the line Class.forName("com.mysql.jdbc.Driver").newInstance();

My current folder structure is:

     C:\
        -> Program Files
            -> Apache Software Foundation 
                ->  Tomcat 6.0
                    -> webapps
                         -> jsp
                             -> index.jsp
                             -> WEB-INF
                                 ->  lib
                                     -> mysql-connector-java-5.1.22-bin.jar

Can anyone help me out?

jars from `jre/lib/ext` (not `jre/lib`) get into classpath automatically, if I'm not mistaken. — Andrew Logvinov, Dec 05 '12 at 10:15
@AndrewLogvinov well, I had copied the jar file in both the folders /lib and /lib/ext — gopi1410, Dec 05 '12 at 10:16
Do not modify the jre libraries because sooner or later you will end with compatibility issues; add the libraries to your webapp libraries. — SJuan76, Dec 05 '12 at 10:21

Abubakkar · Accepted Answer · 2012-12-05T10:40:33.650

2

Put all of your libraries under this kind of structure :

  C:\
    -> Program Files
        -> Apache Software Foundation 
            ->  Tomcat 6.0
                -> webapps
                     -> Your web application
                         -> WEB-INF
                             ->  lib
                                 -> mysql-connector-java-5.1.22-bin.jar (and all other required jars)

You should include all your libraries inside the lib folder as any classes that your web app requires will be available to it readily from there.

This what servletworld.com says
"... classes and resources in JAR files under the /WEB-INF/lib directory are included in classpath and made visible to the containing web application."

edited Dec 05 '12 at 10:40

answered Dec 05 '12 at 10:19

Abubakkar

15,488
8
55
83

Still, not working. When I run `localhost:8080/jsp` in my browser, I still get the same error! – gopi1410 Dec 05 '12 at 10:27
@Abu: I added my directory structure in my question above, check it – gopi1410 Dec 05 '12 at 10:30
@Yevgeniy I added some explanation – Abubakkar Dec 05 '12 at 10:40

score -1 · Answer 2 · answered Dec 05 '12 at 10:18

-1

You can include the mysql jar file in the web application itself. Include the jar in C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\\WEB-INF\lib\mysql-connector-java-5.1.22-bin.jar

answered Dec 05 '12 at 10:18

Mayuran

669
2
8
39

yep, had seen this somewhere. But there is **NO** WEB_INF folder in my webapps. I even tried creating one, but still no effect. – gopi1410 Dec 05 '12 at 10:19
Then you must create one... – Vishal Dec 05 '12 at 10:21
It is not WEB_INF. It is WEB-INF(hyphen). Try with it – Mayuran Dec 05 '12 at 10:26
yup, actually my mistake. I had tried with WEB-INF. – gopi1410 Dec 05 '12 at 10:28

MySQL jdbc driver ClassNotFoundException: com.mysql.jdbc.Driver

2 Answers2