Hi Peter,
I wondered if you got a chance to try what Tyre suggested in his posting. May be what you are encountering is
http://issues.apache.org/jira/browse/DERBY-85
thanks,
Mamta
On 6/6/05, Peter Nabbefeld <[EMAIL PROTECTED]> wrote:
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
>
>
