ClassNotFoundException when trying to connect to Mysql database

[mchammer11]

Hi all,

I am trying to get my program to connect to a mysql database, and I am getting a ClassNotFoundException: com.mysql.jdbc.Driver error. My code is below:

public void connect() {
    Connection conn = null;

    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      conn = DriverManager.getConnection("jdbc:mysql://localhost/cmp_wrkr",
                                                         "root", "myPassHere");
                //TODO remove debug
		System.out.println("Connected");

    } catch(Exception e) {
	 	e.printStackTrace();

    } finally {
      try {
        if(conn != null)
          conn.close();
      } catch(SQLException e) {}
   }

Thanks in advance for your help

[r035198x]

Add the mysql driver to the classpath.

[mchammer11]

Do you have an example of this? I can't seem to find a good one.

[Fubarable]

Much depends on how you are compiling and running the code. Are you doing this on the command line? In NetBeans? Eclipse? JCreator? Other?

If the command line, have you looked at the standard Sun tutorials on the classpath?

[mchammer11]

I am trying to do this using Eclipse

[Fubarable]

I am trying to do this using Eclipse

Then you'll need to add the jar to your project's build path. Right click on your project in the package view window on the left and then click on properties. Find the java build path and click on it, and then try to add the jar by going into the Libraries tab.

[mchammer11]

Awesome, it worked. Thanks so much Fubar!

[Fubarable]

You're welcome