my dog learned polymorphism*
The moose likes JDBC and the fly likes Insertion  Of  Data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Insertion  Of  Data" Watch "Insertion  Of  Data" New topic
Author

Insertion Of Data

Navtaj Singh
Ranch Hand

Joined: Jan 30, 2001
Posts: 37
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
Ranch Hand

Joined: May 05, 2000
Posts: 13974
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

Joined: Jan 30, 2001
Posts: 37
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

Joined: Jan 30, 2001
Posts: 37
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

Joined: Jun 13, 2004
Posts: 110
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

Joined: Jun 05, 2003
Posts: 51
Change:

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

That should sort it.


Cheers!
 
wood burning stoves
 
subject: Insertion Of Data
 
Similar Threads
JDBC and Stored Procedure
Which is best and y
Implementing CASCADE DELETE using Java
xml is for describing data
How to submit a null in radio button