Re: DB2 trigger doesn't work when INSERT comes from Java app; works fine from STRSQL

Sounds like a bug? Or maybe running in another library from Java where the
trigger wasn't added?

You could always make a stored procedure which inserts the record and
creates a key and call the proc instead of using INSERT directly, as a
workaround...

Luther

----- Original Message -----
From: "Jacob Madsen" <jom@mail.ikasths.dk>
To: <JAVA400-L@midrange.com>
Sent: Thursday, April 27, 2000 11:37 AM
Subject: DB2 trigger doesn't work when INSERT comes from Java app; works
fine from STRSQL


> Hi all
>
> I have created a trigger in ILE C, which takes care of autogenerating a
> primary key for a statistics table. This is made the following way:
>
> 1. The primary key has a DEFAULT of 0
> 2. The trigger first adds 1 to the value in the key table - a separate
table
> only with the key.
> 3. The trigger updates the value each time after insert in the statistics
> table WHERE primary key = 0.
>
> Now the weird part comes. I've tested this with INSERT statements in
STRSQL,
> and it works exactly like it's supposed to. But when I execute a INSERT
> statement from the Java app, for which the database is made, the trigger
> never runs, which of course results in a key violation.
>
> Any good ideas?
>
> Jacob
>
>
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---