This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 223729 - com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10120][10898] Invalid operation: result set is closed.
Summary: com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10120][10898] Invalid operati...
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.3
Hardware: All All
: P3 normal (vote)
Assignee: Jaroslav Havlin
URL:
Keywords:
: 223768 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-12-12 14:17 UTC by vbeffa
Modified: 2012-12-14 02:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 166129

Attachments
stacktrace (820 bytes, text/plain)
2012-12-12 14:17 UTC, vbeffa 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description vbeffa 2012-12-12 14:17:48 UTC 
Build: NetBeans IDE 7.3 Beta 2 (Build 201211062253)
VM: Java HotSpot(TM) 64-Bit Server VM, 20.10-b01, Java(TM) SE Runtime Environment, 1.6.0_35-b10
OS: Windows 7

User Comments:
GUEST: Deleted all the records present in the query with empty result set this strange error is thrown.

vbeffa: getting data from an empty table




Stacktrace: 
com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10120][10898] Invalid operation: result set is closed.
   at com.ibm.db2.jcc.c.wf.mb(wf.java:3193)
   at com.ibm.db2.jcc.c.wf.c(wf.java:247)
   at com.ibm.db2.jcc.c.wf.next(wf.java:234)
   at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.loadDataFrom(SQLExecutionHelper.java:611)
   at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$1Loader.run(SQLExecutionHelper.java:180)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
Comment 1 vbeffa 2012-12-12 14:17:50 UTC 
Created attachment 129269 [details]
stacktrace
Comment 2 Jaroslav Havlin 2012-12-12 15:03:13 UTC 
Is this exception raised every time you try to get data from an empty table?
Thanks.
Comment 3 Jaroslav Havlin 2012-12-12 15:55:52 UTC 
http://hg.netbeans.org/core-main/rev/f66a8a00e35c
Should be fixed now. Please verify.
Thank you for reporting.
Comment 4 vbeffa 2012-12-12 17:07:40 UTC 
(In reply to comment #2)
> Is this exception raised every time you try to get data from an empty table?
> Thanks.

Yes.
Comment 5 vbeffa 2012-12-12 17:08:38 UTC 
(In reply to comment #3)
> http://hg.netbeans.org/core-main/rev/f66a8a00e35c
> Should be fixed now. Please verify.
> Thank you for reporting.

If this can be made available via a NB update, I can verify.
Comment 6 Jaroslav Havlin 2012-12-13 09:21:02 UTC 
(In reply to comment #5)
> If this can be made available via a NB update, I can verify.
It will be available in development builds. You will be informed about integration of the fix to the build. Thank you.
Comment 7 Jaroslav Havlin 2012-12-13 13:25:02 UTC 
*** Bug 223768 has been marked as a duplicate of this bug. ***
Comment 8 Quality Engineering 2012-12-14 02:45:46 UTC 
Integrated into 'main-golden', will be available in build *201212140001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/f66a8a00e35c
User: Jaroslav Havlin <jhavlin@netbeans.org>
Log: #223729: com.ibm.db2.jcc.c.SqlException: Invalid operation: result set is closed

If method ResultSet.next() returns null, it should not be called again.
Simplifying code.