Field Summary |
|
final public static boolean | ALIAS_COLUMN_NAME System property h2.aliasColumnName (default: false).
When enabled, aliased columns (as in SELECT ID AS I FROM TEST) return the
real table and column name in ResultSetMetaData.getTableName() and
getColumnName(). |
final public static String | ALLOWED_CLASSES System property h2.allowedClasses (default: *).
Comma separated list of class names or prefixes. |
final public static boolean | ALLOW_BIG_DECIMAL_EXTENSIONS System property h2.allowBigDecimalExtensions (default:
false).
When enabled, classes that extend BigDecimal are supported in
PreparedStatement.setBigDecimal. |
final public static String | BIND_ADDRESS System property h2.bindAddress (default: *).
Comma separated list of class names or prefixes. |
final public static int | CACHE_SIZE_DEFAULT System property h2.cacheSizeDefault (default: 16384).
The default cache size in KB. |
final public static int | CACHE_SIZE_INDEX_DEFAULT |
final public static int | CACHE_SIZE_INDEX_SHIFT System property h2.cacheSizeIndexShift (default: 3).
How many time the cache size value is divided by two to get the index
cache size. |
final public static boolean | CHECK System property h2.check (default: true).
Assertions in the database engine. |
final public static boolean | CHECK2 System property h2.check2 (default: true).
Additional assertions in the database engine. |
final public static String | CLIENT_TRACE_DIRECTORY System property h2.clientTraceDirectory (default:
trace.db/).
Directory where the trace files of the JDBC client are stored (only for
client / server). |
final public static int | COLLATOR_CACHE_SIZE System property h2.collatorCacheSize (default: 10000).
The cache size for collation keys (in elements). |
final public static int | DATASOURCE_TRACE_LEVEL System property h2.dataSourceTraceLevel (default: 1).
The trace level of the data source implementation. |
final public static int | DEFAULT_LOCK_MODE System property h2.defaultLockMode (default: 3).
The default value for the LOCK_MODE setting. |
final public static int | DEFAULT_MAX_MEMORY_UNDO System property h2.defaultMaxMemoryUndo (default: 100000).
The default value for the MAX_MEMORY_UNDO setting. |
final public static int | DEFAULT_MAX_OPERATION_MEMORY System property h2.defaultMaxOperationMemory (default:
100000).
The default for the setting MAX_OPERATION_MEMORY. |
final public static int | EMERGENCY_SPACE_INITIAL System property h2.emergencySpaceInitial (default: 262144).
Size of 'reserve' file to detect disk full problems early. |
final public static int | EMERGENCY_SPACE_MIN System property h2.emergencySpaceMin (default: 65536).
Minimum size of 'reserve' file. |
final public static String | FILE_ENCODING System property file.encoding (default: Cp1252).
It is usually set by the system and is the default encoding used for the
RunScript and CSV tool. |
final public static String | FILE_SEPARATOR System property file.separator (default: /).
It is usually set by the system, and used to build absolute file names. |
final public static String | H2_COLLATOR_CACHE_SIZE |
final public static String | H2_LOG_DELETE_DELAY |
final public static String | H2_MAX_QUERY_TIMEOUT |
final public static int | LARGE_RESULT_BUFFER_SIZE System property h2.largeResultBufferSize (default: 4096).
Buffer size for large result sets. |
final public static String | LINE_SEPARATOR System property line.separator (default: \n).
It is usually set by the system, and used by the script and trace tools. |
final public static boolean | LOB_FILES_IN_DIRECTORIES System property h2.lobFilesInDirectories (default: false).
Store LOB files in subdirectories. |
final public static int | LOB_FILES_PER_DIRECTORY System property h2.lobFilesPerDirectory (default: 256).
Maximum number of LOB files per directory. |
final public static boolean | LOG_ALL_ERRORS System property h2.logAllErrors (default: false).
Write stack traces of any kind of error to a file. |
final public static String | LOG_ALL_ERRORS_FILE System property h2.logAllErrorsFile (default:
h2errors.txt).
File name to log errors. |
final public static int | MAX_FILE_RETRY System property h2.maxFileRetry (default: 16).
Number of times to retry file delete and rename. |
final public static int | MAX_MEMORY_ROWS_DISTINCT System property h2.maxMemoryRowsDistinct (default:
Integer.MAX_VALUE).
The maximum number of rows kept in-memory for SELECT DISTINCT queries. |
final public static int | MAX_QUERY_TIMEOUT System property h2.maxQueryTimeout (default: 0).
The maximum timeout of a query. |
final public static int | MIN_COLUMN_NAME_MAP System property h2.minColumnNameMap (default: 3).
The minimum number of columns where a hash table is created when result set
methods with column name (instead of column index) parameter are called. |
final public static int | MIN_WRITE_DELAY System property h2.minWriteDelay (default: 5).
The minimum write delay that causes commits to be delayed. |
final public static boolean | OBJECT_CACHE System property h2.objectCache (default: true).
Cache commonly used objects (integers, strings). |
final public static int | OBJECT_CACHE_MAX_PER_ELEMENT_SIZE System property h2.objectCacheMaxPerElementSize (default:
4096).
Maximum size of an object in the cache. |
final public static int | OBJECT_CACHE_SIZE System property h2.objectCacheSize (default: 1024).
Maximum size of an object in the cache. |
final public static boolean | OPTIMIZE_DISTINCT System property h2.optimizeDistinct (default: true).
Improve the performance of simple DISTINCT queries if an index is
available for the given column. |
final public static boolean | OPTIMIZE_DROP_DEPENDENCIES System property h2.optimizeDropDependencies (default:
true).
Improve the performance of DROP and DROP ALL OBJECTS by quicker scanning
if other objects depend on this object. |
final public static boolean | OPTIMIZE_EVALUATABLE_SUBQUERIES System property h2.optimizeEvaluatableSubqueries (default:
true).
Optimize subqueries that are not dependent on the outer query. |
final public static boolean | OPTIMIZE_GROUP_SORTED System property h2.optimizeGroupSorted (default: false).
Optimize GROUP BY queries if an index can be used that matches the group
by columns. |
final public static boolean | OPTIMIZE_IN System property h2.optimizeIn (default: true).
Optimize IN(...) comparisons. |
final public static boolean | OPTIMIZE_IN_JOIN System property h2.optimizeInJoin (default: false).
Optimize IN(...) comparisons by converting them to inner joins. |
final public static boolean | OPTIMIZE_MIN_MAX System property h2.optimizeMinMax (default: true).
Optimize MIN and MAX aggregate functions. |
final public static boolean | OPTIMIZE_NOT System property h2.optimizeNot (default: true).
Optimize NOT conditions by removing the NOT and inverting the condition. |
final public static boolean | OPTIMIZE_SUBQUERY_CACHE System property h2.optimizeSubqueryCache (default: true).
Cache subquery results. |
final public static boolean | OPTIMIZE_TWO_EQUALS System property h2.optimizeTwoEquals (default: true).
Optimize expressions of the form A=B AND B=1. |
final public static boolean | OVERFLOW_EXCEPTIONS System property h2.overflowExceptions (default: true).
Throw an exception on integer overflows. |
final public static boolean | RECOMPILE_ALWAYS System property h2.recompileAlways (default: false).
Always recompile prepared statements. |
final public static int | REDO_BUFFER_SIZE System property h2.redoBufferSize (default: 262144).
Size of the redo buffer (used at startup when recovering). |
final public static int | REUSE_SPACE_AFTER System property h2.reuseSpaceAfter (default: 16).
Reuse space in database files after this many pages are free. |
final public static boolean | REUSE_SPACE_QUICKLY System property h2.reuseSpaceQuickly (default: true).
Reuse space in database files quickly. |
final public static int | SERVER_CACHED_OBJECTS System property h2.serverCachedObjects (default: 64).
TCP Server: number of cached objects per session. |
final public static int | SERVER_RESULT_SET_FETCH_SIZE System property h2.serverResultSetFetchSize (default: 100).
The default result set fetch size when using the server mode. |
final public static boolean | TRACE_IO System property h2.traceIO (default: false).
Trace all I/O operations. |
final public static String | USER_HOME System property user.home (default: empty string).
It is usually set by the system, and used as a replacement for ~ in file
names. |
public static boolean | lobCloseBetweenReads System property h2.lobCloseBetweenReads (default: false).
Close LOB files between read operations. |
public static boolean | runFinalize System property h2.runFinalize (default: true).
Run finalizers to detect unclosed connections. |
public static String | scriptDirectory System property h2.scriptDirectory (default: empty
string).
Relative or absolute directory where the script files are stored to or
read from. |