Home » Server Options » Streams & AQ » Capture Process to Java JMS problem
Capture Process to Java JMS problem [message #260029] Fri, 17 August 2007 03:30
Messages: 8
Registered: August 2007
Junior Member
Currently i want to build a application that read oracle redo log.
I know it is rocket science to read it directly.
So i find Oracle Streams.
I will start a Capture Process where redo log resides, and i set up a JMS application to read the Queue.
But i am failed to build this system, i wonder if it is possible to use JMS application to read Capture Process queue, or I must create Apply Process in the same database, then create DML/DDL handler?

architecture : Capture Process => Queue => JMS application

does it possible?

Or i must use this architecture instead?

Capture Process => Queue => Apply Process => DML/DDL Handler => User Application

I create the capture process in my source database, also i create the AQ agent, and monitor the capture process with following results.

Capture Session Total
Process Session Serial Redo Entries LCRs
Number ID Number State Scanned Enqueued
------- ------- ------- ----------------- ------------ --------
CP01 16 2 CAPTURING CHANGES 273755 10

So i got 10 LCRs enqueued.

and i build my Java JMS application trying to receive these LCRs.

But it always saying there is no messages in the queue.

I am sure it is the same queue that both capture process and JMS application.

So, now, i wonder if it is possible to receive the LCRs from capture process queue? or it must create Propagation Process and Apply process?
Previous Topic: Dare to Solve my Problem!(Propagation propagate but apply process does not get it)
Next Topic: Issues in dropping an Apply process
Goto Forum:

Current Time: Mon May 22 20:18:22 CDT 2017

Total time taken to generate the page: 0.06610 seconds