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

US7433950B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Paul M. Bird · Markham, CA
• William Robert Bireley · معلمی نژاد, US
• Curt L. Cotner · Gilroy, US
• Tammie Dang · معلمی نژاد, US
• Margaret A. Dong · San Jose, US
• Georgia C. Fuller · San Jose, US
• Michelle Lam · Los Angeles, US
• James W. Pickel · Gilroy, US
• Frankie K. Sun · North York, CA

Key dates

• Filing date: Dec 4, 2003
• Grant date: Oct 7, 2008
• Expiry date: Jan 7, 2026

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y10S707/99953
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

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.