Method and system for handling asynchronous database transactions in a web based environment

摘要

A method and system for handling asynchronous database transactions in a web based environment is disclosed. The method and system comprise providing a first ID from a device via a dedicated persistent connection and generating a second ID in an application server upon receipt of the first ID. The method and system also also include utilizing the first ID and second ID to obtain the appropriate data from a database system and to send the appropriate data to the device. A system and method in accordance with the present invention uses a database resource adapter, which runs inside an application server, to generate a socket ID internally for every input transaction running with the dedicated persistent socket connection and also saves the customer-specified client ID for database queue creation and legacy application. This operation is transparent to the customers' client application.