|
|||||||||
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).When enabled, aliased columns (as in SELECT ID AS I FROM TEST) return the alias (I in this case) in ResultSetMetaData.getColumnName() and 'null' in getTableName(). |
int |
analyzeAuto
Database setting ANALYZE_AUTO (default: 0).After changing this many rows, ANALYZE is automatically run for a table. |
int |
analyzeSample
Database setting ANALYZE_SAMPLE (default: 10000).The default sample size when analyzing a table. |
boolean |
databaseToUpper
Database setting DATABASE_TO_UPPER (default: true).Database short names are converted to uppercase for the DATABASE() function, and in the CATALOG column of all database meta data methods. |
boolean |
dbCloseOnExit
Database setting DB_CLOSE_ON_EXIT (default: true).Close the database when the virtual machine exits normally, using a shutdown hook. |
java.lang.String |
defaultEscape
Database setting DEFAULT_ESCAPE (default: \).The default escape character for LIKE comparisons. |
boolean |
defragAlways
Database setting DEFRAG_ALWAYS (default: false).Each time the database is closed, it is fully defragmented (SHUTDOWN DEFRAG). |
boolean |
dropRestrict
Database setting DROP_RESTRICT (default: false).Whether the default action for DROP TABLE and DROP VIEW is RESTRICT. |
int |
estimatedFunctionTableRows
Database setting ESTIMATED_FUNCTION_TABLE_ROWS (default:
1000).The estimated number of rows in a function table (for example, CSVREAD or FTL_SEARCH). |
boolean |
functionsInSchema
Database setting FUNCTIONS_IN_SCHEMA (default:
false).If set, all functions are stored in a schema. |
int |
largeResultBufferSize
Database setting LARGE_RESULT_BUFFER_SIZE (default: 4096).Buffer size for large result sets. |
boolean |
largeTransactions
Database setting LARGE_TRANSACTIONS (default: false).Support very large transactions |
int |
maxCompactCount
Database setting MAX_COMPACT_COUNT
(default: Integer.MAX_VALUE).The maximum number of pages to move when closing a database. |
int |
maxCompactTime
Database setting MAX_COMPACT_TIME (default: 200).The maximum time in milliseconds used to compact a database when closing. |
int |
maxMemoryRowsDistinct
Database setting MAX_MEMORY_ROWS_DISTINCT (default:
Integer.MAX_VALUE).The maximum number of rows kept in-memory for SELECT DISTINCT queries. |
int |
maxQueryTimeout
Database setting MAX_QUERY_TIMEOUT (default: 0).The maximum timeout of a query in milliseconds. |
boolean |
nestedJoins
Database setting NESTED_JOINS (default: false).Whether nested joins should be supported. |
boolean |
optimizeDistinct
Database setting OPTIMIZE_DISTINCT (default: true).Improve the performance of simple DISTINCT queries if an index is available for the given column. |
boolean |
optimizeEvaluatableSubqueries
Database setting OPTIMIZE_EVALUATABLE_SUBQUERIES (default:
true).Optimize subqueries that are not dependent on the outer query. |
boolean |
optimizeInList
Database setting OPTIMIZE_IN_LIST (default: true).Optimize IN(...) and IN(SELECT ...) comparisons. |
boolean |
optimizeInsertFromSelect
Database setting OPTIMIZE_INSERT_FROM_SELECT
(default: false).Insert into table from query directly bypassing temporary disk storage. |
boolean |
optimizeIsNull
Database setting OPTIMIZE_IS_NULL (default: false).Use an index for condition of the form columnName IS NULL. |
boolean |
optimizeOr
Database setting OPTIMIZE_OR (default: false).Convert (C=? OR C=?) to (C IN(?, ?)). |
boolean |
optimizeSubqueryCache
Database setting OPTIMIZE_SUBQUERY_CACHE (default: true).Cache subquery results. |
boolean |
optimizeTwoEquals
Database setting OPTIMIZE_TWO_EQUALS (default: true).Optimize expressions of the form A=B AND B=1. |
boolean |
optimizeUpdate
Database setting OPTIMIZE_UPDATE (default: true).Speed up inserts, updates, and deletes by not reading all rows from a page unless necessary. |
boolean |
pageStoreInternalCount
Database setting PAGE_STORE_INTERNAL_COUNT
(default: false).Update the row counts on a node level. |
boolean |
pageStoreTrim
Database setting PAGE_STORE_TRIM (default: true).Trim the database size when closing. |
int |
queryCacheSize
Database setting QUERY_CACHE_SIZE (default: 0).The size of the query cache. |
boolean |
recompileAlways
Database setting RECOMPILE_ALWAYS (default: false).Always recompile prepared statements. |
int |
reconnectCheckDelay
Database setting RECONNECT_CHECK_DELAY (default: 200).Check the .lock.db file every this many milliseconds to detect that the database was changed. |
boolean |
selectForUpdateMvcc
Database setting SELECT_FOR_UPDATE_MVCC
(default: false).If set, SELECT .. |
boolean |
shareLinkedConnections
Database setting SHARE_LINKED_CONNECTIONS
(default: true).Linked connections should be shared, that means connections to the same database should be used for all linked tables that connect to the same database. |
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: 0).
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 final java.lang.String defaultEscape
DEFAULT_ESCAPE
(default: \).
public final boolean defragAlways
DEFRAG_ALWAYS
(default: false).
public final boolean dropRestrict
DROP_RESTRICT
(default: false).
public final int estimatedFunctionTableRows
ESTIMATED_FUNCTION_TABLE_ROWS
(default:
1000).
public final boolean functionsInSchema
FUNCTIONS_IN_SCHEMA
(default:
false).
public final int largeResultBufferSize
LARGE_RESULT_BUFFER_SIZE
(default: 4096).
public final boolean largeTransactions
LARGE_TRANSACTIONS
(default: false).
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:
Integer.MAX_VALUE).
public int maxQueryTimeout
MAX_QUERY_TIMEOUT
(default: 0).
public final boolean nestedJoins
NESTED_JOINS
(default: false).
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: false).
public final boolean optimizeInList
OPTIMIZE_IN_LIST
(default: true).
public final boolean optimizeIsNull
OPTIMIZE_IS_NULL
(default: false).
public final boolean optimizeOr
OPTIMIZE_OR
(default: false).
public final boolean optimizeSubqueryCache
OPTIMIZE_SUBQUERY_CACHE
(default: true).
public final boolean optimizeTwoEquals
OPTIMIZE_TWO_EQUALS
(default: true).
public final boolean optimizeUpdate
OPTIMIZE_UPDATE
(default: true).
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: 0).
public final boolean recompileAlways
RECOMPILE_ALWAYS
(default: false).
public final int reconnectCheckDelay
RECONNECT_CHECK_DELAY
(default: 200).
public final boolean selectForUpdateMvcc
SELECT_FOR_UPDATE_MVCC
(default: false).
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 |