Insertion Of Data
Navtaj Singh
Ranch Hand
Posts: 37
posted 16 years ago
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
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
Thomas Paul
mister krabs
Ranch Hand
Ranch Hand
Posts: 13974
posted 16 years ago
The insert statement won't create a ResultSet. What is the actual error?
Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Navtaj Singh
Ranch Hand
Posts: 37
posted 16 years ago
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.
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.
Navtaj Singh
Ranch Hand
Posts: 37
Matthew Taylor
Rancher
Posts: 110
posted 12 years ago
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.
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.
Grails Consultant
http://dangertree.net
| It is sorta covered in the JavaRanch Style Guide. |