SOA 12c DB Adapter configuration

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

SOA 12c DB Adapter configuration

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

DB Adapter configuration wizard

Create or select the created database connection details

Database Connection

Select the Database Operation Type

DB Adapter operation type

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

DB Adapter Import Table

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

DB Adapter after read action

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

DB Adapter logical delete

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

DB Pooling Options

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.

DB Selection Criteria

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.

DB Adapter in composite