[jira] [Created] (DERBY-7098) Derby issues an ERROR java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Verify that autocommit is off

["Ed lang (Jira)" <ji...@apache.org>]

Ed lang created DERBY-7098:
------------------------------

             Summary: Derby issues an ERROR  java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Verify that autocommit is off 
                 Key: DERBY-7098
                 URL: https://issues.apache.org/jira/browse/DERBY-7098
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.14.2.0
         Environment: NetBeans IDE 12.0
GLASSFISH 
Java: 1.8.0_265; OpenJDK 64-Bit Server VM 25.265-b01
Runtime: OpenJDK Runtime Environment 1.8.0_265-b01
System: Windows 10 version 10.0 running on amd64; Cp1252; en_US (nb)
            Reporter: Ed lang


While running queries derby issues:  java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Verify that autocommit is off

 

This error appears to be unfounded.

The process it is in has run about 15 queries prior to this.  Each Prepared statement and result set is closed after use.

 

Here are particulars:

*Manifest-Version: 1.0*
Ant-Version: Apache Ant 1.9.5
Created-By: 1.8.0_151-b12 (Oracle Corporation)
Bundle-Vendor: Apache Software Foundation
Bundle-Name: Apache Derby 10.14
Bundle-Version: 10.14.2000000.1828579
Bundle-ManifestVersion: 2
Sealed: true
Bundle-Activator: org.apache.derby.osgi.EmbeddedActivator
Bundle-SymbolicName: derby
DynamicImport-Package: *
Export-Package: org.apache.derby.authentication,org.apache.derby.datab
 ase,org.apache.derby.io,org.apache.derby.jdbc,org.apache.derby.vti
Class-Path: derbyLocale_cs.jar derbyLocale_de_DE.jar derbyLocale_es.ja
 r derbyLocale_fr.jar derbyLocale_hu.jar derbyLocale_it.jar derbyLocal
 e_ja_JP.jar derbyLocale_ko_KR.jar derbyLocale_pl.jar derbyLocale_pt_B
 R.jar derbyLocale_ru.jar derbyLocale_zh_CN.jar derbyLocale_zh_TW.jar

Name: org/apache/derby/impl/tools/sysinfo/
Sealed: false

Name: org/apache/derby/iapi/services/context/
Sealed: false

Name: org/apache/derby/iapi/services/info/
Sealed: false

Name: org/apache/derby/jdbc/
Sealed: false

Name: org/apache/derby/info/
Sealed: false

Name: org/apache/derby/iapi/services/i18n/
Sealed: false

Name: org/apache/derby/shared/common/error/
Sealed: false

Name: org/apache/derby/shared/common/sanity/
Sealed: false

Name: org/apache/derby/iapi/tools/i18n/
Sealed: false

Name: org/apache/derby/loc/
Sealed: false

Name: org/apache/derby/tools/
Sealed: false

 

*At Server Level:*

DP - database.Dictionary : USER : Derby Started at Address: localhost/127.0.0.1 Port: 1527|#]
 DP - database.Dictionary : USER PROPERTIES : \{derby.drda.traceDirectory=E:\opt\avnoc\JAVADB, derby.drda.maxThreads=0, derby.drda.sslMode=off, derby.drda.keepAlive=true, derby.drda.minThreads=0, derby.drda.portNumber=1527, derby.drda.logConnections=false, derby.drda.timeSlice=0, derby.drda.startNetworkServer=false, derby.drda.host=localhost, derby.drda.traceAll=true}|#]
 DP - database.Dictionary : USER runTimeInfo : --- Derby Network Server Runtime Information ---

---------- Session Information ------------------------- Session Information ---------------Session # :9-------------------------------------------------------------# Connection Threads : 1# Active Sessions : 1# Waiting  Sessions : 0Total Memory : 257425408 Free Memory : 255180496|#]

 

*At query level:*

autocommit: false warnings: null FreeMemory: 100835432|#]

 

*The Code:*

 

System.out.println("autocommit: " + this.conn.getAutoCommit() + " warnings: " + this.conn.getWarnings() + " FreeMemory: " + Runtime.getRuntime().freeMemory());

 

RUNTIME: autocommit: false warnings: null FreeMemory: 100835432|#]

 


 PreparedStatement psNHG2 = this.conn.prepareStatement("select * from ASSETS where ID = ? and NAGNOTIFICATIONENABLED = '1' order by ASTSEQ");

psNHG2.setString(1, this.custid);
 ResultSet rsNHG2 = psNHG2.executeQuery();

 while (rsNHG2.next()) {

 

I noticed in 2011 there was a similar issue but considered it to be irrevelent as so many versions have transpired.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)