Adapter Services
To use Adapter for JDBC, you create adapter services. Adapter services help to connect to the adapter's resource and initiate an operation on the resource from Integration Server.
You call adapter services from flow or Java services to interact with database tables. The adapter services perform database operations by calling JDBC APIs. Integration Server then uses adapter connections that you defined earlier to run the adapter services. For details, see Adapter Service Transaction Processing.
Adapter services are based on templates that are provided with Adapter for JDBC. Each template represents a specific technique for doing work on a resource, such as using the SelectSQL template to retrieve specified information from a database.
An adapter service template contains all the code necessary for interacting with the resource but without the data specifications. You provide these specifications when you create a new adapter service.
Creating a service from an adapter service template is straightforward. Using IBM webMethods Designer, you assign the service a default adapter connection.
After you select the connection for the adapter service, you select the adapter service template and supply the data specifications by using Designer. Some familiarity with using Designer is required. For more information, see the IBM webMethods Service Development Help for your release.
Adapter for JDBC provides the following adapter service templates:
| Adapter Service Type | Adapter Service Template | Description |
|---|---|---|
| Select SQL | SelectSQL | Retrieves specified information from a database table and
includes a mapping for an output field that stores the number of rows retrieved. For instructions about configuring the service, see Configuring SelectSQL Services. |
| Insert SQL | InsertSQL | Insert new information into a database table. For instructions about configuring the service, see Configuring InsertSQL Services. |
| Update SQL | UpdateSQL | Update the existing information in a database table and
include a mapping for an output field that stores the number of affected rows. For instructions about configuring the service, see Configuring UpdateSQL Services. |
| Batch Insert SQL | BatchInsertSQL | Insert new information into a database table. Use this
service when you are inserting a large volume of data into a single table. The data source for the
service can be from a flat file or from other services that generate an Integration Server document list. For instructions about configuring the service, see Configuring BatchInsertSQL Services. |
| Batch Update SQL | BatchUpdateSQL | Updates information in a database table with a large
volume of data. Use this service when you are updating a large volume of data in a single table. The
data source for the service can be from a flat file or from other services that generate an Integration Server document list. For instructions about configuring the service, see Configuring BatchUpdateSQL Services. |
| Delete SQL | DeleteSQL | Deletes rows from a table and includes a mapping for an
output field that stores the number of affected rows. For instructions about configuring the service, see Configuring DeleteSQL Services. |
| Custom SQL | CustomSQL | Defines and runs custom SQL to perform database
operations. You can run most SQL statements, including the statements for data management. For instructions about configuring the service, see Configuring CustomSQL Services. |
| Dynamic SQL | DynamicSQL | Defines and runs an SQL statement, part of which you set
at run time through the input field. For instructions about configuring the service, see Configuring DynamicSQL Services. |
| Stored Procedure | StoredProcedure | The Stored Procedure service calls
a stored procedure to perform database operations. For instructions about configuring the service, see Configuring StoredProcedure Services. |
| Stored Procedure with signature | StoredProcedureWithSignature | The Stored Procedure with signature
service calls a stored procedure to perform database operations. It gets the stored
procedure's parameters by introspecting. It lists the stored procedure's signature when you
configure the adapter service. For instructions about configuring the service, see Configuring StoredProcedureWithSignature Services. |
| Execute Service | ExecuteService |
Runs a Java or flow service by using a JDBC connection object from the Adapter for JDBC connection pool. For more information, see Using a Connection from the Connection Pool Within a Java or Flow Service. For instructions about configuring the service, see Configuring ExecuteService Services. |