Error in connection

[Rupashree Kalita]

Hi, The following code is giving continuously error..I requust you to help me. I tried a alot on this code..


import java.sql.*;

public class CreateCoffees {

public static void main(String args[]) {

String url = "jdbc dbc:COFFEES";
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("sun.jdbc.odbc.JdbcOdbcDriver");

} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection(url,"sa","");

stmt = con.createStatement();
stmt.executeUpdate(createString);

stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}

[edited to disable smilies]
[ September 13, 2004: Message edited by: Jeanne Boyarsky ]

[Giju George]

Hi, The following code is giving continuously error..I requust you to help me. I tried a alot on this code..


You didn't mention what type of error you are getting!!.
Is your odbc configured correctly... ?
do u have sufficient rights to create tables in the database... ?
what type of database are u using ...?