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

2021-02-03 Thread Ed lang (Jira) 


 [ 
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.200.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)

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

2021-02-03 Thread Ed lang (Jira) 


[ 
https://issues.apache.org/jira/browse/DERBY-7098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17278403#comment-17278403
 ] 

Ed lang commented on DERBY-7098:


Richard,

It is solved. I had a mistake in an EJB which used this connection and did a 
commit.  Setting the log level to 0 helped me zero in on the issue.

 

Thank you.

 

ed

 

> 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
>
> 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.200.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)

Re: DB web site migration from CMS

2021-02-03 Thread Bryan Pendleton 
I'm sorry, I haven't done much on this in a long time. I'd have to do
a bunch of research to figure out what is done, and what is left to be
done.

bryan

On Wed, Feb 3, 2021 at 12:44 PM Craig Russell  wrote:
>
>
>
> On Feb 3, 2021, at 7:22 AM, Rick Hillegas  wrote:
>
> I have not been following this issue. I believe that Bryan put some effort 
> into converting the Derby website, but I don't know where that stands. A 
> couple questions:
>
> 1) How much effort was required to migrate JDO?
>
>
> Non-trivial. We decided to use github with actions and .asf.yaml on a brand 
> new repository with asciidoc as the source. Tilmann did most of the initial 
> work and now there is a lot of cleanup due to the fact that there are 
> multiple sources for: db.apache.org, db.apache.org/torque, 
> db.apache.org/derby, as well as jdo.
>
>
> 2) Can we still manage our code repo with subversion?
>
>
> This is above my pay grade. ;-)
>
> Craig
>
>
> Thanks,
> -Rick
>
> On 2/2/21 11:26 AM, Craig Russell wrote:
>
> Hi,
>
> priv...@db.apache.org in bcc...
>
> The JDO project is almost complete migrating the db.apache.org/jdo site from 
> the soon-to-be-retired CMS system to a new github site repo using GitHub 
> Actions and .asf.yaml to publish the site.
>
> Infra wants to know what the plans are for the main site, Derby, and Torque 
> to migrate.
>
> Craig
>
> Craig L Russell
> c...@apache.org
>
>
>
> Craig L Russell
> c...@apache.org
>

Re: DB web site migration from CMS

2021-02-03 Thread Craig Russell 


> On Feb 3, 2021, at 7:22 AM, Rick Hillegas  wrote:
> 
> I have not been following this issue. I believe that Bryan put some effort 
> into converting the Derby website, but I don't know where that stands. A 
> couple questions:
> 
> 1) How much effort was required to migrate JDO?

Non-trivial. We decided to use github with actions and .asf.yaml on a brand new 
repository with asciidoc as the source. Tilmann did most of the initial work 
and now there is a lot of cleanup due to the fact that there are multiple 
sources for: db.apache.org , db.apache.org/torque 
, db.apache.org/derby 
, as well as jdo. 
> 
> 2) Can we still manage our code repo with subversion?

This is above my pay grade. ;-) 

Craig
> 
> Thanks,
> -Rick
> 
> On 2/2/21 11:26 AM, Craig Russell wrote:
>> Hi,
>> 
>> priv...@db.apache.org in bcc...
>> 
>> The JDO project is almost complete migrating the db.apache.org/jdo site from 
>> the soon-to-be-retired CMS system to a new github site repo using GitHub 
>> Actions and .asf.yaml to publish the site.
>> 
>> Infra wants to know what the plans are for the main site, Derby, and Torque 
>> to migrate.
>> 
>> Craig
>> 
>> Craig L Russell
>> c...@apache.org
>> 
> 

Craig L Russell
c...@apache.org

Re: DB web site migration from CMS

2021-02-03 Thread Rick Hillegas 
I have not been following this issue. I believe that Bryan put some 
effort into converting the Derby website, but I don't know where that 
stands. A couple questions:


1) How much effort was required to migrate JDO?

2) Can we still manage our code repo with subversion?

Thanks,
-Rick

On 2/2/21 11:26 AM, Craig Russell wrote:

Hi,

priv...@db.apache.org in bcc...

The JDO project is almost complete migrating the db.apache.org/jdo site from 
the soon-to-be-retired CMS system to a new github site repo using GitHub 
Actions and .asf.yaml to publish the site.

Infra wants to know what the plans are for the main site, Derby, and Torque to 
migrate.

Craig

Craig L Russell
c...@apache.org