Patent Number: 6,434,543

Title: System and method for reliable caching of database connections in a distributed application

Abstract: Connection information for open database connections is stored or "cached" in a connection manager at the database client. Therefore, even when a query is complete and the connection between the client and server is released, the manager maintains the database connection open. When a new query arrives at the client, the connection manager compares the connection information in the query to the corresponding information stored for each open connection. If there is a match and the connection is not in use, the already open connection is used for the new query. If there is no match, a new connection is opened until a predetermined limit of the number of connections is reached. When the limit is reached, an open connection which is not in use is closed and a new connection is established. In accordance with a preferred embodiment, a "free" list of open connections which are not in use is maintained so that a quick comparison can be made with the incoming query information.

Inventors: Goldberg; Robert N. (Redwood City, CA), White; Seth J. (San Jose, CA)

Assignee: Sun Microsystems, Inc.

International Classification: G06F 17/30 (20060101); G06F 017/30 ()

Expiration Date: 08/13/2019