Method for handling asynchronous database transactions in a web based environment

A computer implemented method, comprising:

• receiving a first transaction message from a sysplex distributor at a first application server of a plurality of application servers, wherein the first application server is selected based on a workload analysis of the plurality of application servers, the first transaction message asynchronously transmitted to the sysplex distributor from a first client device of a plurality of client devices, wherein the first transaction message includes a first client identifier associated with the first client device, and wherein the first transaction message includes a request for information from a database system;
• generating a first socket identifier;
• assigning the first socket identifier to the first transaction message via a first resource adapter of the first application server, the first socket identifier associated with a first persistent socket connection;
• adding the first client identifier and the first socket identifier to a first header of the first transaction message;
• and
• sending the first transaction message to a first database queue of the database system via a transmission control protocol/internet protocol (TCP/IP) gateway using the first persistent socket connection, wherein the first database queue is associated with the first client identifier,
• wherein the database system receives the first transaction message, identifies a particular database queue from a plurality of database queues in which to place the first transaction message for processing, the particular database queue identified based on the first socket identifier, and sends a result of processing the first transaction message to the first client device via the dedicated persistent socket connection based on the first socket identifier when the database system has completed processing the first transaction message, and
• wherein the first resource adapter of the first application server receives instructions from the database system to add the first socket identifier to a connection pool for re-use after the database system has completed processing the first transaction message.

A storage device storing program instructions executable by a processor to:

• transmit a transaction message from a particular application server of a plurality of application servers, wherein the transaction message was communicated to the particular application server via a sysplex distributor configured to assign the transaction message to the particular application server based on a workload analysis of the plurality of application servers;
• generate a socket identifier associated with a dedicated persistent socket connection;
• receive the transaction message at a database system from the application server using the dedicated persistent socket connection via a transmission control protocol/internet protocol TCP/IP gateway, wherein the transaction message includes a client identifier associated with a client device of a plurality of client devices and the socket identifier;
• identify a particular database queue from a plurality of database queues in which to place the transaction message for processing, the particular database queue identified based on the socket identifier;
• process the transaction message in the particular database queue;
• send a result of processing the transaction message to the client device via the dedicated persistent socket connection based on the socket identifier after the database queue has completed processing of the transaction message;
• and
• instruct a resource adapter of the application server to add the socket identifier to a connection pool for re-use after the database queue has completed processing of the transaction message.