How to Force Message Ordering in an ESB Service in an Error Scenario
(Doc ID 731430.1)
Last updated on JUNE 18, 2018
Applies to:Oracle ESB - Version: 10.1.3.3
Information in this document applies to any platform.
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!