Mechanism for executing nested transactions in an execution environment supporting flat transactions only
View Patent ↗Disclosed is a means and a method for executing a nested transaction in an execution environment supporting flat transactions only. To process a StartTransaction operation within a nested transaction it is suggested to check whether the StartTransaction operation is on the first nesting level of the nested transactions. An actual transaction within the execution environment by issuing a corresponding StartTransaction is started only in the affirmative case but not otherwise. To process a CommitTransaction operation within a nested transaction to successfully terminate a transaction it is suggested to check whether the CommitTransaction operation is on the first nesting level of the nested transaction. An actual transaction within the execution environment will be terminated only by issuing a corresponding CommitTransaction operation in the affirmative case but not otherwise. To process a RollbackTransaction operation within a nested transaction aborting a transaction as unsuccessful, it is suggested to issue a corresponding RollbackTransaction operation within the execution environment independent from the nesting level of said RollbackTransaction operation.
1. A computerized method comprising: executing a nested transaction for computing data in an execution environment supporting a flat transaction only, and wherein a nested transaction encapsulates between a first StartTransaction operation and a corresponding first EndTransaction operation on a first nesting level a hierarchy of one or more further StartTransaction operations and corresponding further EndTransaction operations on further nesting levels, wherein a StartTransaction operation starts a transaction; and wherein an EndTransaction operation ends a transaction; wherein a facade library provides access from an object oriented environment to a relational database system, having a transaction object comprises a depth counter, a CommitTransaction operation, and a RollbackTransaction operation as object methods, and said method further comprising performing a StartTransaction operation by,
checking whether said StartTransaction operation is on the first testing level of said nested transaction, and
issuing a corresponding StartTransaction operation within said execution environment only when said StartTransaction operation is on the first testing level of said nested transaction.
2. A computerized method for executing a nested transaction for computing data in an execution environment supporting a flat transaction only according to claim 1 , said method performing an EndTransaction operation by:
checking, in case said EndTransaction operation is a CommitTransaction operation successfully terminating a transaction, whether said EndTransaction operation is on said first nesting level of said nested transaction, and
issuing a corresponding CommitTransaction operation within said execution environment only when said EndTransaction operation is on said first nesting level of said nested transactions.
3. A computerized method for executing a nested transaction for computing data in an execution environment supporting a flat transaction only according to claim 2 , said method performing an EndTransaction operation in case said EndTransaction operation is a RollbackTransaction operation aborting a transaction as unsuccessful, by issuing a corresponding RollbackTransaction operation within said execution environment independent from the nesting level of said RollbackTransaction operation.
4. A computerized method for executing a nested transaction for computing data in an execution environment supporting a flat transaction only according to claim 3 , said method performing, once a RollbackTransaction operation has been executed within said nested transaction, any further StartTransaction operation or any further EndTransaction operation within said nested transaction independent from its nesting level by rejecting it as being in error without issuing a corresponding StartTransaction operation or a corresponding EndTransaction operation to the execution environment.
5. A computerized method for executing a nested transaction in an execution environment supporting a flat transaction only according to claim 1 , said method performing an EndTransaction operation for computing data by:
checking, in case said EndTransaction operation is a CommitTransaction operation successfully terminating a transaction, whether said EndTransaction operation is on said first nesting level of said nested transaction, and
issuing a corresponding CommitTransaction operation within said execution environment only when said EndTransaction operation is on said first nesting level of said nested transaction;
said method performing an EndTransaction operation in case said EndTransaction operation is a RollbackTransaction operation aborting a transaction as unsuccessful, by issuing a corresponding RollbackTransaction operation within said execution environment independent from the nesting level of said RollbackTransaction operation; and
said method performing, once a RollbackTransaction operation has been executed within said nested transaction, any further StartTransaction operation or any further EndTransaction operation within said nested transaction independent from its nesting level by rejecting it as being in error without issuing a corresponding StartTransaction operation or a corresponding EndTransaction operation to the execution environment.
6. A data processing program for execution in a data processing system comprising software code portions for performing a computerized method for executing a nested transaction for computing data in an execution environment supporting a flat transaction only, and wherein a nested transaction encapsulates between a first StartTransaction operation and a corresponding first EndTransaction operation on a first nesting level a hierarchy of one or more further StartTransaction operations and corresponding further EndTransaction operations on further nesting levels, wherein a StartTransaction operation starts a transaction; and wherein an EndTransaction operation ends a transaction; wherein a facade library provides access from an object oriented environment to a relational database system, having a transaction object comprises a depth counter, a CommitTransaction operation, and a RollbackTransaction operation as object methods, and said method further comprising performing a StartTransaction operation by,
checking whether said StartTransaction operation is on the first nesting level of said nested transaction, and
issuing a corresponding StartTransaction operation within said execution environment only when said StartTransaction operation is on the first nesting level of said nested transaction.
7. A computer program product stored on a computer usable medium, comprising computer readable program means for causing a computer to perform a method executing a nested transaction in an execution environment supporting a flat transaction only, and wherein a nested transaction encapsulates between a first StartTransaction operation and a corresponding first EndTransaction operation on a first nesting level a hierarchy of one or more further StartTransaction operations and corresponding further EndTransaction operations on further nesting levels, wherein a StartTransaction operation starts a transaction; and wherein an EndTransaction operation ends a transaction;
wherein a facade library provides access from an object oriented environment to a relational database system, having a transaction object comprises a depth counter, a CommitTransaction operation, and a RollbackTransaction operation as object methods, and said method further comprising performing a StartTransaction operation by,
checking whether said StartTransaction operation is on the first nesting level of said nested transaction, and
issuing a corresponding StartTransaction operation within said execution environment only when said StartTransaction operation is on the first testing level of said nested transaction.