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.