Hi,
We are trying to dequeue messages in an Oracle AQ Queue(multi-consumer enabled) from JMS MDB in weblogic. The MDB recognizes the messages using onMessages but never dequeues the message from oracle AQ
Gave couple of prints in java code to understand where is it stuck. Everytime a new message is placed, its stuck in the dequeue.
Message found in Queue
Successful getQueueTableJMSPOCQUEUETABLE
Successful getQueueJMSPOCUSERQUEUE
CONTROL - I am from dequeueMessage, before performing dequeue
Below is my dequeue code, where it is stuck at the queue.dequeue(deq_option) always.
System.out.println("CONTROL - I am from dequeueMessage, before performing dequeue");
//aqmessage = queue.dequeue(deq_option);
//below never gets executed, stuck here. no errors though
aqmessage = ((AQOracleQueue) queue).dequeue(deq_option);
System.out.println("Successful dequeue" + aqmessage);
The queue is enabled to both enqueue and dequeue. I do see active subscriber connected to the queue from the jms mdb. Don't see any other issue that cause the dequeue to fail or stuck like this.
Any suggestions to troubleshoot?