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