IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > JDBC > Overview of IBM WebSphere Adapter for JDBC > Technical overview > Outbound processing

Outbound operations

Application components use operations to perform actions such as retrieving from a database. The adapter provides certain outbound operations. Details are provided on how the adapter processes business objects for each of the supported operations.

An operation can be performed using a standard SQL statement provided by the adapter or by a stored procedure that you define.

You can run a stored procedure to perform the operation or to do custom processing before or after the operation. In each business object, you can configure how each operation is performed.

• Create operation
  The Create operation creates rows in database tables corresponding to the business object in the request. When given a hierarchical business object, the Create operation recursively traverses the business object, creating rows corresponding to each business object in the hierarchy.
• Retrieve operation
  The Retrieve operation extracts data from a database for a hierarchy of business objects.
• RetrieveAll operation
  The adapter uses the RetrieveAll operation to retrieve an array of business objects from the database. The adapter uses different processes depending on whether the RetrieveAll operation is for database table business objects or for user-specified SQL business objects.
• Update operation
  The Update operation is performed by comparing the source business object with a business object that is retrieved from the database using the primary keys specified in the top-level, source business object.
• UpdateAll operation
  The UpdateAll operation updates multiple database records at a time, and returns the record count to indicate how many records have been updated.
• ApplyChanges operation
  The ApplyChanges operation provides both delta and after-image support for modifying or deleting a business object. The ApplyChanges operation is available only if you use business graphs.
• Delete operation
  The Delete operation is performed by pruning the incoming business object and then retrieving the complete business object from the database. The Delete operation is then applied recursively on each business object in the hierarchy.
• DeleteAll operation
  The DeleteAll operation deletes multiple database records at a time, and returns the record count to indicate how many records have been deleted.
• Execute operation
  The Execute operation is used to run stored procedures and stored functions, as well as wrapper stored procedures and stored functions. The external service wizard generates the required stored procedure business object that corresponds to the stored procedure or stored function definition in the database. The adapter uses the Execute operation to process the stored procedure business object.
• Exists operation
  The Exists operation determines whether the database contains records that match the attributes set in a business object.
• Upsert operation
  The Upsert operation either updates or inserts records in a table. If the table does not have the record that matches the query, the Upsert operation inserts a new record. If the table already has the record that matches the query, the Upsert operation updates the existing record.
• Batch operations
  

Outbound processing

Related concepts:

Outbound processing

Stored procedure overview