2
<!--Copyright 1997-2002 by Sleepycat Software, Inc.-->
3
<!--All rights reserved.-->
4
<!--See the file LICENSE for redistribution information.-->
7
<title>Berkeley DB: DB_TXN->commit</title>
8
<meta name="description" content="Berkeley DB: An embedded database programmatic toolkit.">
9
<meta name="keywords" content="embedded,database,programmatic,toolkit,b+tree,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,java,C,C++">
12
<a name="2"><!--meow--></a>
13
<table width="100%"><tr valign=top>
15
<h1>DB_TXN->commit</h1>
18
<a href="../api_c/c_index.html"><img src="../images/api.gif" alt="API"></a><a href="../reftoc.html"><img src="../images/ref.gif" alt="Ref"></a>
26
DB_TXN->commit(DB_TXN *tid, u_int32_t flags);
29
<p>The DB_TXN->commit method ends the transaction.
30
<p>In the case of nested transactions, if the transaction is a parent
31
transaction, committing the parent transaction causes all unresolved
32
children of the parent to be committed. In the case of nested
33
transactions, if the transaction is a child transaction, its locks are
34
not released, but are acquired by its parent. Although the commit of the
35
child transaction will succeed, the actual resolution of the child
36
transaction is postponed until the parent transaction is committed or
37
aborted; that is, if its parent transaction commits, it will be
38
committed; and if its parent transaction aborts, it will be aborted.
39
<p>The <b>flags</b> value must be set to 0 or
40
one of the following values:
42
<p><dt><a name="DB_TXN_NOSYNC">DB_TXN_NOSYNC</a><dd>Do not synchronously flush the log. This means the transaction will
43
exhibit the ACI (atomicity, consistency, and isolation) properties, but
44
not D (durability); that is, database integrity will be maintained, but
45
it is possible that this transaction may be undone during recovery.
46
<p>This behavior may be set for a Berkeley DB environment using the
47
<a href="../api_c/env_set_flags.html">DB_ENV->set_flags</a> interface or for a single transaction using the
48
<a href="../api_c/txn_begin.html">DB_ENV->txn_begin</a> interface. Any value specified in this interface
49
overrides both of those settings.
50
<p><dt><a name="DB_TXN_SYNC">DB_TXN_SYNC</a><dd>Synchronously flush the log. This means the transaction will exhibit
51
all of the ACID (atomicity, consistency, isolation, and durability)
53
<p>This behavior is the default for Berkeley DB environments unless the
54
<a href="../api_c/env_set_flags.html#DB_TXN_NOSYNC">DB_TXN_NOSYNC</a> flag was specified to the <a href="../api_c/env_set_flags.html">DB_ENV->set_flags</a>
55
interface. This behavior may also be set for a single transaction using
56
the <a href="../api_c/txn_begin.html">DB_ENV->txn_begin</a> interface. Any value specified in this interface
57
overrides both of those settings.
59
<p>All cursors opened within the transaction must be closed before the
60
transaction is committed.
61
<p>After DB_TXN->commit has been called, regardless of its return, the
62
<a href="../api_c/txn_class.html">DB_TXN</a> handle may not be accessed again. If DB_TXN->commit
63
encounters an error, the transaction and all child transactions of the
64
transaction are aborted.
65
<p>The DB_TXN->commit method returns a non-zero error value on failure and 0 on success.
67
<p>The DB_TXN->commit method may fail and return a non-zero error for errors specified for other Berkeley DB and C library or system functions.
68
If a catastrophic error has occurred, the DB_TXN->commit method may fail and
69
return <a href="../ref/program/errorret.html#DB_RUNRECOVERY">DB_RUNRECOVERY</a>,
70
in which case all subsequent Berkeley DB calls will fail in the same way.
72
<a href="../api_c/env_class.html">DB_ENV</a>, <a href="../api_c/txn_class.html">DB_TXN</a>
74
<a href="../api_c/txn_list.html">Transaction Subsystem and Related Methods</a>
76
<table width="100%"><tr><td><br></td><td align=right>
77
<a href="../api_c/c_index.html"><img src="../images/api.gif" alt="API"></a><a href="../reftoc.html"><img src="../images/ref.gif" alt="Ref"></a>
79
<p><font size=1><a href="http://www.sleepycat.com">Copyright Sleepycat Software</a></font>