Limiting DB Adapter Record Polling Volume (Doc ID 1308195.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle SOA Platform - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

BPEL process that uses a DB adapter to poll a table (Logical Delete), to read a field (unread + read value) and polls every 5 seconds.

Database Rows per XML Document = 1, Database Rows per Transaction = 1, Distributed Polling checked

However, with the above settings the adapter grabs and processes all records available, instead of limiting it to one record per 5 seconds.

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