SOA 11g: Instances of Mediator or BPEL Triggered by a Database Adapter are all Receiving the Same Row
Last updated on SEPTEMBER 15, 2012
Applies to:Oracle SOA Platform - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Mediator or BPEL are using the Database Adapter in polling mode ("Poll for new or changed records in table") :-
Polling frequency: 10s
Database rows per XML Document: 1
Database rows per transaction: 100
If the DB Adapter returns multiple rows in the resultset, then muliple instances of the Mediator / BPEL will be triggered.
The expectation is that each instance will receive a unique row from the database resultset.
The problem is that each triggered Mediator/BPEL instance receives the same row . Each instance is receiving the first row in the resultset, and the remaining rows in the resultset are lost.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms