Getting an Exception wile accessing data

[Jay Shukla]

Hi I'm just trying to access data for testing purpose only.

For this i have created mysql data "test" and created a table "country" (srno, countryname).

I have created following java class and trying to pull filed values from above table country.

ShowParameters.java

    
package com;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class ShowParameters{
    public static void main(String args[]) throws Exception{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
        System.out.println("Connection con is : " + con);
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("select * from country");
        while(rs.next()){
            System.out.print(rs.getInt(1));
            System.out.println(rs.getString(2));
        }
        stmt.close();
        con.close();
    }
}

But i'm getting following Exception.

    
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.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at com.ShowParameters.main(ShowParameters.java:20)
Java Result: 1

I'm using NetBeans 6.1 to create mysql database and java class.

Could anyone please tell me what is going wrong in above source code.

Thanks in Advance.

[Henry Wong]

The mysql (jdbc driver) jar file is not in your class path. You need to configure netbeans to include it.

Henry

[Jay Shukla]

Hi Henry,

Thanks a lot for reply. Could you let me the exact name of the jar so that i can add it.

[Rob Spoor]

http://dev.mysql.com/downloads/connector/j/5.1.html

[Campbell Ritchie]

Maybe late, but this would sit better on our databases forum. Moving.