You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ed lang (Jira)" <ji...@apache.org> on 2021/02/03 22:49:00 UTC
[jira] [Closed] (DERBY-7098) Derby issues an ERROR
java.sql.SQLException: ResultSet not open. Operation 'next' not permitted.
Verify that autocommit is off
[ https://issues.apache.org/jira/browse/DERBY-7098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ed lang closed DERBY-7098.
--------------------------
Fix Version/s: 10.14.2.0
Issue & fix info: Newcomer
Resolution: Fixed
> 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
> Priority: Major
> Fix For: 10.14.2.0
>
>
> 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)