BPEL DB Adapter Polling With Update Sequencing Table

Sometimes we required to poll a table depending upon last polled date time or last polled sequence id. To handle this scenario BPEL DB adapter gives after poll option as given below,

• Update a Sequencing Table
• Update an External Sequencing Table on a Different Database
• Update a Sequencing File

To use the Update a Sequencing Table need to create another table which minimum have two columns. One contains the polling table name and 2nd column contain the last value(ID/Last fetch date). Please follow the below snapshots.

• Create a BPEL process and use a DB adapter to poll the corresponding database records.

• Choose the Table you want to poll.

• After Polling choose the option as Update a Sequencing Table.

• Fill the Details of Sequencing table as mentioned in the comments of the below snapshot.

• The above configuration generates the Polling DB adapter SQL query as given below.

• Now this DB adapter is ready to poll the records depending upon last modify date.

Also see : fetch-validate-activity-log-message