ORA-25257: consumer must be specified with a multi-consumer queue
Hi all, I'm using AQ from JDBC to implement a publisher/multiple-subscriber pattern (open set, publishers do not know about subscribers) and I receive the above error when I try to register an asynchronous listener through OracleConnection.registerAQNotification(...).
I setup a multi-consumer queue and I added a new subscriber to it. This was done through a stored procedure since there is no JDBC counterpart.
The purpose was to have the current application as first subscriber, however I miss any relationship between it and an agent creation through sys.aq$_agent('myApp', null, null).
Then I tried to register a listener and I got the above error.
The overall mechanism is far from well documented while used from java. One of the most confusing area concerns consumers, subscribers, recipients.
Any help is appreciated.