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
Joined: May 05, 2000
The insert statement won't create a ResultSet. What is the actual error?
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).]
Joined: Jun 13, 2004
Okay, this topic is about 4 years old, but I'm going to answer it anyway.
The reason the executeQuery() is not producing a result set is because you're making an update, not pulling information with a query.
You should use the executeUpdate() method with your update when you are creating a table or inserting data. The executeUpdate() method returns an int, I think, being the status of the update.
That should update the DB. You don't even need to return anything if you don't want to. There will not be a result set.
Joined: Jun 05, 2003
ResulSet RS = statment.executeQuery(...) to int RS = stmt.executeUpdate(...)