|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.h2.engine.SettingsBase
org.h2.constant.DbSettings
public class DbSettings
This class contains various database-level settings. To override the documented default value for a database, append the setting in the database URL: "jdbc:h2:test;ALIAS_COLUMN_NAME=TRUE" when opening the first connection to the database. The settings can not be changed once the database is open.
Some settings are a last resort and temporary solution to work around a problem in the application or database engine. Also, there are system properties to enable features that are not yet fully tested or that are not backward compatible.
Field Summary | |
---|---|
boolean |
aliasColumnName
Database setting ALIAS_COLUMN_NAME (default: false). |
int |
analyzeAuto
Database setting ANALYZE_AUTO (default: 2000). |
int |
analyzeSample
Database setting ANALYZE_SAMPLE (default: 10000). |
boolean |
databaseToUpper
Database setting DATABASE_TO_UPPER (default: true). |
boolean |
dbCloseOnExit
Database setting DB_CLOSE_ON_EXIT (default: true). |
boolean |
defaultConnection
Database setting DEFAULT_CONNECTION (default: false). |
java.lang.String |
defaultEscape
Database setting DEFAULT_ESCAPE (default: \). |
boolean |
defragAlways
Database setting DEFRAG_ALWAYS (default: false). |
boolean |
dropRestrict
Database setting DROP_RESTRICT (default: true). |
boolean |
earlyFilter
Database setting EARLY_FILTER (default: false). |
int |
estimatedFunctionTableRows
Database setting ESTIMATED_FUNCTION_TABLE_ROWS (default:
1000). |
boolean |
functionsInSchema
Database setting FUNCTIONS_IN_SCHEMA (default:
true). |
int |
largeResultBufferSize
Database setting LARGE_RESULT_BUFFER_SIZE (default: 4096). |
boolean |
largeTransactions
Database setting LARGE_TRANSACTIONS (default: true). |
int |
maxCompactCount
Database setting MAX_COMPACT_COUNT
(default: Integer.MAX_VALUE). |
int |
maxCompactTime
Database setting MAX_COMPACT_TIME (default: 200). |
int |
maxMemoryRowsDistinct
Database setting MAX_MEMORY_ROWS_DISTINCT (default:
10000). |
int |
maxQueryTimeout
Database setting MAX_QUERY_TIMEOUT (default: 0). |
boolean |
nestedJoins
Database setting NESTED_JOINS (default: true). |
boolean |
optimizeDistinct
Database setting OPTIMIZE_DISTINCT (default: true). |
boolean |
optimizeEvaluatableSubqueries
Database setting OPTIMIZE_EVALUATABLE_SUBQUERIES (default:
true). |
boolean |
optimizeInList
Database setting OPTIMIZE_IN_LIST (default: true). |
boolean |
optimizeInSelect
Database setting OPTIMIZE_IN_SELECT (default: true). |
boolean |
optimizeInsertFromSelect
Database setting OPTIMIZE_INSERT_FROM_SELECT
(default: true). |
boolean |
optimizeIsNull
Database setting OPTIMIZE_IS_NULL (default: false). |
boolean |
optimizeOr
Database setting OPTIMIZE_OR (default: true). |
boolean |
optimizeTwoEquals
Database setting OPTIMIZE_TWO_EQUALS (default: true). |
boolean |
optimizeUpdate
Database setting OPTIMIZE_UPDATE (default: true). |
boolean |
pageStoreInternalCount
Database setting PAGE_STORE_INTERNAL_COUNT
(default: false). |
int |
pageStoreMaxGrowth
Database setting PAGE_STORE_MAX_GROWTH
(default: 128 * 1024). |
boolean |
pageStoreTrim
Database setting PAGE_STORE_TRIM (default: true). |
int |
queryCacheSize
Database setting QUERY_CACHE_SIZE (default: 8). |
boolean |
recompileAlways
Database setting RECOMPILE_ALWAYS (default: false). |
int |
reconnectCheckDelay
Database setting RECONNECT_CHECK_DELAY (default: 200). |
boolean |
rowId
Database setting ROWID (default: true). |
boolean |
selectForUpdateMvcc
Database setting SELECT_FOR_UPDATE_MVCC
(default: true). |
boolean |
shareLinkedConnections
Database setting SHARE_LINKED_CONNECTIONS
(default: true). |
Method Summary | |
---|---|
static DbSettings |
getInstance(java.util.HashMap<java.lang.String,java.lang.String> s)
INTERNAL. |
Methods inherited from class org.h2.engine.SettingsBase |
---|
containsKey, get, get, get, getSettings |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public final boolean aliasColumnName
ALIAS_COLUMN_NAME
(default: false).
public final int analyzeAuto
ANALYZE_AUTO
(default: 2000).
public final int analyzeSample
ANALYZE_SAMPLE
(default: 10000).
public final boolean databaseToUpper
DATABASE_TO_UPPER
(default: true).
public final boolean dbCloseOnExit
DB_CLOSE_ON_EXIT
(default: true).
public boolean defaultConnection
DEFAULT_CONNECTION
(default: false).DriverManager.getConnection("jdbc:default:connection")
to
get a database connection. This feature is disabled by default for
performance reasons. Please note the Oracle JDBC driver will try to
resolve this database URL if it is loaded before the H2 driver.
public final java.lang.String defaultEscape
DEFAULT_ESCAPE
(default: \).
public final boolean defragAlways
DEFRAG_ALWAYS
(default: false).
public final boolean dropRestrict
DROP_RESTRICT
(default: true).
public final boolean earlyFilter
EARLY_FILTER
(default: false).
public final int estimatedFunctionTableRows
ESTIMATED_FUNCTION_TABLE_ROWS
(default:
1000).
public final boolean functionsInSchema
FUNCTIONS_IN_SCHEMA
(default:
true).
public final int largeResultBufferSize
LARGE_RESULT_BUFFER_SIZE
(default: 4096).
public final boolean largeTransactions
LARGE_TRANSACTIONS
(default: true).
public final int maxCompactCount
MAX_COMPACT_COUNT
(default: Integer.MAX_VALUE).
public final int maxCompactTime
MAX_COMPACT_TIME
(default: 200).
public final int maxMemoryRowsDistinct
MAX_MEMORY_ROWS_DISTINCT
(default:
10000).
public int maxQueryTimeout
MAX_QUERY_TIMEOUT
(default: 0).
public final boolean nestedJoins
NESTED_JOINS
(default: true).
public final boolean optimizeDistinct
OPTIMIZE_DISTINCT
(default: true).
public final boolean optimizeEvaluatableSubqueries
OPTIMIZE_EVALUATABLE_SUBQUERIES
(default:
true).
public final boolean optimizeInsertFromSelect
OPTIMIZE_INSERT_FROM_SELECT
(default: true).
public final boolean optimizeInList
OPTIMIZE_IN_LIST
(default: true).
public final boolean optimizeInSelect
OPTIMIZE_IN_SELECT
(default: true).
public final boolean optimizeIsNull
OPTIMIZE_IS_NULL
(default: false).
public final boolean optimizeOr
OPTIMIZE_OR
(default: true).
public final boolean optimizeTwoEquals
OPTIMIZE_TWO_EQUALS
(default: true).
public final boolean optimizeUpdate
OPTIMIZE_UPDATE
(default: true).
public final int pageStoreMaxGrowth
PAGE_STORE_MAX_GROWTH
(default: 128 * 1024).
public final boolean pageStoreInternalCount
PAGE_STORE_INTERNAL_COUNT
(default: false).
public final boolean pageStoreTrim
PAGE_STORE_TRIM
(default: true).
public final int queryCacheSize
QUERY_CACHE_SIZE
(default: 8).
public final boolean recompileAlways
RECOMPILE_ALWAYS
(default: false).
public final int reconnectCheckDelay
RECONNECT_CHECK_DELAY
(default: 200).
public final boolean rowId
ROWID
(default: true).
public final boolean selectForUpdateMvcc
SELECT_FOR_UPDATE_MVCC
(default: true).
public final boolean shareLinkedConnections
SHARE_LINKED_CONNECTIONS
(default: true).
Method Detail |
---|
public static DbSettings getInstance(java.util.HashMap<java.lang.String,java.lang.String> s)
s
- the settings
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |