Re: Problem with a data base trigger not working when program is called from Java

Yep. Turned out to be a lib list problem. Since I can't assume anything
about QZRCSRVS, and the job could be used by another process, it seemed
safest to

save the LIBL
set it the way the program needs it
run the RPG program which updates the data base file iwth the
trigger
restore the save LIBL






Bill Blalock/TUS/US/Certegy@Certegy
10/10/2007 12:24 PM
Please respond to Java Programming on and around the iSeries / AS400

To: Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>
cc: (bcc: Bill Blalock/TUS/US/Certegy)
Subject: Re: Problem with a data base trigger not working
when programiscalled from Java

s there any possibility that there's a library list issue? Or an

authority issue?
Lib list is okay.
QZRCSRVS runs under QUSER. I am checking on that as I have thought of
that one. If QUSER authority were the problem I would expect to see
problems elsewhere. We just use QUSER as an internal user.
Thanks




James Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
10/10/2007 12:55 PM
Please respond to Java Programming on and around the iSeries / AS400

To: Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>
cc: (bcc: Bill Blalock/TUS/US/Certegy)
Subject: Re: Problem with a data base trigger not working
when program iscalled from Java

bill.blalock@xxxxxxxx wrote:

I have Java program running on a server is calling a System i RPGLE
program . . .
The called RPGLE program runs in the job QZRCSRVS

A trigger was added to the data base file the called PRGLE program

writes.

The called RPGLE program is now failing.

. . .

The called RPGLE program works fine in a "normal" environment. The
trigger fires when the data base record is changed, etc.

Any ideas?

Is there any possibility that there's a library list issue? Or an
authority issue?