public class SysProperties extends Object
System properties can be set when starting the virtual machine:
java -Dh2.baseDir=/tempThey can be set within the application, but this must be done before loading any classes of this database (before loading the JDBC driver):
System.setProperty("h2.baseDir", "/temp");
Modifier and Type | Field and Description |
---|---|
static boolean |
ALLOW_BIG_DECIMAL_EXTENSIONS
System property
h2.allowBigDecimalExtensions (default:
false).When enabled, classes that extend BigDecimal are supported in PreparedStatement.setBigDecimal. |
static String |
ALLOWED_CLASSES
System property
h2.allowedClasses (default: *).Comma separated list of class names or prefixes. |
static String |
BIND_ADDRESS
System property
h2.bindAddress (default: null).The bind address to use. |
static String |
BROWSER
System property
h2.browser (default: null).The preferred browser to use. |
static boolean |
CHECK
System property
h2.check (default: true).Assertions in the database engine. |
static boolean |
CHECK2
System property
h2.check2 (default: true).Additional assertions in the database engine. |
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). |
static int |
COLLATOR_CACHE_SIZE
System property
h2.collatorCacheSize (default: 32000).The cache size for collation keys (in elements). |
static boolean |
CONSOLE_STREAM
System property
h2.consoleStream (default: true).H2 Console: stream query results. |
static int |
DATASOURCE_TRACE_LEVEL
System property
h2.dataSourceTraceLevel (default: 1).The trace level of the data source implementation. |
static int |
DELAY_WRONG_PASSWORD_MAX
System property
h2.delayWrongPasswordMax (default: 4000).The maximum delay in milliseconds before an exception is thrown for using the wrong user name or password. |
static int |
DELAY_WRONG_PASSWORD_MIN
System property
h2.delayWrongPasswordMin (default: 250).The minimum delay in milliseconds before an exception is thrown for using the wrong user name or password. |
static boolean |
EMPTY_PASSWORD
System property
h2.emptyPassword (default: true).Don't use a secure hash if the user name and password are empty or not set. |
static boolean |
ENABLE_ANONYMOUS_SSL
System property
h2.enableAnonymousSSL (default: true).When using SSL connection, the anonymous cipher suite SSL_DH_anon_WITH_RC4_128_MD5 should be enabled. |
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. |
static String |
FILE_SEPARATOR
System property
file.separator (default: /).It is usually set by the system, and used to build absolute file names. |
static String |
H2_BROWSER
INTERNAL
|
static String |
H2_SCRIPT_DIRECTORY
INTERNAL
|
static String |
JAVA_SPECIFICATION_VERSION
System property
java.specification.version .It is set by the system. |
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. |
static int |
LOB_CLIENT_MAX_SIZE_MEMORY
System property
h2.lobClientMaxSizeMemory (default: 65536).The maximum size of a LOB object to keep in memory on the client side when using the server mode. |
static int |
LOB_FILES_PER_DIRECTORY
System property
h2.lobFilesPerDirectory (default: 256).Maximum number of LOB files per directory. |
static boolean |
LOB_IN_DATABASE
System property
h2.lobInDatabase (default: false).Store LOB files in the database. |
static boolean |
lobCloseBetweenReads
System property
h2.lobCloseBetweenReads (default: false).Close LOB files between read operations. |
static int |
MAX_FILE_RETRY
System property
h2.maxFileRetry (default: 16).Number of times to retry file delete and rename. |
static int |
MAX_RECONNECT
System property
h2.maxReconnect (default: 3).The maximum number of tries to reconnect in a row. |
static long |
MAX_TRACE_DATA_LENGTH
System property
h2.maxTraceDataLength (default: 65535).The maximum size of a LOB value that is written as data to the trace system. |
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. |
static boolean |
NIO_CLEANER_HACK
System property
h2.nioCleanerHack (default: false).If enabled, use the reflection hack to un-map the mapped file if possible. |
static boolean |
NIO_LOAD_MAPPED
System property
h2.nioLoadMapped (default: false).If the mapped buffer should be loaded when the file is opened. |
static boolean |
OBJECT_CACHE
System property
h2.objectCache (default: true).Cache commonly used values (numbers, strings). |
static int |
OBJECT_CACHE_MAX_PER_ELEMENT_SIZE
System property
h2.objectCacheMaxPerElementSize (default:
4096).The maximum size (precision) of an object in the cache. |
static int |
OBJECT_CACHE_SIZE
System property
h2.objectCacheSize (default: 1024).The maximum number of objects in the cache. |
static String |
PG_DEFAULT_CLIENT_ENCODING
System property
h2.pgClientEncoding (default: UTF-8).Default client encoding for PG server. |
static String |
PREFIX_TEMP_FILE
System property
h2.prefixTempFile (default: h2.temp).The prefix for temporary files in the temp directory. |
static boolean |
RETURN_LOB_OBJECTS
System property
h2.returnLobObjects (default: true).When true, ResultSet.getObject for CLOB or BLOB will return a java.sql.Clob / java.sql.Blob object. |
static boolean |
runFinalize
System property
h2.runFinalize (default: true).Run finalizers to detect unclosed connections. |
static int |
SERVER_CACHED_OBJECTS
System property
h2.serverCachedObjects (default: 64).TCP Server: number of cached objects per session. |
static int |
SERVER_RESULT_SET_FETCH_SIZE
System property
h2.serverResultSetFetchSize
(default: 100).The default result set fetch size when using the server mode. |
static int |
SOCKET_CONNECT_RETRY
System property
h2.socketConnectRetry (default: 16).The number of times to retry opening a socket. |
static int |
SOCKET_CONNECT_TIMEOUT
System property
h2.socketConnectTimeout (default: 2000).The timeout in milliseconds to connect to a server. |
static boolean |
SORT_NULLS_HIGH
System property
h2.sortNullsHigh (default: false).Invert the default sorting behavior for NULL, such that NULL is at the end of a result set in an ascending sort and at the beginning of a result set in a descending sort. |
static long |
SPLIT_FILE_SIZE_SHIFT
System property
h2.splitFileSizeShift (default: 30).The maximum file size of a split file is 1L << x. |
static boolean |
STORE_LOCAL_TIME
System property
h2.storeLocalTime (default: false).Store the local time. |
static String |
SYNC_METHOD
System property
h2.syncMethod (default: sync).What method to call when closing the database, on checkpoint, and on CHECKPOINT SYNC. |
static boolean |
TRACE_IO
System property
h2.traceIO (default: false).Trace all I/O operations. |
static String |
URL_MAP
System property
h2.urlMap (default: null).A properties file that contains a mapping between database URLs. |
static String |
USER_HOME
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. |
static int |
WEB_MAX_VALUE_LENGTH
System property
h2.webMaxValueLength (default: 100000).The H2 Console will abbreviate (truncate) result values larger than this size. |
Modifier and Type | Method and Description |
---|---|
static String |
getBaseDir()
INTERNAL
|
static String |
getScriptDirectory()
System property
h2.scriptDirectory (default: empty
string).Relative or absolute directory where the script files are stored to or read from. |
static void |
setBaseDir(String dir)
INTERNAL
|
public static final String H2_SCRIPT_DIRECTORY
public static final String H2_BROWSER
public static final String FILE_ENCODING
file.encoding
(default: Cp1252).public static final String FILE_SEPARATOR
file.separator
(default: /).public static final String JAVA_SPECIFICATION_VERSION
java.specification.version
.public static final String LINE_SEPARATOR
line.separator
(default: \n).public static final String USER_HOME
user.home
(empty string if not set).public static final boolean ALLOW_BIG_DECIMAL_EXTENSIONS
h2.allowBigDecimalExtensions
(default:
false).public static final String ALLOWED_CLASSES
h2.allowedClasses
(default: *).public static final String BROWSER
h2.browser
(default: null).java -Dh2.browser="open,-a,Safari,%url" ...
.public static final boolean ENABLE_ANONYMOUS_SSL
h2.enableAnonymousSSL
(default: true).public static final String BIND_ADDRESS
h2.bindAddress
(default: null).public static final boolean CHECK
h2.check
(default: true).public static final boolean CHECK2
h2.check2
(default: true).public static final String CLIENT_TRACE_DIRECTORY
h2.clientTraceDirectory
(default:
trace.db/).public static final int COLLATOR_CACHE_SIZE
h2.collatorCacheSize
(default: 32000).public static final boolean CONSOLE_STREAM
h2.consoleStream
(default: true).public static final int DATASOURCE_TRACE_LEVEL
h2.dataSourceTraceLevel
(default: 1).public static final int DELAY_WRONG_PASSWORD_MIN
h2.delayWrongPasswordMin
(default: 250).public static final int DELAY_WRONG_PASSWORD_MAX
h2.delayWrongPasswordMax
(default: 4000).public static final boolean EMPTY_PASSWORD
h2.emptyPassword
(default: true).public static boolean lobCloseBetweenReads
h2.lobCloseBetweenReads
(default: false).public static final int LOB_FILES_PER_DIRECTORY
h2.lobFilesPerDirectory
(default: 256).public static final boolean LOB_IN_DATABASE
h2.lobInDatabase
(default: false).public static final int LOB_CLIENT_MAX_SIZE_MEMORY
h2.lobClientMaxSizeMemory
(default: 65536).public static final int MAX_FILE_RETRY
h2.maxFileRetry
(default: 16).public static final int MAX_RECONNECT
h2.maxReconnect
(default: 3).public static final long MAX_TRACE_DATA_LENGTH
h2.maxTraceDataLength
(default: 65535).public static final int MIN_COLUMN_NAME_MAP
h2.minColumnNameMap
(default: 3).public static final boolean NIO_LOAD_MAPPED
h2.nioLoadMapped
(default: false).public static final boolean NIO_CLEANER_HACK
h2.nioCleanerHack
(default: false).public static final boolean OBJECT_CACHE
h2.objectCache
(default: true).public static final int OBJECT_CACHE_MAX_PER_ELEMENT_SIZE
h2.objectCacheMaxPerElementSize
(default:
4096).public static final int OBJECT_CACHE_SIZE
h2.objectCacheSize
(default: 1024).public static final String PG_DEFAULT_CLIENT_ENCODING
h2.pgClientEncoding
(default: UTF-8).public static final String PREFIX_TEMP_FILE
h2.prefixTempFile
(default: h2.temp).public static final boolean RETURN_LOB_OBJECTS
h2.returnLobObjects
(default: true).public static boolean runFinalize
h2.runFinalize
(default: true).public static final int SERVER_CACHED_OBJECTS
h2.serverCachedObjects
(default: 64).public static final int SERVER_RESULT_SET_FETCH_SIZE
h2.serverResultSetFetchSize
(default: 100).public static final int SOCKET_CONNECT_RETRY
h2.socketConnectRetry
(default: 16).public static final int SOCKET_CONNECT_TIMEOUT
h2.socketConnectTimeout
(default: 2000).public static final boolean SORT_NULLS_HIGH
h2.sortNullsHigh
(default: false).public static final long SPLIT_FILE_SIZE_SHIFT
h2.splitFileSizeShift
(default: 30).public static final boolean STORE_LOCAL_TIME
h2.storeLocalTime
(default: false).public static final String SYNC_METHOD
h2.syncMethod
(default: sync).public static final boolean TRACE_IO
h2.traceIO
(default: false).public static final String URL_MAP
h2.urlMap
(default: null).public static final int WEB_MAX_VALUE_LENGTH
h2.webMaxValueLength
(default: 100000).public static void setBaseDir(String dir)
public static String getBaseDir()
public static String getScriptDirectory()
h2.scriptDirectory
(default: empty
string).Copyright © 2012 JBoss by Red Hat. All Rights Reserved.