469,338 Members | 8,595 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,338 developers. It's quick & easy.

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 15502
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
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
3 posts views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.