====== metaTransaction =====
~~NOTOC~~
== See Also ==
[[v5:reference:connection:settransactionmode|setTransactionMode()]]
== Syntax ==
string metaTransaction(
string $transactionLevel,
string $dataProvider
)
===== Description =====
The method ''metaTransaction()'' returns a database specific isolation level statement for a supplied database and meta transaction level.
===== Parameters =====
==== $transactionLevel=====
There are 4 available options for this parameter:
* READ UNCOMMITTED
* READ COMMITTED
* REPEATABLE READ
* SERIALIZABLE
==== $dataProvider ====
A string representing an ADOdb data provider, not necessarily the currently connected database.
===== Usage =====
/*
* No valid connection is necessary
*/
$t = $db->metaTransaction('serializable','oci8');
print $t;
/*
* prints ISOLATION LEVEL SERIALIZABLE
*/
===== Resources =====
[[https://msdn.microsoft.com/en-us/library/ms173763.aspx|Microsoft SQL Server]]
[[https://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html|MySQL]]
[[http://www.postgresql.org/docs/8.1/interactive/sql-set-transaction.html|Postgresql]]
[[http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_10005.htm|Oracle]]