WebSphere JDBC Adapter Inbound Service Performance Tuning

Overview

The JDBC Adapter (Adapter) Inbound service is widely used in enterprise application integration which needs to monitor the business data tables in the database. Because of the different scale of enterprise application, the performance requirements of Adapter inbound service are different, how to configure Adapter inbound service to improve the performance of Adapter processing events is very important in practical application. This article provides a comprehensive overview of how to tailor the Adapter inbound service configuration to meet the performance requirements for Adapter inbound services in a variety of enterprise integrations.

Introduction to JDBC Adapter Inbound services

JDBC Adapter is a J2CA specification that runs on the WebSphere Process Server and provides adapters for various database vendors to connect to applications. Adapter the ability to have two-way connectivity between databases and applications, including outbound connectivity from applications to databases, and inbound connectivity from databases to applications. With Adapter inbound services, applications can monitor the changes in database business data tables and are therefore widely used in integrated integration of various database-centric enterprise applications. Figure 1 shows the basic workings of a typical Adapter inbound service. Various applications built on the database to write data to the business data table according to the business logic of the existing application. Adapter uses event triggers (Trigger) or event notification mechanisms specific to various databases, such as dbms_notification packages for Oracle databases, transparently monitors business data changes for various applications, and caches events in the Event log table. The Adapter inbound service deployed on the server periodically polls the event record table and passes the newly discovered database event to the module that handles the event.

Figure 1. JDBC Adapter Inbound Service Basic Working principle

In addition to providing basic inbound connectivity, Adapter provides complete event forwarding assurance, data consistency, and transactional support for database event monitoring to ensure that business data events are handled securely and correctly. In practical applications, due to the different scale of business, the system's performance requirements for business data event processing vary, for this Adapter provides a wealth of performance configuration options to meet the performance requirements of various applications for event handling. This article describes in detail the various performance options for Adapter in a later section.