hi guys...i am trying to use ms access db in my java program(jcreator)...but it throw

[rathna ravi]

import java.sql.*;

import java.io.*;
import java.lang.*;

public class rrw {

public static void main(String args[])throws IOException
{
try
{


Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
System.out.prin tln("driver loaded");


Connection c=null;
c=DriverManager .getConnection( "jdbc:odbc:rat" );
System.out.prin tln(" database connnected...\n ");



Statement st=c.createStat ement();
st.executeUpdat e("create table stud(sno number,sname varchar2(20))") ;
System.out.prin tln("table created");
}
catch(Exception e)
{
e.printStackTra ce();
}
}
}









and the error is:
driver loaded
java.sql.SQLExc eption: No data found
at sun.jdbc.odbc.J dbcOdbc.standar dError(JdbcOdbc .java:7138)
at sun.jdbc.odbc.J dbcOdbc.SQLDriv erConnect(JdbcO dbc.java:3073)
at sun.jdbc.odbc.J dbcOdbcConnecti on.initialize(J dbcOdbcConnecti on.java:323)
at sun.jdbc.odbc.J dbcOdbcDriver.c onnect(JdbcOdbc Driver.java:174 )
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:582)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:207)
at rrw.main(rrw.ja va:27)

[rajujrk]

Use PreparedStateme nt instead of using Statement..

Try the Below Code

PreparedStatement pstmt = conn.prepareStatement("create table stud(sno number,sname varchar2(20))");

    pstmt.executeUpdate();

Before doing this, first study whats the difference between Statement and PreparedStateme nt.