v5:userguide:transactions
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:userguide:transactions [2016/02/27 17:13] – [Default Behaviour] mnewnham | v5:userguide:transactions [2016/04/14 15:29] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Transaction Handling In ADOdb ====== | ======Transaction Handling In ADOdb ====== | ||
===== Overview ===== | ===== Overview ===== | ||
- | There are 2 ways of overriding the default transaction handling in ADOdb, **Granular** and **Smart**. Each way holds benefits but they cannot be mixed. Each method comprises a series of methods. | + | There are 2 ways of overriding the default |
* Granular transactions allow full control of individual commits | * Granular transactions allow full control of individual commits | ||
Line 25: | Line 25: | ||
<WRAP right box> | <WRAP right box> | ||
== Available Methods == | == Available Methods == | ||
- | [[v5: | + | [[v5: |
- | [[v5: | + | [[v5: |
- | [[v5: | + | [[v5: |
+ | == See Also == | ||
+ | [[v5: | ||
+ | [[v5: | ||
</ | </ | ||
When using granular transactions, | When using granular transactions, | ||
Line 68: | Line 71: | ||
<WRAP right box> | <WRAP right box> | ||
== Available Methods == | == Available Methods == | ||
- | [[v5: | + | [[v5: |
- | [[v5: | + | [[v5: |
- | [[v5: | + | [[v5: |
- | [[v5: | + | [[v5: |
+ | == See Also == | ||
+ | [[v5: | ||
+ | [[v5: | ||
</ | </ | ||
Smart Transactions are much easier to use in large procedures because you do not have to track the error status. You start a smart transaction by calling StartTrans(): | Smart Transactions are much easier to use in large procedures because you do not have to track the error status. You start a smart transaction by calling StartTrans(): | ||
Line 119: | Line 125: | ||
</ | </ | ||
- | You can also check if a transaction has failed, using [[v5: | + | You can also check if a transaction has failed, using [[v5: |
- | * if [[v5: | + | * if [[v5: |
- | * There was an error in the SQL execution. | + | * There was an error in the SQL execution. This execution comprises all scenarios where the SQL statement was successfully issued, but failed to complete. This does not include scenarios where the construction of the statement failed, and an error occurred that was trapped by PHP error handling. |
Make sure you call '' | Make sure you call '' | ||
Line 161: | Line 167: | ||
==== Savepoints ==== | ==== Savepoints ==== | ||
Savepoints are currently not supported. | Savepoints are currently not supported. | ||
- |
v5/userguide/transactions.txt · Last modified: 2020/08/26 10:09 by dregad