Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 20028 invoked from network); 29 Jan 2009 11:36:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Jan 2009 11:36:59 -0000 Received: (qmail 64581 invoked by uid 500); 29 Jan 2009 11:36:56 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 64473 invoked by uid 500); 29 Jan 2009 11:36:55 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 64452 invoked by uid 99); 29 Jan 2009 11:36:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 03:36:55 -0800 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 11:36:47 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1LSVC7-0002sd-27 for derby-user@db.apache.org; Thu, 29 Jan 2009 03:36:27 -0800 Message-ID: <21725256.post@talk.nabble.com> Date: Thu, 29 Jan 2009 03:36:27 -0800 (PST) From: MartinEW To: derby-user@db.apache.org Subject: NPE from NoRowsResultSetImpl.close() MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: martin.walsh@sun.com X-Virus-Checked: Checked by ClamAV on apache.org I am receiving a NPE when attempting to delete records from tables. I have attached a simplified SQL script that replicates my problem - http://www.nabble.com/file/p21725256/script.sql script.sql . Can anyone else replicate this issue? The exception is: 2009-01-29 11:22:51.346 GMT Thread[DRDAConnThread_20,5,derby.daemons] (XID = 2515), (SESSIONID = 35), (DATABASE = test), (DRDAID = NF000001.E18A-522134848570106079{35}), Cleanup action starting 2009-01-29 11:22:51.346 GMT Thread[DRDAConnThread_20,5,derby.daemons] (XID = 2515), (SESSIONID = 35), (DATABASE = test), (DRDAID = NF000001.E18A-522134848570106079{35}), Failed Statement is: delete from collectives java.lang.NullPointerException at org.apache.derby.impl.sql.execute.NoRowsResultSetImpl.close(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteResultSet.cleanUp(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.cleanUp(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.cleanUp(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) 2009-01-29 11:22:51.346 GMT Thread[DRDAConnThread_20,5,derby.daemons] Equally severe exception raised during cleanup (ignored) null java.lang.NullPointerException at org.apache.derby.impl.sql.execute.NoRowsResultSetImpl.close(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteResultSet.cleanUp(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.cleanUp(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteCascadeResultSet.cleanUp(Unknown Source) at org.apache.derby.impl.sql.conn.GenericStatementContext.cleanupOnError(Unknown Source) at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) Cleanup action completed Thanks Martin -- View this message in context: http://www.nabble.com/NPE-from-NoRowsResultSetImpl.close%28%29-tp21725256p21725256.html Sent from the Apache Derby Users mailing list archive at Nabble.com.