Mamta Satoor schrieb:

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.
Hmm, I don't know, if I will be able to isolate a special test case. Is it possible to browse the cvs? There is something missing, probably it would give a hint to look what is the missing object.

Basically, I've done the following:
1. Create a database, a table, and a stored function (a reference to a static java method).
2. Create a trigger, which calls the stored function

Kind regards

Peter Nabbefeld


thanks,
Mamta

On 6/5/05, *Peter Nabbefeld* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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 <http://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



Reply via email to