Re: Insert from DB2 to oracle using Java

    Hi Andres,

    Just a note to second Ashish's suggestion.  We have something similar
that requires possible action on an insert.  We use an RPG trigger to post
to a message queue and a batch Java program handles it from there.  If you
use a trigger, do the least amount of processing possible in it or
performance can suffer.

    There are several benefits, but two are: You don't have to mess with or
suffer the issues with calling Java from RPG ( in fact, the language doesn't
matter so long as it can communicate with a message queue; others use data
queues for the same sort of thing ) and your RPG ( or initiating ) program
can continue on with its processing without waiting for the Java program to
return.

> > But, what it´s the best to way to comunicate both
> > databases? other
> > posibility?

    There are XA drivers that can be used with the Java Transaction API to
deal with two-phase commits among multiple databases ( and similar tools for
other languages ), but they tend to get both expensive and complicated.  If
you have that need, they are great, but otherwise handling as above is
usually Good Enough.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Ashish Kulkarni" <kulkarni_ash1312@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Monday, June 13, 2005 10:28 AM
Subject: Re: Insert from DB2 to oracle using Java


> Hi
> I have defined a subsystem, in this subsystem i have
> submitted a java program which is listening to Messqe
> Queue, from RPG program i insert values in this
> message queue, this java program then reads these
> values and then creates a PDF file on AS400 IFS file
> system( you can insert them in oracle)
>
> Ashish
>
> --- ANDRES COLODRERO LEHMANN <andres@xxxxxxxxxx>
> wrote:
>
> > I have two applications. First, its a iSeries
> > applications with RPG and
> > second its a external Oracle aplications. From
> > I need connect both applications on-line. DB2 always
> > insert, update or
> > deleted in Oracle. RPG have the control.
> >
> >  I think to use RPG to CALL java program with
> > parameters for insert in
> > oracle database. Java could be batch programs. ¿it´s
> > a good idea?
> >
> > But, what it´s the best to way to comunicate both
> > databases? other
> > posibility?
> >
> > Thanks
> > --