RE: trigger or listener?

Glenn,

Another approach that I have used is to create a web service(s) on the Linux
box which accepts the appropriate parameters from your trigger program.
That data can then be inserted into your database or you can retrieve any
other data you may need from the 400. Your trigger program calls a java
program that resides on the 400, which in turn calls the web service on the
Linux box.  It may sound complicated, but it's really pretty easy.  The
reason I chose this over the listener is that you never have to worry about
the listener ending for some unknown reason.

Chad Cornelius, IIS
(720) 921-7835

-----Original Message-----
From: Glenn Holmer [mailto:gholmer@xxxxxxxxxxxxxx] 
Sent: Wednesday, October 05, 2005 4:03 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: trigger or listener?

On Wednesday 05 October 2005 11:50, Jose Luis Calvo wrote:
> One way to do that is using the best of the two alternatives, the
> trigger (may be in RPG) put an entry in a DTAQ, an have a Java
> program waiting in that DTAQ.

Thanks for the replies; we're going to set up a trigger against the 
database on the '400 that writes the record into a data queue.  A 
program on the Linux server will read from that queue and write the 
record into his (Postgres) database.  I'll let you know how it turns 
out...