Automatic status detection for an asynchronous processing request

A computer-implemented method comprising:

• obtaining, responsive to a first request from a requesting client to perform a plurality of database operations in a single transaction, a connection identifier for a connection to a database, the connection to be used to execute the plurality database operations;
• storing the connection identifier and a connection active flag in a status table, the connection active flag having an initial value of true;
• providing the connection identifier to the requesting client;
• receiving a second request from the requesting client, the second request being for a status of the connection;
• and
• providing a response to the second request that includes a value of the connective active flag from the status table.

A computer program product tangibly embodied on a non-transitory computer-readable storage medium and comprising instructions that, when executed, are configured to cause at least one computing device to:

• obtain, at a processing client and responsive to a first request from a requesting client to perform a plurality of database operations in a single transaction, a connection identifier for a connection to a database on a database server, the connection to be used to execute the plurality database operations;
• store the connection identifier in a row of a status table, the existence of the row indicating a status of the connection is active;
• provide the connection identifier to the requesting client;
• receive a second request from the requesting client, the second request being for a status of the connection;
• determine whether the row still exists in the status table;
• and
• provide a response to the second request that indicates whether the row still exists in the status table.