Geoff hendrey <[EMAIL PROTECTED]> writes: > I am seeing a strange problem trying to execute a simple delete statement. I > have never had a problem with this in the past. It seems NullPointerException > is happening inside the derby delete code. > > DELETE FROM GEOFF__BLOG__USER WHERE "PK"=3 > > Caused by: 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) > ... 32 more
Hi Geoff, Are you able to reproduce this? It would be great if you could file a JIRA issue for this error and upload a test case to reproduce it, if you have one. From the stack trace, it looks like the NPE happens when the delete cascades to another table which references GEOFF__BLOG__USER, so the schema of the other tables would also be useful in the bug report. -- Knut Anders
