ConstantsConstants are fixed values that are used in the whole database code.
SUFFIX_DB_FILE = ".db"The file name suffix of all database files.
SUFFIX_PAGE_FILE = ".h2.db"The file name suffix of page files.
SERVER_PROPERTIES_NAME = ".h2.server.properties"The name of the server properties file for the H2 Console.
SUFFIX_LOB_FILE = ".lob.db"The file name suffix of large object files.
SUFFIX_LOBS_DIRECTORY = ".lobs.db"The suffix of the directory name used if LOB objects are stored in a
directory.
SUFFIX_LOCK_FILE = ".lock.db"The file name suffix of file lock files that are used to make sure a
database is open by only one process at any time.
SUFFIX_MV_FILE = ".mv.db"The file name suffix of a MVStore file.
SUFFIX_TEMP_FILE = ".temp.db"The file name suffix of temporary files.
SUFFIX_TRACE_FILE = ".trace.db"The file name suffix of trace files.
BUILD_DATE_STABLE = "2014-01-18"The build date is updated for each public release.
BUILD_DATE = "2014-04-05"The build date is updated for each public release.
PREFIX_INDEX = "INDEX_"The name prefix used for indexes that are not explicitly named.
CACHE_TYPE_DEFAULT = "LRU"The default cache type.
PREFIX_PRIMARY_KEY = "PRIMARY_KEY_"The name prefix used for primary key constraints that are not explicitly
named.
PUBLIC_ROLE_NAME = "PUBLIC"Every user belongs to this role.
SCHEMA_MAIN = "PUBLIC"The name of the default schema.
PREFIX_JOIN = "SYSTEM_JOIN_"The name prefix used for synthetic nested join tables.
CLUSTERING_ENABLED = "TRUE"The value of the cluster setting if clustering is enabled (the actual
value is checked later).
CLUSTERING_DISABLED = "\'\'"The value of the cluster setting if clustering is disabled.
CONN_URL_COLUMNLIST = "jdbc:columnlist:connection"The database URL used when calling a function if only the column list
should be returned.
CONN_URL_INTERNAL = "jdbc:default:connection"The database URL used when calling a function if the data should be
returned.
START_URL = "jdbc:h2:"The database URL prefix of this database.
URL_FORMAT = "jdbc:h2:{ {.|mem:}[name] | [file:]fileName | {tcp|ssl}:[//]server[:port][,server2[:port]]/name }[;key=value...]"The database URL format in simplified Backus-Naur form.
USER_PACKAGE = "org.h2.dynamic"The package name of user defined classes.
SERVER_PROPERTIES_DIR = "~"The default directory name of the server properties file for the H2
Console.
ALLOW_LITERALS_NONE = 0Constant meaning no literals are allowed in SQL statements.
LOCK_MODE_OFF = 0The lock mode that means no locking is used at all.
ALLOW_LITERALS_NUMBERS = 1Constant meaning only numbers are allowed in SQL statements (but no
texts).
LOCK_MODE_TABLE = 1The lock mode that means table level locking is used for reads and
writes.
VERSION_MAJOR = 1The major version of this database.
TCP_PROTOCOL_VERSION_10 = 10The TCP protocol version number 10.
DEADLOCK_CHECK = 100The number of milliseconds after which to check for a deadlock if locking
is not successful.
COST_ROW_OFFSET = 1000The cost is calculated on rowcount + this offset,
to avoid using the wrong or no index if the table
contains no rows _currently_ (when preparing the statement)
LOCK_SLEEP = 1000The number of milliseconds to wait between checking the .lock.db file
still exists once a database is locked.
DEFAULT_MAX_MEMORY_ROWS = 10000The default maximum number of rows to be kept in memory in a result set.
SELECTIVITY_DISTINCT_COUNT = 10000The number of distinct values to keep in memory when running ANALYZE.
VIEW_COST_CACHE_MAX_AGE = 10000The maximum time in milliseconds to keep the cost of a view.
10000 means 10 seconds.
DEFAULT_MAX_OPERATION_MEMORY = 100000The default for the setting MAX_OPERATION_MEMORY.
MAX_PARAMETER_INDEX = 100000The highest possible parameter index.
DEFAULT_RESULT_SET_CONCURRENCY = 1007The default result set concurrency for statements created with
Connection.createStatement() or prepareStatement(String sql).
SLOW_QUERY_LIMIT_MS = 100LQueries that take longer than this number of milliseconds are written to
the trace file with the level info.
ENCRYPTION_KEY_HASH_ITERATIONS = 1024The password is hashed this many times
to slow down dictionary attacks.
UNDO_BLOCK_SIZE = 1048576The maximum size of an undo log block.
TCP_PROTOCOL_VERSION_11 = 11The TCP protocol version number 11.
TCP_PROTOCOL_VERSION_12 = 12The TCP protocol version number 12.
MEMORY_PAGE_DATA_OVERFLOW = 120The memory needed by an object of class PageDataOverflow.
DEFAULT_MAX_LENGTH_INPLACE_LOB = 128The default maximum length of an LOB that is stored with the record
itself, and not in a separate place.
TCP_PROTOCOL_VERSION_13 = 13The TCP protocol version number 13.
IO_BUFFER_SIZE_COMPRESS = 131072The block size used to compress data in the LZFOutputStream.
TCP_PROTOCOL_VERSION_14 = 14The TCP protocol version number 14.
CACHE_MIN_RECORDS = 16The minimum number of entries to keep in the cache.
FILE_BLOCK_SIZE = 16The block of a file. It is also the encryption block size.
CACHE_SIZE_DEFAULT = 16384The default cache size in KB.
DEFAULT_MAX_LOG_SIZE = 16777216LThe default value for the maximum transaction log size.
BUILD_ID_STABLE = 175The build id of the last stable release.
BUILD_ID = 176The build id is incremented for each public release.
MEMORY_PAGE_BTREE = 184The memory needed by an object of class PageBtree.
ALLOW_LITERALS_ALL = 2Constant meaning both numbers and text is allowed in SQL statements.
LOCK_MODE_TABLE_GC = 2The lock mode that means table level locking is used for reads and
writes. If a table is locked, System.gc is called to close forgotten
connections.
INITIAL_LOCK_TIMEOUT = 2000For testing, the lock timeout is smaller than for interactive use cases.
This value could be increased to about 5 or 10 seconds.
DEFAULT_PAGE_SIZE = 2048The default page size to use for new databases.
MEMORY_DATA = 24The memory needed by a object of class Data
MEMORY_OBJECT = 24The memory needed by a regular object with at least one field.
MEMORY_PAGE_DATA = 240The memory needed by an object of class PageData.
DEFAULT_LOCK_MODE = 3The default value for the LOCK_MODE setting.
LOCK_MODE_READ_COMMITTED = 3The lock mode that means read locks are acquired, but they are released
immediately after the statement is executed.
VERSION_MINOR = 3The minor version of this database.
MEMORY_ROW = 40The memory needed by a Row.
IO_BUFFER_SIZE = 4096The block size for I/O operations.
MIN_WRITE_DELAY = 5The minimum write delay that causes commits to be delayed.
SELECTIVITY_DEFAULT = 50The default selectivity (used if the selectivity is not calculated).
THROTTLE_DELAY = 50The delay that is to be used if throttle has been enabled.
DEFAULT_WRITE_DELAY = 500The default delay in milliseconds before the transaction log is written.
DEFAULT_MAX_MEMORY_UNDO = 50000The default value for the MAX_MEMORY_UNDO setting.
TCP_PROTOCOL_VERSION_6 = 6The TCP protocol version number 6.
MEMORY_FACTOR = 64This value is used to calculate the average memory usage.
VIEW_INDEX_CACHE_SIZE = 64The name of the index cache that is used for temporary view (subqueries
used as tables).
TCP_PROTOCOL_VERSION_7 = 7The TCP protocol version number 7.
MEMORY_POINTER = 8The memory needed by a pointer.
SALT_LEN = 8The number of bytes in random salt that is used to hash passwords.
TCP_PROTOCOL_VERSION_8 = 8The TCP protocol version number 8.
DEFAULT_HTTP_PORT = 8082The default port number of the HTTP server (for the H2 Console).
This value is also in the documentation and in the Server javadoc.
TCP_PROTOCOL_VERSION_9 = 9The TCP protocol version number 9.
DEFAULT_TCP_PORT = 9092The default port of the TCP server.
This port is also used in the documentation and in the Server javadoc.
BUILD_VENDOR_AND_VERSIONIf H2 is compiled to be included in a product, this should be set to
a unique vendor id (to distinguish from official releases).
Additionally, a version number should be set to distinguish releases.
Example: ACME_SVN1651_BUILD3
UTF8Name of the character encoding format.
BLOB_SEARCH = falseWhether searching in Blob values should be supported.
BUILD_SNAPSHOT = falseWhether this is a snapshot version.
|