The webMethods JDBC Adapter is an add-on to the webMethods Integration Platform that provides seamless and real-time integration with many relational database systems that support and provide JDBC drivers.
This adapter supports not only standard database operations, such as Insert, Update, and Delete, but also provides extensive support for stored procedures and notifications.
The JDBC Adapter now supports the following additional databases running on the operating systems supported by the database vendors:
JDBC Adapter 6.0.3 also adds support for DataDirect Connect for JDBC, edition 3.3, where appropriate. See the webMethods JDBC Adapter Installation Guide for a detailed list of supported operating systems and drivers.
The JDBC Adapter now supports two new services for performing faster Inserts and Updates of large amounts of data:
|
Template |
Description |
|
BatchInsertSQL |
Inserts new information into a database table in a batch manner, where a COMMIT does not occur until all data has been inserted successfully. |
|
BatchUpdateSQL |
Updates existing information in a database table in a batch manner, where a COMMIT does not occur until all update operations have completed successfully. |
These templates include a mapping for an output field to reflect the number of affected rows. The services return either the number of rows or an integer that indicates successful execution.
The JDBC Adapter now supports the following additional databases running on the operating systems supported by the database vendors.
JDBC Adapter 6.0.2 also adds support for Solaris 2.9 and DataDirect Connect for JDBC, edition 3.2, where appropriate. See the webMethods JDBC Adapter Installation Guide for a detailed list of supported operating systems and drivers.
The JDBC adapter can now publish notification data for multiple Insert, Update, and Delete operations on multiple tables in the order in which the events occurred. An Ordered Notification template is provided in the webMethods Developer.
The JDBC Adapter uses the Integration Server’s logging mechanism to capture messages and write them to the Audit, Error, or Server logs. Information for the JDBC Adapter’s error codes is also now provided in the webMethods JDBC Adapter User's Guide.
Users can now provide a schema list to be used as a table filter as a better performing alternative to the default behavior of automatic introspection of all database objects when creating an adapter service or notification for a large database.
The webMethods JDBC Adapter Installation Guide references a utility available for assisting users upgrading from the Enterprise JDBC Adapter Version 4.6 to the webMethods JDBC Adapter Version 6.0.2.
The JDBC Adapter supports notifications, which are changes of interest that have taken place in the database. The adapter supports notifications that result from Insert, Update and Delete operations, as well as those prompted through stored procedure calls. There are Automatic, Basic, and Stored Procedure Notifications. Automatic notifications create triggers on a database and buffer tables to hold data.
The JDBC Adapter supports Automatic (NO_TRANSACTION), Controlled (LOCAL_TRANSACTION), and 2-phased (XA_TRANSACTION) transactions. In Automatic transaction mode, the adapter handles the transaction boundaries. In Controlled transaction mode, users have control over the transactions. Using XA JDBC drivers, the adapter can support 2-phase transactions executed across multiple databases. The adapter works with the webMethods Integration Server to act as the transaction manager for 2-phase transactions.
The JDBC Adapter supports connection pooling, which provides for efficient use of connections. The connections are held by the various flow services while they are actively processing database transactions and returned to the pool as soon as transactions are over. This is particularly efficient in cases where the flow service does several things besides doing transactions with a database.
The JDBC Adapter supports exactly once notification in association with the Integration Server configuration for transient storage. This feature ensures that duplicate documents are not forwarded to the Integration Server even under fault/failure situations.
The JDBC Adapter provides service templates and notification templates for interactions with databases. This makes it easy to develop flow services to interact with a database without having to type the SQL.
Service templates and notification templates represent specific tasks for doing work within a database. For example, a JDBC adapter service that deletes data from a database might be based on the DeleteSQL service template included with the adapter. You can create specific adapter services using the templates and execute them using parameters specified when the adapter runs. These parameters include the actual data required by the adapter to perform the operation, such as a table name.
The JDBC Adapter supports the following templates:
| Template | Description |
| CustomSQL | Executes free format SQL on a database. |
| DeleteSQL | Deletes rows from a table and includes a mapping for an output field that stores the number of affected rows. |
| InsertSQL | Inserts new information into a database table. |
| SelectSQL | Retrieves specified information from a database table. |
| StoredProcedure | Calls a stored procedure to perform database operations. |
| UpdateSQL | Updates existing information in a database table and includes a mapping for an output field that stores the number of affected rows. |
| DynamicSQL | Configures a dynamic SQL statement, part of which is set at runtime using the Input field. |
| BasicNotification | Polls a database table for data using a SELECT operation. |
| DeleteNotification | Publishes notification of DELETE operations on a database table. |
| InsertNotification | Publishes notification of INSERT operations on a database table. |
| StoredProcedureNotification | Publishes notification data by calling a stored procedure on a database. |
| UpdateNotification | Publishes notification of UPDATE operations on a database table. |
The JDBC Adapter supports the following databases and operating systems:
| Database & Version | Operating System |
| Oracle 8.0.5, 8.1.7, 9.0.1, 9.2.0 |
|
| Microsoft SQL Server 7.0 & 2000 |
|
The JDBC Adapter supports the following JDBC drivers:
| Database & Version | Driver & Version |
| Oracle 8.0.5, 8.1.7, 9.0.1, 9.2.0 | Oracle JDBC Thin Driver and OCI Driver |
| Microsoft SQL Server 7.0 | DataDirect Connect for JDBC, edition 3.1 |
| Microsoft SQL Server 2000 | Microsoft SQL Server 2000 Driver for JDBC, version 2.2.0019 |
Note: For a complete listing of the combinations of databases, operating systems, and drivers the JDBC Adapter supports, see the webMethods JDBC Adapter Installation Guide Version 6.0.1.
webMethods Administrator, webMethods Broker, webMethods Developer, webMethods Installer, webMethods Integration Server, webMethods Mainframe, webMethods Manager, webMethods Modeler, webMethods Monitor, webMethods Trading Networks, webMethods Workflow, and the webMethods logo are trademarks of webMethods, Inc. "webMethods" is a registered trademark of webMethods, Inc.
All other marks are the property of their respective owners.
Copyright © 2002-2003 by webMethods, Inc. All rights reserved, including the right of reproduction in whole or in part in any form.