International Business Machines Corporation

Michelle D Lam

Curt Lee Cotner

Paul Miller Bird

James Willis Pickel

Tammie Dang

William Robert Bireley

Margaret Ann Dong

Georgia Carroll Fuller

Frankie K Sun

In a 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.

Computer-readable medium to multiplex multiple application server requests over a single database connection

In a method 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.

Method and mechanism to multiplex multiple application server requests over a single database connection

Growing community of inventors

San Jose, CA, United States of America

Michelle D Lam