Java Mysql Driver Error

I have just installed Mysql 5 and MySQL Connector/J 5.0. I try to load driver. Here is my code.

VB Code:

import java.sql.*;
 
public class TestMysql
{
  public static void main(String args[]) throws Exception{
      String driver = "com.mysql.jdbc.Driver";      
      Class.forName( driver );      
  }
}

Then i compiled and run. The following message display.

VB Code:

Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driv
er
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClassInternal(Unknown Source)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at TestMysql.main(TestMysql.java:7)

What does it mean? I am new to Java and Mysql. Please tell me step by step to connect Java with Mysql.

That looks right... Have you even installed mysql??

Quote:

---

Originally Posted by System_Error

That looks right... Have you even installed mysql??

---

It's not that he didn't install but I beleive the problem is in the IDE he's using

I have installed MySql already. I didn't use any Java IDE. I use Notepad and compile and run it in DOS Prompt.

Try explicitly tellling the JVM which to use:

java -Djdbc.drivers=com.mysql.jdbc.Driver YourJavaProgram

or something like that.

You could also do this:

Class.forName("com.mysql.jdbc.Driver").newInstance();


PS: Good job on writing and compiling the real way ;)

Code:

---

    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test?user=procopio&password=alibi");
        } catch (Exception ex) {
            ex.printStackTrace();
        }

---

Works fine with me. You should check the classpath variable for the runtime to locate the class com.mysql.jdbc.Driver.

Please see, http://vbforums.com/showthread.php?t...ight=classpath