SalzoTech: Maximum redelivery retries and retry delay in AQ backed MDB in Weblogic

When working with AQ backed MDB in Weblogic, the maximum redelivery retry count and retry delay can be configured at AQ queue level. The two related parameters, are:

max_retries
retry_delay

They can be configured at queue creation time (DBMS_AQADM.CREATE_QUEUE) or can be updated in a existent queue (DBMS_AQADM.ALTER_QUEUE). The default values are 5 for max_retries and 0 for retry (as soon as possible). The complete set of parameters can be found here.

In Weblogic, you can verify the parameter's operation with something like this:

@MessageDriven(

activationConfig = {

@ActivationConfigProperty(propertyName = "ConnectionFactoryJndiName", propertyValue = "..."),

@ActivationConfigProperty(propertyName = "DestinationJndiName", propertyValue = "..."),

@ActivationConfigProperty(propertyName = "DestinationType", propertyValue = "javax.jms.Queue")

})

public class TestMyQueueMDB implements MessageListener {

@Resource

private MessageDrivenContext mdc;

public void onMessage(Message message) {

try {

System.out.println("onMessage][START]time=" + new Date());

System.out.println("JMSMessageID : " + message.getJMSMessageID());

System.out.println("JMSRedelivered : " + message.getJMSRedelivered());

System.out.println("JMSXDeliveryCount: " + message.getIntProperty("JMSXDeliveryCount"));

//force retry

mdc.setRollbackOnly();

} catch(Exception e) {

//...

} finally {

System.out.println("[onMessage][END]");

System.out.println();

}

//...

}

With an queue created with the default values,

dbms_aqadm.create_queue(

queue_name=>'myQueue',

queue_table=>'myQueueTable'

);

it should print something like this:

[onMessage][START]time: Mon Mar 03 13:18:26 COT 2014