SYSTEM FOR HANDLING ASYNCHRONOUS DATABASE TRANSACTIONS IN A WEB BASED ENVIRONMENT

A system and computer readable medium for handling asynchronous database transactions in a web based environment is disclosed. The system and computer readable medium 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 system and computer readable medium 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 computer readable medium 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.