Insertion Of Data

Ranch Hand

Posts: 37

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Thomas Paul

mister krabs

Posts: 13974

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

Navtaj Singh

Ranch Hand

Posts: 37

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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).]

Matthew Taylor

Rancher

Posts: 110

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

Grails Consultant
http://dangertree.net

Bob Backlund

Ranch Hand

Posts: 51

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Change:

ResulSet RS = statment.executeQuery(...)
to
int RS = stmt.executeUpdate(...)

That should sort it.

Cheers!

He was giving me directions and I was powerless to resist. I cannot resist this tiny ad:

free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth

https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter