OC4J server DB persistence - queue message getting retrieved multiple times

[Yogi Nayudu]

Hello,

Thanks for trying to help ...

We are using oc4j server 10.1.3 and oracle 10g database and using database persistence for the the MDB in the application

we have 3 application servers and connected through the load balancer in the production enviornment

As we are using database persistence the messages are sending to the database queue and message listeners on the 3 servers are pointing to the same database queue

and some of the properties are following

Queue Properties

Max_Retries - 5
Retry_Delay - 900

Queue Table Properties

RECIPIENTS - Single

MESSAGE_GROUPING - NONE

COMPATIBLE - 8.1.3

PRIMARY_INSTANCE - 0

SECONDARY_INSTANCE - 0

OWNER_INSTANCE - 1

The following Message listener Properties has been set

AcknowledgeMode - Auto-acknowledge

ConnectionFactoryJndiName
DestinationName
DestinationType


Now the question is that though I set that the queue table Recipients to 'Single' some of the messages were getting received by 2 message listeners

At one time message listener in the first application server is receiving the message and processing and while the message is being processed the same message is being received by another message listener and start processing

This is causing the issue in our production environment as our requirement is to process the message only once.

Can someone help me that any property can I set to avoid this issue?


Thanks in Advance
Yogi

[Yogi Nayudu]

Common Guys ...

Can someone tell me what could be the problem?


Waiting for the help


THanks in Advance

Yogi