MySql connection issue

[kittu karan]

Hi,
I wrote below code
import java.io.*;
import java.sql.*;
public class JdbcConnection {
public static void main (String[] args)
{
try{
String userName = "root";
String password = "admin";
//String url = "jdbc:mysql://localhost:3306/test";
String url="jdbc:kiran";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
Connection conn = DriverManager.getConnection (url,userName ,password );
System.out.println ("Database connection established");
}catch (Exception e)
{
e.printStackTrace();
System.err.println ("Cannot connect to database server");
}
}
}

I created DSN name as kiran using MySQL ODBC 3.51 Driver.
No compilation error occuring but runtime error is occuring like

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
other exception regarding url and classloader
whether I have to set any jar files.

[Jeanne Boyarsky]

Kiran,
Is the mysql driver in your runtime classpath?

[kittu karan]

No, I don't have.

[Scott Selikoff]

Download it from the MySQL website. Just search google for: mysql java connector.

[Muhammad Saifuddin]

Originally posted by kiran peruka:
No, I don't have.

then you should have.