do i need odbc to run java applications - reg connection

[riyaz udeen]

iam new to jdbc . i hav installed mysql 4.1.
since iam working on java & jdbc, i got the zip of connector/j 3.1.8.
i unzipped it in a folder-a & added the folder to class path env variables.moreover i also added the myconnector-java-3.1.8-bin jar file avl inside the above a - folder.moreover i did not found
the com & org sub directorie in the unziped folder-a.

when i runned this programm after sucessgully starting the mysql server
i got this messg:

SQLException: No suitable driver
SQLState: 08001
VendorError: 0

the programm is :

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;

public class start {
public static void main(String[] args) {

Statement st ;
String create;
create = " CREATE TABLE tea ( tea_name VARCHAR (20), id NUMBER (3))";



try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) { }

try {
Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1/testuser=riyaz&password=zarina");
st = c.createStatement();
st.executeUpdate (create);
st.close();
c.close();
}
catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
}
}

kindly provide me the rectification for this problm.moreover i dont have mysql driver in my system.thank u .

regards
riyaz

[Bear Bibeault]

Please do not post the same question more than once.