MySQL JDBC Driver ClassNotFound

Hi,

I have problem to make a connection to mySQL db

Here's the code in NetBeans 7

public class TestConnection {
public static void main(String[] argv) throws Exception
{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");

if (!con.isClosed())
{
System.out.println("Connected");
con.close();
}
else {System.out.println("Not connected");}


}
}

I'm using XP n I have set the classpath in the system environment variable to the folder that hold the jar for msql connection.

However I get this error message :
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 06)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 51)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at TestConnection.main(TestConnection.java:14)

I've browsed the topics n see many things but mostly about classpath which I already set, so now in quite a confusion.
Anyway I intended to first check the connection to MySQL before anything else which I never do before.

I also use javac from command line with including -cp <path to mysql connection jar file> file.java....then run java file, also generating around the same error message


Thanks in advance

Changing the code into :

public static void main (String[] args)
{
Connection conn = null;

try
{
String userName = "root";
String password = "root";
String url = "jdbc:mysql://localhost:3306/test";
Class.forName ("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection (url, userName, password);
System.out.println ("Database connection established");
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server");
System.out.println (e);
}
finally
{
if (conn != null)
{
try
{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) { /* ignore close errors */ }
}
}
}

Just see from one post that seems working n here's the debug in netbeans

debug:
Cannot connect to database server
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
BUILD SUCCESSFUL (total time: 1 second)

I've set the library in Tools - Libraries...adding the path to mysql connector jar file n even specifically point to the jar file itself.

You are not adding MySQL library to your project. To add this using netbeans
Right click your project, you can see it in project window.
Then, click properties>libraries>Add Library>Import> select MySQL JDBC Library.

That solve the problem with netbeans but I'm curious as to how that's done with command line if you know.

Anyway the problem is solved, thanks a lot :(y):

With the command line you use the -cp option to add classpaths.
So:
java -cp<path to jars>;. myclass
Don't forget the "."