There could be scenarios where BPEL Service need to integrated with Database for the persistence or data retrieval while developing  custom SOA Services. The below given are the steps to  configure the DB Adapter in the SOA Project.

Select the DB Adapter from the Components -> Technology

Provide the name to the DB Adapter which need to be configured

Create or select the created database connection details

Select the Database Operation Type

Select the database table by clicking on Import Tables button and select the columns that are required

Select the option which need to be performed once the new records are picked for processing

Update the values for the Logical Delete , Read records and Unread records

Update the Database Polling options as per the application need.  Select the Distributed Polling in case of Clustered environment.

Add the parameter binding in case of run time value to be passed to the Database SQL or Edit the provided SQL in case of any additional check to be updated.

Update the Java Connector End Point Properties as per application need

Click Finish to complete the Database Adapter Configuration Wizard.

The DB Adapter will be configured in the SOA Project with the selected options in the Configuration Wizard.