public Class SysProperties

System property h2.allowedClasses (default: *). Comma separated list of class names or prefixes.

System property h2.authConfigFile (default: null). authConfigFile define the URL of configuration file of org.h2.security.auth.DefaultAuthenticator

System property h2.bindAddress (default: null). The bind address to use.

System property h2.check (default: true for JDK/JRE, false for Android). Optional additional checks in the database engine.

System property h2.clientTraceDirectory (default: trace.db/). Directory where the trace files of the JDBC client are stored (only for client / server).

System property h2.collatorCacheSize (default: 3 2000). The cache size for collation keys (in elements). Used when a collator has been set for the database.

System property h2.consoleProcedureColumns (default: 500). Up to this many procedures, the column names are listed.

System property h2.consoleTableColumns (default: 500). Up to this many tables, the column names are listed.

System property h2.consoleTableIndexes (default: 100). Up to this many tables, the column type and indexes are listed.

System property h2.consoleStream (default: true). H2 Console: stream query results.

System property h2.consoleTimeout (default: 1800000). H2 Console: session timeout in milliseconds. The default is 30 minutes.

System property h2.dataSourceTraceLevel (default: 1). The trace level of the data source implementation. Default is 1 for error.

System property h2.delayWrongPasswordMax (default: 4000). The maximum delay in milliseconds before an exception is thrown for using the wrong user name or password. This slows down brute force attacks. The delay is reset after a successful login. The value 0 means there is no maximum delay.

System property h2.delayWrongPasswordMin (default: 250). The minimum delay in milliseconds before an exception is thrown for using the wrong user name or password. This slows down brute force attacks. The delay is reset to this value after a successful login. Unsuccessful logins will double the time until DELAY_WRONG_PASSWORD_MAX. To disable the delay, set this system property to 0.

System property h2.forceAutoCommitOffOnCommit (default: false). Throw error if transaction's auto-commit property is true when a commit is executed.

INTERNAL

INTERNAL

System property h2.javaObjectSerializer (default: null). The JavaObjectSerializer class name for java objects being stored in column of type OTHER. It must be the same on client and server to work correctly.

System property h2.javaSystemCompiler (default: true). Whether to use the Java system compiler (ToolProvider.getSystemJavaCompiler()) if it is available to compile user defined functions. If disabled or if the system compiler is not available, the com.sun.tools.javac compiler is used if available, and "javac" (as an external process) is used if not.

System property h2.lobClientMaxSizeMemory (default: 1048576). The maximum size of a LOB object to keep in memory on the client side when using the server mode.

System property h2.lobCloseBetweenReads (default: false). Close LOB files between read operations.

System property h2.maxFileRetry (default: 16). Number of times to retry file delete and rename. in Windows, files can't be deleted if they are open. Waiting a bit can help (sometimes the Windows Explorer opens the files for a short time) may help. Sometimes, running garbage collection may close files if the user forgot to call Connection.close() or InputStream.close().

System property h2.maxMemoryRows (default: 40000 per GB of available RAM). The default maximum number of rows to be kept in memory in a result set.

System property h2.maxReconnect (default: 3). The maximum number of tries to reconnect in a row.

System property h2.maxTraceDataLength (default: 65535). The maximum size of a LOB value that is written as data to the trace system.

System property h2.nioCleanerHack (default: false). If enabled, use the reflection hack to un-map the mapped file if possible. If disabled, System.gc() is called in a loop until the object is garbage collected. See also https://bugs.openjdk.java.net/browse/JDK-4724038

System property h2.nioLoadMapped (default: false). If the mapped buffer should be loaded when the file is opened. This can improve performance.

System property h2.objectCache (default: true). Cache commonly used values (numbers, strings). There is a shared cache for all values.

System property h2.objectCacheMaxPerElementSize (default: 4096). The maximum size (precision) of an object in the cache.

System property h2.objectCacheSize (default: 1024). The maximum number of objects in the cache. This value must be a power of 2.

System property h2.pgClientEncoding (default: UTF-8). Default client encoding for PG server. It is used if the client does not sends his encoding.

System property h2.prefixTempFile (default: h2.temp). The prefix for temporary files in the temp directory.

System property h2.serverCachedObjects (default: 64). TCP Server: number of cached objects per session.

System property h2.serverResultSetFetchSize (default: 100). The default result set fetch size when using the server mode.

System property h2.socketConnectRetry (default: 16). The number of times to retry opening a socket. Windows sometimes fails to open a socket, see bug https://bugs.openjdk.java.net/browse/JDK-6213296

System property h2.socketConnectTimeout (default: 2000). The timeout in milliseconds to connect to a server.

System property h2.splitFileSizeShift (default: 30). The maximum file size of a split file is 1L << x.

System property h2.threadDeadlockDetector (default: false). Detect thread deadlocks in a background thread.

System property h2.traceIO (default: false). Trace all I/O operations.

System property h2.urlMap (default: null). A properties file that contains a mapping between database URLs. New connections are written into the file. An empty value in the map means no redirection is used for the given URL.

System property h2.useThreadContextClassLoader (default: false). Instead of using the default class loader when deserializing objects, the current thread-context class loader will be used.

System property user.home (empty string if not set). It is usually set by the system, and used as a replacement for ~ in file names.

INTERNAL

Returns:String

base directory

System property h2.scriptDirectory (default: empty string). Relative or absolute directory where the script files are stored to or read from.

Returns:String

the current value

INTERNAL

Parameters

dir:String

base directory