Abstract: A client or client representative of a database maintains a configurable table of database messages and associated values, at least some of which include references to commands to be executed upon the occurrence of the message being issued from the database. One or more of these command sets respond to a lack of resource message by causing the system to automatically increase the allocated resources of the database to allow the request to be processed, preferably transparently to the client. After increasing the resource allocation, the request is then automatically retried.

Abstract: The present invention provides a method, system, and computer program product for caching dynamically generated queries such as SQL (Structured Query Language) statements. A method in accordance with an embodiment of the present invention comprises: providing a partial update query for updating at least one column in a table stored in a database; generating a key using a number representative of an update status of each column in the table; and determining if a prepared statement corresponding to the partial update query is located in a prepared statement cache using the key.

Abstract: A method, apparatus, system, and signal-bearing medium that, in an embodiment, receive an allocation request for a resource and registers the resource as a non-voting participant if the resource desires to delegate commit voting to another resource. The registered resource is then prohibited from participating in an enclosing transactional context and instead is informed when the transaction completes. The resource is enlisted as a voting participant if the resource does not desire to delegate commit voting. In this way, when multiple resources are used in a transaction, a resource may be registered and receive notifications of transaction completion instead of being enlisted and voting on commit decisions. The result of a transaction in which a single resource takes responsibility for a number of other resources is that transaction completion avoids the two-phase commit protocol and the resulting performance degradation.

Abstract: An apparatus and method enable batch processing of database updates without modifying generated code, i.e., without redeployment of the application server or application. A batch mechanism intercepts calls from the generated code, compiles updates into batches, and processes the updates to the database in batches. In this manner the batch mechanism takes advantage of the batch processing capabilities of the database without modifying the generated code.