Java Connect to database Error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Question

Hey stupid question but I'm having a hard time connecting my java program to a mysql database. Throwing an exception when I hit this line.

Class.forName(driverName).newInstance();

The driver name is com.mysql.jdbc.Driver. I've searched around a bit on google and found something about a mysql-connector.jar file that I'm apparently supposed to have but I really haven't looked into it yet. Thanks.

Entire code:

Connection connection = null;
    try
    {
        String driverName = "com.mysql.jdbc.Driver"; // MySQL MM JDBC driver 
        Class.forName(driverName).newInstance();

        String serverName = "*********";
        String database = "canteen_web3";
        String url = "jdbc:mysql://" + serverName + "/" + database;
        final String username = "*****";
        final String password = "******";
        connection = DriverManager.getConnection(url,username,password);
        System.out.println("Connected!");
    }

    catch(Exception ex)
    {
        throw new ICException(ex.getMessage());
    }

I don't want to be rude, but look into it. (here's a link anyway: mysql.com/downloads/connector/j ) — MByD
– MByD, Commented Aug 4, 2011 at 21:33

Stefan Schubert-Peters · Accepted Answer · 2011-08-04 22:14:45Z

1

Start your app with

java -classpath .:mysql-connector.jar MyClass

The colon separates two paths. The . is the directory you are in (and hopefully the class or the base package), the latter jar is the driver.

For further information refer to the various sources of documentation http://download.oracle.com/javase/1.5.0/docs/tooldocs/windows/classpath.html

edited Aug 4, 2011 at 22:14

answered Aug 4, 2011 at 21:35

Stefan Schubert-Peters

5,4792 gold badges22 silver badges21 bronze badges

I just did add the jar to my C:\Program Files\Java\jre and \jre\lib directories without any success. Also trying to run from the CMD produces the same result. Thanks for the quick reply!

tier1
– tier1

08/04/2011 21:55:31
Commented Aug 4, 2011 at 21:55
The first should not work. I referred to the lib directory of an application container.

Stefan Schubert-Peters
– Stefan Schubert-Peters

08/04/2011 22:04:06
Commented Aug 4, 2011 at 22:04
If you set the classpath you have to set the path of the actual class as well. I forgot that and updated my answer.

Stefan Schubert-Peters
– Stefan Schubert-Peters

08/04/2011 22:15:50
Commented Aug 4, 2011 at 22:15
+1 - this is the only correct answer. You already have the evidence that your solution doesn't work, because the class loader never found that JAR. Believe what the JVM is telling you.

duffymo
– duffymo

08/05/2011 00:25:22
Commented Aug 5, 2011 at 0:25
I ended up getting this to work correctly. Thank you guys for the help

tier1
– tier1

08/05/2011 12:22:49
Commented Aug 5, 2011 at 12:22

Add a comment |

Collectives™ on Stack Overflow

Java Connect to database Error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

1 Answer 1

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related