Polling for changes in a database has been a requirement for systems for a very long time. With Oracle BPEL, of course, this need exists and we will review one way you can go about this.

Note: This particular article is not meant to provide a detailed background for each step, nor does it go through showing how to test end-to-end, but feel free to ask questions in your comments and I will be happy to update any areas that you are confused about.

Objective

Create a BPEL process that would poll the database periodically for records with a specific flag.

Step-by-Step Walkthrough with Screenshots

Create an asynchronous BPEL project using JDeveloper BPEL Plugin

Click Finish and view the JDeveloper design view.

Create a Database Adapter, by dragging and dropping ‘Database Adapter’ from the ‘Component Palette’ and begin configuring using the wizard.

Click ‘Next’ and choose a name for the service that will be created and available for consumption by your BPEL process.

Click ‘Next’ and select the appropriate ‘Database’ Connection from the drop down (or create a new connection if needed).

Click ‘Next’ and select ‘Poll for New or Changed Records in a Table’

Click on ‘Import Tables’ and Select the table that you wish to poll.

Once your table is selected:
Click ‘Next’
Click ‘Next’
Click ‘Next’

As you poll entries, you must decide on a way to read and mark entries. We have chosen to update a field, setting all values to “FALSE” since we do not want Oracle BPEL to automatically update a field as soon as it is read; instead, we want to update the value ourselves later in the process, once we are sure certain processing has been completed.

Note: Assuming that you will update the ‘Task_Completed’ Flag after processing the records, you might want to change the wsdl to modify polling parameters.

Modify the receive activity to get data from the new Database Adapter Service

Related Information:

1. Asynchronous vs Synchronous BPEL Processes

   Asynchronous and Synchronous BPEL processes, as their names imply, process a request in parallel or sequenctially respectively. Screenshot: Invoke Asynchronous...

2. JDeveloper Freezing - Optimize Performance for Large BPEL Flows

   I was running into issues with my Jdev being inadequately slow, hanging, or freezing when working with large BPEL process...

3. JDeveloper 11g Download

   If you haven’t already, download Oracle JDeveloper 11g for free using the links below or directly from the JDeveloper 11g...

4. Oracle SOA Environment Performance Tuning Options - Quick Notes

   Tuning OAS and BPEL Console....

5. Oracle AS: Undeploying Multiple Applications (including BPEL Human Tasks)

   Undeploying a single application in Oracle Application Server is pretty straightforward. However, I had a scenario where I needed to...

6. Oracle BPEL Sensors for Real Time Event Publishing from Business Processes - A Design Perspective

   This article is a look at Oracle’s BPEL Sensor approach to publishing real time data and events for in flight...

7. Salesforce.com Integration - Oracle Fusion Middleware SOA and BPEL

   Oracle Corporation has recently published a white paper written by M&S Consulting, where we take the opportunity to outline an...

8. JDeveloper 11g Installation Screenshots - Windows XP

   Below is a link to a PDF document containing all (or most of the screens) you will find when going...