|Capture Process to Java JMS problem [message #260029]
||Fri, 17 August 2007 03:30
Registered: August 2007
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?