<HTML ><HEAD ><TITLE >sesam_settransaction</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="SESAM database functions" HREF="ref.sesam.html"><LINK REL="PREVIOUS" TITLE="sesam_seek_row" HREF="function.sesam-seek-row.html"><LINK REL="NEXT" TITLE="Session handling functions" HREF="ref.session.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.sesam-seek-row.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="ref.session.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.sesam-settransaction" ></A >sesam_settransaction</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN83786" ></A ><P > (PHP 3 CVS only)</P >sesam_settransaction -- Set SESAM transaction parameters</DIV ><DIV CLASS="refsect1" ><A NAME="AEN83789" ></A ><H2 >Description</H2 >bool <B CLASS="methodname" >sesam_settransaction</B > ( int isolation_level, int read_only)<BR ></BR ><P > Returns: <TT CLASS="constant" ><B >TRUE</B ></TT > if the values are valid, and the <B CLASS="function" >settransaction()</B > operation was successful, <TT CLASS="constant" ><B >FALSE</B ></TT > otherwise. </P ><P > <B CLASS="function" >sesam_settransaction()</B > 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. </P ><P > <B CLASS="function" >sesam_settransaction()</B > can only be called before starting a transaction, not after the transaction has been started already. </P ><P > To simplify the use in php scripts, the following constants have been predefined in php (see SESAM handbook for detailed explanation of the semantics): <DIV CLASS="table" ><A NAME="AEN83809" ></A ><P ><B >Table 1. Valid values for <TT CLASS="parameter" ><I >"Isolation_Level"</I ></TT > parameter </B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Value</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Constant</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Meaning</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >1</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_TXISOL_READ_UNCOMMITTED</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Read Uncommitted</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >2</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_TXISOL_READ_COMMITTED</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Read Committed</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >3</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_TXISOL_REPEATABLE_READ</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Repeatable Read</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >4</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_TXISOL_SERIALIZABLE</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Serializable</TD ></TR ></TBODY ></TABLE ></DIV > <DIV CLASS="table" ><A NAME="AEN83839" ></A ><P ><B >Table 2. Valid values for <TT CLASS="parameter" ><I >"Read_Only"</I ></TT > parameter </B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Value</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Constant</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Meaning</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >0</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_TXREAD_READWRITE</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Read/Write</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >1</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_TXREAD_READONLY</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Read-Only</TD ></TR ></TBODY ></TABLE ></DIV > </P ><P > The values set by <B CLASS="function" >sesam_settransaction()</B > will override the default setting specified in the <A HREF="ref.sesam.html#ini.sesam-configfile" >SESAM configuration file</A >. </P ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN83863" ></A ><P ><B >Example 1. Setting SESAM transaction parameters</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="php" ><?php sesam_settransaction (SESAM_TXISOL_REPEATABLE_READ, SESAM_TXREAD_READONLY); ?></PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.sesam-seek-row.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="ref.session.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >sesam_seek_row</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.sesam.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Session handling functions</TD ></TR ></TABLE ></DIV ></BODY ></HTML >