Insertion Of Data
posted 17 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
posted 17 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 17 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
posted 17 years ago
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).]
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).]
posted 14 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
posted 14 years ago
Change:
ResulSet RS = statment.executeQuery(...)
to
int RS = stmt.executeUpdate(...)
That should sort it.
ResulSet RS = statment.executeQuery(...)
to
int RS = stmt.executeUpdate(...)
That should sort it.
Cheers!
| With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |