AQ messages not dequeued in AQ/JMS setup
421962Jun 19 2006 — edited Jun 27 2006We have a setup where the database triggers does the enqueue, which generates event for JMS (run by a weblogic service) to perform the dequeue. In our tests, we have noticed that sometimes the records are not being dequeued for no real apparent reason. The only way we've been able to get them to dequeue is to restart the weblogic service...
I've been asked to investigate but am at a loss here. I'm still going through the AQ documentation that Oracle provided, but would really appreciate any suggestion on things to check whenever this happens, or any documents/reference other than the Oracle AQ development guide that I should read up on...