public Class Constants

Constant meaning both numbers and text is allowed in SQL statements.

Constant meaning no literals are allowed in SQL statements.

Constant meaning only numbers are allowed in SQL statements (but no texts).

Whether searching in Blob values should be supported.

The build date is updated for each public release.

Sequential version number. Even numbers are used for official releases, odd numbers are used for development builds.

Whether this is a snapshot version.

If 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

The minimum number of entries to keep in the cache.

The default cache type.

The value of the cluster setting if clustering is disabled.

The value of the cluster setting if clustering is enabled (the actual value is checked later).

The database URL used when calling a function if only the column list should be returned.

The database URL used when calling a function if the data should be returned.

The 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)

The number of milliseconds after which to check for a deadlock if locking is not successful.

The default port number of the HTTP server (for the H2 Console). This value is also in the documentation and in the Server javadoc.

The default value for the LOCK_MODE setting.

The default maximum length of an LOB that is stored with the record itself, and not in a separate place.

The default for the setting MAX_OPERATION_MEMORY.

The default page size to use for new databases.

The default result set concurrency for statements created with Connection.createStatement() or prepareStatement(String sql).

The default port of the TCP server. This port is also used in the documentation and in the Server javadoc.

The default delay in milliseconds before the transaction log is written.

The password is hashed this many times to slow down dictionary attacks.

The block of a file. It is also the encryption block size.

The complete version number of this database, consisting of the major version, the minor version, the build id, and the build date.

The identity of INFORMATION_SCHEMA.

For testing, the lock timeout is smaller than for interactive use cases. This value could be increased to about 5 or 10 seconds.

The block size for I/O operations.

The block size used to compress data in the LZFOutputStream.

The lock mode that means no locking is used at all.

The lock mode that means read locks are acquired, but they are released immediately after the statement is executed.

The lock mode that means table level locking is used for reads and writes.

The 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.

The number of milliseconds to wait between checking the .lock.db file still exists once a database is locked.

The identity of PUBLIC schema.

The maximum allowed cardinality of array.

The maximum number of columns in a table, select statement or row value.

The maximum allowed length of identifiers.

The maximum allowed precision of numeric data types.

The highest possible parameter index.

The maximum allowed length for character string, binary string, and other data types based on them; excluding LOB data types.

This needs to be less than (2^31-8)/2 to avoid running into the limit on encoding data fields when storing rows.

The memory needed by an array.

The memory needed by a regular object with at least one field.

The memory needed by a pointer.

The memory needed by a Row.

The minimum number of characters in web admin password.

The identity of pg_catalog schema.

Announced version for PgServer.

The name prefix used for indexes that are not explicitly named.

The name prefix used for synthetic nested join tables.

The name prefix used for primary key constraints that are not explicitly named.

The name prefix used for query aliases that are not explicitly named.

Every user belongs to this role.

The maximum number of entries in query statistics.

The number of bytes in random salt that is used to hash passwords.

The name of the default schema.

The name of the pg_catalog schema.

The default selectivity (used if the selectivity is not calculated).

The number of distinct values to keep in memory when running ANALYZE.

The default directory name of the server properties file for the H2 Console.

The name of the server properties file for the H2 Console.

Queries that take longer than this number of milliseconds are written to the trace file with the level info.

The database URL prefix of this database.

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.

The file name suffix of a MVStore file.

The file name suffix of a new MVStore file, used when compacting a store.

The file name suffix of a temporary MVStore file, used when compacting a store.

The file name suffix of a H2 version 1.1 database file.

The file name suffix of temporary files.

The file name suffix of trace files.

The TCP protocol version number 17.

Since

1.4.197 (2018-03-18)

The TCP protocol version number 18.

Since

1.4.198 (2019-02-22)

The TCP protocol version number 19.

Since

1.4.200 (2019-10-14)

The TCP protocol version number 20.

Since

2.0.202 (2021-11-25)

The TCP protocol version number 21.

Since

2.3.230 (TODO)

Maximum supported version of TCP protocol.

Minimum supported version of TCP protocol.

How often we check to see if we need to apply a throttling delay if SET THROTTLE has been used.

SNAPSHOT isolation level of transaction.

The database URL format in simplified Backus-Naur form.

The package name of user defined classes.

The version of this product, consisting of major version, minor version, and build id.

The major version of this database.

The minor version of this database.

The maximum time in milliseconds to keep the cost of a view. 10000 means 10 seconds.

The name of the index cache that is used for temporary view (subqueries used as tables).