You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by bkbonner <br...@paraware.com> on 2006/11/13 20:12:10 UTC

NPE on CreateTrigger

I'm trying to create the following trigger:

CREATE TRIGGER  PID.DELCONGT
    AFTER
    DELETE
    ON PID.PIDPDTCO
    REFERENCING
      OLD AS OROW
    FOR EACH  ROW    MODE DB2SQL
    DELETE FROM PID.PIDCONGT WHERE CON_UPC_NO = OROW.CON_UPC_NO;

For all intents and purposes, it looks like this should work, however I get:

ERROR XJ001: Java exception: ': java.lang.NullPointerException'.


The log shows:
java.lang.NullPointerException
	at
org.apache.derby.impl.sql.catalog.SYSSTATEMENTSRowFactory.makeSYSSTATEMENTSrow(Unknown
Source)
	at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
Source)
	at
org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.createSPS(Unknown
Source)
	at
org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.executeConstantAction(Unknown
Source)
	at org.apache.derby.impl.sql.execute.MiscResultSet.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)

I'm running 10.1.2.1


Any thoughts?
-- 
View this message in context: http://www.nabble.com/NPE-on-CreateTrigger-tf2624509.html#a7323514
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: NPE on CreateTrigger

Posted by bkbonner <br...@paraware.com>.
Doh!  It looks like if I had looked at the log and searched nabble instead of
searching nabble for the NPE and then the log, I would have found that I was
experiencing:

http://issues.apache.org/jira/browse/DERBY-85

I can create a non-empty default table in the schema and it works as a
workaround.

Brian



bkbonner wrote:
> 
> I'm trying to create the following trigger:
> 
> CREATE TRIGGER  PID.DELCONGT
>     AFTER
>     DELETE
>     ON PID.PIDPDTCO
>     REFERENCING
>       OLD AS OROW
>     FOR EACH  ROW    MODE DB2SQL
>     DELETE FROM PID.PIDCONGT WHERE CON_UPC_NO = OROW.CON_UPC_NO;
> 
> For all intents and purposes, it looks like this should work, however I
> get:
> 
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> 
> 
> The log shows:
> java.lang.NullPointerException
> 	at
> org.apache.derby.impl.sql.catalog.SYSSTATEMENTSRowFactory.makeSYSSTATEMENTSrow(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addSPSDescriptor(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.createSPS(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.execute.CreateTriggerConstantAction.executeConstantAction(Unknown
> Source)
> 	at org.apache.derby.impl.sql.execute.MiscResultSet.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)
> 
> I'm running 10.1.2.1
> 
> 
> Any thoughts?
> 

-- 
View this message in context: http://www.nabble.com/NPE-on-CreateTrigger-tf2624509.html#a7323703
Sent from the Apache Derby Users mailing list archive at Nabble.com.