× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

On Wed, 2005-10-05 at 11:30 -0500, Glenn Holmer wrote:
> We want to have a Postgres database on a Linux web server updated when 
> the corresponding record on the AS/400 changes.  We are thinking:
> 
> a) DB trigger on the '400 that wakes up when the record is changed and 
> calls a Java program (also on the '400), passing the needed parameters 
> as arguments to main(); the Java program uses JDBC to update the 
> Postgres database on the Linux server.  Pro: probably easy to set up, 
> Con: new process spawned for each write.
> 
> b) A Java program that runs all the time and listens for changes on the 
> AS/400 database using something like FileListener from the JT400 
> toolbox (haven't researched this yet); he would do the same as a).  
> Pro: single program, Con: don't know if it's possible.
> 
> What recommendations would you guys make?  We are hoping to get away 
> without modifying the program that is actually making the changes on 
> the '400.  We are not talking about a huge number of records here; 
> probably a couple hundred every few hours.
> 
> -- 
> ____________________________________________________________
> Glenn Holmer                          gholmer@xxxxxxxxxxxxxx
> Software Engineer                        phone: 414-908-1809
> Weyco Group, Inc.                          fax: 414-908-1601

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.