Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Overview of the Adapter | Adapter Services | Adapter Service Transaction Processing
 
Adapter Service Transaction Processing
The following diagram illustrates how Adapter for JDBC processes adapter services at run time.
Step
Description
1
An Integration Server client, typically using a flow or Java service, invokes a Adapter for JDBC service on Integration Server to perform an operation on a database.
You configured the adapter service earlier using Designer.
2
The adapter service gets a connection from the service's connection pool.
Adapter connections contain connection information for the database, including JDBC driver parameters.
3
The adapter service uses the JDBC driver to connect to the database.
You created and enabled the adapter connection earlier using Integration Server Administrator.
4
All adapter services except ExecuteService perform a SQL operation against the database.
*For SelectSQL, InsertSQL, UpdateSQL, DeleteSQL, CustomSQL, and DynamicSQL services, the adapter service executes a SQL statement against the database.
*For BatchInsertSQL and BatchUpdateSQL services, the adapter service executes batch SQL statements against the database. The adapter service will continue to loop through the document list that is used as input, set the fields to the parameters of the SQL statement and then add that command set to the batch. Upon completion, the adapter sends the entire batch to the database resource for execution.
*For StoredProcedure and StoredProcedureWithSignature services, the adapter service executes a stored procedure against the database.
*The ExecuteService adapter service executes a Java or flow service that needs a connection object from the connection pool. For more information see Using a Connection from the Connection Pool Within a Java or Flow Service.
5
Depending on the adapter service type, such as a SelectSQL service, the adapter service may return data to Integration Server.
*If the operation is successful, the service returns the output from the service's database operation, if applicable.
With BatchInsertSQL and BatchUpdateSQL services, if all commands are successfully executed, the adapter commits all commands in the batch and returns a list of String values. These values will vary by driver. Refer to your driver documentation for details.
*If the operation is unsuccessful, the service returns an error such as an AdapterException. If the database throws an exception while performing the adapter service's operation, the adapter passes the exception to the Integration Server logs.
For more information about how the adapter handles exceptions, see Overview of Logging and Exception Handling.