Home » Server Options » Streams & AQ » Streams DML to java JMS client
Streams DML to java JMS client [message #75701] Thu, 29 April 2004 22:21
Messages: 6
Registered: June 2002
Junior Member
I've been trying to setup a capture process to capture changes in a table and recieve the LCRs in a java client. I've based my setup and code on the "Enqueue and Dequeue Events Using JMS" section in chapter 19 of the streams manual.

I have two java apps, one that can publish a message and one to recieve a message and that seems to work. But when I setup the capture on the table to publish the change LCRs to the same queue, I never see the change events in the java client. It looks to me like the changes are not being captured and written to the queue in the DB.

Is there somewhere in the DB that I can look (via SQLPlus?) to see the events as they are captured? When I run the java publisher I can see it's published events in the strmadmin view AQ$NOTIF_QUEUE_TABLE (my queue is called NOTIF_QUEUE) but I never see any events generated by the changes in the database.

(Oracle on Linux, 2.4.25 kernel, Sun JDK 1.4.2_04)

Any pointers appreciated
Previous Topic: Oracle Stream Setup thru OEM.
Next Topic: Help please! Can't find Oracle Transparent Gateway for SQLServer
Goto Forum:

Current Time: Sat Apr 01 10:11:00 CDT 2023