Hi! Thanks for answering
Well here is the code bit ,:-
String str="create table student(stid Number,stname Number)";
res=stm.executeQuery(str);
PreparedStatement pstm=con.prepareStatement("INSERT INTO student (stid,stname) VALUES (?,?)");
pstm.setInt(1,9);
pstm.setInt(2,6);
pstm.executeUpdate();
ResultSet res1=stm.executeQuery("SELECT stid,stname FROM student");
out.println("<html>");
...
...
The error is :-
SQLException caught : No ResultSet was produced .
When i check the ms-access database,the table gets created
but the "Insert" statement does not execute.
ie.
Thanks
Navi.