Method, system and mechanism to multiplex multiple application server requests over a single database connection
First Claim
1. A method for avoiding section collision for application server requests over a single database connection, the method comprising:
- (a) receiving a first statement assigned a first command source identifier by a database server from a first application source over a single database connection between the database server and an application server;
(b) receiving a second statement assigned a second command source identifier by the database server from a second application source over the single database connection, wherein the first statement is substantially identical to the second statement; and
(c) executing the first statement assigned a first command source identifier separately from and in parallel with the second statement assigned the second command source without section collision.
3 Assignments
0 Petitions
Accused Products
Abstract
In a method and system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.
-
Citations
28 Claims
-
1. A method for avoiding section collision for application server requests over a single database connection, the method comprising:
-
(a) receiving a first statement assigned a first command source identifier by a database server from a first application source over a single database connection between the database server and an application server;
(b) receiving a second statement assigned a second command source identifier by the database server from a second application source over the single database connection, wherein the first statement is substantially identical to the second statement; and
(c) executing the first statement assigned a first command source identifier separately from and in parallel with the second statement assigned the second command source without section collision. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method for avoiding section collision for application server requests over a single database connection, the method comprising:
-
(a) receiving a first statement to open a cursor by an database server over a single database connection between the database server and an application server;
(b) creating a first instance of the cursor in response to the first statement;
(c) assigning the first instance a first query identifier;
(d) receiving a second statement to open the same cursor by the database server over the single database connection before the first instance of the cursor closes;
(e) creating a second instance of the cursor in response to the second statement; and
(f) assigning the second instance a second query identifier. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A computer readable medium with program instructions for avoiding section collision for application server requests over a single database connection, comprising the instructions for:
-
(a) receiving a first statement assigned a first command source identifier by a database server from a first application source over a single database connection between the database server and an application server;
(b) receiving a second statement assigned a second command source identifier by the database server from a second application source over the single database connection, wherein the first statement is substantially identical to the second statement; and
(c) executing the first statement assigned a first command source identifier separately from and in parallel with the second statement assigned the second command source without section collision. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
-
22. A computer readable medium with program instructions for avoiding section collision for application server requests over a single database connection, comprising the instructions for:
-
(a) receiving a first statement to open a cursor by an database server over a single database connection between the database server and an application server;
(b) creating a first instance of the cursor in response to the first statement;
(c) assigning the first instance a first query identifier;
(d) receiving a second statement to open the same cursor by the database server over the single database connection before the first instance of the cursor closes;
(e) creating a second instance of the cursor in response to the second statement; and
(f) assigning the second instance a second query identifier. - View Dependent Claims (23, 24, 25, 26, 27, 28)
-
Specification