WebSphere JDBC Adapter Inbound Service Performance Tuning

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.