Abstract: A method, system, and computer program product for managing a heterogeneous connection pooling structure. The heterogeneous architecture of pooling management comprises connections having different connection attributes (i.e. different data source properties) that can share a same connection pool (i.e. same connection pool data source). An application requests a connection from data source having a specified data source property. An application server searches a pool module for an available cached connection. If a cached connection is available, the cached connection is automatically selected as a returned connection. A connection reuse protocol and a statement reuse protocol is determined and invoked to reconfigure the cached connection for reuse as a connection between the application and a database server.

Abstract: A method and system for efficient allocation of memory in database retrieval employs a technique which allocates a memory portion of a first size which may or may not be smaller than a data item to be retrieved from the database (such as a column which may be of indeterminate length). In that circumstance, a first FETCH, for example, an SQL FETCH, is followed by a new syntactical instruction, a FETCH CONTINUE, until all of the data item is retrieved. The FETCH CONTINUE may involve allocating memory portions of similar or different sizes to accommodate additional fetched portions, and may involve varying numbers of fetches.

Abstract: A method and system for efficient allocation of memory in database retrieval employs a technique which allocates a memory portion of a first size which may or may not be smaller than a data item to be retrieved from the database (such as a column which may be of indeterminate length). In that circumstance, a first FETCH, for example, an SQL FETCH, is followed by a new syntactical instruction, a FETCH CONTINUE, until all of the data item is retrieved. The FETCH CONTINUE may involve allocating memory portions of similar or different sizes to accommodate additional fetched portions, and may involve varying numbers of fetches.