My Oracle Support Banner

How to Force Message Ordering in an ESB Service in an Error Scenario (Doc ID 731430.1)

Last updated on MARCH 27, 2020

Applies to:

Oracle Enterprise Service Bus - Version and later
Information in this document applies to any platform.
Information in this document applies to any platform.


Describe how to enforce message ordering in an ESB service in an error case.

Use this scenario as an example:
1.  A polling DB adapter initiates an ESB process by consuming a row from the database tables.
2.  The message is going to the ESB_JAVA_DEFERRED queue (perform asynchronous call).
3.  Due to a network or hardware failure the database (here and after we will call it DB1) is not available
(the ESB process performs a PL/SQL procedure call in order to gather the required data).
4.  ESB instance fails at step 3.
5.  The database DB1 becomes available.
6.  The consequent message from the polling DB adapter is consumed, passes through the ESB_JAVA_DEFERRED queue and then comes the error due to this message.  The error message depends on the message from step 3.

The idea is that at the Step 3 the ESB message processing should be stopped until the message is resubmitted successfully.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.