CreateCoffees

[bernd pier]

hey,
i`m just a newbee in java and database.
i work with suse 7.3, j2sdk1.4.0, mm.mysql driver and mysql.
on java.sun.com i found a java tutorial and follow the examples.but the first example CreateCoffees doesn`t work.
here is the code

import java.sql.*;
 
public class CreateCoffees {
public static void main(String args[]) {
 
String url = "jdbc:mysql:CafeJava";
Connection con;
String createString;
createString = "create table COFFEES " +
"(COF_NAME varchar(32), " +
"SUP_ID int, " +
"PRICE float, " +
"SALES int, " +
"TOTAL int)";
Statement stmt;
 
try {
Class.forName("org.gjt.mm.mysql.Driver");
 
} catch(java.lang.ClassNotFoundException e) {
 
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
 
try {
con = DriverManager.getConnection(url,"root", "");
 
stmt = con.createStatement();
       stmt.executeUpdate(createString);
 
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}

when i run this program the following error comes:
linux:~/tomcat/webapps/examples/codeExamples/firstEdition # javac CreateCoffees.
java
linux:~/tomcat/webapps/examples/codeExamples/firstEdition # java CreateCoffees
SQLException: No suitable driver
linux:~/tomcat/webapps/examples/codeExamples/firstEdition #

is there anybody out there who have an idea?
thanks bernd
[ Edited by Dave to format code and highlight error ]
[ June 23, 2002: Message edited by: David O'Meara ]

[Bosun Bello]

Do you have the mySQL driver downloaded? If you do, do oyu have it in the appropriate directory?

[David O'Meara]

"beatles",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave

[bernd pier]

[halleluja,
the problem is fixed.
bernd