SOA 11g: Instances of Mediator or BPEL Triggered by a Database Adapter are all Receiving the Same Row

(Doc ID 1489474.1)

Last updated on SEPTEMBER 15, 2012

Applies to:

Oracle SOA Platform - Version 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