Hi! I am using MS-access as backend and jdbc connection for transfering data from a servlet.But it gives an error saying that:SQL Exception, no resultset was created. The Select ,Create table statement were executed successful. Only the Insert statement is not executing correctly. Navi
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.
Joined: Jan 30, 2001
Ahoy! Anybody Ahoy! Please Help me out! Navi [This message has been edited by Navtaj Singh (edited February 16, 2001).] [This message has been edited by Navtaj Singh (edited February 16, 2001).]