471,870 Members | 1,353 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,870 software developers and data experts.

SQLException No ResultSet set was produce

Hi Everyone,
I am gettiing exception while deleting a record,that
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
But the record is deleted successfully. Please help me.

Thanks,
Raja Mohammed
Aug 8 '07 #1
6 15687
JosAH
11,448 Expert 8TB
Hi Everyone,
I am gettiing exception while deleting a record,that
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
But the record is deleted successfully. Please help me.

Thanks,
Raja Mohammed
Show us a bit of code please; to me it makes sense that no ResultSet was
produced because you deleted a record (which worked as you wrote) but I
suspect you still want to do something with that (non-existent) ResultSet.

kind regards,

Jos
Aug 8 '07 #2
praveen2gupta
201 100+
Hi Everyone,
I am gettiing exception while deleting a record,that
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
But the record is deleted successfully. Please help me.

Thanks,
Raja Mohammed
Hi
Your error is absolute right. Resultset is required for the select command only. When data is coming from table to the web page. while for delete,update and insert operations you required to executeUpdate only. There is no role of Resultset in these cases. In these command you are performing operation on the tables.
Aug 8 '07 #3
Hi
Your error is absolute right. Resultset is required for the select command only. When data is coming from table to the web page. while for delete,update and insert operations you required to executeUpdate only. There is no role of Resultset in these cases. In these command you are performing operation on the tables.
Hi JosAH, Praveen,
Thanks for your help. previously I used executeQuery. Now I used excuteUpdate. Now the exception is not coming, Thanks a lot.
-Raja Mohammed
Aug 9 '07 #4
Hi all. This article helped me when i was searching for this exception.

--Santhosh ch
Mar 1 '12 #5
Thanks everyone. This post helped me in hunting down the issue
Jul 9 '12 #6
use executeUpdate instead of executeQuery
Aug 8 '16 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Eckard Buchner | last post: by
reply views Thread by David Linsin | last post: by
madhoriya22
21 posts views Thread by madhoriya22 | last post: by
5 posts views Thread by lost1 | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.