Re: Replication of data from Oracle to SQL Server and Sybase using a trigger/procedure or java program

Hi,

You can take a look at Oracle Gateway but i'd nerver use it.

I suggest you to modify your servlet
to pass the db in parameter and
call it 3 times (1 for each DB)

hth
Chris

jamesong74_at_hotmail.com (jameso) wrote in message news:<155bbed8.0201101738.7209ed3_at_posting.google.com>...
> Hi,
> I am inserting data into Oracle DB from a Java servlet. After which, I
> want to automatically insert the same data to SQL Server and Sybase
> simultaneously.
>
> Is it possible to do the above mentioned, either by writing a
> trigger/procedure or calling another java program (servlet) to perform
> the insertion?
>
> If I call a trigger/procedure, where/how do I define the ip address,
> user id and password of the SQL Server and Sybase DB in order to
> insert the same data as the Oracle DB?
>
> If a call another java program, where do I write it and how do I call
> it from Oracle?
>
> Are there any good links that I can refer to with regards to the
> above?
>
> Please advise.
>
> Thank you.
Received on Tue Jan 15 2002 - 23:01:16 CET