1<!--$Id: txn_commit.so,v 10.49 2004/08/13 03:39:03 bostic Exp $--> 2<!--Copyright (c) 1997,2008 Oracle. All rights reserved.--> 3<!--See the file LICENSE for redistribution information.--> 4<html> 5<head> 6<title>Berkeley DB: DB_TXN->commit</title> 7<meta name="description" content="Berkeley DB: An embedded database programmatic toolkit."> 8<meta name="keywords" content="embedded,database,programmatic,toolkit,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,Java,C,C++"> 9</head> 10<body bgcolor=white> 11<table width="100%"><tr valign=top> 12<td> 13<b>DB_TXN->commit</b> 14</td> 15<td align=right> 16<a href="/api_c/api_core.html"><img src="/images/api.gif" alt="API"></a> 17<a href="/ref/toc.html"><img src="/images/ref.gif" alt="Ref"></a></td> 18</tr></table> 19<hr size=1 noshade> 20<tt> 21<b><pre> 22#include <db.h> 23<p> 24int 25DB_TXN->commit(DB_TXN *tid, u_int32_t flags); 26</pre></b> 27<hr size=1 noshade> 28<b>Description: DB_TXN->commit</b> 29<p>The DB_TXN->commit method ends the transaction.</p> 30<p>In the case of nested transactions, if the transaction is a parent 31transaction, committing the parent transaction causes all unresolved 32children of the parent to be committed. In the case of nested 33transactions, if the transaction is a child transaction, its locks are 34not released, but are acquired by its parent. Although the commit of the 35child transaction will succeed, the actual resolution of the child 36transaction is postponed until the parent transaction is committed or 37aborted; that is, if its parent transaction commits, it will be 38committed; and if its parent transaction aborts, it will be aborted.</p> 39<p>All cursors opened within the transaction must be closed before the 40transaction is committed.</p> 41<p>After DB_TXN->commit has been called, regardless of its return, the 42<a href="/api_c/txn_class.html">DB_TXN</a> handle may not be accessed again. If DB_TXN->commit 43encounters an error, the transaction and all child transactions of the 44transaction are aborted.</p> 45<p>The DB_TXN->commit method 46returns a non-zero error value on failure 47and 0 on success. 48</p> 49<b>Parameters</b> <br> 50 <b>flags</b><ul compact><li>The <b>flags</b> parameter must be set to 0 or 51one of the following values: 52<br> 53<b><a name="DB_TXN_NOSYNC">DB_TXN_NOSYNC</a></b><ul compact><li>Do not synchronously flush the log. This means the transaction will 54exhibit the ACI (atomicity, consistency, and isolation) properties, but 55not D (durability); that is, database integrity will be maintained, but 56it is possible that this transaction may be undone during recovery. 57<p>This behavior may be set for a Berkeley DB environment using the 58<a href="/api_c/env_set_flags.html">DB_ENV->set_flags</a> method or for a single transaction using the 59<a href="/api_c/txn_begin.html">DB_ENV->txn_begin</a> method. Any value specified to this method overrides 60both of those settings.</p></ul> 61<b><a name="DB_TXN_SYNC">DB_TXN_SYNC</a></b><ul compact><li>Synchronously flush the log. This means the transaction will exhibit 62all of the ACID (atomicity, consistency, isolation, and durability) 63properties. 64<p>This behavior is the default for Berkeley DB environments unless the 65<a href="/api_c/env_set_flags.html#DB_TXN_NOSYNC">DB_TXN_NOSYNC</a> flag was specified to the 66<a href="/api_c/env_set_flags.html">DB_ENV->set_flags</a> method. This behavior may also be set for a single 67transaction using the <a href="/api_c/txn_begin.html">DB_ENV->txn_begin</a> method. Any value specified to this 68method overrides both of those settings.</p></ul> 69<br></ul> 70<br> 71<hr size=1 noshade> 72<br><b>Class</b> 73<a href="/api_c/env_class.html">DB_ENV</a>, <a href="/api_c/txn_class.html">DB_TXN</a> 74<br><b>See Also</b> 75<a href="/api_c/txn_list.html">Transaction Subsystem and Related Methods</a> 76</tt> 77<table width="100%"><tr><td><br></td><td align=right> 78<a href="/api_c/api_core.html"><img src="/images/api.gif" alt="API"></a><a href="/ref/toc.html"><img src="/images/ref.gif" alt="Ref"></a> 79</td></tr></table> 80<p><font size=1>Copyright (c) 1996,2008 Oracle. All rights reserved.</font> 81</body> 82</html> 83