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 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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