wood burning stoves 2.0*
The moose likes JDBC and the fly likes ClassNotFoundException generated! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ClassNotFoundException generated!" Watch "ClassNotFoundException generated!" New topic
Author

ClassNotFoundException generated!

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi all,
I have written the foll code. But it generated the execption
ClassNotFoundException .What may be the reason??
import java.sql.*;
public class Select {
public static void main(String args[]) {
String url = "jdbc dbc:mrai";
Connection con;
String createString;
createString = "create table COFFEES " + "(COF_NAME VARCHAR(32), " +
"SUP_ID INTEGER, " + "PRICE FLOAT, " + "SALES INTEGER, " + "TOTAL INTEGER)";
Statement stmt;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(java.lang.ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); }
try {
con = DriverManager.getConnection(url, "scott", "tiger");
stmt = con.createStatement();
stmt.executeUpdate(createString);
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage()); }
}
}
Adrian Yan
Ranch Hand

Joined: Oct 02, 2000
Posts: 688
Usually, these type of errors is caused by your incorrect setting in your Classpath variables. May sure you have the class path set up correctly.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: ClassNotFoundException generated!
 
Similar Threads
What's wrong with this code?
No Suitible Driver Error
Class.forName() for drive using Oracle 8i
Access to the Oracle database using Java Applets
Error in connection