Hello Peter,
 
NPE is never a good news. Can you please provide a reproducible case which someone can use in their own environment to see the NPE? It will make it easier to investigate the problem by others.
 
thanks,
Mamta

 
On 6/5/05, Peter Nabbefeld <Peter.Nabbefeld@gmx.de> wrote:

Hello,

I've got the following NPE:

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.execute(Unknown
Source)
       ...

My SQL statement is:
CREATE TRIGGER APPBUT_USER.EMRSZDEL AFTER DELETE ON
APPBUT_USER.EMPLOYERS FOR EACH STATEMENT MODE DB2SQL
VALUES(APPBUT_USER.TRIGGER_RESIZE('APPBUT_USER','EMPLOYERS'))

Could anybody please tell me, what's wrong with that? I'm using derby
10.0.2.2.

BTW: Please provide source bundles, too. It's not a good idea, if a user
has to install svn just to get sources for a release version (most
current version is okay, as most people who want this would most likely
also want to work actively with the source code and probably contribute
their changes).

Kind regards

Peter Nabbefeld