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 240516 - java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
Summary: java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Ve...
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.4
Hardware: All All
: P3 normal (vote)
Assignee: matthias42
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-15 20:10 UTC by Exceptions Reporter
Modified: 2015-04-04 19:33 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter: 206592

Attachments
stacktrace (1.84 KB, text/plain)
2014-01-15 20:10 UTC, Exceptions Reporter 		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 Exceptions Reporter 2014-01-15 20:10:03 UTC 
This bug was originally marked as duplicate of bug 187470, that is already resolved. This bug is still valid, so this seems to be another bug, but it might be related.

Build: NetBeans IDE 7.4 (Build 201310111528)
VM: Java HotSpot(TM) Client VM, 24.45-b08, Java(TM) SE Runtime Environment, 1.7.0_45-b18
OS: Windows 7

User Comments:
GUEST: Trying to run an SQL command SELECT * From <tablename> where <tablefield> = '2014-01-14'




Stacktrace: 
java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
   at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:0)
   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:0)
   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:0)
   at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:0)
   at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:0)
   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:0)
Comment 1 Exceptions Reporter 2014-01-15 20:10:04 UTC 
Created attachment 144003 [details]
stacktrace
Comment 2 matthias42 2015-04-04 19:33:48 UTC 
There were changes in the result set handling in recent changes. Please test a current netbeans nightly build whether this bug is reproducible. For me this work so a better lead is necessary.

If you can reproduce please reopen this bug and provide a description how you did it: DB, Version, table schema, if possible sample data and steps.

Thank you!