problem with mysql jdbc connection

[guptabandhu roy]

hi ,
i am using MySql database 5.0.

    
 import java.sql.*;
class TestUsers 
{
public static void main(String[] args) 
{   try{
Statement stmt;
ResultSet rs;
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        String url="jdbc:sql://localhost:3306/csehackers";
Connection con=DriverManager.getConnection(url,"root","krypton");
stmt=con.createStatement();
stmt.executeUpdate("insert into users values('indranil ghosh','85-10-03','hasta','motu','[e-mail]'");
con.close();
}
catch(Exception e)
{ e.printStackTrace();
}

 
System.out.println("Hello World!");
}
}
 

i am getting the following o/p :-
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        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 TestUsers.main(TestUsers.java:8)
Hello World!   
 

[prash patil]

Hi
Add the MySQL Jar file to the Classpath.
i.e. mysql-connector-java-3.0.16-ga-bin.jar
You can find it at
Driver JAR

regards,
PP