webMethods JDBC Adapter 6.0.3

Release Notes


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.

Summary of Major Features for Version 6.0.3

Additional Database and Driver Support

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.

Batch Services

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.

Summary of Major Features for Version 6.0.2

Additional Database and Driver Support

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.

Support for Ordered Notifications

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.

Enhanced Logging Support

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.

Enhanced Adapter Service Template Scalability

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.

Upgrade Utility Support

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.


Version 6.0.1 Release Notes

Support for Notifications

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.

Support for Multiple Transaction Types

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.

Support for Connection Pooling

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.

Support for Exactly Once Notification

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.

Template-Based Integrations

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.

Platform Support for JDBC Adapter 6.0.1

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
  • Windows NT 4.0
  • Windows 2000 Professional
  • Windows 2000 Server
  • Windows 2000 Advanced Server
  • Windows XP Professional
  • Sun Solaris 2.7, 2.8
  • HP-UX 11, 11i
  • AIX 4.3.3, 5.1
  • Linux 2.2
  • Mac OS X
Microsoft SQL Server 7.0 & 2000
  • Windows NT 4.0
  • Windows 2000 Professional
  • Windows 2000 Server
  • Windows 2000 Advanced Server
  • Windows XP Professional

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.