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

Another thought- what commitment control option are you using in the
connection? Try viewing the insert results while the java app is still
connected and then again after it disconnects and see if they are the same.
Try other commitment options. Which JDBC driver are you using? The native
drivers directly on the 400 or the toolbox drivers? If you are running on
the 400 try both...

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
+---