JDBC Adapter Database Operations (BPEL)

Within a BPEL business process, the JDBC Adapter uses BPEL Activities to perform basic outbound database operations, including:

• Insert

• Update

• Delete

• SelectOne

• SelectMultiple

• SelectAll

In addition to these outbound operations, the JDBC Adapter also employs the inbound Activity ReceiveOne within a Prepared Statement OTD.

The ability to perform any of the above methods using a table OTD may not be possible with all third-party drivers. You have to use a Prepared Statement to perform such an operation. Check with the respective driver’s vendor for further information. This feature is known as Updatable ResultSet.