Patent ID: 8326996

Claim:
A method for establishing multiple sessions between a database and a middle-tier client, the method comprising: receiving a single request for a plurality of sessions at a database from a middle-tier client; in response to successfully authenticating the middle-tier client, creating a first session between the database and the middle-tier client; creating, by the database, other sessions by cloning the first session one or more times; sending from the database to the middle-tier client a plurality of session-handles for the first and the other cloned sessions in response to the single request, wherein each session-handle comprises a session-key; receiving at the database from the middle-tier client a session-handle selected from the plurality of session-handles by an end-user client, wherein the received session-handle corresponds to a second session; verifying, at the database, the session-key in the received session-handle to determine that the middle-tier client is authorized to use the second session; and executing, at the database, a command received from the middle-tier client using the second session.