ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== metaTransaction =====
~~NOTOC~~
<WRAP right box>
== See Also ==
[[v5:reference:connection:settransactionmode|setTransactionMode()]]
== Syntax == 
  string metaTransaction(
    string $transactionLevel,
    string $dataProvider
    )
  
</WRAP>
===== 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 =====
<code php>
/*
 * No valid connection is necessary 
 */
$t = $db->metaTransaction('serializable','oci8');
print $t;
/*
 * prints ISOLATION LEVEL SERIALIZABLE
*/
</code>

===== 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]]