MANAGING DATABASE CONNECTIONS

• US 20090234957A1
• Filed: 06/29/2008
• Published: 09/17/2009
• Est. Priority Date: 06/29/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: LI, Ying, CHEN, Ying
• Granted Patent: US 7,844,720 B2
• Time in Patent Office: Days
• US Class Current: 709/229
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

The present invention provides a method for managing a database connection, comprising the steps of: in responsive to a connection request of a first application, allocating an available connection for the first application; if there is no available connection, selecting a held connection being used by a second application; backing up connection context of the held connection; releasing the held connection; and allocating the held connection for the first application. Since connection context of the application has been restorably backed up, a connection of the application can be cut off and the connection re-scheduled when necessary. As a result, the connection utilization rate is enhanced. The present invention further provides a device and system that can manage a database connection based on the technology of connection pools.

Claims

1. A method for managing a database connection, the method comprising:

in responsive to a connection request of a first application, allocating an available connection for the first application;

selecting an allocated connection being held by a second application if there is no available connection;

backing up connection context of the connection being held;

releasing the connection being held; and

allocating the connection being held for the first application.

2. The method according to claim 1, further comprising:

if the second application makes a request for restoring a previous connection state, allocating a new connection for the second application based on the backing up of the connection context and restoring the previous connection state.

3. The method according to claim 2, wherein the application is a Java application, and the connection is a JDBC connection.

4. The method according to claim 3, wherein the selection step comprises at least one of:

selecting a held connection that will be released among all held connections using a Lease Recently Used algorithm; and

selecting a held connection that has exceeded a predetermined time.

5. The method according to claim 4, wherein the step of backing up connection context of the held connection further comprises:

defining a key for a statement of the application for which backup was performed, and establishing a correspondence between connection context of the held connection and the key.

6. The method according to claim 5, wherein the key is any character that uniquely identifies a statement of each application.

7. The method according to claim 6, wherein the key is specific information of the connection context.

8. The method according to claim 1, wherein the step of backing up connection context of the held connection further comprises:

defining a key for a statement of the application for which backup was performed, and establishing a correspondence between connection context of the held connection and the key.

9. The method according to claim 8, wherein the key is any character that uniquely identifies a statement of each application.

10. The method according to claim 8, wherein the key is specific information of the connection context.

11. A database connection manager for managing connections in a connection pool to a database, the database connection manager comprising:

connection context backup means for backing up context of a connection;

connection scheduling means for scheduling the connection, comprising;

means for allocating an available connection for a first application in responsive to a connection request of the first application;

means for selecting an allocated connection being held by a second application if there is no available connection;

means for controlling the connection context backup means to back up connection context of the connection being held;

means for releasing the connection being held; and

means for allocating the connection being held for the first application.

12. The database connection manager according to claim 11, further comprising connection context restoration means for, if the second application makes a request for restoring a previous connection state, allocating a new connection for the second application based on the backup of the connection context and restoring the previous connection state.

13. The database connection manager according to claim 12, wherein the application is a Java application, and the connection is a JDBC connection.

14. The database connection manager according to claim 13, wherein the selection means is used for performing at least one of:

selecting a held connection that will be released among all held connections using a Lease Recently Used algorithm; and

selecting a held connection that has exceeded a predetermined time.

15. The database connection manager according to claim 14, further comprising key management means for defining a key for a statement of the application for which backup was performed and establishing a correspondence between connection context of the connection being held and the key.

16. The database connection manager according to claim 15, wherein the key is any character that uniquely identifies a statement of each application.

17. The database connection manager according to claim 16, wherein the key is specific information of the connection context.

18. The database connection manager according to claim 11, further comprising key management means for defining a key for a statement of the application for which backup was performed and establishing a correspondence between connection context of the held connection and the key.

19. The database connection manager according to claim 18, wherein the key is any character that uniquely identifies a statement of each application.

20. The database connection manager according to claim 18, wherein the key is specific information of the connection context.