Re: Oracle messaging options
- From: Ram K <lambu999@xxxxxxxxx>
- To: sfaroult@xxxxxxxxxxxx
- Date: Sat, 28 Jan 2006 09:28:21 -0500
Hi, Does synchronism matter here? Whether the update in the second database has to happen synchronously/asynchronously with the changes in first database. On 1/25/06, Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote: > > John, > > I would say that you HAVE to use a queuing system. The very last > thing you want to see on a WAN is synchronous processing. I haven't much > used Advanced Queuing myself but it fits the bill. I would say that the > question is rather Advanced Queuing or another messaging system (some of > my customers use Tibco, for instance) that would happen to be already > used, and that people would already be familiar with. > > Stéphane Faroult > > On Wed, 2006-01-25 at 09:09 +0000, John Dunn wrote: > > I have a requirement for some sort of messaging between oracle databases > > over a WAN. > > > > Basically I want an event in one database to trigger some code (PL/SQL > or > > Java) to run on the remote database > > > > What are the options, is Advancd Queuing still the best option? Oracle > > platform will be Oracle 9 or 10 on AIX 5. > > > > John Dunn > > > > -- > Thanks, > Ram.