<!--$Id: db_set_flags.html,v 1.1 2003/02/15 04:55:50 zarzycki Exp $--> <!--Copyright 1997-2002 by Sleepycat Software, Inc.--> <!--All rights reserved.--> <!--See the file LICENSE for redistribution information.--> <html> <head> <title>Berkeley DB: Db.set_flags</title> <meta name="description" content="Berkeley DB: An embedded database programmatic toolkit."> <meta name="keywords" content="embedded,database,programmatic,toolkit,b+tree,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,java,C,C++"> </head> <body bgcolor=white> <a name="2"><!--meow--></a> <table width="100%"><tr valign=top> <td> <h1>Db.set_flags</h1> </td> <td align=right> <a href="../api_java/c_index.html"><img src="../images/api.gif" alt="API"></a><a href="../reftoc.html"><img src="../images/ref.gif" alt="Ref"></a> </td></tr></table> <hr size=1 noshade> <tt> <h3><pre> import com.sleepycat.db.*; <p> public void set_flags(int flags) throws DbException; </pre></h3> <h1>Description</h1> <p>Calling Db.set_flags is additive; there is no way to clear flags. <p>The <b>flags</b> value must be set to 0 or by bitwise inclusively <b>OR</b>'ing together one or more of the following values: <h3>General</h3> <p>The following flags may be specified for any Berkeley DB access method: <p><dl compact> <a name="3"><!--meow--></a> <p><dt><a name="Db.DB_CHKSUM_SHA1">Db.DB_CHKSUM_SHA1</a><dd>Do checksum verification of pages read into the cache from the backing filestore, using the SHA1 Secure Hash Algorithm. <p>Calling Db.set_flags with the Db.DB_CHKSUM_SHA1 flag only affects the specified <a href="../api_java/db_class.html">Db</a> handle (and any other Berkeley DB handles opened within the scope of that handle). <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_CHKSUM_SHA1 flag will be ignored. If creating additional databases in a file, the checksum behavior specified must be consistent with the existing databases in the file or an error will be returned. <a name="4"><!--meow--></a> <p><dt><a name="Db.DB_ENCRYPT">Db.DB_ENCRYPT</a><dd>Encrypt the database using the cryptographic password specified to the <a href="../api_java/env_set_encrypt.html">DbEnv.set_encrypt</a> or <a href="../api_java/db_set_encrypt.html">Db.set_encrypt</a> methods. <p>Calling Db.set_flags with the Db.DB_ENCRYPT flag only affects the specified <a href="../api_java/db_class.html">Db</a> handle (and any other Berkeley DB handles opened within the scope of that handle). <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_ENCRYPT flag must be the same as the existing database or an error will be returned. If creating additional databases in a file, the encryption behavior specified must be consistent with the existing databases in the file or an error will be returned. </dl> <h3>Btree</h3> <p>The following flags may be specified for the Btree access method: <p><dl compact> <a name="5"><!--meow--></a> <p><dt><a name="Db.DB_DUP">Db.DB_DUP</a><dd>Permit duplicate data items in the tree; that is, insertion when the key of the key/data pair being inserted already exists in the tree will be successful. The ordering of duplicates in the tree is determined by the order of insertion, unless the ordering is otherwise specified by use of a cursor operation. It is an error to specify both Db.DB_DUP and Db.DB_RECNUM. <p>Calling Db.set_flags with the Db.DB_DUP flag affects the database, including all threads of control accessing the database. <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_DUP flag must be the same as the existing database or an error will be returned. <a name="6"><!--meow--></a> <p><dt><a name="Db.DB_DUPSORT">Db.DB_DUPSORT</a><dd>Permit duplicate data items in the tree; that is, insertion when the key of the key/data pair being inserted already exists in the tree will be successful. The ordering of duplicates in the tree is determined by the duplicate comparison function. A default lexical comparison will be used. It is an error to specify both Db.DB_DUPSORT and Db.DB_RECNUM. <p>Calling Db.set_flags with the Db.DB_DUPSORT flag affects the database, including all threads of control accessing the database. <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_DUPSORT flag must be the same as the existing database or an error will be returned. <a name="7"><!--meow--></a> <p><dt><a name="Db.DB_RECNUM">Db.DB_RECNUM</a><dd>Support retrieval from the Btree using record numbers. For more information, see the <a href="../api_java/db_get.html#DB_SET_RECNO">Db.DB_SET_RECNO</a> flag to the <a href="../api_java/db_get.html">Db.get</a> and <a href="../api_java/dbc_get.html">Dbc.get</a> methods. <p>Logical record numbers in Btree databases are mutable in the face of record insertion or deletion. See the Db.DB_RENUMBER flag in the Recno access method information for further discussion. <p>Maintaining record counts within a Btree introduces a serious point of contention, namely the page locations where the record counts are stored. In addition, the entire tree must be locked during both insertions and deletions, effectively single-threading the tree for those operations. Specifying Db.DB_RECNUM can result in serious performance degradation for some applications and data sets. <p>It is an error to specify both Db.DB_DUP and Db.DB_RECNUM. <p>Calling Db.set_flags with the Db.DB_RECNUM flag affects the database, including all threads of control accessing the database. <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_RECNUM flag must be the same as the existing database or an error will be returned. <a name="8"><!--meow--></a><a name="9"><!--meow--></a> <p><dt><a name="Db.DB_REVSPLITOFF">Db.DB_REVSPLITOFF</a><dd>Turn off reverse splitting in the Btree. As pages are emptied in a database, the Berkeley DB Btree implementation attempts to coalesce empty pages into higher-level pages in order to keep the tree as small as possible and minimize tree search time. This can hurt performance in applications with cyclical data demands; that is, applications where the database grows and shrinks repeatedly. For example, because Berkeley DB does page-level locking, the maximum level of concurrency in a database of two pages is far smaller than that in a database of 100 pages, so a database that has shrunk to a minimal size can cause severe deadlocking when a new cycle of data insertion begins. <p>Calling Db.set_flags with the Db.DB_REVSPLITOFF flag only affects the specified <a href="../api_java/db_class.html">Db</a> handle (and any other Berkeley DB handles opened within the scope of that handle). </dl> <h3>Hash</h3> <p>The following flags may be specified for the Hash access method: <p><dl compact> <p><dt><a name="Db.DB_DUP">Db.DB_DUP</a><dd>Permit duplicate data items in the tree; that is, insertion when the key of the key/data pair being inserted already exists in the tree will be successful. The ordering of duplicates in the tree is determined by the order of insertion, unless the ordering is otherwise specified by use of a cursor operation. It is an error to specify both Db.DB_DUP and Db.DB_RECNUM. <p>Calling Db.set_flags with the Db.DB_DUP flag affects the database, including all threads of control accessing the database. <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_DUP flag must be the same as the existing database or an error will be returned. <p><dt><a name="Db.DB_DUPSORT">Db.DB_DUPSORT</a><dd>Permit duplicate data items in the tree; that is, insertion when the key of the key/data pair being inserted already exists in the tree will be successful. The ordering of duplicates in the tree is determined by the duplicate comparison function. A default lexical comparison will be used. It is an error to specify both Db.DB_DUPSORT and Db.DB_RECNUM. <p>Calling Db.set_flags with the Db.DB_DUPSORT flag affects the database, including all threads of control accessing the database. <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_DUPSORT flag must be the same as the existing database or an error will be returned. </dl> <h3>Queue</h3> <p>There are no additional flags that may be specified for the Queue access method. <h3>Recno</h3> <p>The following flags may be specified for the Recno access method: <p><dl compact> <a name="10"><!--meow--></a> <p><dt><a name="Db.DB_RENUMBER">Db.DB_RENUMBER</a><dd>Specifying the Db.DB_RENUMBER flag causes the logical record numbers to be mutable, and change as records are added to and deleted from the database. For example, the deletion of record number 4 causes records numbered 5 and greater to be renumbered downward by one. If a cursor was positioned to record number 4 before the deletion, it will refer to the new record number 4, if any such record exists, after the deletion. If a cursor was positioned after record number 4 before the deletion, it will be shifted downward one logical record, continuing to refer to the same record as it did before. <p>Using the <a href="../api_java/db_put.html">Db.put</a> or <a href="../api_java/dbc_put.html">Dbc.put</a> interfaces to create new records will cause the creation of multiple records if the record number is more than one greater than the largest record currently in the database. For example, creating record 28, when record 25 was previously the last record in the database, will create records 26 and 27 as well as 28. Attempts to retrieve records that were created in this manner will result in an error return of <a href="../ref/program/errorret.html#DB_KEYEMPTY">Db.DB_KEYEMPTY</a>. <p>If a created record is not at the end of the database, all records following the new record will be automatically renumbered upward by one. For example, the creation of a new record numbered 8 causes records numbered 8 and greater to be renumbered upward by one. If a cursor was positioned to record number 8 or greater before the insertion, it will be shifted upward one logical record, continuing to refer to the same record as it did before. <p>For these reasons, concurrent access to a Recno database with the Db.DB_RENUMBER flag specified may be largely meaningless, although it is supported. <p>Calling Db.set_flags with the Db.DB_RENUMBER flag affects the database, including all threads of control accessing the database. <p>If the database already exists when <a href="../api_java/db_open.html">Db.open</a> is called, the DB_RENUMBER flag must be the same as the existing database or an error will be returned. <a name="11"><!--meow--></a> <p><dt><a name="Db.DB_SNAPSHOT">Db.DB_SNAPSHOT</a><dd>This flag specifies that any specified <b>re_source</b> file be read in its entirety when <a href="../api_java/db_open.html">Db.open</a> is called. If this flag is not specified, the <b>re_source</b> file may be read lazily. <p>Calling Db.set_flags with the Db.DB_SNAPSHOT flag only affects the specified <a href="../api_java/db_class.html">Db</a> handle (and any other Berkeley DB handles opened within the scope of that handle). </dl> <p>The Db.set_flags interface may not be called after the <a href="../api_java/db_open.html">Db.open</a> interface is called. <p>The Db.set_flags method throws an exception that encapsulates a non-zero error value on failure. <h1>Errors</h1> <p>The Db.set_flags method may fail and throw an exception encapsulating a non-zero error for the following conditions: <p><dl compact> <p><dt>EINVAL<dd>An invalid flag value or parameter was specified. </dl> <p>The <a href="../api_java/db_set_bt_compare.html">Db.set_bt_compare</a> method may fail and throw an exception for errors specified for other Berkeley DB and C library or system methods. If a catastrophic error has occurred, the <a href="../api_java/db_set_bt_compare.html">Db.set_bt_compare</a> method may fail and throw a <a href="../api_java/runrec_class.html">DbRunRecoveryException</a>, in which case all subsequent Berkeley DB calls will fail in the same way. <h1>Class</h1> <a href="../api_java/db_class.html">Db</a> <h1>See Also</h1> <a href="../api_java/db_list.html">Databases and Related Methods</a> </tt> <table width="100%"><tr><td><br></td><td align=right> <a href="../api_java/c_index.html"><img src="../images/api.gif" alt="API"></a><a href="../reftoc.html"><img src="../images/ref.gif" alt="Ref"></a> </td></tr></table> <p><font size=1><a href="http://www.sleepycat.com">Copyright Sleepycat Software</a></font> </body> </html>