Let's build the process we just described. First, you create the database tables to support the process, and then you use the BPEL PM Designer to model the process.
Because the process stores the retry status in the database, you need to design the database component before creating the BPEL process. As discussed earlier, the main database additions that need to be made are:
More fields to track the status of records being processed
Updatable view
Status procedure
The additional fields can be added to the row that contains the data being modified or to a parallel table with a one-to-one relationship to the main table. The main columns that should be added are:
Status
Process Not Before
Retry Count
Create DTS
Last Modified DTS
The status field should be the same one that is used by BPEL's database polling adapter to identify unprocessed records. It is helpful to create a convention to make it easy to identify records that are still being processed...