Patent ID: 7917470

Claim:
A computer implemented method for using a logging last resource (LLR) enabled connection pool, comprising the steps of: providing a database for use in processing transactions; providing a transaction manager that coordinates one or more resource managers to participate in transactions that include the database; providing a logging last resource (LLR) enabled connection pool that provides connections to access or update data at the database; wherein when a particular transaction is initiated, one of the connections within the connection pool is selected to provide communication with the database for the transaction, the transaction manager prepares the transaction at one or more non-LLR resource managers participating in the transaction, and the selected connection is used by the transaction manager to write transaction log information for LLR resource managers to an LLR table, so that database operations associated with the LLR resource managers can be committed using a one-phase or local commit, and database operations associated with non-LLR resource managers can be committed using a two phase commit; and wherein upon reboot from a crash, the method further comprises examining the LLR table at the database to read any transaction log records stored therein and determining how to resolve any transaction which included the one-phase or local commit by the logging last resource manager.