MySQL JDBC Driver ClassNotFound

[Levian]

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

[Levian]

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.

[mine0926]

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.

[Levian]

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

[Tolls]

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