sesam_settransaction
(PHP 3 CVS only)
sesam_settransaction -- Set SESAM transaction parameters
Description
bool
sesam_settransaction ( int isolation_level, int read_only )
Overrides the default values for the isolation level
and read-only transaction parameters (which are set in
the SESAM configuration file), in order to optimize subsequent queries and
guarantee database consistency. The overridden values are used for the
next transaction only. See the SESAM handbook for detailed explanation of
the semantics.
This function can only be called before starting a transaction, not after
the transaction has been started already.
The values set by sesam_settransaction() will override
the default setting specified in the SESAM configuration file.
Parameters
isolation_level
Table 1.
Valid values for isolation_level
parameter
| Value | Constant | Meaning |
|---|
| 1 | SESAM_TXISOL_READ_UNCOMMITTED | Read Uncommitted |
| 2 | SESAM_TXISOL_READ_COMMITTED | Read Committed |
| 3 | SESAM_TXISOL_REPEATABLE_READ | Repeatable Read |
| 4 | SESAM_TXISOL_SERIALIZABLE | Serializable |
read_only
Table 2.
Valid values for read_only parameter
| Value | Constant | Meaning |
|---|
| 0 | SESAM_TXREAD_READWRITE | Read/Write |
| 1 | SESAM_TXREAD_READONLY | Read-Only |
Return Values
Returns TRUE if the values are valid, and the
settransaction operation was successful, FALSE
otherwise.
Examples
Example 1. Setting SESAM transaction parameters
<?php
sesam_settransaction (SESAM_TXISOL_REPEATABLE_READ,
SESAM_TXREAD_READONLY);
?>
|
|