DB Adapter Polling - Using MAXTRANSACTIONSIZE and Ordering Clause does not Guarantee the Order
(Doc ID 1911488.1)
Last updated on APRIL 23, 2019
Applies to:Oracle Service Bus - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Using MaxTransactionSize = and ordering clause on a specific column,
the generated SELECT statement doesn't guarantee the ordered polling of the events based on the column specified.
In fact, the generated SELECT is the following:
Using ROWNUM and ORDER BY at the same level, as documented here
Oracle® Database SQL Reference
10g Release 1 (10.1)
Part Number B10759-01
the order of the events is not kept.
It should be used a nested SELECT statement with ORDER BY, used by an external SELECT statement using ROWNUM:
SELECT ... FROM
( SELECT ... FROM ...
ORDER BY ....
WHERE ROWNUM < xxxxx;
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