A B C D E F G H I J K L M N O P Q R S T U V W Z

## A

abort(Executor) - Method in class org.h2.jdbc.JdbcConnection
  [Not supported]
absolute(int) - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to a specific row.
absolute(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
acceptsCommaAsJsonKeyValueSeparator - Variable in class org.h2.engine.Mode
  Accepts comma ',' as key/value separator in JSON_OBJECT and JSON_OBJECTAGG functions.
ACCESS_DENIED_TO_CLASS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90134` is thrown when trying to load a Java class that is not part of the allowed classes.
actionPerformed(ActionEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
add(Object) - Method in interface org.h2.api.Aggregate
  This method is called once for each row.
add(Object) - Method in interface org.h2.api.AggregateFunction
  This method is called once for each row.
addBatch(String) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Calling this method is not legal on a PreparedStatement.
addBatch() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Adds the current settings to the batch.
addBatch(String) - Method in class org.h2.jdbc.JdbcStatement
  Adds a statement to the batch.
addColumn(String, int, int, int) - Method in class org.h2.tools.SimpleResultSet
  Adds a column to the result set.
addColumn(String, int, String, int, int) - Method in class org.h2.tools.SimpleResultSet
  Adds a column to the result set.
addConnectionEventListener(ConnectionEventListener) - Method in class org.h2.jdbcx.JdbcXAConnection
  Register a new listener for the connection.
addDatabaseObject(SessionLocal, DbObject) - Method in class org.h2.engine.Database
  Add an object to the database.
addLocalTempTable(Table) - Method in class org.h2.engine.SessionLocal
  Add a local temporary table to this session.
addLocalTempTableConstraint(Constraint) - Method in class org.h2.engine.SessionLocal
  Add a local temporary constraint to this session.
addLocalTempTableIndex(Index) - Method in class org.h2.engine.SessionLocal
  Add a local temporary index to this session.
addProcedure(Procedure) - Method in class org.h2.engine.SessionLocal
  Add a procedure to this session.
addRow(Object...) - Method in class org.h2.tools.SimpleResultSet
  Add a new row to the result set.
addSavepoint(String) - Method in class org.h2.engine.SessionLocal
  Create a savepoint that is linked to the current log position.
addSchemaObject(SessionLocal, SchemaObject) - Method in class org.h2.engine.Database
  Add a schema object to the database.
addStatementEventListener(StatementEventListener) - Method in class org.h2.jdbcx.JdbcXAConnection
  [Not supported] Add a statement event listener.
addTemporaryLob(ValueLob) - Method in class org.h2.engine.Session
  Add a temporary LOB, which is closed when the session commits.
addTemporaryLob(ValueLob) - Method in class org.h2.engine.SessionLocal
addTemporaryLob(ValueLob) - Method in class org.h2.engine.SessionRemote
addWords(FullTextSettings, Set<String>, Reader) - Static method in class org.h2.fulltext.FullText
  Add all words in the given text to the hash set.
addWords(FullTextSettings, Set<String>, String) - Static method in class org.h2.fulltext.FullText
  Add all words in the given text to the hash set.
ADMIN_RIGHTS_REQUIRED - Static variable in class org.h2.api.ErrorCode
  The error with code `90040` is thrown when a user that is not administrator tries to execute a statement that requires admin privileges.
afterLast() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to after the last row, that means after the end.
afterLast() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
Aggregate - Interface in org.h2.api
  A user-defined aggregate function needs to implement this interface.
AGGREGATE - Static variable in class org.h2.engine.DbObject
  This object is a user-defined aggregate function.
AGGREGATE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90132` is thrown when trying to drop a user-defined aggregate function that doesn't exist.
AggregateFunction - Interface in org.h2.api
  A user-defined aggregate function needs to implement this interface.
aliasColumnName - Variable in class org.h2.engine.Mode
  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().
ALL - Static variable in class org.h2.engine.Right
  The right bit mask that means: select, insert, update, delete, and update for this object is allowed.
allNumericTypesHavePrecision - Variable in class org.h2.engine.Mode
  If `true` all numeric data types may have precision and 'UNSIGNED' clause.
allocateObjectId() - Method in class org.h2.engine.Database
  Allocate a new object id.
ALLOW_LITERALS_ALL - Static variable in class org.h2.engine.Constants
  Constant meaning both numbers and text is allowed in SQL statements.
ALLOW_LITERALS_NONE - Static variable in class org.h2.engine.Constants
  Constant meaning no literals are allowed in SQL statements.
ALLOW_LITERALS_NUMBERS - Static variable in class org.h2.engine.Constants
  Constant meaning only numbers are allowed in SQL statements (but no texts).
allowDB2TimestampFormat - Variable in class org.h2.engine.Mode
  Whether DB2 TIMESTAMP formats are allowed.
ALLOWED_CLASSES - Static variable in class org.h2.engine.SysProperties
  System property `h2.allowedClasses` (default: *).
allowEmptyInPredicate - Variable in class org.h2.engine.Mode
  Whether IN predicate may have an empty value list.
allowEmptySchemaValuesAsDefaultSchema - Variable in class org.h2.engine.Mode
  If `true` constructs like 'CREATE TABLE CATALOG..TABLE_NAME' are allowed, the default schema is used.
allowNonRepeatableRead() - Method in enum org.h2.engine.IsolationLevel
  Returns whether a non-repeatable read phenomena is allowed.
allowPlusForStringConcat - Variable in class org.h2.engine.Mode
  Text can be concatenated using '+'.
allowUnrelatedOrderByExpressionsInDistinctQueries - Variable in class org.h2.engine.Mode
  If `true` unrelated ORDER BY expression are allowed in DISTINCT queries, if `false` they are disallowed.
allowUsingFromClauseInUpdateStatement - Variable in class org.h2.engine.Mode
  If `true`, allow using from clause in update statement.
allProceduresAreCallable() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if all procedures callable.
allTablesAreSelectable() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if it possible to query all tables returned by getTables.
ALTER_ANY_SCHEMA - Static variable in class org.h2.engine.Right
  The right bit mask that means: create/alter/drop schema is allowed.
alterTableExtensionsMySQL - Variable in class org.h2.engine.Mode
  If `true` some additional non-standard ALTER TABLE commands are allowed.
alterTableModifyColumn - Variable in class org.h2.engine.Mode
  If `true` non-standard ALTER TABLE MODIFY COLUMN is allowed.
alterTableModifyColumnPreserveNullability - Variable in class org.h2.engine.Mode
  If `true` non-standard ALTER TABLE MODIFY COLUMN preserves nullability when changing data type.
AMBIGUOUS_COLUMN_NAME_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90059` is thrown when a query contains a column that could belong to multiple tables.
analyzeAuto - Variable in class org.h2.engine.DbSettings
  Database setting `ANALYZE_AUTO` (default: 2000).
analyzeSample - Variable in class org.h2.engine.DbSettings
  Database setting `ANALYZE_SAMPLE` (default: 10000).
areEqual(Value, Value) - Method in class org.h2.engine.SessionLocal
  Check if two values are equal with the current comparison mode.
array(H2Type) - Static method in class org.h2.api.H2Type
  Returns ARRAY data type with the specified component type.
ARRAY_ELEMENT_ERROR_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `22034` is thrown when an attempt is made to read non-existing element of an array.
asString(Object, int) - Static method in class org.h2.fulltext.FullText
  INTERNAL.
AUTH_CONFIG_FILE - Static variable in class org.h2.engine.SysProperties
  System property `h2.authConfigFile` (default: null).
AUTHENTICATOR_NOT_AVAILABLE - Static variable in class org.h2.api.ErrorCode
  The error with code `90144` is thrown when user trying to login into a database with AUTHREALM set and the target database doesn't have an authenticator defined
AUTO - Static variable in class org.h2.engine.GeneratedKeysMode
  Generated keys should be configured automatically.
autoCommitFailureClosesAllResultSets() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether an exception while auto commit is on closes all result sets.
autoCommitIfCluster() - Method in class org.h2.engine.SessionRemote
  Calls COMMIT if the session is in cluster mode.
autoCompactFillRate - Variable in class org.h2.engine.DbSettings
  Database setting `AUTO_COMPACT_FILL_RATE` (default: 90, which means 90%, 0 disables auto-compacting).
autoIncrementClause - Variable in class org.h2.engine.Mode
  Whether MySQL-style AUTO_INCREMENT clause is supported.

## B

Backup - Class in org.h2.tools
  Creates a backup of a database.
Backup() - Constructor for class org.h2.tools.Backup
before - Variable in class org.h2.tools.TriggerAdapter
  Whether the fire method is called before or after the operation is performed.
beforeFirst() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to before the first row, that means resets the result set.
beforeFirst() - Method in class org.h2.tools.SimpleResultSet
  Moves the current position to before the first row, that means the result set is reset.
begin() - Method in class org.h2.engine.SessionLocal
  Begin a transaction.
BIGINT - Static variable in class org.h2.api.H2Type
  The BIGINT data type.
BINARY - Static variable in class org.h2.api.H2Type
  The BINARY data type.
BIND_ADDRESS - Static variable in class org.h2.engine.SysProperties
  System property `h2.bindAddress` (default: null).
BLOB - Static variable in class org.h2.api.H2Type
  The BINARY LARGE OBJECT data type.
BLOB_SEARCH - Static variable in class org.h2.engine.Constants
  Whether searching in Blob values should be supported.
BOOLEAN - Static variable in class org.h2.api.H2Type
  The BOOLEAN data type
BUILD_DATE - Static variable in class org.h2.engine.Constants
  The build date is updated for each public release.
BUILD_ID - Static variable in class org.h2.engine.Constants
  Sequential version number.
BUILD_SNAPSHOT - Static variable in class org.h2.engine.Constants
  Whether this is a snapshot version.
BUILD_VENDOR_AND_VERSION - Static variable in class org.h2.engine.Constants
  If H2 is compiled to be included in a product, this should be set to a unique vendor id (to distinguish from official releases).
buildUser(AuthenticationInfo, Database, boolean) - Static method in class org.h2.engine.UserBuilder
  Build the database user starting from authentication informations.

## C

CACHE_MIN_RECORDS - Static variable in class org.h2.engine.Constants
  The minimum number of entries to keep in the cache.
CACHE_TYPE_DEFAULT - Static variable in class org.h2.engine.Constants
  The default cache type.
CAN_ONLY_ASSIGN_TO_VARIABLE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90137` is thrown when trying to assign a value to something that is not a variable.
cancel() - Method in class org.h2.engine.Session
  Cancel the current or next command (called when closing a connection).
cancel() - Method in class org.h2.engine.SessionLocal
cancel() - Method in class org.h2.engine.SessionRemote
cancel() - Method in class org.h2.jdbc.JdbcStatement
  Cancels a currently running statement.
cancelRowUpdates() - Method in class org.h2.jdbc.JdbcResultSet
  Cancels updating a row.
cancelRowUpdates() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
cancelStatement(int) - Method in class org.h2.engine.SessionRemote
  Cancel the statement with the given id.
CANNOT_CHANGE_SETTING_WHEN_OPEN_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90133` is thrown when trying to change a specific database property while the database is already open.
CANNOT_DROP_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90107` is thrown when trying to drop an object because another object would become invalid.
CANNOT_DROP_CURRENT_USER - Static variable in class org.h2.api.ErrorCode
  The error with code `90019` is thrown when trying to drop the current user, if there are no other admin users.
CANNOT_DROP_LAST_COLUMN - Static variable in class org.h2.api.ErrorCode
  The error with code `90084` is thrown when trying to drop the last column of a table.
CANNOT_DROP_TABLE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90118` is thrown when trying to drop a table can not be dropped.
CANNOT_MIX_INDEXED_AND_UNINDEXED_PARAMS - Static variable in class org.h2.api.ErrorCode
  The error with code `90123` is thrown when trying mix regular parameters and indexed parameters in the same statement.
CANNOT_TRUNCATE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90106` is thrown when trying to truncate a table that can not be truncated.
caseInsensitiveIdentifiers - Variable in class org.h2.engine.DbSettings
  Database setting `CASE_INSENSITIVE_IDENTIFIERS` (default: false).
caseInsensitiveIdentifiers - Variable in class org.h2.engine.Session.StaticSettings
  Whether all identifiers are case insensitive.
CastDataProvider - Interface in org.h2.engine
  Provides information for type casts and comparison operations.
CHANGE_ID - Static variable in class org.h2.engine.SessionRemote
ChangeFileEncryption - Class in org.h2.tools
  Allows changing the database file encryption password or algorithm.
ChangeFileEncryption() - Constructor for class org.h2.tools.ChangeFileEncryption
CHAR - Static variable in class org.h2.api.H2Type
  The CHARACTER data type.
charAndByteLengthUnits - Variable in class org.h2.engine.Mode
  If `true` 'CHAR' and 'BYTE' length units are allowed.
charPadding - Variable in class org.h2.engine.Mode
  How to pad or trim CHAR values.
CHECK - Static variable in class org.h2.engine.SysProperties
  System property `h2.check` (default: true for JDK/JRE, false for Android).
CHECK_CONSTRAINT_INVALID - Static variable in class org.h2.api.ErrorCode
  The error with code `23514` is thrown when evaluation of a check constraint resulted in an error.
CHECK_CONSTRAINT_VIOLATED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `23513` is thrown when a check constraint is violated.
checkAdmin() - Method in class org.h2.engine.User
  Checks if this user has admin rights.
checkCanceled() - Method in class org.h2.engine.SessionLocal
  Check if the current transaction is canceled by calling Statement.cancel() or because a session timeout was set and expired.
checkClosed() - Method in class org.h2.engine.SessionRemote
  Check if this session is closed and throws an exception if so.
checkClosed() - Method in class org.h2.jdbc.JdbcConnection
  INTERNAL.
checkOwnsNoSchemas() - Method in class org.h2.engine.RightOwner
  Check that this right owner does not own any schema.
checkpoint() - Method in class org.h2.engine.Database
  Flush all changes and open a new transaction log.
checkPowerOff() - Method in class org.h2.engine.Database
checkPowerOff() - Method in class org.h2.engine.SessionRemote
checkPowerOff() - Method in class org.h2.tools.Recover
  INTERNAL
checkRename() - Method in class org.h2.engine.Comment
checkRename() - Method in class org.h2.engine.DbObject
  Check if renaming is allowed.
checkRename() - Method in class org.h2.engine.Right
checkRename() - Method in class org.h2.engine.Setting
checkSchemaAdmin() - Method in class org.h2.engine.User
  Checks if this user has schema admin rights for every schema.
checkSchemaOwner(Schema) - Method in class org.h2.engine.User
  Checks if this user has schema owner rights for the specified schema.
checkTableRight(Table, int) - Method in class org.h2.engine.User
  Checks that this user has the given rights for the specified table.
checkWritingAllowed() - Method in class org.h2.engine.Database
checkWritingAllowed() - Method in class org.h2.engine.SessionRemote
checkWritingAllowed() - Method in class org.h2.tools.Recover
  INTERNAL
CLASS_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90086` is thrown when a class can not be loaded because it is not in the classpath or because a related class is not in the classpath.
cleanAuthenticationInfo() - Method in class org.h2.engine.ConnectionInfo
  Clear authentication properties.
clearBatch() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Clears the batch.
clearBatch() - Method in class org.h2.jdbc.JdbcStatement
  Clears the batch.
clearParameters() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Clears all parameters.
clearViewIndexCache() - Method in class org.h2.engine.SessionLocal
  Clear the view cache for this session.
clearWarnings() - Method in class org.h2.jdbc.JdbcConnection
  Clears all warnings.
clearWarnings() - Method in class org.h2.jdbc.JdbcResultSet
  Clears all warnings.
clearWarnings() - Method in class org.h2.jdbc.JdbcStatement
  Clears all warnings.
clearWarnings() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
CLIENT_TRACE_DIRECTORY - Static variable in class org.h2.engine.SysProperties
  System property `h2.clientTraceDirectory` (default: trace.db/).
CLOB - Static variable in class org.h2.api.H2Type
  The CHARACTER LARGE OBJECT data type.
clone() - Method in class org.h2.engine.ConnectionInfo
close() - Method in interface org.h2.api.Trigger
  This method is called when the database is closed.
close() - Method in class org.h2.engine.Session
  Roll back pending transactions and close the session.
close() - Method in class org.h2.engine.SessionLocal
close() - Method in class org.h2.engine.SessionRemote
close() - Method in class org.h2.fulltext.FullText.FullTextTrigger
  INTERNAL
close() - Method in class org.h2.fulltext.FullTextLucene.FullTextTrigger
  INTERNAL
close() - Method in class org.h2.jdbc.JdbcConnection
  Closes this connection.
close() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Closes this statement.
close() - Method in class org.h2.jdbc.JdbcResultSet
  Closes the result set.
close() - Method in class org.h2.jdbc.JdbcStatement
  Closes this statement.
close() - Method in class org.h2.jdbcx.JdbcXAConnection
  Close the physical connection.
close() - Method in class org.h2.tools.Csv
  INTERNAL
close() - Method in class org.h2.tools.SimpleResultSet
  Closes the result set and releases the resources.
close() - Method in interface org.h2.tools.SimpleRowSource
  Close the row source.
closeAll() - Static method in class org.h2.fulltext.FullText
  INTERNAL Close all fulltext settings, freeing up memory.
closeOldResultSet() - Method in class org.h2.jdbc.JdbcStatement
  INTERNAL.
closeOnCompletion() - Method in class org.h2.jdbc.JdbcStatement
  Specifies that this statement will be closed when its dependent result set is closed.
closingDatabase() - Method in interface org.h2.api.DatabaseEventListener
  This method is called before the database is closed normally.
CLUSTER_ERROR_DATABASE_RUNS_ALONE - Static variable in class org.h2.api.ErrorCode
  The error with code `90093` is thrown when trying to connect to a clustered database that runs in standalone mode.
CLUSTER_ERROR_DATABASE_RUNS_CLUSTERED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90094` is thrown when trying to connect to a clustered database that runs together with a different cluster node setting than what is used when trying to connect.
CLUSTERING_DISABLED - Static variable in class org.h2.engine.Constants
  The value of the cluster setting if clustering is disabled.
CLUSTERING_ENABLED - Static variable in class org.h2.engine.Constants
  The value of the cluster setting if clustering is enabled (the actual value is checked later).
COLLATION_CHANGE_WITH_DATA_TABLE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90089` is thrown when trying to change the collation while there was already data in the database.
COLLATOR_CACHE_SIZE - Static variable in class org.h2.engine.SysProperties
  System property `h2.collatorCacheSize` (default: 3 2000).
COLUMN_ALIAS_IS_NOT_SPECIFIED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90156` is thrown when trying to create a view or a table from a select and some expression doesn't have a column name or alias when it is required by a compatibility mode.
COLUMN_CONTAINS_NULL_VALUES_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90081` is thrown when trying to alter a column to not allow NULL, if there is already data in the table where this column is NULL.
COLUMN_COUNT_DOES_NOT_MATCH - Static variable in class org.h2.api.ErrorCode
  The error with code `21002` is thrown when the number of columns does not match.
COLUMN_IS_PART_OF_INDEX_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90075` is thrown when trying to alter a table and allow null for a column that is part of a primary key or hash index.
COLUMN_IS_REFERENCED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90083` is thrown when trying to drop a column that is part of a constraint.
COLUMN_MUST_NOT_BE_NULLABLE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90023` is thrown when trying to set a primary key on a nullable column or when trying to drop NOT NULL constraint on primary key or identity column.
COLUMN_NAMES - Static variable in class org.h2.engine.GeneratedKeysMode
  Use specified column names to return generated keys from.
COLUMN_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42122` is thrown when referencing an non-existing column.
COLUMN_NUMBERS - Static variable in class org.h2.engine.GeneratedKeysMode
  Use specified column indices to return generated keys from.
columns - Variable in class org.h2.fulltext.IndexInfo
  The column names.
command - Variable in class org.h2.jdbc.JdbcPreparedStatement
COMMAND_CLOSE - Static variable in class org.h2.engine.SessionRemote
COMMAND_COMMIT - Static variable in class org.h2.engine.SessionRemote
COMMAND_EXECUTE_QUERY - Static variable in class org.h2.engine.SessionRemote
COMMAND_EXECUTE_UPDATE - Static variable in class org.h2.engine.SessionRemote
COMMAND_GET_META_DATA - Static variable in class org.h2.engine.SessionRemote
Comment - Class in org.h2.engine
  Represents a database object comment.
Comment(Database, int, DbObject) - Constructor for class org.h2.engine.Comment
COMMENT - Static variable in class org.h2.engine.DbObject
  This object is a comment.
comment - Variable in class org.h2.engine.DbObject
  The comment (if set).
commit(boolean) - Method in class org.h2.engine.SessionLocal
  Commit the current transaction.
commit() - Method in class org.h2.jdbc.JdbcConnection
  Commits the current transaction.
commit(Xid, boolean) - Method in class org.h2.jdbcx.JdbcXAConnection
  Commit a transaction.
COMMIT_ROLLBACK_NOT_ALLOWED - Static variable in class org.h2.api.ErrorCode
  The error with code `90058` is thrown when trying to call commit or rollback inside a trigger, or when trying to call a method inside a trigger that implicitly commits the current transaction, if an object is locked.
compare(Value, Value) - Method in class org.h2.engine.SessionLocal
  Compare two values with the current comparison mode.
compare(long[], long[]) - Method in class org.h2.tools.MultiDimension
compareTo(MetaRecord) - Method in class org.h2.engine.MetaRecord
  Sort the list of meta records by 'create order'.
compareTypeSafe(Value, Value) - Method in class org.h2.engine.SessionLocal
  Compare two values with the current comparison mode.
compareWithNull(Value, Value, boolean) - Method in class org.h2.engine.SessionLocal
  Compare two values with the current comparison mode.
compress(byte[], String) - Method in class org.h2.tools.CompressTool
  Compressed the data using the specified algorithm.
compressData - Variable in class org.h2.engine.DbSettings
  Database setting `COMPRESS` (default: false).
COMPRESSION_ERROR - Static variable in class org.h2.api.ErrorCode
  The error with code `90104` is thrown when the data can not be de-compressed.
CompressTool - Class in org.h2.tools
  A tool to losslessly compress data, and expand the compressed data again.
CONCURRENT_UPDATE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90131` is thrown when using multi version concurrency control, and trying to update the same row from within two connections at the same time, or trying to insert two rows with the same key from two connections.
conn - Variable in class org.h2.jdbc.JdbcStatement
CONN_URL_COLUMNLIST - Static variable in class org.h2.engine.Constants
  The database URL used when calling a function if only the column list should be returned.
CONN_URL_INTERNAL - Static variable in class org.h2.engine.Constants
  The database URL used when calling a function if the data should be returned.
connectEmbeddedOrServer(boolean) - Method in class org.h2.engine.SessionRemote
  Open a new (remote or embedded) session.
CONNECTION_BROKEN_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90067` is thrown when the client could not connect to the database, or if the connection was lost.
connectionClosed(ConnectionEvent) - Method in class org.h2.jdbcx.JdbcConnectionPool
  INTERNAL
connectionErrorOccurred(ConnectionEvent) - Method in class org.h2.jdbcx.JdbcConnectionPool
  INTERNAL
ConnectionInfo - Class in org.h2.engine
  Encapsulates the connection settings, including user name and password.
ConnectionInfo(String) - Constructor for class org.h2.engine.ConnectionInfo
  Create a connection info object.
ConnectionInfo(String, Properties, String, Object) - Constructor for class org.h2.engine.ConnectionInfo
  Create a connection info object.
Console - Class in org.h2.tools
  Starts the H2 Console (web-) server, as well as the TCP and PG server.
Console() - Constructor for class org.h2.tools.Console
CONSOLE_MAX_PROCEDURES_LIST_COLUMNS - Static variable in class org.h2.engine.SysProperties
  System property `h2.consoleProcedureColumns` (default: 500).
CONSOLE_MAX_TABLES_LIST_COLUMNS - Static variable in class org.h2.engine.SysProperties
  System property `h2.consoleTableColumns` (default: 500).
CONSOLE_MAX_TABLES_LIST_INDEXES - Static variable in class org.h2.engine.SysProperties
  System property `h2.consoleTableIndexes` (default: 100).
CONSOLE_STREAM - Static variable in class org.h2.engine.SysProperties
  System property `h2.consoleStream` (default: true).
CONSOLE_TIMEOUT - Static variable in class org.h2.engine.SysProperties
  System property `h2.consoleTimeout` (default: 1800000).
CONSTANT - Static variable in class org.h2.engine.DbObject
  This object is a constant.
CONSTANT_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90114` is thrown when trying to create a constant if a constant with this name already exists.
CONSTANT_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90115` is thrown when trying to drop a constant that does not exists.
Constants - Class in org.h2.engine
  Constants are fixed values that are used in the whole database code.
CONSTRAINT - Static variable in class org.h2.engine.DbObject
  This object is a constraint (check constraint, unique constraint, or referential constraint).
CONSTRAINT_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90045` is thrown when trying to create a constraint if an object with this name already exists.
CONSTRAINT_IS_USED_BY_CONSTRAINT_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90152` is thrown when trying to manually drop a unique or primary key constraint that is referenced by a foreign key constraint without a CASCADE clause.
CONSTRAINT_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90057` is thrown when trying to drop a constraint that does not exist.
containsKey(String) - Method in class org.h2.engine.SettingsBase
  Check if the settings contains the given key.
containsUncommitted() - Method in class org.h2.engine.SessionLocal
  Whether the session contains any uncommitted changes.
convertException(Exception) - Static method in class org.h2.fulltext.FullTextLucene
  Convert an exception to a fulltext exception.
convertOnlyToSmallerScale - Variable in class org.h2.engine.Mode
  When converting the scale of decimal data, the number is only converted if the new scale is smaller than the current scale.
ConvertTraceFile - Class in org.h2.tools
  Converts a .trace.db file to a SQL script and Java source code.
ConvertTraceFile() - Constructor for class org.h2.tools.ConvertTraceFile
COST_ROW_OFFSET - Static variable in class org.h2.engine.Constants
  The cost is calculated on rowcount + this offset, to avoid using the wrong or no index if the table contains no rows _currently_ (when preparing the statement)
count - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The number of times the statement was executed.
create(ConnectionPoolDataSource) - Static method in class org.h2.jdbcx.JdbcConnectionPool
  Constructs a new connection pool.
create(String, String, String) - Static method in class org.h2.jdbcx.JdbcConnectionPool
  Constructs a new connection pool for H2 databases.
createArrayOf(String, Object[]) - Method in class org.h2.jdbc.JdbcConnection
  Create a new Array object.
createBlob() - Method in class org.h2.jdbc.JdbcConnection
  Create a new empty Blob object.
createClob() - Method in class org.h2.jdbc.JdbcConnection
  Create a new empty Clob object.
CreateCluster - Class in org.h2.tools
  Creates a cluster from a stand-alone database.
CreateCluster() - Constructor for class org.h2.tools.CreateCluster
createConnection(boolean) - Method in class org.h2.engine.SessionLocal
  Create an internal connection.
createIndex(Connection, String, String, String) - Static method in class org.h2.fulltext.FullText
  Create a new full text index for a table and column list.
createIndex(Connection, String, String, String) - Static method in class org.h2.fulltext.FullTextLucene
  Create a new full text index for a table and column list.
createNClob() - Method in class org.h2.jdbc.JdbcConnection
  Create a new empty NClob object.
createPgServer(String...) - Static method in class org.h2.tools.Server
  Create a new PG server, but does not start it yet.
createResultSet(boolean) - Static method in class org.h2.fulltext.FullText
  Create an empty search result and initialize the columns.
createSession(ConnectionInfo) - Static method in class org.h2.engine.Engine
  Open a database connection with the given connection information.
createSQLXML() - Method in class org.h2.jdbc.JdbcConnection
  Create a new SQLXML object with no data.
createStatement() - Method in class org.h2.jdbc.JdbcConnection
  Creates a new statement.
createStatement(int, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a statement with the specified result set type and concurrency.
createStatement(int, int, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a statement with the specified result set type, concurrency, and holdability.
createStruct(String, Object[]) - Method in class org.h2.jdbc.JdbcConnection
  [Not supported] Create a new empty Struct object.
createTable(CreateTableData) - Method in interface org.h2.api.TableEngine
  Create new table.
createTcpServer(String...) - Static method in class org.h2.tools.Server
  Create a new TCP server, but does not start it yet.
createUniqueConstraintForReferencedColumns - Variable in class org.h2.engine.Mode
  If `true`, referential constraints will create a unique constraint on referenced columns if it doesn't exist instead of throwing an exception.
createWebServer(String...) - Static method in class org.h2.tools.Server
  Create a new web server, but does not start it yet.
CredentialsValidator - Interface in org.h2.api
  A class that implement this interface can be used to validate credentials provided by client.
Csv - Class in org.h2.tools
  A facility to read from and write to CSV (comma separated values) files.
Csv() - Constructor for class org.h2.tools.Csv
CURRENT_SEQUENCE_VALUE_IS_NOT_DEFINED_IN_SESSION_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90148` is thrown when trying to access the current value of a sequence before execution of NEXT VALUE FOR sequenceName in the current session.
currentTimestamp() - Method in interface org.h2.engine.CastDataProvider
  Returns the current timestamp with maximum resolution.
currentTimestamp() - Method in class org.h2.engine.Database
currentTimestamp() - Method in class org.h2.engine.SessionLocal
currentTimestamp() - Method in class org.h2.engine.SessionRemote
currentTimestamp() - Method in class org.h2.jdbc.JdbcConnection
currentTimeZone() - Method in interface org.h2.engine.CastDataProvider
  Returns the current time zone.
currentTimeZone() - Method in class org.h2.engine.Database
currentTimeZone() - Method in class org.h2.engine.SessionLocal
currentTimeZone() - Method in class org.h2.engine.SessionRemote
currentTimeZone() - Method in class org.h2.jdbc.JdbcConnection

## D

DATA_CONVERSION_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `22018` is thrown when trying to convert a value to a data type where the conversion is undefined, or when an error occurred trying to convert.
Database - Class in org.h2.engine
  There is one database object per open database.
Database(ConnectionInfo, String) - Constructor for class org.h2.engine.Database
database - Variable in class org.h2.engine.DbObject
  The database.
DATABASE_ALREADY_OPEN_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90020` is thrown when trying to open a database in embedded mode if this database is already in use in another process (or in a different class loader).
DATABASE_CALLED_AT_SHUTDOWN - Static variable in class org.h2.api.ErrorCode
  The error with code `90121` is thrown when a database operation is started while the virtual machine exits (for example in a shutdown hook), or when the session is closed.
DATABASE_IS_CLOSED - Static variable in class org.h2.api.ErrorCode
  The error with code `90098` is thrown when the database has been closed, for example because the system ran out of memory or because the self-destruction counter has reached zero.
DATABASE_IS_IN_EXCLUSIVE_MODE - Static variable in class org.h2.api.ErrorCode
  The error with code `90135` is thrown when trying to open a connection to a database that is currently open in exclusive mode.
DATABASE_IS_NOT_PERSISTENT - Static variable in class org.h2.api.ErrorCode
  The error with code `90126` is thrown when trying to call the BACKUP statement for an in-memory database.
DATABASE_IS_READ_ONLY - Static variable in class org.h2.api.ErrorCode
  The error with code `90097` is thrown when trying to delete or update a database if it is open in read-only mode.
DATABASE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90013` is thrown when when trying to access a database object with a catalog name that does not match the database name.
DATABASE_NOT_FOUND_WITH_IF_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90146` is thrown when trying to open a database that does not exist using the flag IFEXISTS=TRUE
DatabaseEventListener - Interface in org.h2.api
  A class that implements this interface can get notified about exceptions and other events.
databaseToLower - Variable in class org.h2.engine.DbSettings
  Database setting `DATABASE_TO_LOWER` (default: false).
databaseToLower - Variable in class org.h2.engine.Session.StaticSettings
  Whether unquoted identifiers are converted to lower case.
databaseToUpper - Variable in class org.h2.engine.DbSettings
  Database setting `DATABASE_TO_UPPER` (default: true).
databaseToUpper - Variable in class org.h2.engine.Session.StaticSettings
  Whether unquoted identifiers are converted to upper case.
dataDefinitionCausesTransactionCommit() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether CREATE/DROP commit an open transaction.
dataDefinitionIgnoredInTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether CREATE/DROP do not affect transactions.
DATASOURCE_TRACE_LEVEL - Static variable in class org.h2.engine.SysProperties
  System property `h2.dataSourceTraceLevel` (default: 1).
DATE - Static variable in class org.h2.api.H2Type
  The DATE data type.
dateIsTimestamp0 - Variable in class org.h2.engine.Mode
  Whether DATE data type is parsed as TIMESTAMP(0).
dateTimeValueWithinTransaction - Variable in class org.h2.engine.Mode
  If `true`, datetime value function return the same value within a transaction, if `false` datetime value functions return the same value within a command.
dbCloseOnExit - Variable in class org.h2.engine.DbSettings
  Database setting `DB_CLOSE_ON_EXIT` (default: true).
DbObject - Class in org.h2.engine
  A database object such as a table, an index, or a user.
DbObject(Database, int, String, int) - Constructor for class org.h2.engine.DbObject
  Initialize some attributes of this object.
DbSettings - Class in org.h2.engine
  This class contains various database-level settings.
DEADLOCK_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `40001` is thrown when the database engine has detected a deadlock.
DEADLOCK_CHECK - Static variable in class org.h2.engine.Constants
  The number of milliseconds after which to check for a deadlock if locking is not successful.
DECFLOAT - Static variable in class org.h2.api.H2Type
  The DECFLOAT data type.
decimalSequences - Variable in class org.h2.engine.Mode
  If `true` NEXT VALUE FOR SEQUENCE, CURRENT VALUE FOR SEQUENCE, SEQUENCE.NEXTVAL, and SEQUENCE.CURRVAL return values with DECIMAL/NUMERIC data type instead of BIGINT.
DEFAULT - Static variable in class org.h2.engine.DbSettings
  INTERNAL.
DEFAULT_HTTP_PORT - Static variable in class org.h2.engine.Constants
  The default port number of the HTTP server (for the H2 Console).
DEFAULT_LOCK_MODE - Static variable in class org.h2.engine.Constants
  The default value for the LOCK_MODE setting.
DEFAULT_MAX_LENGTH_INPLACE_LOB - Static variable in class org.h2.engine.Constants
  The default maximum length of an LOB that is stored with the record itself, and not in a separate place.
DEFAULT_MAX_OPERATION_MEMORY - Static variable in class org.h2.engine.Constants
  The default for the setting MAX_OPERATION_MEMORY.
DEFAULT_PAGE_SIZE - Static variable in class org.h2.engine.Constants
  The default page size to use for new databases.
DEFAULT_RESULT_SET_CONCURRENCY - Static variable in class org.h2.engine.Constants
  The default result set concurrency for statements created with Connection.createStatement() or prepareStatement(String sql).
DEFAULT_TCP_PORT - Static variable in class org.h2.engine.Constants
  The default port of the TCP server.
DEFAULT_WRITE_DELAY - Static variable in class org.h2.engine.Constants
  The default delay in milliseconds before the transaction log is written.
defaultConnection - Variable in class org.h2.engine.DbSettings
  Database setting `DEFAULT_CONNECTION` (default: false).
defaultEscape - Variable in class org.h2.engine.DbSettings
  Database setting `DEFAULT_ESCAPE` (default: \).
defaultTableEngine - Variable in class org.h2.engine.DbSettings
  Database setting `DEFAULT_TABLE_ENGINE` (default: null).
defragAlways - Variable in class org.h2.engine.DbSettings
  Database setting `DEFRAG_ALWAYS` (default: false) Each time the database is closed normally, it is fully defragmented (the same as SHUTDOWN DEFRAG).
deinterleave(int, long, int) - Method in class org.h2.tools.MultiDimension
  Gets one of the original multi-dimensional values from a scalar value.
DELAY_WRONG_PASSWORD_MAX - Static variable in class org.h2.engine.SysProperties
  System property `h2.delayWrongPasswordMax` (default: 4000).
DELAY_WRONG_PASSWORD_MIN - Static variable in class org.h2.engine.SysProperties
  System property `h2.delayWrongPasswordMin` (default: 250).
DELETE - Static variable in interface org.h2.api.Trigger
  The trigger is called for DELETE statements.
DELETE - Static variable in class org.h2.engine.Right
  The right bit mask that means: deleting rows from a table is allowed.
DeleteDbFiles - Class in org.h2.tools
  Deletes all files belonging to a database.
DeleteDbFiles() - Constructor for class org.h2.tools.DeleteDbFiles
deleteIdentifierFrom - Variable in class org.h2.engine.Mode
  If `true` DELETE identifier FROM is allowed
deleteRow() - Method in class org.h2.jdbc.JdbcResultSet
  Deletes the current row.
deleteRow() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
deletesAreDetected(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether deletes are detected.
DESERIALIZATION_FAILED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90027` is thrown when an object could not be de-serialized.
deserialize(byte[]) - Method in interface org.h2.api.JavaObjectSerializer
  Deserialize object from byte array.
disallowedTypes - Variable in class org.h2.engine.Mode
  An optional Set of hidden/disallowed column types.
discardWithTableHints - Variable in class org.h2.engine.Mode
  Discard SQLServer table hints (e.g.
dispose() - Method in class org.h2.jdbcx.JdbcConnectionPool
  Closes all unused pooled connections.
DIVISION_BY_ZERO_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `22012` is thrown when trying to divide a value by zero.
doesMaxRowSizeIncludeBlobs() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the maximum row size includes blobs.
DOMAIN - Static variable in class org.h2.engine.DbObject
  This object is a domain.
DOMAIN_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90119` is thrown when trying to create a domain if an object with this name already exists, or when trying to overload a built-in data type.
DOMAIN_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90120` is thrown when trying to drop a domain that doesn't exist.
done(Transfer) - Method in class org.h2.engine.SessionRemote
  Called to flush the output after data has been sent to the server and just before receiving data.
DOUBLE_PRECISION - Static variable in class org.h2.api.H2Type
  The DOUBLE PRECISION data type.
DRIVER_VERSION_ERROR_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90047` is thrown when trying to connect to a TCP server with an incompatible client.
dropAll(Connection) - Static method in class org.h2.fulltext.FullText
  Drops all full text indexes from the database.
dropAll(Connection) - Static method in class org.h2.fulltext.FullTextLucene
  Drops all full text indexes from the database.
dropIndex(Connection, String, String) - Static method in class org.h2.fulltext.FullText
  Drop an existing full text index for a table.
dropIndex(Connection, String, String) - Static method in class org.h2.fulltext.FullTextLucene
  Drop an existing full text index for a table.
dropRestrict - Variable in class org.h2.engine.DbSettings
  Database setting `DROP_RESTRICT` (default: true) Whether the default action for DROP TABLE, DROP VIEW, DROP SCHEMA, DROP DOMAIN, and DROP CONSTRAINT is RESTRICT.
DUPLICATE_COLUMN_NAME_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42121` is thrown when trying to create a table or insert into a table and use the same column name twice.
DUPLICATE_KEY_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `23505` is thrown when trying to insert a row that would violate a unique index or primary key.
DUPLICATE_PROPERTY_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90066` is thrown when the same property appears twice in the database URL or in the connection properties.
DynamicSettings(Mode, TimeZoneProvider) - Constructor for class org.h2.engine.Session.DynamicSettings
  Creates new instance of dynamic settings.

## E

ENABLE_ANONYMOUS_TLS - Static variable in class org.h2.engine.SysProperties
  System property `h2.enableAnonymousTLS` (default: true).
ENCRYPTION_KEY_HASH_ITERATIONS - Static variable in class org.h2.engine.Constants
  The password is hashed this many times to slow down dictionary attacks.
end(Xid, int) - Method in class org.h2.jdbcx.JdbcXAConnection
  End a transaction.
endStatement() - Method in class org.h2.engine.SessionLocal
  Mark the statement as completed.
Engine - Class in org.h2.engine
  The engine contains a map of all open databases.
enquoteIdentifier(String, boolean) - Method in class org.h2.jdbc.JdbcStatement
enquoteIdentifier(String, boolean) - Method in interface org.h2.jdbc.JdbcStatementBackwardsCompat
  Enquotes the specified identifier.
ENUM - Static variable in class org.h2.api.H2Type
  The ENUM data type.
ENUM_DUPLICATE - Static variable in class org.h2.api.ErrorCode
  The error with code `22033` is thrown when an attempt is made to add or modify an ENUM-typed column so that it would have duplicate values.
ENUM_EMPTY - Static variable in class org.h2.api.ErrorCode
  The error with code `22032` is thrown when an attempt is made to add or modify an ENUM-typed column so that one or more of its enumerators would be empty.
ENUM_VALUE_NOT_PERMITTED - Static variable in class org.h2.api.ErrorCode
  The error with code `22030` is thrown when an attempt is made to INSERT or UPDATE an ENUM-typed cell, but the value is not one of the values enumerated by the type.
equals(Object) - Method in class org.h2.api.Interval
equalsIdentifiers(String, String) - Method in class org.h2.engine.Database
  Compare two identifiers (table names, column names,...) and verify they are equal.
ERROR_ACCESSING_LINKED_TABLE_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90111` is thrown when an exception occurred while accessing a linked table.
ERROR_CREATING_TRIGGER_OBJECT_3 - Static variable in class org.h2.api.ErrorCode
  The error with code `90043` is thrown when there is an error initializing the trigger, for example because the class does not implement the Trigger interface.
ERROR_EXECUTING_TRIGGER_3 - Static variable in class org.h2.api.ErrorCode
  The error with code `90044` is thrown when an exception or error occurred while calling the triggers fire method.
ERROR_OPENING_DATABASE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `8000` is thrown when there was a problem trying to create a database lock.
ERROR_SETTING_DATABASE_EVENT_LISTENER_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90099` is thrown when an error occurred trying to initialize the database event listener.
ErrorCode - Class in org.h2.api
  This class defines the error codes used for SQL exceptions.
estimatedFunctionTableRows - Variable in class org.h2.engine.DbSettings
  Database setting `ESTIMATED_FUNCTION_TABLE_ROWS` (default: 1000).
EXCEPTION_IN_FUNCTION_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90105` is thrown when an exception occurred in a user-defined method.
EXCEPTION_OPENING_PORT_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90061` is thrown when trying to start a server if a server is already running at the same port.
exceptionThrown(SQLException, String) - Method in interface org.h2.api.DatabaseEventListener
  This method is called if an exception occurred.
exceptionThrown(SQLException, String) - Method in class org.h2.engine.Database
  This method is called after an exception occurred, to inform the database event listener (if one is set).
execute() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Executes an arbitrary statement.
execute(String) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns type of its result.
execute(String, int) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns type of its result.
execute(String, int[]) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns type of its result.
execute(String, String[]) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns type of its result.
execute(String, String, String, boolean) - Static method in class org.h2.tools.Backup
  Backs up database files.
execute(String, String, String, char[], char[], boolean) - Static method in class org.h2.tools.ChangeFileEncryption
  Changes the password for a database.
execute(String, String, String, String, String) - Method in class org.h2.tools.CreateCluster
  Creates a cluster.
execute(String, String, boolean) - Static method in class org.h2.tools.DeleteDbFiles
  Deletes the database files.
execute(String, String) - Static method in class org.h2.tools.Recover
  Dumps the contents of a database to a SQL script file.
execute(String, String, String) - Static method in class org.h2.tools.Restore
  Restores database files.
execute(Connection, Reader) - Static method in class org.h2.tools.RunScript
  Executes the SQL commands read from the reader against a database.
execute(String, String, String, String, Charset, boolean) - Static method in class org.h2.tools.RunScript
  Executes the SQL commands in a script file against a database.
executeBatch() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Executes the batch.
executeBatch() - Method in class org.h2.jdbc.JdbcStatement
  Executes the batch.
executeLargeBatch() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Executes the batch.
executeLargeBatch() - Method in class org.h2.jdbc.JdbcStatement
  Executes the batch.
executeLargeUpdate() - Method in class org.h2.jdbc.JdbcCallableStatement
  Executes a statement (insert, update, delete, create, drop) and returns the update count.
executeLargeUpdate() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Executes a statement (insert, update, delete, create, drop) and returns the update count.
executeLargeUpdate(String) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement (insert, update, delete, create, drop) and returns the update count.
executeLargeUpdate(String, int) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns the update count.
executeLargeUpdate(String, int[]) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns the update count.
executeLargeUpdate(String, String[]) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns the update count.
executeQuery() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Executes a query (select statement) and returns the result set.
executeQuery(String) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Calling this method is not legal on a PreparedStatement.
executeQuery(String) - Method in class org.h2.jdbc.JdbcStatement
  Executes a query (select statement) and returns the result set.
executeUpdate() - Method in class org.h2.jdbc.JdbcCallableStatement
  Executes a statement (insert, update, delete, create, drop) and returns the update count.
executeUpdate() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Executes a statement (insert, update, delete, create, drop) and returns the update count.
executeUpdate(String) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement (insert, update, delete, create, drop) and returns the update count.
executeUpdate(String, int) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns the update count.
executeUpdate(String, int[]) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns the update count.
executeUpdate(String, String[]) - Method in class org.h2.jdbc.JdbcStatement
  Executes a statement and returns the update count.
executionTimeCumulativeNanos - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The total execution time.
executionTimeMaxNanos - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The maximum execution time, in nanoseconds.
executionTimeMeanNanos - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The mean execution time.
executionTimeMinNanos - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The minimum execution time, in nanoseconds.
expand(byte[]) - Method in class org.h2.tools.CompressTool
  Expands the compressed data.
expand(byte[], byte[], int) - Static method in class org.h2.tools.CompressTool
  INTERNAL
expressionNames - Variable in class org.h2.engine.Mode
  How column names are generated for expressions.

## F

FEATURE_NOT_SUPPORTED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `50100` is thrown when calling an unsupported JDBC method or database feature.
fetchSize - Variable in class org.h2.jdbc.JdbcStatement
FILE_BLOCK_SIZE - Static variable in class org.h2.engine.Constants
  The block of a file.
FILE_CORRUPTED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90030` is thrown when the database engine has detected a checksum mismatch in the data or index.
FILE_CREATION_FAILED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90062` is thrown when a directory or file could not be created.
FILE_DELETE_FAILED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90025` is thrown when a file could not be deleted, because it is still in use (only in Windows), or because an error occurred when deleting.
FILE_ENCRYPTION_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90049` is thrown when trying to open an encrypted database with the wrong file encryption password or algorithm.
FILE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90124` is thrown when trying to access a file that doesn't exist.
FILE_RENAME_FAILED_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90024` is thrown when a file could not be renamed.
FILE_VERSION_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90048` is thrown when the file header of a database files (*.db) does not match the expected version, or if it is corrupted.
findColumn(String) - Method in class org.h2.jdbc.JdbcResultSet
  Searches for a specific column in the result set.
findColumn(String) - Method in class org.h2.tools.SimpleResultSet
  Searches for a specific column in the result set.
findComment(DbObject) - Method in class org.h2.engine.Database
  Get the comment for the given database object if one exists, or null if not.
findLocalTempTable(String) - Method in class org.h2.engine.SessionLocal
  Get the local temporary table if one exists with that name, or null if not.
findLocalTempTableConstraint(String) - Method in class org.h2.engine.SessionLocal
  Get the local temporary constraint if one exists with that name, or null if not.
findLocalTempTableIndex(String) - Method in class org.h2.engine.SessionLocal
  Get the local temporary index if one exists with that name, or null if not.
findRole(String) - Method in class org.h2.engine.Database
  Get the role if it exists, or null if not.
findSchema(String) - Method in class org.h2.engine.Database
  Get the schema if it exists, or null if not.
findSetting(String) - Method in class org.h2.engine.Database
  Get the setting if it exists, or null if not.
findUser(String) - Method in class org.h2.engine.Database
  Get the user if it exists, or null if not.
findUserOrRole(String) - Method in class org.h2.engine.Database
  Get the user or role if it exists, or `null` if not.
fire(Connection, Object[], Object[]) - Method in interface org.h2.api.Trigger
  This method is called for each triggered action.
fire(Connection, Object[], Object[]) - Method in class org.h2.fulltext.FullText.FullTextTrigger
  INTERNAL
fire(Connection, Object[], Object[]) - Method in class org.h2.fulltext.FullTextLucene.FullTextTrigger
  INTERNAL
fire(Connection, Object[], Object[]) - Method in class org.h2.tools.TriggerAdapter
fire(Connection, ResultSet, ResultSet) - Method in class org.h2.tools.TriggerAdapter
  This method is called for each triggered action by the default fire(Connection conn, Object[] oldRow, Object[] newRow) method.
first() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to the first row.
first() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
flush() - Method in class org.h2.engine.Database
  Flush all pending changes to the transaction log.
FOR_UPDATE_IS_NOT_ALLOWED_IN_DISTINCT_OR_GROUPED_SELECT - Static variable in class org.h2.api.ErrorCode
  The error with code `90145` is thrown when trying to execute a SELECT statement with non-window aggregates, DISTINCT, GROUP BY, or HAVING clauses together with FOR UPDATE clause.
forBitData - Variable in class org.h2.engine.Mode
  If `true` 'FOR BIT DATA' clauses are allowed for character string data types.
FORCE_AUTOCOMMIT_OFF_ON_COMMIT - Static variable in class org.h2.engine.SysProperties
  System property `h2.forceAutoCommitOffOnCommit` (default: false).
forget(Xid) - Method in class org.h2.jdbcx.JdbcXAConnection
  Forget a transaction.
free() - Method in class org.h2.jdbc.JdbcArray
  Release all resources of this object.
free() - Method in class org.h2.jdbc.JdbcLob
  Release all resources of this object.
free() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
fromJdbc(int) - Static method in enum org.h2.engine.IsolationLevel
  Returns the isolation level from LOCK_MODE equivalent for PageStore and old versions of H2.
fromLockMode(int) - Static method in enum org.h2.engine.IsolationLevel
  Returns the isolation level from LOCK_MODE equivalent for PageStore and old versions of H2.
fromSql(String) - Static method in enum org.h2.engine.IsolationLevel
  Returns the isolation level from its SQL name.
FULL_VERSION - Static variable in class org.h2.engine.Constants
  The complete version number of this database, consisting of the major version, the minor version, the build id, and the build date.
FullText - Class in org.h2.fulltext
  This class implements the native full text search.
FullText() - Constructor for class org.h2.fulltext.FullText
FullText.FullTextTrigger - Class in org.h2.fulltext
  Trigger updates the index when a inserting, updating, or deleting a row.
FullTextLucene - Class in org.h2.fulltext
  This class implements the full text search based on Apache Lucene.
FullTextLucene() - Constructor for class org.h2.fulltext.FullTextLucene
FullTextLucene.FullTextTrigger - Class in org.h2.fulltext
  Trigger updates the index when a inserting, updating, or deleting a row.
FullTextTrigger() - Constructor for class org.h2.fulltext.FullText.FullTextTrigger
FullTextTrigger() - Constructor for class org.h2.fulltext.FullTextLucene.FullTextTrigger
FUNCTION_ALIAS - Static variable in class org.h2.engine.DbObject
  This object is an alias for a Java function.
FUNCTION_ALIAS_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90076` is thrown when trying to create a function alias for a system function or for a function that is already defined.
FUNCTION_ALIAS_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90077` is thrown when trying to drop a system function or a function alias that does not exist.
FUNCTION_MUST_RETURN_RESULT_SET_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90000` is thrown when a function that does not return a result set was used in the FROM clause.
FUNCTION_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90022` is thrown when trying to call a unknown function.

## G

GENERAL_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `50000` is thrown when something unexpected occurs, for example an internal stack overflow.
GENERATED_COLUMN_CANNOT_BE_ASSIGNED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90154` is thrown when trying to assign a value to a generated column.
GENERATED_COLUMN_CANNOT_BE_UPDATABLE_BY_CONSTRAINT_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90155` is thrown when trying to create a referential constraint that can update a referenced generated column.
generatedKeyAlwaysReturned() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether database always returns generated keys if valid names or indexes of columns were specified and command was completed successfully.
generatedKeys - Variable in class org.h2.jdbc.JdbcStatement
GeneratedKeysMode - Class in org.h2.engine
  Modes of generated keys' gathering.
generatePreparedQuery(String, String, String[]) - Method in class org.h2.tools.MultiDimension
  Generates an optimized multi-dimensional range query.
GEOMETRY - Static variable in class org.h2.api.H2Type
  The GEOMETRY data type.
get(String, boolean) - Method in class org.h2.engine.SettingsBase
  Get the setting for the given key.
get(String, int) - Method in class org.h2.engine.SettingsBase
  Get the setting for the given key.
get(String, String) - Method in class org.h2.engine.SettingsBase
  Get the setting for the given key.
GET_JDBC_META - Static variable in class org.h2.engine.SessionRemote
getActiveConnections() - Method in class org.h2.jdbcx.JdbcConnectionPool
  Returns the number of active (open) connections of this pool.
getAllComments() - Method in class org.h2.engine.Database
getAllowLiterals() - Method in class org.h2.engine.Database
getAllowLiterals() - Method in class org.h2.engine.SessionLocal
getAllRights() - Method in class org.h2.engine.Database
getAllSchemas() - Method in class org.h2.engine.Database
getAllSchemasNoMeta() - Method in class org.h2.engine.Database
getAllSettings() - Method in class org.h2.engine.Database
getAllSynonyms() - Method in class org.h2.engine.Database
  Get all synonyms.
getAllTablesAndViews() - Method in class org.h2.engine.Database
  Get all tables and views.
getAllUsersAndRoles() - Method in class org.h2.engine.Database
getArray() - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a Java array.
getArray(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a Java array.
getArray(long, int) - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a Java array.
getArray(long, int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a Java array.
getArray(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as an Array.
getArray(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as an Array.
getArray(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an Array.
getArray(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an Array.
getArray(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Array.
getArray(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Array.
getArray() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  Get the object array.
getArray(Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getArray(long, int) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getArray(long, int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getAsciiStream() - Method in class org.h2.jdbc.JdbcClob
  Returns the input stream.
getAsciiStream(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an input stream.
getAsciiStream(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an input stream.
getAsciiStream(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getAsciiStream(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getAttributes(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  [Not supported]
getAuthenticator() - Method in class org.h2.engine.Database
  get authenticator for database users
getAutoClose() - Method in class org.h2.tools.SimpleResultSet
  Get the current auto-close behavior.
getAutoCommit() - Method in class org.h2.engine.Session
  Check if this session is in auto-commit mode.
getAutoCommit() - Method in class org.h2.engine.SessionLocal
getAutoCommit() - Method in class org.h2.engine.SessionRemote
getAutoCommit() - Method in class org.h2.jdbc.JdbcConnection
  Gets the current setting for auto commit.
getBackgroundException() - Method in class org.h2.engine.Database
getBaseDir() - Static method in class org.h2.engine.SysProperties
  INTERNAL
getBaseType() - Method in class org.h2.jdbc.JdbcArray
  Returns the base type of the array.
getBaseType() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  Get the base type of this array.
getBaseTypeName() - Method in class org.h2.jdbc.JdbcArray
  Returns the base type name of the array.
getBaseTypeName() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  Get the base type name of this array.
getBestRowIdentifier(String, String, String, int, boolean) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of columns that best identifier a row in a table.
getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Deprecated.
  use `JdbcCallableStatement.getBigDecimal(int)`
getBigDecimal(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a BigDecimal.
getBigDecimal(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a BigDecimal.
getBigDecimal(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a BigDecimal.
getBigDecimal(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a BigDecimal.
getBigDecimal(String, int) - Method in class org.h2.jdbc.JdbcResultSet
  Deprecated.
  use `JdbcResultSet.getBigDecimal(String)`
getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcResultSet
  Deprecated.
  use `JdbcResultSet.getBigDecimal(int)`
getBigDecimal(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.math.BigDecimal.
getBigDecimal(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.math.BigDecimal.
getBigDecimal(int, int) - Method in class org.h2.tools.SimpleResultSet
  Deprecated.
  INTERNAL
getBigDecimal(String, int) - Method in class org.h2.tools.SimpleResultSet
  Deprecated.
  INTERNAL
getBinaryStream() - Method in class org.h2.jdbc.JdbcBlob
getBinaryStream(long, long) - Method in class org.h2.jdbc.JdbcBlob
  Returns the input stream, starting from an offset.
getBinaryStream(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an input stream.
getBinaryStream(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an input stream.
getBinaryStream() - Method in class org.h2.jdbc.JdbcSQLXML
getBinaryStream(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.io.InputStream.
getBinaryStream(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.io.InputStream.
getBlob(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Blob.
getBlob(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Blob.
getBlob(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a Blob.
getBlob(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a Blob.
getBlob(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Blob.
getBlob(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Blob.
getBlockingSessionId() - Method in class org.h2.engine.SessionLocal
getBoolean(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a boolean.
getBoolean(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a boolean.
getBoolean(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a boolean.
getBoolean(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a boolean.
getBoolean(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a boolean.
getBoolean(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a boolean.
getBranchQualifier() - Method in class org.h2.jdbcx.JdbcXid
  The transaction branch identifier.
getByte(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a byte.
getByte(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a byte.
getByte(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a byte.
getByte(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a byte.
getByte(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a byte.
getByte(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a byte.
getBytes(long, int) - Method in class org.h2.jdbc.JdbcBlob
  Returns some bytes of the object.
getBytes(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a byte array.
getBytes(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a byte array.
getBytes(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a byte array.
getBytes(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a byte array.
getBytes(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a byte array.
getBytes(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a byte array.
getCacheType() - Method in class org.h2.engine.Database
getCancel() - Method in class org.h2.engine.SessionLocal
  Get the cancel time.
getCaseSensitiveColumnNames() - Method in class org.h2.tools.Csv
  Get the current case sensitive column names setting.
getCatalog() - Method in class org.h2.jdbc.JdbcConnection
  Gets the current catalog name.
getCatalogName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the catalog name.
getCatalogName(int) - Method in class org.h2.tools.SimpleResultSet
  Returns empty string.
getCatalogs() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of catalogs.
getCatalogSeparator() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the catalog separator.
getCatalogTerm() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the term for "catalog".
getCharacterStream(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a reader.
getCharacterStream(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a reader.
getCharacterStream() - Method in class org.h2.jdbc.JdbcClob
getCharacterStream(long, long) - Method in class org.h2.jdbc.JdbcClob
  Returns the reader, starting from an offset.
getCharacterStream(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a reader.
getCharacterStream(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a reader.
getCharacterStream() - Method in class org.h2.jdbc.JdbcSQLXML
getCharacterStream(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.io.Reader.
getCharacterStream(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.io.Reader.
getChildren() - Method in class org.h2.engine.DbObject
  Get the list of dependent children (for tables, this includes indexes and so on).
getChildren() - Method in class org.h2.engine.Role
getChildren() - Method in class org.h2.engine.User
getClientInfo() - Method in class org.h2.jdbc.JdbcConnection
  Get the client properties.
getClientInfo(String) - Method in class org.h2.jdbc.JdbcConnection
  Get a client property.
getClientInfoProperties() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
getClientVersion() - Method in class org.h2.engine.SessionRemote
  Returns the TCP protocol version of remote connection.
getClob(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Clob.
getClob(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Clob.
getClob(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a Clob.
getClob(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a Clob.
getClob(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Clob.
getClob(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Clob.
getCluster() - Method in class org.h2.engine.Database
getClusterServers() - Method in class org.h2.engine.Session
  Get the list of the cluster servers for this session.
getClusterServers() - Method in class org.h2.engine.SessionLocal
getClusterServers() - Method in class org.h2.engine.SessionRemote
getColumnClassName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Gets the Java class name of the object that will be returned if ResultSet.getObject is called.
getColumnClassName(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the Java class name if this column.
getColumnCount() - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the number of columns.
getColumnCount() - Method in class org.h2.tools.SimpleResultSet
  Returns the column count.
getColumnDisplaySize(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Gets the maximum display size for this column.
getColumnDisplaySize(int) - Method in class org.h2.tools.SimpleResultSet
  Returns 15.
getColumnLabel(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the column label.
getColumnLabel(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the column label.
getColumnName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the column name.
getColumnName(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the column name.
getColumnPrivileges(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of column privileges.
getColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of columns.
getColumnType(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the data type of a column.
getColumnType(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the SQL type.
getColumnTypeName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the data type name of a column.
getColumnTypeName(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the data type name of a column.
getCommandStartOrEnd() - Method in class org.h2.engine.SessionLocal
getComment() - Method in class org.h2.engine.DbObject
  Get the current comment of this object.
getCompareMode() - Method in class org.h2.engine.Database
getCompareMode() - Method in class org.h2.engine.SessionRemote
getCompareMode() - Method in class org.h2.tools.Recover
getCompiler() - Method in class org.h2.engine.Database
getConcurrency() - Method in class org.h2.jdbc.JdbcResultSet
  Gets the result set concurrency.
getConcurrency() - Method in class org.h2.tools.SimpleResultSet
  Returns ResultSet.CONCUR_READ_ONLY.
getConnection() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the connection that created this object.
getConnection() - Method in class org.h2.jdbc.JdbcStatement
  Returns the connection that created this object.
getConnection() - Method in class org.h2.jdbcx.JdbcConnectionPool
  Retrieves a connection from the connection pool.
getConnection(String, String) - Method in class org.h2.jdbcx.JdbcConnectionPool
  INTERNAL
getConnection() - Method in class org.h2.jdbcx.JdbcDataSource
  Open a new connection using the current URL, user name and password.
getConnection(String, String) - Method in class org.h2.jdbcx.JdbcDataSource
  Open a new connection using the current URL and the specified user name and password.
getConnection() - Method in class org.h2.jdbcx.JdbcXAConnection
  Get a connection that is a handle to the physical connection.
getCreateSQL() - Method in class org.h2.engine.Comment
getCreateSQL() - Method in class org.h2.engine.DbObject
  Construct the CREATE ...
getCreateSQL() - Method in class org.h2.engine.Right
getCreateSQL(boolean) - Method in class org.h2.engine.Role
  Get the CREATE SQL statement for this object.
getCreateSQL() - Method in class org.h2.engine.Role
getCreateSQL() - Method in class org.h2.engine.Setting
getCreateSQL() - Method in class org.h2.engine.User
getCreateSQL(boolean) - Method in class org.h2.engine.User
  Get the CREATE SQL statement for this object.
getCreateSQLForCopy(Table, String) - Method in class org.h2.engine.DbObject
  Build a SQL statement to re-create the object, or to create a copy of the object with a different name or referencing a different table
getCreateSQLForCopy(Table, String) - Method in class org.h2.engine.Right
getCreateSQLForMeta() - Method in class org.h2.engine.DbObject
  Construct the CREATE ...
getCrossReference(String, String, String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of foreign key columns that references a table, as well as the list of primary key columns that are references by a table.
getCurrentCommand() - Method in class org.h2.engine.SessionLocal
getCurrentId() - Method in class org.h2.engine.SessionRemote
getCurrentSchemaName() - Method in class org.h2.engine.Session
  Get current schema.
getCurrentSchemaName() - Method in class org.h2.engine.SessionLocal
getCurrentSchemaName() - Method in class org.h2.engine.SessionRemote
getCurrentValueFor(Sequence) - Method in class org.h2.engine.SessionLocal
  Returns the current value of the sequence in this session.
getCursorName() - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Gets the cursor name if it was defined.
getCursorName() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getDatabase() - Method in class org.h2.engine.DbObject
  Get the database.
getDatabase() - Method in class org.h2.engine.SessionLocal
getDatabaseMajorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the major version of the database.
getDatabaseMeta() - Method in class org.h2.engine.Session
  Returns database meta information.
getDatabaseMeta() - Method in class org.h2.engine.SessionLocal
getDatabaseMeta() - Method in class org.h2.engine.SessionRemote
getDatabaseMinorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the minor version of the database.
getDatabasePath() - Method in class org.h2.engine.Database
getDatabasePath() - Method in class org.h2.engine.SessionRemote
getDatabasePath() - Method in class org.h2.tools.Recover
  INTERNAL
getDatabaseProductName() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the database product name.
getDatabaseProductVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the product version of the database.
getDataHandler() - Method in class org.h2.engine.Session
  Get the data handler object.
getDataHandler() - Method in class org.h2.engine.SessionLocal
getDataHandler() - Method in class org.h2.engine.SessionRemote
getDate(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Date.
getDate(int, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Date using a specified time zone.
getDate(String, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Date using a specified time zone.
getDate(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Date.
getDate(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Date.
getDate(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Date.
getDate(int, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Date using a specified time zone.
getDate(String, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Date using a specified time zone.
getDate(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an java.sql.Date.
getDate(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Date.
getDate(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getDate(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getDays() - Method in class org.h2.api.Interval
  Returns days value, if any.
getDbSettings() - Method in class org.h2.engine.ConnectionInfo
getDefaultNullOrdering() - Method in class org.h2.engine.Database
getDefaultTableType() - Method in class org.h2.engine.Database
getDefaultTransactionIsolation() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the default transaction isolation level.
getDependentTable(SchemaObject, Table) - Method in class org.h2.engine.Database
  Get the first table that depends on this object.
getDescription() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the current description.
getDouble(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a double.
getDouble(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a double.
getDouble(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a double.
getDouble(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a double.
getDouble(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an double.
getDouble(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a double.
getDriverMajorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the major version of this driver.
getDriverMinorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the minor version of this driver.
getDriverName() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the name of the JDBC driver.
getDriverVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the version number of the driver.
getDropSQL() - Method in class org.h2.engine.DbObject
  Construct a DROP ...
getDynamicSettings() - Method in class org.h2.engine.Session
  Returns dynamic settings.
getDynamicSettings() - Method in class org.h2.engine.SessionLocal
getDynamicSettings() - Method in class org.h2.engine.SessionRemote
getEnum() - Method in class org.h2.engine.Mode
getErrorCode() - Method in interface org.h2.jdbc.JdbcException
  Returns the H2-specific error code.
getEscapeCharacter() - Method in class org.h2.tools.Csv
  Get the current escape character.
getExclusiveSession() - Method in class org.h2.engine.Database
getExecutionTimeStandardDeviation() - Method in class org.h2.engine.QueryStatisticsData.QueryEntry
getExportedKeys(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of foreign key columns that reference a table.
getExtraNameCharacters() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'.
getFetchDirection() - Method in class org.h2.jdbc.JdbcResultSet
  Gets the fetch direction.
getFetchDirection() - Method in class org.h2.jdbc.JdbcStatement
  Gets the fetch direction.
getFetchDirection() - Method in class org.h2.tools.SimpleResultSet
  Returns ResultSet.FETCH_FORWARD.
getFetchSize() - Method in class org.h2.jdbc.JdbcResultSet
  Gets the number of rows suggested to read in one step.
getFetchSize() - Method in class org.h2.jdbc.JdbcStatement
  Gets the number of rows suggested to read in one step.
getFetchSize() - Method in class org.h2.tools.SimpleResultSet
  Returns 0.
getFieldDelimiter() - Method in class org.h2.tools.Csv
  Get the current field delimiter.
getFieldSeparatorRead() - Method in class org.h2.tools.Csv
  Get the current field separator for reading.
getFieldSeparatorWrite() - Method in class org.h2.tools.Csv
  Get the current field separator for writing.
getFilePasswordHash() - Method in class org.h2.engine.ConnectionInfo
  Get the file password hash if it is set.
getFirstUserTable() - Method in class org.h2.engine.Database
  Get the first user defined table, excluding the LOB_BLOCKS table that the Recover tool creates.
getFloat(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a float.
getFloat(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a float.
getFloat(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a float.
getFloat(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a float.
getFloat(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a float.
getFloat(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a float.
getFormatId() - Method in class org.h2.jdbcx.JdbcXid
  Get the format id.
getFunctionColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  [Not supported] Gets the list of function columns.
getFunctions(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  [Not supported] Gets the list of functions.
getGeneratedKeys() - Method in class org.h2.jdbc.JdbcPreparedStatement
getGeneratedKeys() - Method in class org.h2.jdbc.JdbcStatement
  Return a result set with generated keys from the latest executed command or an empty result set if keys were not generated or were not requested with `Statement.RETURN_GENERATED_KEYS`, column indexes, or column names.
getGlobalTransactionId() - Method in class org.h2.jdbcx.JdbcXid
  The global transaction identifier.
getGrantedObject() - Method in class org.h2.engine.Right
getGrantedRole() - Method in class org.h2.engine.Right
getGrantee() - Method in class org.h2.engine.Right
getHoldability() - Method in class org.h2.jdbc.JdbcConnection
  Returns the current result set holdability.
getHoldability() - Method in class org.h2.jdbc.JdbcResultSet
  Returns the current result set holdability.
getHoldability() - Method in class org.h2.tools.SimpleResultSet
  Returns the current result set holdability.
getHours() - Method in class org.h2.api.Interval
  Returns hours value, if any.
getId() - Method in class org.h2.engine.DbObject
  Get the unique object id.
getId() - Method in class org.h2.engine.MetaRecord
getId() - Method in class org.h2.engine.SessionLocal
getIdentifierQuoteString() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the string used to quote identifiers.
getIgnoreCase() - Method in class org.h2.engine.Database
getIgnoreCatalogs() - Method in class org.h2.engine.Database
getImportedKeys(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of primary key columns that are referenced by a table.
getIndexAccess(Connection) - Static method in class org.h2.fulltext.FullTextLucene
  Get the index writer/searcher wrapper for the given connection.
getIndexInfo(String, String, String, boolean, boolean) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of indexes for this database.
getIndexPath(Connection) - Static method in class org.h2.fulltext.FullTextLucene
  Get the path of the Lucene index for this database.
getInDoubtTransactions() - Method in class org.h2.engine.Database
  Get the list of in-doubt transactions.
getInstance(String) - Static method in class org.h2.engine.Mode
  Get the mode with the given name.
getInstance() - Static method in class org.h2.tools.CompressTool
  Get a new instance.
getInstance() - Static method in class org.h2.tools.MultiDimension
  Get the singleton.
getInt(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as an int.
getInt(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as an int.
getInt(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an int.
getInt(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as an int.
getInt(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an int.
getInt(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an int.
getInternal(int) - Method in class org.h2.jdbc.JdbcResultSet
  INTERNAL
getInternalType(int[]) - Method in interface org.h2.api.Aggregate
  This method must return the H2 data type, `Value`, of the aggregate function, given the H2 data type of the input data.
getIntValue() - Method in class org.h2.engine.Setting
getIsolationLevel() - Method in class org.h2.engine.Session
  Returns the isolation level.
getIsolationLevel() - Method in class org.h2.engine.SessionLocal
getIsolationLevel() - Method in class org.h2.engine.SessionRemote
getJavaObjectSerializer() - Method in interface org.h2.engine.CastDataProvider
  Returns the custom Java object serializer, or `null`.
getJavaObjectSerializer() - Method in class org.h2.engine.Database
getJavaObjectSerializer() - Method in class org.h2.engine.SessionLocal
getJavaObjectSerializer() - Method in class org.h2.engine.SessionRemote
getJavaObjectSerializer() - Method in class org.h2.jdbc.JdbcConnection
getJdbc() - Method in enum org.h2.engine.IsolationLevel
  Returns the JDBC constant for this isolation level.
getJDBCMajorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the major version of the supported JDBC API.
getJDBCMinorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the minor version of the supported JDBC API.
getLargeMaxRows() - Method in class org.h2.jdbc.JdbcStatement
  Gets the maximum number of rows for a ResultSet.
getLargeUpdateCount() - Method in class org.h2.jdbc.JdbcStatement
  Returns the last update count of this statement.
getLastIdentity() - Method in class org.h2.engine.SessionLocal
getLastReconnect() - Method in class org.h2.engine.SessionRemote
getLeading() - Method in class org.h2.api.Interval
  Returns value of leading field of this interval.
getLineCommentCharacter() - Method in class org.h2.tools.Csv
  Get the line comment character.
getLineSeparator() - Method in class org.h2.tools.Csv
  Get the line separator used for writing.
getLinkConnection(String, String, String, String) - Method in class org.h2.engine.Database
  Open a new connection or get an existing connection to another database.
getLobFileListCache() - Method in class org.h2.engine.Database
getLobFileListCache() - Method in class org.h2.engine.SessionRemote
getLobFileListCache() - Method in class org.h2.tools.Recover
  INTERNAL
getLobSession() - Method in class org.h2.engine.Database
getLobStorage() - Method in class org.h2.engine.Database
getLobStorage() - Method in class org.h2.engine.SessionRemote
getLobStorage() - Method in class org.h2.tools.Recover
  INTERNAL
getLobSyncObject() - Method in class org.h2.engine.Database
getLobSyncObject() - Method in class org.h2.engine.SessionRemote
getLobSyncObject() - Method in class org.h2.tools.Recover
  INTERNAL
getLocalTempTableConstraints() - Method in class org.h2.engine.SessionLocal
  Get the map of constraints for all constraints on local, temporary tables, if any.
getLocalTempTableIndexes() - Method in class org.h2.engine.SessionLocal
getLocalTempTables() - Method in class org.h2.engine.SessionLocal
getLockMode() - Method in class org.h2.engine.Database
getLockMode() - Method in enum org.h2.engine.IsolationLevel
  Returns the LOCK_MODE equivalent for PageStore and old versions of H2.
getLocks() - Method in class org.h2.engine.SessionLocal
getLockTimeout() - Method in class org.h2.engine.Database
getLockTimeout() - Method in class org.h2.engine.SessionLocal
getLoginTimeout() - Method in class org.h2.jdbcx.JdbcConnectionPool
  Gets the maximum time in seconds to wait for a free connection.
getLoginTimeout() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the login timeout in seconds, 0 meaning no timeout.
getLogWriter() - Method in class org.h2.jdbcx.JdbcConnectionPool
  INTERNAL
getLogWriter() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the current log writer for this object.
getLong(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a long.
getLong(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a long.
getLong(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a long.
getLong(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a long.
getLong(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a long.
getLong(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a long.
getMainSchema() - Method in class org.h2.engine.Database
  Returns main schema (usually PUBLIC).
getMaxBinaryLiteralLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for hex values (characters).
getMaxCatalogNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for a catalog name.
getMaxCharLiteralLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for literals.
getMaxColumnNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for column names.
getMaxColumnsInGroupBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of columns in GROUP BY.
getMaxColumnsInIndex() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of columns in CREATE INDEX.
getMaxColumnsInOrderBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of columns in ORDER BY.
getMaxColumnsInSelect() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of columns in SELECT.
getMaxColumnsInTable() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of columns in CREATE TABLE.
getMaxConnections() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of open connection.
getMaxConnections() - Method in class org.h2.jdbcx.JdbcConnectionPool
  Gets the maximum number of connections to use.
getMaxCursorNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for a cursor name.
getMaxFieldSize() - Method in class org.h2.jdbc.JdbcStatement
  Gets the maximum number of bytes for a result set column.
getMaxIndexLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for an index (in bytes).
getMaxLengthInplaceLob() - Method in class org.h2.engine.Database
getMaxLengthInplaceLob() - Method in class org.h2.engine.SessionRemote
getMaxLengthInplaceLob() - Method in class org.h2.tools.Recover
  INTERNAL
getMaxMemoryRows() - Method in class org.h2.engine.Database
getMaxOperationMemory() - Method in class org.h2.engine.Database
getMaxProcedureNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for a procedure name.
getMaxRows() - Method in class org.h2.jdbc.JdbcStatement
  Gets the maximum number of rows for a ResultSet.
getMaxRowSize() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum size of a row (in bytes).
getMaxSchemaNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for a schema name.
getMaxStatementLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length of a statement.
getMaxStatements() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of open statements.
getMaxTableNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for a table name.
getMaxTablesInSelect() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum number of tables in a SELECT.
getMaxUserNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the maximum length for a user name.
getMaxValue(int) - Method in class org.h2.tools.MultiDimension
  Get the maximum value for the given dimension count.
getMessage() - Method in exception org.h2.jdbc.JdbcSQLDataException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
getMessage() - Method in exception org.h2.jdbc.JdbcSQLTransientException
getMetaData() - Method in class org.h2.jdbc.JdbcConnection
  Gets the database meta data for this database.
getMetaData() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Gets the result set metadata of the query returned when the statement is executed.
getMetaData() - Method in class org.h2.jdbc.JdbcResultSet
  Gets the meta data of this result set.
getMetaData() - Method in class org.h2.tools.SimpleResultSet
  Returns a reference to itself.
getMinutes() - Method in class org.h2.api.Interval
  Returns minutes value, if any.
getMode() - Method in interface org.h2.engine.CastDataProvider
  Returns the database mode.
getMode() - Method in class org.h2.engine.Database
getMode() - Method in class org.h2.engine.SessionLocal
getMode() - Method in class org.h2.engine.SessionRemote
getMode() - Method in class org.h2.jdbc.JdbcConnection
getModificationDataId() - Method in class org.h2.engine.Database
getModificationId() - Method in class org.h2.engine.DbObject
getModificationId() - Method in class org.h2.engine.SessionLocal
getModificationMetaId() - Method in class org.h2.engine.Database
getMonths() - Method in class org.h2.api.Interval
  Returns months value, if any.
getMoreResults() - Method in class org.h2.jdbc.JdbcStatement
  Moves to the next result set - however there is always only one result set.
getMoreResults(int) - Method in class org.h2.jdbc.JdbcStatement
  Move to the next result set.
getName() - Method in class org.h2.api.H2Type
getName() - Method in class org.h2.engine.ConnectionInfo
  Get the unique and normalized database name (excluding settings).
getName() - Method in class org.h2.engine.Database
getName() - Method in class org.h2.engine.DbObject
  Get the name.
getName() - Method in class org.h2.engine.Mode
getName() - Method in class org.h2.engine.Procedure
getNanosOfSecond() - Method in class org.h2.api.Interval
  Returns value of fractional part of seconds (in nanoseconds), if any.
getNCharacterStream(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a reader.
getNCharacterStream(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a reader.
getNCharacterStream(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a reader.
getNCharacterStream(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a reader.
getNCharacterStream(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getNCharacterStream(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getNClob(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Clob.
getNClob(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Clob.
getNClob(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a Clob.
getNClob(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a Clob.
getNClob(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getNClob(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getNetworkConnectionInfo() - Method in class org.h2.engine.ConnectionInfo
  Returns the network connection information, or `null`.
getNetworkConnectionInfo() - Method in class org.h2.engine.SessionLocal
  Returns the network connection information, or `null`.
getNetworkTimeout() - Method in class org.h2.jdbc.JdbcConnection
  [Not supported]
getNextId() - Method in class org.h2.engine.SessionRemote
getNextModificationDataId() - Method in class org.h2.engine.Database
getNextModificationMetaId() - Method in class org.h2.engine.Database
getNextRemoteSettingsId() - Method in class org.h2.engine.Database
getNextSystemIdentifier(String) - Method in class org.h2.engine.SessionLocal
  Get the next system generated identifiers.
getNextValueFor(Sequence, Prepared) - Method in class org.h2.engine.SessionLocal
  Returns the next value of the sequence in this session.
getNonKeywords() - Method in class org.h2.engine.SessionLocal
  Gets bit set of non-keywords.
getNString(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a String.
getNString(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a String.
getNString(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a String.
getNString(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a String.
getNString(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getNString(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getNullString() - Method in class org.h2.tools.Csv
  Get the current null string.
getNumericFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the list of numeric functions supported by this database.
getObject(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns a column value as a Java object.
getObject(int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Gets a column as a object using the specified type mapping.
getObject(String, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Gets a column as a object using the specified type mapping.
getObject(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns a column value as a Java object.
getObject(int, Class<T>) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Java object of the specified type.
getObject(String, Class<T>) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a Java object of the specified type.
getObject(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns a column value as a Java object.
getObject(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns a column value as a Java object.
getObject(int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Gets a column as a object using the specified type mapping.
getObject(String, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Gets a column as a object using the specified type mapping.
getObject(int, Class<T>) - Method in class org.h2.jdbc.JdbcResultSet
  Returns a column value as a Java object of the specified type.
getObject(String, Class<T>) - Method in class org.h2.jdbc.JdbcResultSet
  Returns a column value as a Java object of the specified type.
getObject(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an Object.
getObject(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an Object.
getObject(int, Class<T>) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an Object of the specified type.
getObject(String, Class<T>) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an Object of the specified type.
getObject(int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getObject(String, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getObjectInstance(Object, Name, Context, Hashtable<?, ?>) - Method in class org.h2.jdbcx.JdbcDataSourceFactory
  Creates a new object using the specified location or reference information.
getObjectType() - Method in class org.h2.engine.MetaRecord
getOptimizeReuseResults() - Method in class org.h2.engine.Database
getOriginalMessage() - Method in interface org.h2.jdbc.JdbcException
  INTERNAL
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLDataException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLTransientException
getOriginalURL() - Method in class org.h2.engine.ConnectionInfo
  Get the complete original database URL.
getPageSize() - Method in class org.h2.engine.Database
getParameterClassName(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the Java class name of the parameter.
getParameterCount() - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the number of parameters.
getParameterMetaData() - Method in class org.h2.jdbc.JdbcPreparedStatement
  Get the parameter meta data of this prepared statement.
getParameterMode(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the parameter mode.
getParameterType(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the parameter type.
getParameterTypeName(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the parameter type name.
getParentLogger() - Method in class org.h2.jdbcx.JdbcConnectionPool
  [Not supported]
getParentLogger() - Method in class org.h2.jdbcx.JdbcDataSource
  [Not supported]
getPassword() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the current password.
getPooledConnection() - Method in class org.h2.jdbcx.JdbcDataSource
  Open a new pooled connection using the current URL, user name and password.
getPooledConnection(String, String) - Method in class org.h2.jdbcx.JdbcDataSource
  Open a new pooled connection using the current URL and the specified user name and password.
getPort() - Method in class org.h2.tools.Server
  Gets the port this server is listening on.
getPowerOffCount() - Method in class org.h2.engine.Database
getPrecision(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the parameter precision.
getPrecision(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Gets the precision for this column.
getPrecision(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the precision.
getPrepared() - Method in class org.h2.engine.Procedure
getPreserveWhitespace() - Method in class org.h2.tools.Csv
  Whether whitespace in unquoted text is preserved.
getPrimaryKeys(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the primary key columns for a table.
getProcedure(String) - Method in class org.h2.engine.SessionLocal
  Get the procedure with the given name, or null if none exists.
getProcedureColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of procedure columns.
getProcedures(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of procedures.
getProcedureTerm() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the term for "procedure".
getProperty(String, boolean) - Method in class org.h2.engine.ConnectionInfo
  Get a boolean property if it is set and return the value.
getProperty(String, String) - Method in class org.h2.engine.ConnectionInfo
  Get the value of the given property.
getPseudoColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of pseudo and invisible columns.
getPublicRole() - Method in class org.h2.engine.Database
getQualifier() - Method in class org.h2.api.Interval
  Returns qualifier of this interval.
getQueries() - Method in class org.h2.engine.QueryStatisticsData
getQueryStatistics() - Method in class org.h2.engine.Database
getQueryStatisticsData() - Method in class org.h2.engine.Database
getQueryTimeout() - Method in class org.h2.engine.SessionLocal
getQueryTimeout() - Method in class org.h2.jdbc.JdbcStatement
  Gets the current query timeout in seconds.
getRandom() - Method in class org.h2.engine.SessionLocal
getRef(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Gets a column as a reference.
getRef(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Gets a column as a reference.
getRef(int) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Gets a column as a reference.
getRef(String) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Gets a column as a reference.
getRef(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getRef(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getReference() - Method in class org.h2.jdbcx.JdbcDataSource
  Get a new reference for this object, using the current settings.
getReferentialIntegrity() - Method in class org.h2.engine.Database
getRegular() - Static method in class org.h2.engine.Mode
getRemaining() - Method in class org.h2.api.Interval
  Returns combined value of remaining fields of this interval.
getRemoteSettingsId() - Method in class org.h2.engine.Database
getResult() - Method in interface org.h2.api.Aggregate
  This method returns the computed aggregate value.
getResult() - Method in interface org.h2.api.AggregateFunction
  This method returns the computed aggregate value.
getResult() - Method in class org.h2.jdbc.JdbcResultSet
  INTERNAL
getResult(PreparedStatement, int[], int[]) - Method in class org.h2.tools.MultiDimension
  Executes a prepared query that was generated using generatePreparedQuery.
getResultSet() - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a result set.
getResultSet(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a result set.
getResultSet(long, int) - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a result set.
getResultSet(long, int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
  Returns the value as a result set.
getResultSet() - Method in class org.h2.jdbc.JdbcStatement
  Returns the last result set produces by this statement.
getResultSet() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getResultSet(Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getResultSet(long, int) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getResultSet(long, int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
  INTERNAL
getResultSetConcurrency() - Method in class org.h2.jdbc.JdbcStatement
  Gets the result set concurrency created by this object.
getResultSetHoldability() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the result set holdability.
getResultSetHoldability() - Method in class org.h2.jdbc.JdbcStatement
  Gets the result set holdability.
getResultSetType() - Method in class org.h2.jdbc.JdbcStatement
  Gets the result set type.
getRetentionTime() - Method in class org.h2.engine.Database
getRightForObject(DbObject) - Method in class org.h2.engine.RightOwner
  Get the 'grant schema' right of this object.
getRightForRole(Role) - Method in class org.h2.engine.RightOwner
  Get the 'grant role' right of this object.
getRightMask() - Method in class org.h2.engine.Right
getRights() - Method in class org.h2.engine.Right
getRow() - Method in class org.h2.jdbc.JdbcResultSet
  Gets the current row number.
getRow() - Method in class org.h2.tools.SimpleResultSet
  Returns the row number (1, 2,...) or 0 for no row.
getRowCountStandardDeviation() - Method in class org.h2.engine.QueryStatisticsData.QueryEntry
getRowFactory() - Method in class org.h2.engine.Database
getRowId(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Returns the value of the specified column as a row id.
getRowId(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Returns the value of the specified column as a row id.
getRowId(int) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Returns the value of the specified column as a row id.
getRowId(String) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Returns the value of the specified column as a row id.
getRowId(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getRowId(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getRowIdLifetime() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Get the lifetime of a rowid.
getSavepointId() - Method in class org.h2.jdbc.JdbcSavepoint
  Get the generated id of this savepoint.
getSavepointName() - Method in class org.h2.jdbc.JdbcSavepoint
  Get the name of this savepoint.
getScale(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Returns the parameter scale.
getScale(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Gets the scale for this column.
getScale(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the scale.
getSchema(String) - Method in class org.h2.engine.Database
  Get the schema.
getSchema() - Method in class org.h2.jdbc.JdbcConnection
  Retrieves this current schema name for this connection.
getSchemaName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the schema name.
getSchemaName(int) - Method in class org.h2.tools.SimpleResultSet
  Returns empty string.
getSchemas() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of schemas.
getSchemas(String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of schemas in the database.
getSchemaSearchPath() - Method in class org.h2.engine.SessionLocal
getSchemaTerm() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the term for "schema".
getScriptDirectory() - Static method in class org.h2.engine.SysProperties
  System property `h2.scriptDirectory` (default: empty string).
getSearchStringEscape() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the default escape character for DatabaseMetaData search patterns.
getSeconds() - Method in class org.h2.api.Interval
  Returns value of integer part of seconds, if any.
getSecondsAndNanos() - Method in class org.h2.api.Interval
  Returns seconds value measured in nanoseconds, if any.
getService() - Method in class org.h2.tools.Server
  Get the service attached to this server.
getSession() - Method in class org.h2.jdbc.JdbcConnection
  INTERNAL
getSessionCount() - Method in class org.h2.engine.Database
getSessions(boolean) - Method in class org.h2.engine.Database
  Get all sessions that are currently connected to the database.
getSessionStart() - Method in class org.h2.engine.SessionLocal
getSettings() - Method in class org.h2.engine.Database
getSettings() - Method in class org.h2.engine.SettingsBase
  Get all settings.
getShort(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a short.
getShort(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a short.
getShort(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a short.
getShort(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a short.
getShort(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a short.
getShort(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a short.
getShortName() - Method in class org.h2.engine.Database
getSnapshotDataModificationId() - Method in class org.h2.engine.SessionLocal
  Returns the data modification id of transaction's snapshot, or 0 if isolation level doesn't use snapshots.
getSortedSettings() - Method in class org.h2.engine.SettingsBase
  Get all settings in alphabetical order.
getSource(Class<T>) - Method in class org.h2.jdbc.JdbcSQLXML
getSQL(int) - Method in class org.h2.engine.DbObject
getSQL(StringBuilder, int) - Method in class org.h2.engine.DbObject
getSQL() - Method in enum org.h2.engine.IsolationLevel
  Returns the SQL representation of this isolation level.
getSQL() - Method in class org.h2.engine.MetaRecord
getSQL(StringBuilder, int) - Method in enum org.h2.engine.NullsDistinct
getSQL(int) - Method in class org.h2.engine.Setting
getSQL(StringBuilder, int) - Method in class org.h2.engine.Setting
getSQL() - Method in interface org.h2.jdbc.JdbcException
  Returns the SQL statement.
getSQL() - Method in exception org.h2.jdbc.JdbcSQLDataException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
getSQL() - Method in exception org.h2.jdbc.JdbcSQLTransientException
getSQLKeywords() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the comma-separated list of all SQL keywords that are not supported as unquoted identifiers, in addition to the SQL:2003 reserved words.
getSQLStateType() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the SQL State type.
getSQLXML(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a SQLXML object.
getSQLXML(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a SQLXML object.
getSQLXML(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a SQLXML.
getSQLXML(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a SQLXML.
getSQLXML(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getSQLXML(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getState(int) - Static method in class org.h2.api.ErrorCode
  INTERNAL
getState() - Method in class org.h2.engine.SessionLocal
getStatement() - Method in class org.h2.jdbc.JdbcResultSet
  Returns the statement that created this object.
getStatement() - Method in class org.h2.tools.SimpleResultSet
  Returns null.
getStaticSettings() - Method in class org.h2.engine.Session
  Returns static settings.
getStaticSettings() - Method in class org.h2.engine.SessionLocal
getStaticSettings() - Method in class org.h2.engine.SessionRemote
getStaticSettings() - Method in class org.h2.jdbc.JdbcConnection
  INTERNAL
getStatus() - Method in class org.h2.tools.Server
  Get the status of this server.
getStore() - Method in class org.h2.engine.Database
getString(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a String.
getString(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a String.
getString(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a String.
getString(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a String.
getString() - Method in class org.h2.jdbc.JdbcSQLXML
getString(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a String.
getString(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a String.
getStringFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the list of string functions supported by this database.
getStringValue() - Method in class org.h2.engine.Setting
getSubString(long, int) - Method in class org.h2.jdbc.JdbcClob
  Returns a substring.
getSuperTables(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Get the list of super tables of a table.
getSuperTypes(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  [Not supported]
getSystemFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the list of system functions supported by this database.
getSystemSession() - Method in class org.h2.engine.Database
getSystemUser() - Method in class org.h2.engine.Database
  Returns system user.
getTableEngine(String) - Method in class org.h2.engine.Database
  Get the table engine class, loading it if needed.
getTableName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Returns the table name.
getTableName(int) - Method in class org.h2.tools.SimpleResultSet
  Returns empty string.
getTablePrivileges(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of table privileges.
getTables(String, String, String, String[]) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of tables in the database.
getTableTypes() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of table types.
getTempFileDeleter() - Method in class org.h2.engine.Database
getTempFileDeleter() - Method in class org.h2.engine.SessionRemote
getTempFileDeleter() - Method in class org.h2.tools.Recover
  INTERNAL
getTempTableName(String, SessionLocal) - Method in class org.h2.engine.Database
  Get a unique temporary table name.
getTime(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Time.
getTime(int, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Time using a specified time zone.
getTime(String, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Time using a specified time zone.
getTime(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Time.
getTime(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Time.
getTime(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Time.
getTime(int, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Time using a specified time zone.
getTime(String, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Time using a specified time zone.
getTime(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an java.sql.Time.
getTime(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Time.
getTime(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getTime(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getTimeDateFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the list of date and time functions supported by this database.
getTimestamp(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Timestamp.
getTimestamp(int, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
getTimestamp(String, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
getTimestamp(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns the value of the specified column as a java.sql.Timestamp.
getTimestamp(int) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Timestamp.
getTimestamp(String) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Timestamp.
getTimestamp(int, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
getTimestamp(String, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
  Returns the value of the specified column as a java.sql.Timestamp.
getTimestamp(int) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as an java.sql.Timestamp.
getTimestamp(String) - Method in class org.h2.tools.SimpleResultSet
  Returns the value as a java.sql.Timestamp.
getTimestamp(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getTimestamp(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getTimeZone() - Method in class org.h2.engine.ConnectionInfo
  Returns the time zone.
getTrace(int) - Method in class org.h2.engine.Database
  Get the trace object for the given module id.
getTrace() - Method in class org.h2.engine.Session
  Get the trace object
getTrace() - Method in class org.h2.engine.SessionLocal
getTrace() - Method in class org.h2.engine.SessionRemote
getTraceSystem() - Method in class org.h2.engine.Database
getTraceSystem() - Static method in class org.h2.jdbcx.JdbcDataSourceFactory
  INTERNAL
getTransaction() - Method in class org.h2.engine.SessionLocal
  Get the transaction to use for this session.
getTransactionId() - Method in class org.h2.engine.SessionLocal
getTransactionIsolation() - Method in class org.h2.jdbc.JdbcConnection
  Returns the current transaction isolation level.
getTransactionTimeout() - Method in class org.h2.jdbcx.JdbcXAConnection
  Get the transaction timeout.
getType(int[]) - Method in interface org.h2.api.AggregateFunction
  This method must return the SQL type of the method, given the SQL type of the input data.
getType() - Method in class org.h2.engine.Comment
getType() - Method in class org.h2.engine.DbObject
  Get the object type.
getType() - Method in class org.h2.engine.Right
getType() - Method in class org.h2.engine.Role
getType() - Method in class org.h2.engine.Setting
getType() - Method in class org.h2.engine.User
getType() - Method in class org.h2.jdbc.JdbcResultSet
  Get the result set type.
getType() - Method in class org.h2.tools.SimpleResultSet
  Returns the result set type.
getTypeInfo() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of data types.
getTypeMap() - Method in class org.h2.jdbc.JdbcConnection
  Gets the type map.
getTypeName(int, int) - Method in enum org.h2.api.IntervalQualifier
  Returns full type name.
getTypeName(StringBuilder, int, int, boolean) - Method in enum org.h2.api.IntervalQualifier
  Appends full type name to the specified string builder.
getUDTs(String, String, String, int[]) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Gets the list of user-defined data types.
getUnicodeStream(int) - Method in class org.h2.jdbc.JdbcResultSet
  Deprecated.
  since JDBC 2.0, use getCharacterStream
getUnicodeStream(String) - Method in class org.h2.jdbc.JdbcResultSet
  Deprecated.
  since JDBC 2.0, use setCharacterStream
getUnicodeStream(int) - Method in class org.h2.tools.SimpleResultSet
  Deprecated.
  INTERNAL
getUnicodeStream(String) - Method in class org.h2.tools.SimpleResultSet
  Deprecated.
  INTERNAL
getUpdateCount() - Method in class org.h2.jdbc.JdbcStatement
  Returns the last update count of this statement.
getUpdateRow() - Method in class org.h2.jdbc.JdbcResultSet
  INTERNAL
getURL() - Method in class org.h2.engine.ConnectionInfo
  Get the database URL.
getURL(int) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported]
getURL(String) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported]
getURL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the database URL for this connection.
getURL(int) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported]
getURL(String) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported]
getURL() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the current URL.
getUrl() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the current URL.
getURL() - Method in class org.h2.tools.Server
  Gets the URL of this server.
getURL(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getURL(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
getUser(String) - Method in class org.h2.engine.Database
  Get user with the given name.
getUser() - Method in class org.h2.engine.SessionLocal
getUser() - Method in class org.h2.jdbcx.JdbcDataSource
  Get the current user name.
getUserName() - Method in class org.h2.engine.ConnectionInfo
  Get the name of the user.
getUserName() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the user name as passed to DriverManager.getConnection(url, user, password).
getVariable(String) - Method in class org.h2.engine.SessionLocal
  Get the value of the specified user defined variable.
getVariableIntLength(int) - Static method in class org.h2.tools.CompressTool
  Get a variable size integer length using Rice coding.
getVariableNames() - Method in class org.h2.engine.SessionLocal
  Get the list of variable names that are set for this session.
getVendor() - Method in class org.h2.api.H2Type
getVendorTypeNumber() - Method in class org.h2.api.H2Type
  Returns the vendor specific type number for the data type.
getVersionColumns(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Get the list of columns that are update when any value is updated.
getViewIndexCache(boolean) - Method in class org.h2.engine.SessionLocal
  Get the view cache for this session.
getWaitForLock() - Method in class org.h2.engine.SessionLocal
getWaitForLockThread() - Method in class org.h2.engine.SessionLocal
getWarnings() - Method in class org.h2.jdbc.JdbcConnection
  Gets the first warning reported by calls on this object.
getWarnings() - Method in class org.h2.jdbc.JdbcResultSet
  Gets the first warning reported by calls on this object.
getWarnings() - Method in class org.h2.jdbc.JdbcStatement
  Gets the first warning reported by calls on this object.
getWarnings() - Method in class org.h2.tools.SimpleResultSet
  Returns null.
getWriteColumnHeader() - Method in class org.h2.tools.Csv
  Whether the column header is written.
getXAConnection() - Method in class org.h2.jdbcx.JdbcDataSource
  Open a new XA connection using the current URL, user name and password.
getXAConnection(String, String) - Method in class org.h2.jdbcx.JdbcDataSource
  Open a new XA connection using the current URL and the specified user name and password.
getXAResource() - Method in class org.h2.jdbcx.JdbcXAConnection
  Get the XAResource object.
getYears() - Method in class org.h2.api.Interval
  Returns years value, if any.
grantRight(DbObject, Right) - Method in class org.h2.engine.RightOwner
  Grant a right for the given table.
grantRole(Role, Right) - Method in class org.h2.engine.RightOwner
  Grant a role to this object.
GROUP_BY_NOT_IN_THE_RESULT - Static variable in class org.h2.api.ErrorCode
  The error with code `90157` is thrown when the integer index that is used in the GROUP BY is not in the SELECT list
groupByColumnIndex - Variable in class org.h2.engine.Mode
  Allow to use GROUP BY n, where n is column index in the SELECT list, similar to ORDER BY
GUIConsole - Class in org.h2.tools
  Console for environments with AWT support.
GUIConsole() - Constructor for class org.h2.tools.GUIConsole

## H

H2_BROWSER - Static variable in class org.h2.engine.SysProperties
  INTERNAL
H2_SCRIPT_DIRECTORY - Static variable in class org.h2.engine.SysProperties
  INTERNAL
H2Type - Class in org.h2.api
  Data types of H2.
hasChanged(Object[], Object[], int[]) - Static method in class org.h2.fulltext.FullText
  Check if a the indexed columns of a row probably have changed.
hasDays() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has days.
hashCode() - Method in class org.h2.api.Interval
hashCode() - Method in class org.h2.engine.SessionLocal
hasHours() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has hours.
hasMinutes() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has minutes.
hasMonths() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has months.
hasMultipleFields() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has multiple fields.
hasPendingTransaction() - Method in class org.h2.engine.Session
  Check whether this session has a pending transaction.
hasPendingTransaction() - Method in class org.h2.engine.SessionLocal
hasPendingTransaction() - Method in class org.h2.engine.SessionRemote
hasPreparedTransaction() - Method in class org.h2.engine.SessionLocal
  Checks presence of prepared transaction in this session.
hasSeconds() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has seconds.
hasTableRight(Table, int) - Method in class org.h2.engine.User
  See if this user has the given rights for this database object.
hasYears() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier has years.
HEX_STRING_ODD_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90003` is thrown when trying to convert a String to a binary value.
HEX_STRING_WRONG_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90004` is thrown when trying to convert a text to binary, but the expression contains a non-hexadecimal character.

## I

id - Variable in class org.h2.fulltext.IndexInfo
  The index id.
IDENTICAL_EXPRESSIONS_SHOULD_BE_USED - Static variable in class org.h2.api.ErrorCode
  The error with code `42131` is thrown when identical expressions should be used, but different expressions were found.
identityClause - Variable in class org.h2.engine.Mode
  Whether SQL Server-style IDENTITY clause is supported.
identityColumnsHaveDefaultOnNull - Variable in class org.h2.engine.Mode
  If `true`, identity columns have DEFAULT ON NULL clause.
identityDataType - Variable in class org.h2.engine.Mode
  Whether IDENTITY pseudo data type is supported.
ignoreCatalogs - Variable in class org.h2.engine.DbSettings
  Database setting `IGNORE_CATALOGS` (default: false).
INDEX - Static variable in class org.h2.engine.DbObject
  This object is an index.
INDEX_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42111` is thrown when trying to create an index if an index with the same name already exists.
INDEX_BELONGS_TO_CONSTRAINT_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90085` is thrown when trying to manually drop an index that was generated by the system because of a unique or referential constraint.
INDEX_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42112` is thrown when trying to drop or reference an index that does not exist.
indexColumns - Variable in class org.h2.fulltext.IndexInfo
  The column indexes of the index columns.
indexDefinitionInCreateTable - Variable in class org.h2.engine.Mode
  Creating indexes in the CREATE TABLE statement is allowed using `INDEX(..)` or `KEY(..)`.
IndexInfo - Class in org.h2.fulltext
  The settings of one full text search index.
IndexInfo() - Constructor for class org.h2.fulltext.IndexInfo
INFORMATION_SCHEMA_ID - Static variable in class org.h2.engine.Constants
  The identity of INFORMATION_SCHEMA.
init(Connection) - Method in interface org.h2.api.Aggregate
  This method is called when the aggregate function is used.
init(Connection) - Method in interface org.h2.api.AggregateFunction
  This method is called when the aggregate function is used.
init(String) - Method in interface org.h2.api.DatabaseEventListener
  This method is called just after creating the object.
init(Connection, String, String, String, boolean, int) - Method in interface org.h2.api.Trigger
  This method is called by the database engine once when initializing the trigger.
init(Connection, String, String, String, boolean, int) - Method in class org.h2.fulltext.FullText.FullTextTrigger
  INTERNAL
init(Connection) - Static method in class org.h2.fulltext.FullText
  Initializes full text search functionality for this database.
init(Connection, String, String, String, boolean, int) - Method in class org.h2.fulltext.FullTextLucene.FullTextTrigger
  INTERNAL
init(Connection) - Static method in class org.h2.fulltext.FullTextLucene
  Initializes full text search functionality for this database.
init(Connection, String, String, String, boolean, int) - Method in class org.h2.tools.TriggerAdapter
  This method is called by the database engine once when initializing the trigger.
INITIAL_LOCK_TIMEOUT - Static variable in class org.h2.engine.Constants
  For testing, the lock timeout is smaller than for interactive use cases.
INSERT - Static variable in interface org.h2.api.Trigger
  The trigger is called for INSERT statements.
INSERT - Static variable in class org.h2.engine.Right
  The right bit mask that means: inserting rows into a table is allowed.
insertOnConflict - Variable in class org.h2.engine.Mode
  PostgreSQL style INSERT ...
insertRow() - Method in class org.h2.jdbc.JdbcResultSet
  Inserts the current row.
insertRow() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
insertsAreDetected(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether inserts are detected.
INTEGER - Static variable in class org.h2.api.H2Type
  The INTEGER data type.
interleave(int...) - Method in class org.h2.tools.MultiDimension
  Convert the multi-dimensional value into a one-dimensional (scalar) value.
interleave(int, int) - Method in class org.h2.tools.MultiDimension
  Convert the two-dimensional value into a one-dimensional (scalar) value.
Interval - Class in org.h2.api
  INTERVAL representation for result sets.
Interval(IntervalQualifier, boolean, long, long) - Constructor for class org.h2.api.Interval
  Creates a new interval.
INTERVAL_DAY - Static variable in class org.h2.api.H2Type
  The INTERVAL DAY data type.
INTERVAL_DAY_TO_HOUR - Static variable in class org.h2.api.H2Type
  The INTERVAL DAY TO HOUR data type.
INTERVAL_DAY_TO_MINUTE - Static variable in class org.h2.api.H2Type
  The INTERVAL DAY TO MINUTE data type.
INTERVAL_DAY_TO_SECOND - Static variable in class org.h2.api.H2Type
  The INTERVAL DAY TO SECOND data type.
INTERVAL_HOUR - Static variable in class org.h2.api.H2Type
  The INTERVAL HOUR data type.
INTERVAL_HOUR_TO_MINUTE - Static variable in class org.h2.api.H2Type
  The INTERVAL HOUR TO MINUTE data type.
INTERVAL_HOUR_TO_SECOND - Static variable in class org.h2.api.H2Type
  The INTERVAL HOUR TO SECOND data type.
INTERVAL_MINUTE - Static variable in class org.h2.api.H2Type
  The INTERVAL MINUTE data type.
INTERVAL_MINUTE_TO_SECOND - Static variable in class org.h2.api.H2Type
  The INTERVAL MINUTE TO SECOND data type.
INTERVAL_MONTH - Static variable in class org.h2.api.H2Type
  The INTERVAL MONTH data type.
INTERVAL_SECOND - Static variable in class org.h2.api.H2Type
  The INTERVAL SECOND data type.
INTERVAL_YEAR - Static variable in class org.h2.api.H2Type
  The INTERVAL YEAR data type.
INTERVAL_YEAR_TO_MONTH - Static variable in class org.h2.api.H2Type
  The INTERVAL YEAR TO MONTH data type.
IntervalQualifier - Enum in org.h2.api
  Interval qualifier.
INVALID_CLASS_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90125` is thrown when PreparedStatement.setBigDecimal is called with object that extends the class BigDecimal.
INVALID_DATABASE_NAME_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90138` is thrown when trying to open a persistent database using an incorrect database name.
INVALID_DATETIME_CONSTANT_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `22007` is thrown when a text can not be converted to a date, time, or timestamp constant.
INVALID_NAME_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42602` is thrown when invalid name of identifier is used.
INVALID_PARAMETER_COUNT_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `7001` is thrown when trying to call a function with the wrong number of parameters.
INVALID_PRECEDING_OR_FOLLOWING_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `22013` is thrown when preceding or following size in a window function is null or negative.
INVALID_TO_CHAR_FORMAT - Static variable in class org.h2.api.ErrorCode
  The error with code `90010` is thrown when trying to format a timestamp or number using TO_CHAR with an invalid format.
INVALID_TO_DATE_FORMAT - Static variable in class org.h2.api.ErrorCode
  The error with code `90056` is thrown when trying to format a timestamp using TO_DATE and TO_TIMESTAMP with an invalid format.
INVALID_TRIGGER_FLAGS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90005` is thrown when trying to create a trigger with invalid combination of flags.
INVALID_USE_OF_AGGREGATE_FUNCTION_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90054` is thrown when an aggregate function is used where it is not allowed.
INVALID_VALUE_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90008` is thrown when trying to use a value that is not valid for the given operation.
INVALID_VALUE_PRECISION - Static variable in class org.h2.api.ErrorCode
  The error with code `90150` is thrown when trying to use an invalid precision.
INVALID_VALUE_SCALE - Static variable in class org.h2.api.ErrorCode
  The error with code `90151` is thrown when trying to use an invalid scale or fractional seconds precision.
invalidate() - Method in class org.h2.engine.DbObject
  Set the main attributes to null to make sure the object is no longer used.
IO_BUFFER_SIZE - Static variable in class org.h2.engine.Constants
  The block size for I/O operations.
IO_BUFFER_SIZE_COMPRESS - Static variable in class org.h2.engine.Constants
  The block size used to compress data in the LZFOutputStream.
IO_EXCEPTION_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90028` is thrown when an input / output error occurred.
IO_EXCEPTION_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90031` is thrown when an input / output error occurred.
isAdmin() - Method in class org.h2.engine.User
isAfterLast() - Method in class org.h2.jdbc.JdbcResultSet
  Checks if the current position is after the last row, that means next() was called and returned false, and there was at least one row.
isAfterLast() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
isAllowBuiltinAliasOverride() - Method in class org.h2.engine.Database
isAutoIncrement(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this an autoincrement column.
isAutoIncrement(int) - Method in class org.h2.tools.SimpleResultSet
  Returns false.
isBeforeFirst() - Method in class org.h2.jdbc.JdbcResultSet
  Checks if the current position is before the first row, that means next() was not called yet, and there is at least one row.
isBeforeFirst() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
isCancelled() - Method in class org.h2.jdbc.JdbcStatement
  Check whether the statement was cancelled.
isCaseSensitive(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this column is case sensitive.
isCaseSensitive(int) - Method in class org.h2.tools.SimpleResultSet
  Returns true.
isCatalogAtStart() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the catalog is at the beginning.
isClosed() - Method in class org.h2.engine.Session
  Check if close was called.
isClosed() - Method in class org.h2.engine.SessionLocal
isClosed() - Method in class org.h2.engine.SessionRemote
isClosed() - Method in class org.h2.jdbc.JdbcConnection
  Returns true if this connection has been closed.
isClosed() - Method in class org.h2.jdbc.JdbcResultSet
  Returns whether this result set is closed.
isClosed() - Method in class org.h2.jdbc.JdbcStatement
  Returns whether this statement is closed.
isClosed() - Method in class org.h2.tools.SimpleResultSet
  Returns whether this result set has been closed.
isCloseOnCompletion() - Method in class org.h2.jdbc.JdbcStatement
  Returns whether this statement will be closed when its dependent result set is closed.
isClosing() - Method in class org.h2.engine.Database
  Check if the database is in the process of closing.
isClustered() - Method in class org.h2.engine.SessionRemote
  Returns true if the connection was opened in cluster mode.
isCommon(int) - Static method in class org.h2.api.ErrorCode
  INTERNAL
isCurrency(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this is a currency column.
isCurrency(int) - Method in class org.h2.tools.SimpleResultSet
  Returns false.
isDayTime() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier is a day-time interval.
isDefinitelyWritable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks whether a write on this column will definitely succeed.
isDefinitelyWritable(int) - Method in class org.h2.tools.SimpleResultSet
  Returns false.
isFirst() - Method in class org.h2.jdbc.JdbcResultSet
  Checks if the current position is row 1, that means next() was called once and returned true.
isFirst() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
isIgnoredByParser(String) - Static method in class org.h2.engine.ConnectionInfo
  Returns whether setting with the specified name should be ignored by parser.
isLast() - Method in class org.h2.jdbc.JdbcResultSet
  Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.
isLast() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
isLazyQueryExecution() - Method in class org.h2.engine.SessionLocal
isNegative() - Method in class org.h2.api.Interval
  Returns where the interval is negative.
isNullable(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Checks if this is nullable parameter.
isNullable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this is nullable column.
isNullable(int) - Method in class org.h2.tools.SimpleResultSet
  Returns ResultSetMetaData.columnNullableUnknown.
IsolationLevel - Enum in org.h2.engine
  Level of isolation.
isolationLevelInSelectOrInsertStatement - Variable in class org.h2.engine.Mode
  can set the isolation level using WITH {RR|RS|CS|UR}
isOldInformationSchema() - Method in class org.h2.engine.Session
  Returns whether INFORMATION_SCHEMA contains old-style tables.
isOldInformationSchema() - Method in class org.h2.engine.SessionLocal
isOldInformationSchema() - Method in class org.h2.engine.SessionRemote
isOpen() - Method in class org.h2.engine.SessionLocal
isParsingCreateView() - Method in class org.h2.engine.SessionLocal
isPersistent() - Method in class org.h2.engine.ConnectionInfo
  Check if the referenced database is persistent.
isPersistent() - Method in class org.h2.engine.Database
  Check if this database is disk-based.
isPoolable() - Method in class org.h2.jdbc.JdbcStatement
  Returns whether this object is poolable.
isQuirksMode() - Method in class org.h2.engine.SessionLocal
  Returns whether quirks mode is enabled explicitly or implicitly.
isReadOnly() - Method in class org.h2.engine.Database
isReadOnly() - Method in class org.h2.jdbc.JdbcConnection
  Returns true if the database is read-only.
isReadOnly() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns the same as Connection.isReadOnly().
isReadOnly(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this column is read only.
isReadOnly(int) - Method in class org.h2.tools.SimpleResultSet
  Returns true.
isRemote() - Method in class org.h2.engine.ConnectionInfo
  Check if this is a remote connection.
isRemote() - Method in class org.h2.engine.Session
  Check if this session is remote or embedded.
isRemote() - Method in class org.h2.engine.SessionLocal
isRemote() - Method in class org.h2.engine.SessionRemote
isRoleGranted(Role) - Method in class org.h2.engine.RightOwner
  Check if a role has been granted for this right owner.
isRunning(boolean) - Method in class org.h2.tools.Server
  Checks if the server is running.
isSameRM(XAResource) - Method in class org.h2.jdbcx.JdbcXAConnection
  Checks if this is the same XAResource.
isSearchable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this column is searchable.
isSearchable(int) - Method in class org.h2.tools.SimpleResultSet
  Returns true.
isSigned(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Checks if this parameter is signed.
isSigned(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if this column is signed.
isSigned(int) - Method in class org.h2.tools.SimpleResultSet
  Returns true.
isSimpleIdentifier(String) - Method in class org.h2.jdbc.JdbcStatement
isSimpleIdentifier(String) - Method in interface org.h2.jdbc.JdbcStatementBackwardsCompat
  Checks if specified identifier may be used without quotes.
isStarting() - Method in class org.h2.engine.Database
  Check if the database is currently opening.
isSysTableLocked() - Method in class org.h2.engine.Database
  Checks if the system table (containing the catalog) is locked.
isSysTableLockedBy(SessionLocal) - Method in class org.h2.engine.Database
  Checks if the system table (containing the catalog) is locked by the given session.
isTemporary() - Method in class org.h2.engine.DbObject
  Check if this object is temporary (for example, a temporary table).
isTruncateLargeLength() - Method in class org.h2.engine.SessionLocal
  Returns parsing mode of data types with too large length.
isValid() - Method in class org.h2.engine.DbObject
isValid(int) - Method in class org.h2.jdbc.JdbcConnection
  Returns true if this connection is still valid.
isVariableBinary() - Method in class org.h2.engine.SessionLocal
  Returns BINARY data type parsing mode.
isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcConnection
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcResultSet
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcStatement
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbcx.JdbcConnectionPool
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.jdbcx.JdbcDataSource
  Checks if unwrap can return an object of this class.
isWrapperFor(Class<?>) - Method in class org.h2.tools.SimpleResultSet
  Checks if unwrap can return an object of this class.
isWritable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Checks whether it is possible for a write on this column to succeed.
isWritable(int) - Method in class org.h2.tools.SimpleResultSet
  Returns false.
isYearMonth() - Method in enum org.h2.api.IntervalQualifier
  Returns whether interval with this qualifier is a year-month interval.

## J

JAVA_OBJECT - Static variable in class org.h2.api.H2Type
  The JAVA_OBJECT data type.
JAVA_OBJECT_SERIALIZER - Static variable in class org.h2.engine.SysProperties
  System property `h2.javaObjectSerializer` (default: null).
JAVA_OBJECT_SERIALIZER_CHANGE_WITH_DATA_TABLE - Static variable in class org.h2.api.ErrorCode
  The error with code `90141` is thrown when trying to change the java object serializer while there was already data in the database.
JAVA_SYSTEM_COMPILER - Static variable in class org.h2.engine.SysProperties
  System property `h2.javaSystemCompiler` (default: true).
JavaObjectSerializer - Interface in org.h2.api
  Custom serialization mechanism for java objects being stored in column of type OTHER.
JdbcArray - Class in org.h2.jdbc
  Represents an ARRAY value.
JdbcArray(JdbcConnection, Value, int) - Constructor for class org.h2.jdbc.JdbcArray
  INTERNAL
JdbcBatchUpdateException - Exception in org.h2.jdbc
  Represents a batch update database exception.
JdbcBlob - Class in org.h2.jdbc
  Represents a BLOB value.
JdbcBlob(JdbcConnection, Value, JdbcLob.State, int) - Constructor for class org.h2.jdbc.JdbcBlob
  INTERNAL
JdbcCallableStatement - Class in org.h2.jdbc
  Represents a callable statement.
JdbcClob - Class in org.h2.jdbc
  Represents a CLOB value.
JdbcClob(JdbcConnection, Value, JdbcLob.State, int) - Constructor for class org.h2.jdbc.JdbcClob
  INTERNAL
JdbcConnection - Class in org.h2.jdbc
  Represents a connection (session) to a database.
JdbcConnection(String, Properties, String, Object, boolean) - Constructor for class org.h2.jdbc.JdbcConnection
  INTERNAL the session closable object does not leak as Eclipse warns - due to the CloseWatcher.
JdbcConnection(JdbcConnection) - Constructor for class org.h2.jdbc.JdbcConnection
  INTERNAL
JdbcConnection(Session, String, String) - Constructor for class org.h2.jdbc.JdbcConnection
  INTERNAL
JdbcConnectionBackwardsCompat - Interface in org.h2.jdbc
  Allows us to compile on older platforms, while still implementing the methods from the newer JDBC API.
JdbcConnectionPool - Class in org.h2.jdbcx
  A simple standalone JDBC connection pool.
JdbcConnectionPoolBackwardsCompat - Interface in org.h2.jdbcx
  Allows us to compile on older platforms, while still implementing the methods from the newer JDBC API.
JdbcDatabaseMetaData - Class in org.h2.jdbc
  Represents the meta data for a database.
JdbcDatabaseMetaDataBackwardsCompat - Interface in org.h2.jdbc
  Allows us to compile on older platforms, while still implementing the methods from the newer JDBC API.
JdbcDataSource - Class in org.h2.jdbcx
  A data source for H2 database connections.
JdbcDataSource() - Constructor for class org.h2.jdbcx.JdbcDataSource
  The public constructor.
JdbcDataSourceBackwardsCompat - Interface in org.h2.jdbcx
  Allows us to compile on older platforms, while still implementing the methods from the newer JDBC API.
JdbcDataSourceFactory - Class in org.h2.jdbcx
  This class is used to create new DataSource objects.
JdbcDataSourceFactory() - Constructor for class org.h2.jdbcx.JdbcDataSourceFactory
  The public constructor to create new factory objects.
JdbcException - Interface in org.h2.jdbc
  This interface contains additional methods for database exceptions.
JdbcLob - Class in org.h2.jdbc
  Represents a large object value.
JdbcLob.State - Enum in org.h2.jdbc
  State of the object.
JdbcParameterMetaData - Class in org.h2.jdbc
  Information about the parameters of a prepared statement.
JdbcPreparedStatement - Class in org.h2.jdbc
  Represents a prepared statement.
JdbcResultSet - Class in org.h2.jdbc
  Represents a result set.
JdbcResultSet(JdbcConnection, JdbcStatement, CommandInterface, ResultInterface, int, boolean, boolean, boolean) - Constructor for class org.h2.jdbc.JdbcResultSet
JdbcResultSetMetaData - Class in org.h2.jdbc
  Represents the meta data for a ResultSet.
JdbcSavepoint - Class in org.h2.jdbc
  A savepoint is a point inside a transaction to where a transaction can be rolled back.
JdbcSQLDataException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLDataException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLDataException
  Creates a SQLDataException.
JdbcSQLException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLException
  Creates a SQLException.
JdbcSQLFeatureNotSupportedException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLFeatureNotSupportedException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
  Creates a SQLFeatureNotSupportedException.
JdbcSQLIntegrityConstraintViolationException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLIntegrityConstraintViolationException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
  Creates a SQLIntegrityConstraintViolationException.
JdbcSQLInvalidAuthorizationSpecException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLInvalidAuthorizationSpecException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
  Creates a SQLInvalidAuthorizationSpecException.
JdbcSQLNonTransientConnectionException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLNonTransientConnectionException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
  Creates a SQLNonTransientConnectionException.
JdbcSQLNonTransientException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLNonTransientException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLNonTransientException
  Creates a SQLNonTransientException.
JdbcSQLSyntaxErrorException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLSyntaxErrorException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLSyntaxErrorException
  Creates a SQLSyntaxErrorException.
JdbcSQLTimeoutException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLTimeoutException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLTimeoutException
  Creates a SQLTimeoutException.
JdbcSQLTransactionRollbackException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLTransactionRollbackException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLTransactionRollbackException
  Creates a SQLTransactionRollbackException.
JdbcSQLTransientException - Exception in org.h2.jdbc
  Represents a database exception.
JdbcSQLTransientException(String, String, String, int, Throwable, String) - Constructor for exception org.h2.jdbc.JdbcSQLTransientException
  Creates a SQLTransientException.
JdbcSQLXML - Class in org.h2.jdbc
  Represents a SQLXML value.
JdbcSQLXML(JdbcConnection, Value, JdbcLob.State, int) - Constructor for class org.h2.jdbc.JdbcSQLXML
  INTERNAL
JdbcStatement - Class in org.h2.jdbc
  Represents a statement.
JdbcStatementBackwardsCompat - Interface in org.h2.jdbc
  Allows us to compile on older platforms, while still implementing the methods from the newer JDBC API.
JdbcXAConnection - Class in org.h2.jdbcx
  This class provides support for distributed transactions.
JdbcXid - Class in org.h2.jdbcx
  An object of this class represents a transaction id.
JSON - Static variable in class org.h2.api.H2Type
  The JSON data type.

## K

keys - Variable in class org.h2.fulltext.IndexInfo
  The column indexes of the key columns.

## L

last() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to the last row.
last() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
lastUpdateTime - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The last time the statistics for this entry were updated, in milliseconds since 1970.
length() - Method in class org.h2.jdbc.JdbcBlob
  Returns the length.
length() - Method in class org.h2.jdbc.JdbcClob
  Returns the length.
LIKE_ESCAPE_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `22025` is thrown when using an invalid escape character sequence for LIKE or REGEXP.
limit - Variable in class org.h2.engine.Mode
  Whether LIMIT / OFFSET clauses are supported.
LITERALS_ARE_NOT_ALLOWED - Static variable in class org.h2.api.ErrorCode
  The error with code `90116` is thrown when trying use a literal in a SQL statement if literals are disabled.
loadH2(int) - Static method in class org.h2.tools.Upgrade
  Loads the specified version of H2 in a separate class loader.
LOB_CLIENT_MAX_SIZE_MEMORY - Static variable in class org.h2.engine.SysProperties
  System property `h2.lobClientMaxSizeMemory` (default: 1048576).
LOB_CLOSED_ON_TIMEOUT_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90039` is thrown when trying to access a CLOB or BLOB object that timed out.
LOB_READ - Static variable in class org.h2.engine.SessionRemote
lobCloseBetweenReads - Static variable in class org.h2.engine.SysProperties
  System property `h2.lobCloseBetweenReads` (default: false).
lobTimeout - Variable in class org.h2.engine.DbSettings
  Database setting `LOB_TIMEOUT` (default: 300000, which means 5 minutes).
locatorsUpdateCopy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does the database make a copy before updating.
LOCK_MODE_OFF - Static variable in class org.h2.engine.Constants
  The lock mode that means no locking is used at all.
LOCK_MODE_READ_COMMITTED - Static variable in class org.h2.engine.Constants
  The lock mode that means read locks are acquired, but they are released immediately after the statement is executed.
LOCK_MODE_TABLE - Static variable in class org.h2.engine.Constants
  The lock mode that means table level locking is used for reads and writes.
LOCK_MODE_TABLE_GC - Static variable in class org.h2.engine.Constants
  The lock mode that means table level locking is used for reads and writes.
LOCK_SLEEP - Static variable in class org.h2.engine.Constants
  The number of milliseconds to wait between checking the .lock.db file still exists once a database is locked.
LOCK_TIMEOUT_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `50200` is thrown when another connection locked an object longer than the lock timeout set for this connection, or when a deadlock occurred.
lockMeta(SessionLocal) - Method in class org.h2.engine.Database
  Lock the metadata table for updates.
logIsLogBase10 - Variable in class org.h2.engine.Mode
  The single-argument function LOG() uses base 10 instead of E.

## M

main(String...) - Static method in class org.h2.tools.Backup
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.ChangeFileEncryption
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.Console
  When running without options, -tcp, -web, -browser and -pg are started.
main(String...) - Static method in class org.h2.tools.ConvertTraceFile
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.CreateCluster
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.DeleteDbFiles
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.Recover
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.Restore
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.RunScript
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.Script
  Options are case sensitive.
main(String...) - Static method in class org.h2.tools.Server
  When running without options, -tcp, -web, -browser and -pg are started.
main(String...) - Static method in class org.h2.tools.Shell
  Options are case sensitive.
MAIN_SCHEMA_ID - Static variable in class org.h2.engine.Constants
  The identity of PUBLIC schema.
mapUserToRoles(AuthenticationInfo) - Method in interface org.h2.api.UserToRolesMapper
  Map user identified by authentication info to a set of granted roles.
markTableForAnalyze(Table) - Method in class org.h2.engine.SessionLocal
  Mark that the given table needs to be analyzed on commit.
MAX_ARRAY_CARDINALITY - Static variable in class org.h2.engine.Constants
  The maximum allowed cardinality of array.
MAX_COLUMNS - Static variable in class org.h2.engine.Constants
  The maximum number of columns in a table, select statement or row value.
MAX_FILE_RETRY - Static variable in class org.h2.engine.SysProperties
  System property `h2.maxFileRetry` (default: 16).
MAX_IDENTIFIER_LENGTH - Static variable in class org.h2.engine.Constants
  The maximum allowed length of identifiers.
MAX_MEMORY_ROWS - Static variable in class org.h2.engine.SysProperties
  System property `h2.maxMemoryRows` (default: 40000 per GB of available RAM).
MAX_NUMERIC_PRECISION - Static variable in class org.h2.engine.Constants
  The maximum allowed precision of numeric data types.
MAX_PARAMETER_INDEX - Static variable in class org.h2.engine.Constants
  The highest possible parameter index.
MAX_RECONNECT - Static variable in class org.h2.engine.SysProperties
  System property `h2.maxReconnect` (default: 3).
MAX_STRING_LENGTH - Static variable in class org.h2.engine.Constants
  The maximum allowed length for character string, binary string, and other data types based on them; excluding LOB data types.
MAX_TRACE_DATA_LENGTH - Static variable in class org.h2.engine.SysProperties
  System property `h2.maxTraceDataLength` (default: 65535).
maxCompactTime - Variable in class org.h2.engine.DbSettings
  Database setting `MAX_COMPACT_TIME` (default: 200).
maxQueryTimeout - Variable in class org.h2.engine.DbSettings
  Database setting `MAX_QUERY_TIMEOUT` (default: 0).
maxRows - Variable in class org.h2.jdbc.JdbcStatement
MEMORY_ARRAY - Static variable in class org.h2.engine.Constants
  The memory needed by an array.
MEMORY_OBJECT - Static variable in class org.h2.engine.Constants
  The memory needed by a regular object with at least one field.
MEMORY_POINTER - Static variable in class org.h2.engine.Constants
  The memory needed by a pointer.
MEMORY_ROW - Static variable in class org.h2.engine.Constants
  The memory needed by a Row.
mergeWhere - Variable in class org.h2.engine.Mode
  If `true`, merge when matched clause may have WHERE clause.
MetaRecord - Class in org.h2.engine
  A record in the system table of the database.
MetaRecord(SearchRow) - Constructor for class org.h2.engine.MetaRecord
METHOD_DISABLED_ON_AUTOCOMMIT_TRUE - Static variable in class org.h2.api.ErrorCode
  The error with code `90147` is thrown when trying to execute a statement which closes the transaction (such as commit and rollback) and autocommit mode is on.
METHOD_NOT_ALLOWED_FOR_PREPARED_STATEMENT - Static variable in class org.h2.api.ErrorCode
  The error with code `90130` is thrown when an execute method of PreparedStatement was called with a SQL statement.
METHOD_NOT_ALLOWED_FOR_QUERY - Static variable in class org.h2.api.ErrorCode
  The error with code `90001` is thrown when Statement.executeUpdate() was called for a SELECT statement.
METHOD_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90087` is thrown when a method with matching number of arguments was not found in the class.
METHOD_ONLY_ALLOWED_FOR_QUERY - Static variable in class org.h2.api.ErrorCode
  The error with code `90002` is thrown when Statement.executeQuery() was called for a statement that does not return a result set (for example, an UPDATE statement).
METHODS_MUST_HAVE_DIFFERENT_PARAMETER_COUNTS_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90073` is thrown when trying to create an alias for a Java method, if two methods exists in this class that have this name and the same number of parameters.
MIN_WEB_ADMIN_PASSWORD_LENGTH - Static variable in class org.h2.engine.Constants
  The minimum number of characters in web admin password.
minusIsExcept - Variable in class org.h2.engine.Mode
  Whether MINUS can be used as EXCEPT.
Mode - Class in org.h2.engine
  The compatibility modes.
mode - Variable in class org.h2.engine.Session.DynamicSettings
  The database mode.
Mode.CharPadding - Enum in org.h2.engine
  When CHAR values are right-padded with spaces.
Mode.ExpressionNames - Enum in org.h2.engine
  Generation of column names for expressions.
Mode.ModeEnum - Enum in org.h2.engine
Mode.ViewExpressionNames - Enum in org.h2.engine
  Generation of column names for expressions to be used in a view.
mouseClicked(MouseEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
mouseEntered(MouseEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
mouseExited(MouseEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
mousePressed(MouseEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
mouseReleased(MouseEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
moveToCurrentRow() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to the current row.
moveToCurrentRow() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
moveToInsertRow() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to the insert row.
moveToInsertRow() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
MultiDimension - Class in org.h2.tools
  A tool to help an application execute multi-dimensional range queries.
MultiDimension() - Constructor for class org.h2.tools.MultiDimension
MUST_GROUP_BY_COLUMN_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90016` is thrown when a column was used in the expression list or the order by clause of a group or aggregate query, and that column is not in the GROUP BY clause.
mvStore - Variable in class org.h2.engine.DbSettings
  Database setting `MV_STORE` (default: true).
mySqlTableOptions - Variable in class org.h2.engine.Mode
  If `true` MySQL table and column options are allowed

## N

NAME_TOO_LONG_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `42622` is thrown when name of identifier is too long.
nativeSQL(String) - Method in class org.h2.jdbc.JdbcConnection
  Translates a SQL statement into the database grammar.
newConcurrentStringMap() - Method in class org.h2.engine.Database
  Create a new hash map.
newStringMap() - Method in class org.h2.engine.Database
  Create a new hash map.
newStringMap(int) - Method in class org.h2.engine.Database
  Create a new hash map.
next() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the cursor to the next row of the result set.
next() - Method in class org.h2.tools.SimpleResultSet
  Moves the cursor to the next row of the result set.
nextObjectId() - Method in class org.h2.engine.SessionLocal
  Get the next object id.
nextvalAndCurrvalPseudoColumns - Variable in class org.h2.engine.Mode
  If `true`, sequence.NEXTVAL and sequence.CURRVAL pseudo columns are supported.
nextValueReturnsDifferentValues - Variable in class org.h2.engine.Mode
  If `true`, the next value expression returns different values when invoked multiple times within a row.
NIO_CLEANER_HACK - Static variable in class org.h2.engine.SysProperties
  System property `h2.nioCleanerHack` (default: false).
NIO_LOAD_MAPPED - Static variable in class org.h2.engine.SysProperties
  System property `h2.nioLoadMapped` (default: false).
NO_DATA_AVAILABLE - Static variable in class org.h2.api.ErrorCode
  The error with code `2000` is thrown when the result set is positioned before the first or after the last row, or not on a valid row for the given operation.
NO_DEFAULT_SET_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `23507` is thrown when updating or deleting from a table with a foreign key constraint that should set the default value, but there is no default value defined.
NONE - Static variable in class org.h2.engine.GeneratedKeysMode
  Generated keys are not needed.
normalize(int, double, double, double) - Method in class org.h2.tools.MultiDimension
  Normalize a value so that it is between the minimum and maximum for the given number of dimensions.
NOT_ENOUGH_RIGHTS_FOR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90096` is thrown when trying to perform an operation with a non-admin user if the user does not have enough rights.
NOT_ON_UPDATABLE_ROW - Static variable in class org.h2.api.ErrorCode
  The error with code `90029` is thrown when calling ResultSet.deleteRow(), insertRow(), or updateRow() when the current row is not updatable.
NULL_NOT_ALLOWED - Static variable in class org.h2.api.ErrorCode
  The error with code `23502` is thrown when trying to insert NULL into a column that does not allow NULL.
NULL_VALUE_IN_ARRAY_TARGET - Static variable in class org.h2.api.ErrorCode
  The error with code `22035` is thrown when an attempt is made to update an element in NULL array.
nullPlusNonNullIsNull() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether NULL+1 is NULL or not.
nullsAreSortedAtEnd() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if NULL values are sorted at the end (no matter if ASC or DESC is used).
nullsAreSortedAtStart() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if NULL values are sorted at the beginning (no matter if ASC or DESC is used).
nullsAreSortedHigh() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if NULL values are sorted high (bigger than anything that is not null).
nullsAreSortedLow() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if NULL values are sorted low (smaller than anything that is not null).
nullsDistinct - Variable in class org.h2.engine.Mode
  Determines how rows with `NULL` values in indexed columns are handled in unique indexes and constraints by default.
NullsDistinct - Enum in org.h2.engine
  Determines how rows with `NULL` values in indexed columns are handled in unique indexes, unique constraints, or by unique predicate.
NUMERIC - Static variable in class org.h2.api.H2Type
  The NUMERIC data type.
NUMERIC_VALUE_OUT_OF_RANGE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `22003` is thrown when a value is out of range when converting to another data type.
NUMERIC_VALUE_OUT_OF_RANGE_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `22004` is thrown when a value is out of range when converting to another column's data type.
numericIsDecfloat - Variable in class org.h2.engine.Mode
  Whether NUMERIC and DECIMAL/DEC without parameters are parsed as DECFLOAT.
numericWithBooleanComparison - Variable in class org.h2.engine.Mode
  Allow to compare numeric with BOOLEAN.

## O

OBJECT_CACHE - Static variable in class org.h2.engine.SysProperties
  System property `h2.objectCache` (default: true).
OBJECT_CACHE_MAX_PER_ELEMENT_SIZE - Static variable in class org.h2.engine.SysProperties
  System property `h2.objectCacheMaxPerElementSize` (default: 4096).
OBJECT_CACHE_SIZE - Static variable in class org.h2.engine.SysProperties
  System property `h2.objectCacheSize` (default: 1024).
OBJECT_CLOSED - Static variable in class org.h2.api.ErrorCode
  The error with code `90007` is thrown when trying to call a JDBC method on an object that has been closed.
ofDays(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL DAY.
ofDaysHours(long, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL DAY TO HOUR.
ofDaysHoursMinutes(long, int, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL DAY TO MINUTE.
ofDaysHoursMinutesNanos(long, int, int, long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL DAY TO SECOND.
ofDaysHoursMinutesSeconds(long, int, int, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL DAY TO SECOND.
ofHours(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL HOUR.
ofHoursMinutes(long, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL HOUR TO MINUTE.
ofHoursMinutesNanos(long, int, long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL HOUR TO SECOND.
ofHoursMinutesSeconds(long, int, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL HOUR TO SECOND.
ofMinutes(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL MINUTE.
ofMinutesNanos(long, long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL MINUTE TO SECOND.
ofMinutesSeconds(long, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL MINUTE TO SECOND.
ofMonths(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL MONTH.
ofNanos(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL SECOND.
ofSeconds(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL SECOND.
ofSeconds(long, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL SECOND.
ofYears(long) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL YEAR.
ofYearsMonths(long, int) - Static method in class org.h2.api.Interval
  Creates a new INTERVAL YEAR TO MONTH.
onDuplicateKeyUpdate - Variable in class org.h2.engine.Mode
  MySQL style INSERT ...
onRollback(MVMap<Object, VersionedValue<Object>>, Object, VersionedValue<Object>, VersionedValue<Object>) - Method in class org.h2.engine.SessionLocal
openBrowser(String) - Static method in class org.h2.tools.Server
  Open a new browser tab or window with the given URL.
opened() - Method in interface org.h2.api.DatabaseEventListener
  This method is called after the database has been opened.
openFile(String, String, boolean) - Method in class org.h2.engine.Database
openFile(String, String, boolean) - Method in class org.h2.engine.SessionRemote
openFile(String, String, boolean) - Method in class org.h2.tools.Recover
  INTERNAL
optimizeDistinct - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_DISTINCT` (default: true).
optimizeEvaluatableSubqueries - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_EVALUATABLE_SUBQUERIES` (default: true).
optimizeInList - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_IN_LIST` (default: true).
optimizeInSelect - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_IN_SELECT` (default: true).
optimizeInsertFromSelect - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_INSERT_FROM_SELECT` (default: true).
optimizeOr - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_OR` (default: true).
optimizeSimpleSingleRowSubqueries - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_SIMPLE_SINGLE_ROW_SUBQUERIES` (default: true).
optimizeTwoEquals - Variable in class org.h2.engine.DbSettings
  Database setting `OPTIMIZE_TWO_EQUALS` (default: true).
ORDER_BY_NOT_IN_RESULT - Static variable in class org.h2.api.ErrorCode
  The error with code `90068` is thrown when the given expression that is used in the ORDER BY is not in the result list.
org.h2.api - package org.h2.api
  Contains interfaces for user-defined extensions, such as triggers and user-defined aggregate functions.
org.h2.engine - package org.h2.engine
  Contains high level classes of the database and classes that don't fit in another sub-package.
org.h2.fulltext - package org.h2.fulltext
  The native full text search implementation, and the wrapper for the Lucene full text search implementation.
org.h2.jdbc - package org.h2.jdbc
  Implementation of the JDBC API (package java.sql).
org.h2.jdbcx - package org.h2.jdbcx
  Implementation of the extended JDBC API (package javax.sql).
org.h2.tools - package org.h2.tools
  Various tools.
othersDeletesAreVisible(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether other deletes are visible.
othersInsertsAreVisible(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether other inserts are visible.
othersUpdatesAreVisible(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether other updates are visible.
OUT_OF_MEMORY - Static variable in class org.h2.api.ErrorCode
  The error with code `90108` is thrown when not enough heap memory was available.
ownDeletesAreVisible(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether own deletes are visible.
ownInsertsAreVisible(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether own inserts are visible.
ownUpdatesAreVisible(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether own updates are visible.

## P

PARAMETER_NOT_SET_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90012` is thrown when trying to execute a statement with an parameter.
PARSE_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90014` is thrown when trying to parse a date with an unsupported format string, or when the date can not be parsed.
parseKey(Connection, String) - Static method in class org.h2.fulltext.FullText
  Parse a primary key condition into the primary key columns.
PG_CATALOG_SCHEMA_ID - Static variable in class org.h2.engine.Constants
  The identity of pg_catalog schema.
PG_DEFAULT_CLIENT_ENCODING - Static variable in class org.h2.engine.SysProperties
  System property `h2.pgClientEncoding` (default: UTF-8).
PG_VERSION - Static variable in class org.h2.engine.Constants
  Announced version for PgServer.
populateRowFromDBObject(DbObject, SearchRow) - Static method in class org.h2.engine.MetaRecord
  Copy metadata from the specified object into specified search row.
position(byte[], long) - Method in class org.h2.jdbc.JdbcBlob
  [Not supported] Searches a pattern and return the position.
position(Blob, long) - Method in class org.h2.jdbc.JdbcBlob
  [Not supported] Searches a pattern and return the position.
position(String, long) - Method in class org.h2.jdbc.JdbcClob
  [Not supported] Searches a pattern and return the position.
position(Clob, long) - Method in class org.h2.jdbc.JdbcClob
  [Not supported] Searches a pattern and return the position.
PREFIX_INDEX - Static variable in class org.h2.engine.Constants
  The name prefix used for indexes that are not explicitly named.
PREFIX_JOIN - Static variable in class org.h2.engine.Constants
  The name prefix used for synthetic nested join tables.
PREFIX_PRIMARY_KEY - Static variable in class org.h2.engine.Constants
  The name prefix used for primary key constraints that are not explicitly named.
PREFIX_QUERY_ALIAS - Static variable in class org.h2.engine.Constants
  The name prefix used for query aliases that are not explicitly named.
PREFIX_TEMP_FILE - Static variable in class org.h2.engine.SysProperties
  System property `h2.prefixTempFile` (default: h2.temp).
prepare(String) - Method in class org.h2.engine.SessionLocal
  Parse and prepare the given SQL statement.
prepare(String, boolean, boolean) - Method in class org.h2.engine.SessionLocal
  Parse and prepare the given SQL statement.
prepare(Xid) - Method in class org.h2.jdbcx.JdbcXAConnection
  Prepare a transaction.
prepareCall(String) - Method in class org.h2.jdbc.JdbcConnection
  Creates a new callable statement.
prepareCall(String, int, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a callable statement with the specified result set type and concurrency.
prepareCall(String, int, int, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a callable statement with the specified result set type, concurrency, and holdability.
prepareCommand(String, int) - Method in class org.h2.engine.Session
  Parse a command and prepare it for execution.
prepareCommand(String, int) - Method in class org.h2.engine.SessionLocal
prepareCommand(String, int) - Method in class org.h2.engine.SessionRemote
prepareCommit(String) - Method in class org.h2.engine.SessionLocal
  Prepare the given transaction.
prepareLocal(String) - Method in class org.h2.engine.SessionLocal
  Parse and prepare the given SQL statement.
prepareQueryExpression(String) - Method in class org.h2.engine.SessionLocal
  Parse a query and prepare its expressions.
prepareStatement(String) - Method in class org.h2.jdbc.JdbcConnection
  Creates a new prepared statement.
prepareStatement(String, int, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a prepared statement with the specified result set type and concurrency.
prepareStatement(String, int, int, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a prepared statement with the specified result set type, concurrency, and holdability.
prepareStatement(String, int) - Method in class org.h2.jdbc.JdbcConnection
  Creates a new prepared statement.
prepareStatement(String, int[]) - Method in class org.h2.jdbc.JdbcConnection
  Creates a new prepared statement.
prepareStatement(String, String[]) - Method in class org.h2.jdbc.JdbcConnection
  Creates a new prepared statement.
previous() - Method in class org.h2.jdbc.JdbcResultSet
  Moves the cursor to the last row, or row before first row if the current position is the first row.
previous() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
print(String) - Method in class org.h2.tools.Shell
  Print the string without newline, and flush.
printStackTrace() - Method in exception org.h2.jdbc.JdbcBatchUpdateException
  INTERNAL
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcBatchUpdateException
  INTERNAL
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcBatchUpdateException
  INTERNAL
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLDataException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLDataException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLTransientException
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLTransientException
Procedure - Class in org.h2.engine
  Represents a procedure.
Procedure(String, Prepared) - Constructor for class org.h2.engine.Procedure
process(String, String, String, String, String, String) - Static method in class org.h2.tools.Script
  Backs up a database to a stream.
process(Connection, String, String, String) - Static method in class org.h2.tools.Script
  Backs up a database to a stream.
PUBLIC_ROLE_NAME - Static variable in class org.h2.engine.Constants
  Every user belongs to this role.
PUBLIC_STATIC_JAVA_METHOD_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90139` is thrown when the specified public static Java method was not found in the class.

## Q

QUERY_STATISTICS_MAX_ENTRIES - Static variable in class org.h2.engine.Constants
  The maximum number of entries in query statistics.
queryCacheSize - Variable in class org.h2.engine.DbSettings
  Database setting `QUERY_CACHE_SIZE` (default: 8).
QueryEntry(String) - Constructor for class org.h2.engine.QueryStatisticsData.QueryEntry
QueryStatisticsData - Class in org.h2.engine
  Maintains query statistics.
QueryStatisticsData(int) - Constructor for class org.h2.engine.QueryStatisticsData
QueryStatisticsData.QueryEntry - Class in org.h2.engine
  The collected statistics for one query.
quoteSQL(Object, int) - Static method in class org.h2.fulltext.FullText
  INTERNAL.

## R

read(String, String[], String) - Method in class org.h2.tools.Csv
  Reads from the CSV file and returns a result set.
read(Reader, String[]) - Method in class org.h2.tools.Csv
  Reads CSV data from a reader and returns a result set.
readBlobMap(Connection, long, long) - Static method in class org.h2.tools.Recover
  INTERNAL
readClobMap(Connection, long, long) - Static method in class org.h2.tools.Recover
  INTERNAL
readException(Transfer) - Static method in class org.h2.engine.SessionRemote
  Reads an exception.
readLob(long, byte[], long, byte[], int, int) - Method in class org.h2.engine.Database
readLob(long, byte[], long, byte[], int, int) - Method in class org.h2.engine.SessionRemote
readLob(long, byte[], long, byte[], int, int) - Method in class org.h2.tools.Recover
  INTERNAL
readRow() - Method in class org.h2.tools.Csv
  INTERNAL
readRow() - Method in interface org.h2.tools.SimpleRowSource
  Get the next row.
readSessionState() - Method in class org.h2.engine.Session
  Read the session state if necessary.
readVariableInt(byte[], int) - Static method in class org.h2.tools.CompressTool
  Read a variable size integer using Rice coding.
REAL - Static variable in class org.h2.api.H2Type
  The REAL data type.
recompileAlways - Variable in class org.h2.engine.DbSettings
  Database setting `RECOMPILE_ALWAYS` (default: false).
recover(int) - Method in class org.h2.jdbcx.JdbcXAConnection
  Get the list of prepared transaction branches.
Recover - Class in org.h2.tools
  Helps recovering a corrupted database.
Recover() - Constructor for class org.h2.tools.Recover
REFERENTIAL_INTEGRITY_VIOLATED_CHILD_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `23503` is thrown when trying to delete or update a row when this would violate a referential constraint, because there is a child row that would become an orphan.
REFERENTIAL_INTEGRITY_VIOLATED_PARENT_MISSING_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `23506` is thrown when trying to insert or update a row that would violate a referential constraint, because the referenced row does not exist.
refreshRow() - Method in class org.h2.jdbc.JdbcResultSet
  Re-reads the current row from the database.
refreshRow() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
regexpReplaceBackslashReferences - Variable in class org.h2.engine.Mode
  The function REGEXP_REPLACE() uses \ for back-references.
registerOutParameter(int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Registers the given OUT parameter.
registerOutParameter(int, int, String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Registers the given OUT parameter.
registerOutParameter(int, int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Registers the given OUT parameter.
registerOutParameter(String, int, String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Registers the given OUT parameter.
registerOutParameter(String, int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Registers the given OUT parameter.
registerOutParameter(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Registers the given OUT parameter.
registerTableAsLocked(Table) - Method in class org.h2.engine.SessionLocal
  Register table as locked within current transaction.
registerTableAsUpdated(Table) - Method in class org.h2.engine.SessionLocal
  Register table as updated within current transaction.
reindex(Connection) - Static method in class org.h2.fulltext.FullText
  Re-creates the full text index for this database.
reindex(Connection) - Static method in class org.h2.fulltext.FullTextLucene
  Re-creates the full text index for this database.
relative(int) - Method in class org.h2.jdbc.JdbcResultSet
  Moves the current position to a specific row relative to the current row.
relative(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
releaseDatabaseObjectIds(BitSet) - Method in class org.h2.engine.Database
  Mark some database ids as unused.
releaseSavepoint(Savepoint) - Method in class org.h2.jdbc.JdbcConnection
  Releases a savepoint.
REMOTE_CONNECTION_NOT_ALLOWED - Static variable in class org.h2.api.ErrorCode
  The error with code `90117` is thrown when trying to connect to a TCP server from another machine, if remote connections are not allowed.
REMOTE_DATABASE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90149` is thrown when trying to open a database that does not exist remotely without enabling remote database creation first.
remove() - Method in interface org.h2.api.Trigger
  This method is called when the trigger is dropped.
remove() - Method in class org.h2.fulltext.FullText.FullTextTrigger
  INTERNAL
removeAllTriggers(Connection, String) - Static method in class org.h2.fulltext.FullText
  Remove all triggers that start with the given prefix.
removeAtCommit(ValueLob) - Method in class org.h2.engine.SessionLocal
  Remember that the given LOB value must be removed at commit.
removeAtCommitStop(ValueLob) - Method in class org.h2.engine.SessionLocal
  Do not remove this LOB value at commit any longer.
removeChildrenAndResources(SessionLocal) - Method in class org.h2.engine.Comment
removeChildrenAndResources(SessionLocal) - Method in class org.h2.engine.DbObject
  Delete all dependent children objects and resources of this object.
removeChildrenAndResources(SessionLocal) - Method in class org.h2.engine.Right
removeChildrenAndResources(SessionLocal) - Method in class org.h2.engine.Role
removeChildrenAndResources(SessionLocal) - Method in class org.h2.engine.Setting
removeChildrenAndResources(SessionLocal) - Method in class org.h2.engine.User
removeConnectionEventListener(ConnectionEventListener) - Method in class org.h2.jdbcx.JdbcXAConnection
  Remove the event listener.
removeDatabaseObject(SessionLocal, DbObject) - Method in class org.h2.engine.Database
  Remove the object from the database.
removeIndexAccess(String) - Static method in class org.h2.fulltext.FullTextLucene
  Close the index writer and searcher and remove them from the index access set.
removeLocalTempTable(Table) - Method in class org.h2.engine.SessionLocal
  Drop and remove the given local temporary table from this session.
removeLocalTempTableIndex(Index) - Method in class org.h2.engine.SessionLocal
  Drop and remove the given local temporary index from this session.
removeMeta(SessionLocal, int) - Method in class org.h2.engine.Database
  Remove the given object from the meta data.
removeProcedure(String) - Method in class org.h2.engine.SessionLocal
  Remove a procedure from this session.
removeProperty(String, boolean) - Method in class org.h2.engine.ConnectionInfo
  Remove a boolean property if it is set and return the value.
removeSchemaObject(SessionLocal, SchemaObject) - Method in class org.h2.engine.Database
  Remove an object from the system table.
removeServer(IOException, int, int) - Method in class org.h2.engine.SessionRemote
  Remove a server from the list of cluster nodes and disables the cluster mode.
removeSession(SessionLocal) - Method in class org.h2.engine.Database
  Remove a session.
removeStatementEventListener(StatementEventListener) - Method in class org.h2.jdbcx.JdbcXAConnection
  [Not supported] Remove a statement event listener.
rename(String) - Method in class org.h2.engine.DbObject
  Rename the object.
rename(String) - Method in class org.h2.engine.RightOwner
renameDatabaseObject(SessionLocal, DbObject, String) - Method in class org.h2.engine.Database
  Rename a database object.
renameSchemaObject(SessionLocal, SchemaObject, String) - Method in class org.h2.engine.Database
  Rename a schema object.
replaceInto - Variable in class org.h2.engine.Mode
  MySQL style REPLACE INTO.
reset() - Method in class org.h2.tools.Csv
  INTERNAL
reset() - Method in interface org.h2.tools.SimpleRowSource
  Reset the position (before the first row).
resetThreadLocalSession(Session) - Method in class org.h2.engine.Session
  Resets old thread local session.
resetThreadLocalSession(Session) - Method in class org.h2.engine.SessionLocal
Restore - Class in org.h2.tools
  Restores a H2 database by extracting the database files from a .zip file.
Restore() - Constructor for class org.h2.tools.Restore
RESULT_CLOSE - Static variable in class org.h2.engine.SessionRemote
RESULT_FETCH_ROWS - Static variable in class org.h2.engine.SessionRemote
RESULT_RESET - Static variable in class org.h2.engine.SessionRemote
RESULT_SET_NOT_SCROLLABLE - Static variable in class org.h2.api.ErrorCode
  The error with code `90128` is thrown when trying to call a method of the ResultSet that is only supported for scrollable result sets, and the result set is not scrollable.
RESULT_SET_NOT_UPDATABLE - Static variable in class org.h2.api.ErrorCode
  The error with code `90127` is thrown when trying to update or delete a row in a result set if the result set is not updatable.
RESULT_SET_READONLY - Static variable in class org.h2.api.ErrorCode
  The error with code `90140` is thrown when trying to update or delete a row in a result set if the statement was not created with updatable concurrency.
resultSet - Variable in class org.h2.jdbc.JdbcStatement
resultSetConcurrency - Variable in class org.h2.jdbc.JdbcStatement
resultSetType - Variable in class org.h2.jdbc.JdbcStatement
reuseSpace - Variable in class org.h2.engine.DbSettings
  Database setting `REUSE_SPACE` (default: true).
revokeTemporaryRightsOnRoles() - Method in class org.h2.engine.RightOwner
  Remove all the temporary rights granted on roles
RIGHT - Static variable in class org.h2.engine.DbObject
  This object is a right.
Right - Class in org.h2.engine
  An access right.
Right(Database, int, RightOwner, Role) - Constructor for class org.h2.engine.Right
Right(Database, int, RightOwner, int, DbObject) - Constructor for class org.h2.engine.Right
RightOwner - Class in org.h2.engine
  A right owner (sometimes called principal).
RightOwner(Database, int, String, int) - Constructor for class org.h2.engine.RightOwner
ROLE - Static variable in class org.h2.engine.DbObject
  This object is a role.
Role - Class in org.h2.engine
  Represents a role.
Role(Database, int, String, boolean) - Constructor for class org.h2.engine.Role
ROLE_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90069` is thrown when trying to create a role if an object with this name already exists.
ROLE_ALREADY_GRANTED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90074` is thrown when trying to grant a role that has already been granted.
ROLE_CAN_NOT_BE_DROPPED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90091` is thrown when trying to drop the role PUBLIC.
ROLE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90070` is thrown when trying to drop or grant a role that does not exists.
ROLES_AND_RIGHT_CANNOT_BE_MIXED - Static variable in class org.h2.api.ErrorCode
  The error with code `90072` is thrown when trying to grant or revoke both roles and rights at the same time.
rollback() - Method in class org.h2.engine.SessionLocal
  Fully roll back the current transaction.
rollback() - Method in class org.h2.jdbc.JdbcConnection
  Rolls back the current transaction.
rollback(Savepoint) - Method in class org.h2.jdbc.JdbcConnection
  Rolls back to a savepoint.
rollback(Xid) - Method in class org.h2.jdbcx.JdbcXAConnection
  Roll back a transaction.
rollbackTo(SessionLocal.Savepoint) - Method in class org.h2.engine.SessionLocal
  Partially roll back the current transaction.
rollbackToSavepoint(String) - Method in class org.h2.engine.SessionLocal
  Undo all operations back to the log position of the given savepoint.
row(H2Type...) - Static method in class org.h2.api.H2Type
  Returns ROW data type with specified types of fields and default names.
ROW_NOT_FOUND_IN_PRIMARY_INDEX - Static variable in class org.h2.api.ErrorCode
  The error with code `90143` is thrown when trying to fetch a row from the primary index and the row is not there.
ROW_NOT_FOUND_WHEN_DELETING_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90112` is thrown when a row was deleted twice while locking was disabled.
rowCountCumulative - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The total number of rows.
rowCountMax - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The maximum number of rows.
rowCountMean - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The mean number of rows.
rowCountMin - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The minimum number of rows.
rowDeleted() - Method in class org.h2.jdbc.JdbcResultSet
  Detects if the row was deleted (by somebody else or the caller).
rowDeleted() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
rowInserted() - Method in class org.h2.jdbc.JdbcResultSet
  Detects if the row was inserted.
rowInserted() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
rowUpdated() - Method in class org.h2.jdbc.JdbcResultSet
  Detects if the row was updated (by somebody else or the caller).
rowUpdated() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
run() - Method in class org.h2.tools.Server
  INTERNAL
run() - Method in class org.h2.tools.Shell
  INTERNAL.
RunScript - Class in org.h2.tools
  Runs a SQL script against a database.
RunScript() - Constructor for class org.h2.tools.RunScript
runTool(String...) - Method in class org.h2.tools.Backup
runTool(String...) - Method in class org.h2.tools.ChangeFileEncryption
runTool(String...) - Method in class org.h2.tools.Console
  This tool starts the H2 Console (web-) server, as well as the TCP and PG server.
runTool(String...) - Method in class org.h2.tools.ConvertTraceFile
runTool(String...) - Method in class org.h2.tools.CreateCluster
runTool(String...) - Method in class org.h2.tools.DeleteDbFiles
runTool(String...) - Method in class org.h2.tools.Recover
  Dumps the contents of a database file to a human readable text file.
runTool(String...) - Method in class org.h2.tools.Restore
runTool(String...) - Method in class org.h2.tools.RunScript
  Executes the contents of a SQL script file against a database.
runTool(String...) - Method in class org.h2.tools.Script
runTool(String...) - Method in class org.h2.tools.Server
runTool(String...) - Method in class org.h2.tools.Shell
  Run the shell tool with the given command line settings.
runTool(Connection, String...) - Method in class org.h2.tools.Shell
  Run the shell tool with the given connection and command line settings.

## S

SALT_LEN - Static variable in class org.h2.engine.Constants
  The number of bytes in random salt that is used to hash passwords.
Savepoint() - Constructor for class org.h2.engine.SessionLocal.Savepoint
SAVEPOINT_IS_INVALID_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90063` is thrown when trying to rollback to a savepoint that is not defined.
SAVEPOINT_IS_NAMED - Static variable in class org.h2.api.ErrorCode
  The error with code `90065` is thrown when Savepoint.getSavepointId() is called on a named savepoint.
SAVEPOINT_IS_UNNAMED - Static variable in class org.h2.api.ErrorCode
  The error with code `90064` is thrown when Savepoint.getSavepointName() is called on an unnamed savepoint.
SCALAR_SUBQUERY_CONTAINS_MORE_THAN_ONE_ROW - Static variable in class org.h2.api.ErrorCode
  The error with code `90053` is thrown when a subquery that is used as a value contains more than one row.
SCHEMA - Static variable in class org.h2.engine.DbObject
  This object is a schema.
schema - Variable in class org.h2.fulltext.IndexInfo
  The schema name.
SCHEMA_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90078` is thrown when trying to create a schema if an object with this name already exists.
SCHEMA_CAN_NOT_BE_DROPPED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90090` is thrown when trying to drop a schema that may not be dropped (the schema PUBLIC and the schema INFORMATION_SCHEMA).
SCHEMA_MAIN - Static variable in class org.h2.engine.Constants
  The name of the default schema.
SCHEMA_NAME_MUST_MATCH - Static variable in class org.h2.api.ErrorCode
  The error with code `90080` is thrown when trying to rename a object to a different schema, or when trying to create a related object in another schema.
SCHEMA_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90079` is thrown when trying to drop a schema that does not exist.
SCHEMA_OWNER - Static variable in class org.h2.engine.Right
  The right bit mask that means: user is a schema owner.
SCHEMA_PG_CATALOG - Static variable in class org.h2.engine.Constants
  The name of the pg_catalog schema.
schemaName - Variable in class org.h2.tools.TriggerAdapter
  The schema name.
Script - Class in org.h2.tools
  Creates a SQL script file by extracting the schema and data of a database.
Script() - Constructor for class org.h2.tools.Script
search(Connection, String, int, int) - Static method in class org.h2.fulltext.FullText
  Searches from the full text index for this database.
search(Connection, String, int, int, boolean) - Static method in class org.h2.fulltext.FullText
  Do the search.
search(Connection, String, int, int) - Static method in class org.h2.fulltext.FullTextLucene
  Searches from the full text index for this database.
search(Connection, String, int, int, boolean) - Static method in class org.h2.fulltext.FullTextLucene
  Do the search.
searchData(Connection, String, int, int) - Static method in class org.h2.fulltext.FullText
  Searches from the full text index for this database.
searchData(Connection, String, int, int) - Static method in class org.h2.fulltext.FullTextLucene
  Searches from the full text index for this database.
SECOND_PRIMARY_KEY - Static variable in class org.h2.api.ErrorCode
  The error with code `90017` is thrown when trying to define a second primary key constraint for this table.
SELECT - Static variable in interface org.h2.api.Trigger
  The trigger is called for SELECT statements.
SELECT - Static variable in class org.h2.engine.Right
  The right bit mask that means: selecting from a table is allowed.
SELECTIVITY_DEFAULT - Static variable in class org.h2.engine.Constants
  The default selectivity (used if the selectivity is not calculated).
SELECTIVITY_DISTINCT_COUNT - Static variable in class org.h2.engine.Constants
  The number of distinct values to keep in memory when running ANALYZE.
SEQUENCE - Static variable in class org.h2.engine.DbObject
  This object is a sequence.
SEQUENCE_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90035` is thrown when trying to create a sequence if a sequence with this name already exists.
SEQUENCE_ATTRIBUTES_INVALID_7 - Static variable in class org.h2.api.ErrorCode
  The error with code `90009` is thrown when trying to create a sequence with an invalid combination of attributes (min value, max value, start value, etc).
SEQUENCE_BELONGS_TO_A_TABLE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90082` is thrown when trying to drop a system generated sequence.
SEQUENCE_EXHAUSTED - Static variable in class org.h2.api.ErrorCode
  The error with code `90006` is thrown when trying to get a value from a sequence that has run out of numbers and does not have cycling enabled.
SEQUENCE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90036` is thrown when trying to access a sequence that does not exist.
serialDataTypes - Variable in class org.h2.engine.Mode
  Whether SERIAL and BIGSERIAL pseudo data types are supported.
SERIALIZATION_FAILED_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90026` is thrown when an object could not be serialized.
serialize(Object) - Method in interface org.h2.api.JavaObjectSerializer
  Serialize object to byte array.
Server - Class in org.h2.tools
  Starts the H2 Console (web-) server, TCP, and PG server.
Server() - Constructor for class org.h2.tools.Server
Server(Service, String...) - Constructor for class org.h2.tools.Server
  Create a new server for the given service.
SERVER_CACHED_OBJECTS - Static variable in class org.h2.engine.SysProperties
  System property `h2.serverCachedObjects` (default: 64).
SERVER_PROPERTIES_DIR - Static variable in class org.h2.engine.Constants
  The default directory name of the server properties file for the H2 Console.
SERVER_PROPERTIES_NAME - Static variable in class org.h2.engine.Constants
  The name of the server properties file for the H2 Console.
SERVER_RESULT_SET_FETCH_SIZE - Static variable in class org.h2.engine.SysProperties
  System property `h2.serverResultSetFetchSize` (default: 100).
Session - Class in org.h2.engine
  A local or remote session.
session - Variable in class org.h2.jdbc.JdbcStatement
Session.DynamicSettings - Class in org.h2.engine
  Dynamic settings.
Session.StaticSettings - Class in org.h2.engine
  Static settings.
SESSION_CANCEL_STATEMENT - Static variable in class org.h2.engine.SessionRemote
SESSION_CHECK_KEY - Static variable in class org.h2.engine.SessionRemote
SESSION_CLOSE - Static variable in class org.h2.engine.SessionRemote
SESSION_HAS_PENDING_TRANSACTION - Static variable in class org.h2.engine.SessionRemote
SESSION_PREPARE - Static variable in class org.h2.engine.SessionRemote
SESSION_PREPARE_READ_PARAMS2 - Static variable in class org.h2.engine.SessionRemote
SESSION_SET_AUTOCOMMIT - Static variable in class org.h2.engine.SessionRemote
SESSION_SET_ID - Static variable in class org.h2.engine.SessionRemote
SessionLocal - Class in org.h2.engine
  A session represents an embedded database connection.
SessionLocal(Database, User, int) - Constructor for class org.h2.engine.SessionLocal
SessionLocal.Savepoint - Class in org.h2.engine
  Represents a savepoint (a position in a transaction to where one can roll back to).
SessionLocal.State - Enum in org.h2.engine
SessionLocal.TimeoutValue - Class in org.h2.engine
  An LOB object with a timeout.
SessionRemote - Class in org.h2.engine
  The client side part of a session when using the server mode.
SessionRemote(ConnectionInfo) - Constructor for class org.h2.engine.SessionRemote
setAdmin(boolean) - Method in class org.h2.engine.User
setAllowBuiltinAliasOverride(boolean) - Method in class org.h2.engine.Database
setAllowLiterals(int) - Method in class org.h2.engine.Database
setAllowLiterals(boolean) - Method in class org.h2.engine.SessionLocal
setArray(int, Array) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an Array.
setAsciiStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as an ASCII stream.
setAsciiStream(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as an ASCII stream.
setAsciiStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as an ASCII stream.
setAsciiStream(long) - Method in class org.h2.jdbc.JdbcClob
  [Not supported] Returns an output stream.
setAsciiStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an ASCII stream.
setAsciiStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an ASCII stream.
setAsciiStream(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an ASCII stream.
setAuthenticator(Authenticator) - Method in class org.h2.engine.Database
  Set current database authenticator
setAutoClose(boolean) - Method in class org.h2.tools.SimpleResultSet
  Set the auto-close behavior.
setAutoCommit(boolean) - Method in class org.h2.engine.Session
  Set the auto-commit mode.
setAutoCommit(boolean) - Method in class org.h2.engine.SessionLocal
setAutoCommit(boolean) - Method in class org.h2.engine.SessionRemote
setAutoCommit(boolean) - Method in class org.h2.jdbc.JdbcConnection
  Switches auto commit on or off.
setAutoCommitFromServer(boolean) - Method in class org.h2.engine.SessionRemote
setBackgroundException(DbException) - Method in class org.h2.engine.Database
setBaseDir(String) - Method in class org.h2.engine.ConnectionInfo
  Set the base directory of persistent databases, unless the database is in the user home folder (~).
setBaseDir(String) - Static method in class org.h2.engine.SysProperties
  INTERNAL
setBigDecimal(String, BigDecimal) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setBigDecimal(int, BigDecimal) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setBinaryStream(long) - Method in class org.h2.jdbc.JdbcBlob
  Get a writer to update the Blob.
setBinaryStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as an input stream.
setBinaryStream(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as an input stream.
setBinaryStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as an input stream.
setBinaryStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an input stream.
setBinaryStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an input stream.
setBinaryStream(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as an input stream.
setBinaryStream() - Method in class org.h2.jdbc.JdbcSQLXML
setBlob(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Blob.
setBlob(String, Blob) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Blob.
setBlob(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Blob.
setBlob(int, Blob) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Blob.
setBlob(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Blob.
setBlob(int, InputStream, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Blob.
setBoolean(String, boolean) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setBoolean(int, boolean) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setByte(String, byte) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setByte(int, byte) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setBytes(long, byte[]) - Method in class org.h2.jdbc.JdbcBlob
  Fills the Blob.
setBytes(long, byte[], int, int) - Method in class org.h2.jdbc.JdbcBlob
  Sets some bytes of the object.
setBytes(String, byte[]) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a byte array.
setBytes(int, byte[]) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a byte array.
setCacheSize(int) - Method in class org.h2.engine.Database
setCaseSensitiveColumnNames(boolean) - Method in class org.h2.tools.Csv
  Override the case sensitive column names setting.
setCatalog(String) - Method in class org.h2.jdbc.JdbcConnection
  Set the default catalog name.
setCharacterStream(String, Reader, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a character stream.
setCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a character stream.
setCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a character stream.
setCharacterStream(long) - Method in class org.h2.jdbc.JdbcClob
  Get a writer to update the Clob.
setCharacterStream(int, Reader, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a character stream.
setCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a character stream.
setCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a character stream.
setCharacterStream() - Method in class org.h2.jdbc.JdbcSQLXML
setClientInfo(String, String) - Method in class org.h2.jdbc.JdbcConnection
  Set a client property.
setClientInfo(Properties) - Method in class org.h2.jdbc.JdbcConnection
  Set the client properties.
setClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Clob.
setClob(String, Clob) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Clob.
setClob(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a character stream.
setClob(int, Clob) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Clob.
setClob(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Clob.
setClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Clob.
setCloseDelay(int) - Method in class org.h2.engine.Database
setCluster(String) - Method in class org.h2.engine.Database
setColumns(int[], ArrayList<String>, ArrayList<String>) - Static method in class org.h2.fulltext.FullText
  Set the column indices of a set of keys.
setComment(String) - Method in class org.h2.engine.DbObject
  Change the comment of this object.
setCommentText(String) - Method in class org.h2.engine.Comment
  Set the comment text.
setCommitOrRollbackDisabled(boolean) - Method in class org.h2.engine.SessionLocal
setCompactMode(int) - Method in class org.h2.engine.Database
setCompareMode(CompareMode) - Method in class org.h2.engine.Database
setCurrentSchema(Schema) - Method in class org.h2.engine.SessionLocal
setCurrentSchemaName(String) - Method in class org.h2.engine.Session
  Set current schema.
setCurrentSchemaName(String) - Method in class org.h2.engine.SessionLocal
setCurrentSchemaName(String) - Method in class org.h2.engine.SessionRemote
setCursorName(String) - Method in class org.h2.jdbc.JdbcStatement
  Sets the name of the cursor.
setDate(String, Date, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the date using a specified time zone.
setDate(String, Date) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setDate(int, Date) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setDate(int, Date, Calendar) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the date using a specified time zone.
setDefaultNullOrdering(DefaultNullOrdering) - Method in class org.h2.engine.Database
setDefaultTableType(int) - Method in class org.h2.engine.Database
setDeleteFilesOnDisconnect(boolean) - Method in class org.h2.engine.Database
setDescription(String) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the description.
setDouble(String, double) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setDouble(int, double) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setErr(PrintStream) - Method in class org.h2.tools.Shell
  Sets the standard error stream.
setEscapeCharacter(char) - Method in class org.h2.tools.Csv
  Set the escape character.
setEscapeProcessing(boolean) - Method in class org.h2.jdbc.JdbcStatement
  Enables or disables processing or JDBC escape syntax.
setEventListener(DatabaseEventListener) - Method in class org.h2.engine.Database
setEventListenerClass(String) - Method in class org.h2.engine.Database
setExclusiveSession(SessionLocal, boolean) - Method in class org.h2.engine.Database
  Set the session that can exclusively access the database.
setFetchDirection(int) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Sets (changes) the fetch direction for this result set.
setFetchDirection(int) - Method in class org.h2.jdbc.JdbcStatement
  Sets the fetch direction.
setFetchDirection(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
setFetchSize(int) - Method in class org.h2.jdbc.JdbcResultSet
  Sets the number of rows suggested to read in one step.
setFetchSize(int) - Method in class org.h2.jdbc.JdbcStatement
  Sets the number of rows suggested to read in one step.
setFetchSize(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
setFieldDelimiter(char) - Method in class org.h2.tools.Csv
  Set the field delimiter.
setFieldSeparatorRead(char) - Method in class org.h2.tools.Csv
  Override the field separator for reading.
setFieldSeparatorWrite(String) - Method in class org.h2.tools.Csv
  Override the field separator for writing.
setFileEncryptionKey(byte[]) - Method in class org.h2.engine.ConnectionInfo
setFilePasswordHash(byte[]) - Method in class org.h2.engine.ConnectionInfo
  Set the file password hash.
setFloat(String, float) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setFloat(int, float) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setHoldability(int) - Method in class org.h2.jdbc.JdbcConnection
  Changes the current result set holdability.
setIgnoreCase(boolean) - Method in class org.h2.engine.Database
setIgnoreCatalogs(boolean) - Method in class org.h2.engine.Database
setIgnoreList(Connection, String) - Static method in class org.h2.fulltext.FullText
  Change the ignore list.
setIn(InputStream) - Method in class org.h2.tools.Shell
  Redirects the standard input.
setInitialPowerOffCount(int) - Static method in class org.h2.engine.Database
setInReader(BufferedReader) - Method in class org.h2.tools.Shell
  Redirects the standard input.
setInt(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setInt(int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setIntValue(int) - Method in class org.h2.engine.Setting
setIsolationLevel(IsolationLevel) - Method in class org.h2.engine.Session
  Sets the isolation level.
setIsolationLevel(IsolationLevel) - Method in class org.h2.engine.SessionLocal
setIsolationLevel(IsolationLevel) - Method in class org.h2.engine.SessionRemote
setJavaObjectSerializerName(String) - Method in class org.h2.engine.Database
setLargeMaxRows(long) - Method in class org.h2.jdbc.JdbcStatement
  Gets the maximum number of rows for a ResultSet.
setLastIdentity(Value) - Method in class org.h2.engine.SessionLocal
setLazyQueryExecution(boolean) - Method in class org.h2.engine.SessionLocal
setLineCommentCharacter(char) - Method in class org.h2.tools.Csv
  Set the line comment character.
setLineSeparator(String) - Method in class org.h2.tools.Csv
  Set the line separator used for writing.
setLockMode(int) - Method in class org.h2.engine.Database
setLockTimeout(int) - Method in class org.h2.engine.SessionLocal
setLoginTimeout(int) - Method in class org.h2.jdbcx.JdbcConnectionPool
  Sets the maximum time in seconds to wait for a free connection.
setLoginTimeout(int) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the login timeout in seconds, 0 meaning no timeout.
setLogWriter(PrintWriter) - Method in class org.h2.jdbcx.JdbcConnectionPool
  INTERNAL
setLogWriter(PrintWriter) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the current log writer for this object.
setLong(String, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setLong(int, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setMasterUser(User) - Method in class org.h2.engine.Database
setMaxConnections(int) - Method in class org.h2.jdbcx.JdbcConnectionPool
  Sets the maximum number of connections to use from now on.
setMaxFieldSize(int) - Method in class org.h2.jdbc.JdbcStatement
  Sets the maximum number of bytes for a result set column.
setMaxLengthInplaceLob(int) - Method in class org.h2.engine.Database
setMaxMemoryRows(int) - Method in class org.h2.engine.Database
setMaxOperationMemory(int) - Method in class org.h2.engine.Database
setMaxQueryEntries(int) - Method in class org.h2.engine.QueryStatisticsData
setMaxRows(int) - Method in class org.h2.jdbc.JdbcStatement
  Gets the maximum number of rows for a ResultSet.
setMode(Mode) - Method in class org.h2.engine.Database
setModified() - Method in class org.h2.engine.DbObject
  Tell the object that is was modified.
setNCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a character stream.
setNCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a character stream.
setNCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a character stream.
setNCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a character stream.
setNClob(String, NClob) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Clob.
setNClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Clob.
setNClob(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a Clob.
setNClob(int, NClob) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Clob.
setNClob(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Clob.
setNClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a Clob.
setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.ConnectionInfo
  Sets the network connection information.
setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.Session
  Sets the network connection information if possible.
setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.SessionLocal
setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.SessionRemote
setNetworkTimeout(Executor, int) - Method in class org.h2.jdbc.JdbcConnection
  [Not supported]
setNonKeywords(BitSet) - Method in class org.h2.engine.SessionLocal
  Sets bit set of non-keywords.
setNString(String, String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setNString(int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setNull(String, int, String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets a parameter to null.
setNull(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets a parameter to null.
setNull(int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets a parameter to null.
setNull(int, int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets a parameter to null.
setNullString(String) - Method in class org.h2.tools.Csv
  Set the value that represents NULL.
setObject(String, Object) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setObject(String, Object, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setObject(String, Object, int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setObject(String, Object, SQLType) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setObject(String, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setObject(int, Object) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setObject(int, Object, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setObject(int, Object, int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setObject(int, Object, SQLType) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setObject(int, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setObjectName(String) - Method in class org.h2.engine.DbObject
setOldInformationSchema(boolean) - Method in class org.h2.engine.SessionLocal
  Changes INFORMATION_SCHEMA content.
setOptimizeReuseResults(boolean) - Method in class org.h2.engine.Database
setOptions(String) - Method in class org.h2.tools.Csv
  INTERNAL.
setOriginalURL(String) - Method in class org.h2.engine.ConnectionInfo
  Set the original database URL.
setParsingCreateView(boolean) - Method in class org.h2.engine.SessionLocal
  This method is called before and after parsing of view definition and may be called recursively.
setPassword(String) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the current password.
setPasswordChars(char[]) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the current password in the form of a char array.
setPoolable(boolean) - Method in class org.h2.jdbc.JdbcStatement
  Requests that this object should be pooled or not.
setPowerOffCount(int) - Method in class org.h2.engine.Database
setPreparedTransaction(String, boolean) - Method in class org.h2.engine.SessionLocal
  Commit or roll back the given transaction.
setPreserveWhitespace(boolean) - Method in class org.h2.tools.Csv
  Enable or disable preserving whitespace in unquoted text.
setProgress(int, String, long, long) - Method in interface org.h2.api.DatabaseEventListener
  This method is called for long running events, such as recovering, scanning a file or building an index.
setProgress(int, String, long, long) - Method in class org.h2.engine.Database
  Set the progress of a long running operation.
setProperty(String, String) - Method in class org.h2.engine.ConnectionInfo
  Overwrite a property.
setQueryStatistics(boolean) - Method in class org.h2.engine.Database
setQueryStatisticsMaxEntries(int) - Method in class org.h2.engine.Database
setQueryTimeout(int) - Method in class org.h2.engine.SessionLocal
setQueryTimeout(int) - Method in class org.h2.jdbc.JdbcStatement
  Sets the current query timeout in seconds.
setQuirksMode(boolean) - Method in class org.h2.engine.SessionLocal
  Enables or disables the quirks mode.
setReadOnly(boolean) - Method in class org.h2.engine.Database
  Switch the database to read-only mode.
setReadOnly(boolean) - Method in class org.h2.jdbc.JdbcConnection
  According to the JDBC specs, this setting is only a hint to the database to enable optimizations - it does not cause writes to be prohibited.
setRef(int, Ref) - Method in class org.h2.jdbc.JdbcPreparedStatement
  [Not supported] Sets the value of a column as a reference.
setReferentialIntegrity(boolean) - Method in class org.h2.engine.Database
setResult(Class<T>) - Method in class org.h2.jdbc.JdbcSQLXML
setRetentionTime(int) - Method in class org.h2.engine.Database
setRightMask(int) - Method in class org.h2.engine.Right
setRowFactory(RowFactory) - Method in class org.h2.engine.Database
setRowId(String, RowId) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported] Sets the value of a parameter as a row id.
setRowId(int, RowId) - Method in class org.h2.jdbc.JdbcPreparedStatement
  [Not supported] Sets the value of a parameter as a row id.
setSaltAndHash(byte[], byte[]) - Method in class org.h2.engine.User
  Set the salt and hash of the password for this user.
setSavepoint() - Method in class org.h2.engine.SessionLocal
  Create a savepoint to allow rolling back to this state.
setSavepoint() - Method in class org.h2.jdbc.JdbcConnection
  Creates a new unnamed savepoint.
setSavepoint(String) - Method in class org.h2.jdbc.JdbcConnection
  Creates a new named savepoint.
setSchema(String) - Method in class org.h2.jdbc.JdbcConnection
  Sets the given schema name to access.
setSchemaSearchPath(String[]) - Method in class org.h2.engine.SessionLocal
setServerKey(String) - Method in class org.h2.engine.ConnectionInfo
  Switch to server mode, and set the server name and database key.
setShort(String, short) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setShort(int, short) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setShutdownHandler(ShutdownHandler) - Method in class org.h2.tools.Server
  INTERNAL
setSQL(String) - Method in interface org.h2.jdbc.JdbcException
  INTERNAL
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLDataException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLTransientException
setSQLXML(String, SQLXML) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter as a SQLXML object.
setSQLXML(int, SQLXML) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter as a SQLXML.
setString(String, String) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setString(long, String) - Method in class org.h2.jdbc.JdbcClob
  Fills the Clob.
setString(long, String, int, int) - Method in class org.h2.jdbc.JdbcClob
  Fills the Clob.
setString(int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setString(String) - Method in class org.h2.jdbc.JdbcSQLXML
setStringValue(String) - Method in class org.h2.engine.Setting
setTemporary(boolean) - Method in class org.h2.engine.DbObject
  Tell this object that it is temporary or not.
setThreadLocalSession() - Method in class org.h2.engine.Session
  Sets this session as thread local session, if this session is a local session.
setThreadLocalSession() - Method in class org.h2.engine.SessionLocal
setThrottle(int) - Method in class org.h2.engine.SessionLocal
setTime(String, Time, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the time using a specified time zone.
setTime(String, Time) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the time using a specified time zone.
setTime(int, Time) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setTime(int, Time, Calendar) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the time using a specified time zone.
setTimestamp(String, Timestamp, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the timestamp using a specified time zone.
setTimestamp(String, Timestamp) - Method in class org.h2.jdbc.JdbcCallableStatement
  Sets the value of a parameter.
setTimestamp(int, Timestamp) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the value of a parameter.
setTimestamp(int, Timestamp, Calendar) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Sets the timestamp using a specified time zone.
setTimeZone(TimeZoneProvider) - Method in class org.h2.engine.SessionLocal
  Sets current time zone.
SETTING - Static variable in class org.h2.engine.DbObject
  This object is a setting.
Setting - Class in org.h2.engine
  A persistent database setting.
Setting(Database, int, String) - Constructor for class org.h2.engine.Setting
SettingsBase - Class in org.h2.engine
  The base class for settings.
SettingsBase(HashMap<String, String>) - Constructor for class org.h2.engine.SettingsBase
setTransactionIsolation(int) - Method in class org.h2.jdbc.JdbcConnection
  Changes the current transaction isolation level.
setTransactionTimeout(int) - Method in class org.h2.jdbcx.JdbcXAConnection
  Set the transaction timeout.
setTruncateLargeLength(boolean) - Method in class org.h2.engine.SessionLocal
  Changes parsing mode of data types with too large length.
setTypeMap(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcConnection
  [Partially supported] Sets the type map.
setUnicodeStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
  Deprecated.
  since JDBC 2.0, use setCharacterStream
setURL(String, URL) - Method in class org.h2.jdbc.JdbcCallableStatement
  [Not supported]
setURL(int, URL) - Method in class org.h2.jdbc.JdbcPreparedStatement
  [Not supported]
setURL(String) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the current URL.
setUrl(String) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the current URL.
setUser(String) - Method in class org.h2.jdbcx.JdbcDataSource
  Set the current user name.
setUserName(String) - Method in class org.h2.engine.ConnectionInfo
  Overwrite the user name.
setUserPasswordHash(byte[]) - Method in class org.h2.engine.ConnectionInfo
  Set the user password hash.
setUserPasswordHash(byte[]) - Method in class org.h2.engine.User
  Set the user name password hash.
setVariable(String, Value) - Method in class org.h2.engine.SessionLocal
  Set the value of the given variable for this session.
setVariableBinary(boolean) - Method in class org.h2.engine.SessionLocal
  Changes parsing of a BINARY data type.
setWaitForLock(Table, Thread) - Method in class org.h2.engine.SessionLocal
  Set the table this session is waiting for, and the thread that is waiting.
setWhitespaceChars(Connection, String) - Static method in class org.h2.fulltext.FullText
  Change the whitespace characters.
setWriteColumnHeader(boolean) - Method in class org.h2.tools.Csv
  Enable or disable writing the column header.
setWriteDelay(int) - Method in class org.h2.engine.Database
shareLinkedConnections - Variable in class org.h2.engine.DbSettings
  Database setting `SHARE_LINKED_CONNECTIONS` (default: true).
Shell - Class in org.h2.tools
  Interactive command line tool to access a database using JDBC.
Shell() - Constructor for class org.h2.tools.Shell
shutdown() - Method in class org.h2.tools.Console
  INTERNAL.
shutdown() - Method in class org.h2.tools.GUIConsole
shutdown() - Method in class org.h2.tools.Server
  INTERNAL
shutdownImmediately() - Method in class org.h2.engine.Database
  Immediately close the database.
shutdownTcpServer(String, String, boolean, boolean) - Static method in class org.h2.tools.Server
  Shutdown one or all TCP server.
SimpleResultSet - Class in org.h2.tools
  This class is a simple result set and meta data implementation.
SimpleResultSet() - Constructor for class org.h2.tools.SimpleResultSet
  This constructor is used if the result set is later populated with addRow.
SimpleResultSet(SimpleRowSource) - Constructor for class org.h2.tools.SimpleResultSet
  This constructor is used if the result set should retrieve the rows using the specified row source object.
SimpleResultSet.SimpleArray - Class in org.h2.tools
  A simple array implementation, backed by an object array
SimpleRowSource - Interface in org.h2.tools
  This interface is for classes that create rows on demand.
SLOW_QUERY_LIMIT_MS - Static variable in class org.h2.engine.Constants
  Queries that take longer than this number of milliseconds are written to the trace file with the level info.
SMALLINT - Static variable in class org.h2.api.H2Type
  The SMALLINT data type.
SOCKET_CONNECT_RETRY - Static variable in class org.h2.engine.SysProperties
  System property `h2.socketConnectRetry` (default: 16).
SOCKET_CONNECT_TIMEOUT - Static variable in class org.h2.engine.SysProperties
  System property `h2.socketConnectTimeout` (default: 2000).
SPLIT_FILE_SIZE_SHIFT - Static variable in class org.h2.engine.SysProperties
  System property `h2.splitFileSizeShift` (default: 30).
sqlStatement - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
  The SQL statement.
squareBracketQuotedNames - Variable in class org.h2.engine.Mode
  Identifiers may be quoted using square brackets as in [Test].
start(Xid, int) - Method in class org.h2.jdbcx.JdbcXAConnection
  Start or continue to work on a transaction.
start() - Method in class org.h2.tools.Server
  Tries to start the server.
START_URL - Static variable in class org.h2.engine.Constants
  The database URL prefix of this database.
startStatementWithinTransaction(Command) - Method in class org.h2.engine.SessionLocal
  Start a new statement within a transaction.
startWebServer(Connection) - Static method in class org.h2.tools.Server
  Start a web server and a browser that uses the given connection.
startWebServer(Connection, boolean) - Static method in class org.h2.tools.Server
  Start a web server and a browser that uses the given connection.
STATE_BACKUP_FILE - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used during the BACKUP command.
STATE_CREATE_INDEX - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used when re-creating an index.
STATE_RECONNECTED - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used after re-connecting to a database (if auto-reconnect is enabled).
STATE_RECOVER - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used when re-applying the transaction log or rolling back uncommitted transactions.
STATE_SCAN_FILE - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used when scanning the database file.
STATE_STATEMENT_END - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used when a query ends.
STATE_STATEMENT_PROGRESS - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used for periodic notification during long-running queries.
STATE_STATEMENT_START - Static variable in interface org.h2.api.DatabaseEventListener
  This state is used when a query starts.
STATEMENT_WAS_CANCELED - Static variable in class org.h2.api.ErrorCode
  The error with code `57014` is thrown when a statement was canceled using Statement.cancel() or when the query timeout has been reached.
StaticSettings(boolean, boolean, boolean) - Constructor for class org.h2.engine.Session.StaticSettings
  Creates new instance of static settings.
STATUS_CLOSED - Static variable in class org.h2.engine.SessionRemote
STATUS_ERROR - Static variable in class org.h2.engine.SessionRemote
STATUS_OK - Static variable in class org.h2.engine.SessionRemote
STATUS_OK_STATE_CHANGED - Static variable in class org.h2.engine.SessionRemote
STEP_SIZE_MUST_NOT_BE_ZERO - Static variable in class org.h2.api.ErrorCode
  The error with code `90142` is thrown when trying to set zero for step size.
stop() - Method in class org.h2.tools.Server
  Stops the server.
STORE_DOCUMENT_TEXT_IN_INDEX - Static variable in class org.h2.fulltext.FullTextLucene
  Whether the text content should be stored in the Lucene index.
storesLowerCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name.
storesLowerCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name.
storesMixedCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name and identifiers are not case sensitive.
storesMixedCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name and identifiers are case insensitive.
storesUpperCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name.
storesUpperCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name.
STRING_FORMAT_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90095` is thrown when calling the method STRINGDECODE with an invalid escape sequence.
SUBQUERY_IS_NOT_SINGLE_COLUMN - Static variable in class org.h2.api.ErrorCode
  The error with code `90052` is thrown when a single-column subquery is expected but a subquery with other number of columns was specified.
SUFFIX_LOCK_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of file lock files that are used to make sure a database is open by only one process at any time.
SUFFIX_MV_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of a MVStore file.
SUFFIX_MV_STORE_NEW_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of a new MVStore file, used when compacting a store.
SUFFIX_MV_STORE_TEMP_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of a temporary MVStore file, used when compacting a store.
SUFFIX_OLD_DATABASE_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of a H2 version 1.1 database file.
SUFFIX_TEMP_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of temporary files.
SUFFIX_TRACE_FILE - Static variable in class org.h2.engine.Constants
  The file name suffix of trace files.
SUM_OR_AVG_ON_WRONG_DATATYPE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90015` is thrown when using an aggregate function with a data type that is not supported.
supportedClientInfoPropertiesRegEx - Variable in class org.h2.engine.Mode
  Pattern describing the keys the java.sql.Connection.setClientInfo() method accepts.
supportPoundSymbolForColumnNames - Variable in class org.h2.engine.Mode
  Support the # for column names
supportsAlterTableWithAddColumn() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether alter table with add column is supported.
supportsAlterTableWithDropColumn() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether alter table with drop column is supported.
supportsANSI92EntryLevelSQL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether SQL-92 entry level grammar is supported.
supportsANSI92FullSQL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether SQL-92 full level grammar is supported.
supportsANSI92IntermediateSQL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether SQL-92 intermediate level grammar is supported.
supportsBatchUpdates() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether batch updates are supported.
supportsCatalogsInDataManipulation() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.
supportsCatalogsInIndexDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the catalog name in CREATE INDEX is supported.
supportsCatalogsInPrivilegeDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the catalog name in GRANT is supported.
supportsCatalogsInProcedureCalls() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the catalog name in procedure calls is supported.
supportsCatalogsInTableDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the catalog name in CREATE TABLE is supported.
supportsColumnAliasing() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether column aliasing is supported.
supportsConvert() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether CONVERT is supported.
supportsConvert(int, int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether CONVERT is supported for one datatype to another.
supportsCoreSQLGrammar() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether ODBC Core SQL grammar is supported.
supportsCorrelatedSubqueries() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether correlated subqueries are supported.
supportsDataDefinitionAndDataManipulationTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether data manipulation and CREATE/DROP is supported in transactions.
supportsDataManipulationTransactionsOnly() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether only data manipulations are supported in transactions.
supportsDifferentTableCorrelationNames() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether table correlation names (table alias) are restricted to be different than table names.
supportsExpressionsInOrderBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether expression in ORDER BY are supported.
supportsExtendedSQLGrammar() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether ODBC Extended SQL grammar is supported.
supportsFullOuterJoins() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether full outer joins are supported.
supportsGetGeneratedKeys() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does the database support getGeneratedKeys.
supportsGroupBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether GROUP BY is supported.
supportsGroupByBeyondSelect() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks whether a GROUP BY clause can use columns that are not in the SELECT clause, provided that it specifies all the columns in the SELECT clause.
supportsGroupByUnrelated() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether GROUP BY is supported if the column is not in the SELECT list.
supportsIntegrityEnhancementFacility() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether referential integrity is supported.
supportsLikeEscapeClause() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether LIKE...
supportsLimitedOuterJoins() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether limited outer joins are supported.
supportsMinimumSQLGrammar() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether ODBC Minimum SQL grammar is supported.
supportsMixedCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name and identifiers are case sensitive.
supportsMixedCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if a table created with CREATE TABLE "Test"(ID INT) is a different table than a table created with CREATE TABLE "TEST"(ID INT).
supportsMultipleOpenResults() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does the database support multiple open result sets returned from a `CallableStatement`.
supportsMultipleResultSets() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether multiple result sets are supported.
supportsMultipleTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether multiple transactions (on different connections) are supported.
supportsNamedParameters() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does the database support named parameters.
supportsNonNullableColumns() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether columns with NOT NULL are supported.
supportsOpenCursorsAcrossCommit() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether open result sets across commits are supported.
supportsOpenCursorsAcrossRollback() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether open result sets across rollback are supported.
supportsOpenStatementsAcrossCommit() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether open statements across commit are supported.
supportsOpenStatementsAcrossRollback() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether open statements across rollback are supported.
supportsOrderByUnrelated() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether ORDER BY is supported if the column is not in the SELECT list.
supportsOuterJoins() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether outer joins are supported.
supportsPositionedDelete() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether positioned deletes are supported.
supportsPositionedUpdate() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether positioned updates are supported.
supportsResultSetConcurrency(int, int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether a specific result set concurrency is supported.
supportsResultSetHoldability(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does this database supports a result set holdability.
supportsResultSetType(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether a specific result set type is supported.
supportsSavepoints() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does the database support savepoints.
supportsSchemasInDataManipulation() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the schema name in INSERT, UPDATE, DELETE is supported.
supportsSchemasInIndexDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the schema name in CREATE INDEX is supported.
supportsSchemasInPrivilegeDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the schema name in GRANT is supported.
supportsSchemasInProcedureCalls() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the schema name in procedure calls is supported.
supportsSchemasInTableDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the schema name in CREATE TABLE is supported.
supportsSelectForUpdate() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether SELECT ...
supportsStatementPooling() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Does the database support statement pooling.
supportsStoredFunctionsUsingCallSyntax() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether the database supports calling functions using the call syntax.
supportsStoredProcedures() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether stored procedures are supported.
supportsSubqueriesInComparisons() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether subqueries (SELECT) in comparisons are supported.
supportsSubqueriesInExists() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether SELECT in EXISTS is supported.
supportsSubqueriesInIns() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether IN(SELECT...) is supported.
supportsSubqueriesInQuantifieds() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether subqueries in quantified expression are supported.
supportsTableCorrelationNames() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether table correlation names (table alias) are supported.
supportsTransactionIsolationLevel(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether a specific transaction isolation level is supported.
supportsTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether transactions are supported.
supportsUnion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether UNION SELECT is supported.
supportsUnionAll() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether UNION ALL SELECT is supported.
swapConvertFunctionParameters - Variable in class org.h2.engine.Mode
  Swap the parameters of the CONVERT function.
swapLogFunctionParameters - Variable in class org.h2.engine.Mode
  Swap the parameters of LOG() function.
sync() - Method in class org.h2.engine.Database
  Synchronize the files with the file system.
SYNONYM - Static variable in class org.h2.engine.DbObject
  This object is a synonym.
SYNTAX_ERROR_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42000` is thrown when trying to execute an invalid SQL statement.
SYNTAX_ERROR_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `42001` is thrown when trying to execute an invalid SQL statement.
sysDummy1 - Variable in class org.h2.engine.Mode
  Support the pseudo-table SYSIBM.SYSDUMMY1.
sysIdentifier(String) - Method in class org.h2.engine.Database
  Returns identifier in upper or lower case depending on database settings.
SysProperties - Class in org.h2.engine
  The constants defined in this class are initialized from system properties.
systemColumns - Variable in class org.h2.engine.Mode
  The system columns 'ctid' and 'oid' are supported.

## T

table - Variable in class org.h2.fulltext.IndexInfo
  The table name.
TABLE_OR_VIEW - Static variable in class org.h2.engine.DbObject
  The object is of the type table or view.
TABLE_OR_VIEW_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42101` is thrown when trying to create a table or view if an object with this name already exists.
TABLE_OR_VIEW_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42102` is thrown when trying to query, modify or drop a table or view that does not exists in this schema and database.
TABLE_OR_VIEW_NOT_FOUND_DATABASE_EMPTY_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `42104` is thrown when trying to query, modify or drop a table or view that does not exists in this schema and database but it is empty anyway.
TABLE_OR_VIEW_NOT_FOUND_WITH_CANDIDATES_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `42103` is thrown when trying to query, modify or drop a table or view that does not exists in this schema and database but similar names were found.
TableEngine - Interface in org.h2.api
  A class that implements this interface can create custom table implementations.
tableName - Variable in class org.h2.tools.TriggerAdapter
  The name of the table.
takeGeneratedSequenceValue - Variable in class org.h2.engine.Mode
  If `true`, last identity of the session is updated on generation of a new sequence value.
takeInsertedIdentity - Variable in class org.h2.engine.Mode
  If `true`, last identity of the session is updated on insertion of a new value into identity column.
TCP_PROTOCOL_VERSION_17 - Static variable in class org.h2.engine.Constants
  The TCP protocol version number 17.
TCP_PROTOCOL_VERSION_18 - Static variable in class org.h2.engine.Constants
  The TCP protocol version number 18.
TCP_PROTOCOL_VERSION_19 - Static variable in class org.h2.engine.Constants
  The TCP protocol version number 19.
TCP_PROTOCOL_VERSION_20 - Static variable in class org.h2.engine.Constants
  The TCP protocol version number 20.
TCP_PROTOCOL_VERSION_MAX_SUPPORTED - Static variable in class org.h2.engine.Constants
  Maximum supported version of TCP protocol.
TCP_PROTOCOL_VERSION_MIN_SUPPORTED - Static variable in class org.h2.engine.Constants
  Minimum supported version of TCP protocol.
THREAD_DEADLOCK_DETECTOR - Static variable in class org.h2.engine.SysProperties
  System property `h2.threadDeadlockDetector` (default: false).
throttle() - Method in class org.h2.engine.SessionLocal
  Wait for some time if this session is throttled (slowed down).
THROTTLE_DELAY - Static variable in class org.h2.engine.Constants
  How often we check to see if we need to apply a throttling delay if SET THROTTLE has been used.
throwException(String) - Static method in class org.h2.fulltext.FullText
  Throw a SQLException with the given message.
TIME - Static variable in class org.h2.api.H2Type
  The TIME data type.
TIME_WITH_TIME_ZONE - Static variable in class org.h2.api.H2Type
  The TIME WITH TIME ZONE data type.
TIMESTAMP - Static variable in class org.h2.api.H2Type
  The TIMESTAMP data type.
TIMESTAMP_WITH_TIME_ZONE - Static variable in class org.h2.api.H2Type
  The TIMESTAMP WITH TIME ZONE data type.
timeZone - Variable in class org.h2.engine.Session.DynamicSettings
  The current time zone.
TINYINT - Static variable in class org.h2.api.H2Type
  The TINYINT data type.
TOO_MANY_COLUMNS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `54011` is thrown when too many columns were specified in a table, select statement, or row value.
topInDML - Variable in class org.h2.engine.Mode
  Whether TOP clause in DML commands is supported.
topInSelect - Variable in class org.h2.engine.Mode
  Whether TOP clause in SELECT queries is supported.
toString() - Method in class org.h2.api.H2Type
toString() - Method in class org.h2.api.Interval
toString() - Method in enum org.h2.api.IntervalQualifier
toString() - Method in class org.h2.engine.Database
toString() - Method in class org.h2.engine.DbObject
toString() - Method in class org.h2.engine.MetaRecord
toString() - Method in class org.h2.engine.Mode
toString() - Method in class org.h2.engine.SessionLocal
toString() - Method in class org.h2.jdbc.JdbcArray
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcConnection
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  INTERNAL
toString() - Method in interface org.h2.jdbc.JdbcException
  Returns the class name, the message, and in the server mode, the stack trace of the server
toString() - Method in class org.h2.jdbc.JdbcLob
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcParameterMetaData
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcPreparedStatement
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcResultSet
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcResultSetMetaData
  INTERNAL
toString() - Method in class org.h2.jdbc.JdbcSavepoint
  INTERNAL
toString() - Method in exception org.h2.jdbc.JdbcSQLDataException
toString() - Method in exception org.h2.jdbc.JdbcSQLException
toString() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
toString() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
toString() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
toString() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
toString() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
toString() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
toString() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
toString() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
toString() - Method in exception org.h2.jdbc.JdbcSQLTransientException
toString() - Method in class org.h2.jdbc.JdbcStatement
  INTERNAL
toString() - Method in class org.h2.jdbcx.JdbcDataSource
  INTERNAL
toString() - Method in class org.h2.jdbcx.JdbcXAConnection
  INTERNAL
trace - Variable in class org.h2.engine.DbObject
  The trace module.
TRACE_CONNECTION_NOT_CLOSED - Static variable in class org.h2.api.ErrorCode
  The error with code `90018` is thrown when the connection was opened, but never closed.
TRACE_FILE_ERROR_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90034` is thrown when writing to the trace file failed, for example because the there is an I/O exception.
TRACE_IO - Static variable in class org.h2.engine.SysProperties
  System property `h2.traceIO` (default: false).
traceOperation(String, int) - Method in class org.h2.engine.SessionRemote
  Write the operation to the trace system if debug trace is enabled.
TRANSACTION_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90129` is thrown when trying to commit a transaction that doesn't exist.
TRANSACTION_SNAPSHOT - Static variable in class org.h2.engine.Constants
  SNAPSHOT isolation level of transaction.
treatEmptyStringsAsNull - Variable in class org.h2.engine.Mode
  Empty strings are treated like NULL values.
Trigger - Interface in org.h2.api
  A class that implements this interface can be used as a trigger.
TRIGGER - Static variable in class org.h2.engine.DbObject
  This object is a trigger.
TRIGGER_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90041` is thrown when trying to create a trigger and there is already a trigger with that name.
TRIGGER_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90042` is thrown when trying to drop a trigger that does not exist.
TriggerAdapter - Class in org.h2.tools
  An adapter for the trigger interface that allows to use the ResultSet interface instead of a row array.
TriggerAdapter() - Constructor for class org.h2.tools.TriggerAdapter
triggerName - Variable in class org.h2.tools.TriggerAdapter
  The name of the trigger.
truncate(long) - Method in class org.h2.jdbc.JdbcBlob
  [Not supported] Truncates the object.
truncate(long) - Method in class org.h2.jdbc.JdbcClob
  [Not supported] Truncates the object.
truncateTableRestartIdentity - Variable in class org.h2.engine.Mode
  If `true` TRUNCATE TABLE uses RESTART IDENTITY by default.
type - Variable in class org.h2.tools.TriggerAdapter
  The trigger type: INSERT, UPDATE, DELETE, SELECT, or a combination (a bit field).
typeByNameMap - Variable in class org.h2.engine.Mode
  Custom mappings from type names to data types.
TYPES_ARE_NOT_COMPARABLE_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90110` is thrown when trying to compare or combine values of incomparable data types.

## U

UNCOMPARABLE_REFERENCED_COLUMN_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90153` is thrown when trying to reference a column of another data type when data types aren't comparable or don't have a session-independent compare order between each other.
UNKNOWN_DATA_TYPE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `50004` is thrown when creating a table with an unsupported data type, or when the data type is unknown because parameters are used.
UNKNOWN_MODE_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90088` is thrown when trying to switch to an unknown mode.
unloadH2(Driver) - Static method in class org.h2.tools.Upgrade
  Unloads the specified driver of H2.
unlockMeta(SessionLocal) - Method in class org.h2.engine.Database
  Unlock the metadata table.
unsetExclusiveSession(SessionLocal) - Method in class org.h2.engine.Database
  Stop exclusive access the database by provided session.
UNSUPPORTED_CIPHER - Static variable in class org.h2.api.ErrorCode
  The error with code `90055` is thrown when trying to open a database with an unsupported cipher algorithm.
UNSUPPORTED_COMPRESSION_ALGORITHM_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90103` is thrown when trying to use an unsupported compression algorithm.
UNSUPPORTED_COMPRESSION_OPTIONS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90102` is thrown when trying to use unsupported options for the given compression algorithm.
UNSUPPORTED_LOCK_METHOD_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90060` is thrown when trying to use a file locking mechanism that is not supported.
UNSUPPORTED_SETTING_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90113` is thrown when the database URL contains unsupported settings.
UNSUPPORTED_SETTING_COMBINATION - Static variable in class org.h2.api.ErrorCode
  The error with code `90021` is thrown when trying to change a specific database property that conflicts with other database properties.
unwrap(Class<T>) - Method in class org.h2.jdbc.JdbcConnection
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbc.JdbcParameterMetaData
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbc.JdbcResultSet
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbc.JdbcResultSetMetaData
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbc.JdbcStatement
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbcx.JdbcConnectionPool
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.jdbcx.JdbcDataSource
  Return an object of this class if possible.
unwrap(Class<T>) - Method in class org.h2.tools.SimpleResultSet
  Return an object of this class if possible.
UPDATE - Static variable in interface org.h2.api.Trigger
  The trigger is called for UPDATE statements.
update(String, long, long) - Method in class org.h2.engine.QueryStatisticsData
  Update query statistics.
UPDATE - Static variable in class org.h2.engine.Right
  The right bit mask that means: updating data is allowed.
updateArray(int, Array) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateArray(String, Array) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateArray(int, Array) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateArray(String, Array) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateAsciiStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateAsciiStream(int, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateAsciiStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateAsciiStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateAsciiStream(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateAsciiStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateAsciiStream(int, InputStream) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateAsciiStream(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateAsciiStream(int, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateAsciiStream(String, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateAsciiStream(int, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateAsciiStream(String, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBigDecimal(int, BigDecimal) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBigDecimal(String, BigDecimal) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBigDecimal(int, BigDecimal) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBigDecimal(String, BigDecimal) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBinaryStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBinaryStream(int, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBinaryStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBinaryStream(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBinaryStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBinaryStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBinaryStream(int, InputStream) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBinaryStream(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBinaryStream(int, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBinaryStream(String, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBinaryStream(int, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBinaryStream(String, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBlob(int, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBlob(int, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBlob(int, Blob) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBlob(String, Blob) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBlob(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBlob(String, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBlob(int, Blob) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBlob(String, Blob) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBlob(int, InputStream) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBlob(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBlob(int, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBlob(String, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBoolean(int, boolean) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBoolean(String, boolean) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBoolean(int, boolean) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBoolean(String, boolean) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateByte(int, byte) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateByte(String, byte) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateByte(int, byte) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateByte(String, byte) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBytes(int, byte[]) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBytes(String, byte[]) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateBytes(int, byte[]) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateBytes(String, byte[]) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateCharacterStream(int, Reader, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateCharacterStream(String, Reader, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateCharacterStream(int, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCharacterStream(String, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCharacterStream(int, Reader, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCharacterStream(String, Reader, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCharacterStream(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCharacterStream(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateClob(int, Clob) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateClob(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateClob(String, Clob) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateClob(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateClob(int, Clob) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateClob(String, Clob) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateClob(int, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateClob(String, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateClob(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateClob(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateCount - Variable in class org.h2.jdbc.JdbcStatement
updateDate(int, Date) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateDate(String, Date) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateDate(int, Date) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateDate(String, Date) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateDouble(int, double) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateDouble(String, double) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateDouble(int, double) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateDouble(String, double) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateFloat(int, float) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateFloat(String, float) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateFloat(int, float) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateFloat(String, float) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateInt(int, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateInt(String, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateInt(int, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateInt(String, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateLong(int, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateLong(String, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateLong(int, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateLong(String, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateMeta(SessionLocal, DbObject) - Method in class org.h2.engine.Database
  Update an object in the system table.
updateNCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNCharacterStream(int, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNCharacterStream(String, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNCharacterStream(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNCharacterStream(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNClob(int, NClob) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNClob(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNClob(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNClob(String, NClob) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNClob(int, NClob) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNClob(String, NClob) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNClob(int, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNClob(String, Reader) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNClob(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNClob(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNString(int, String) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNString(String, String) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNString(int, String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNString(String, String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNull(int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNull(String) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateNull(int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateNull(String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateObject(int, Object, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(String, Object, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(int, Object) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(String, Object) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(int, Object, SQLType) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(int, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(String, Object, SQLType) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(String, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateObject(int, Object) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateObject(String, Object) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateObject(int, Object, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateObject(String, Object, int) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateRef(int, Ref) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported]
updateRef(String, Ref) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported]
updateRef(int, Ref) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateRef(String, Ref) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateRow() - Method in class org.h2.jdbc.JdbcResultSet
  Updates the current row.
updateRow() - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateRowId(int, RowId) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Updates a column in the current or insert row.
updateRowId(String, RowId) - Method in class org.h2.jdbc.JdbcResultSet
  [Not supported] Updates a column in the current or insert row.
updateRowId(int, RowId) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateRowId(String, RowId) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updatesAreDetected(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Returns whether updates are detected.
updateSequenceOnManualIdentityInsertion - Variable in class org.h2.engine.Mode
  If `true`, sequences of generated by default identity columns are updated when value is provided by user.
updateShort(int, short) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateShort(String, short) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateShort(int, short) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateShort(String, short) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateSQLXML(int, SQLXML) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateSQLXML(String, SQLXML) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateSQLXML(int, SQLXML) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateSQLXML(String, SQLXML) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateString(int, String) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateString(String, String) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateString(int, String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateString(String, String) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateTime(int, Time) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateTime(String, Time) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateTime(int, Time) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateTime(String, Time) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateTimestamp(int, Timestamp) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateTimestamp(String, Timestamp) - Method in class org.h2.jdbc.JdbcResultSet
  Updates a column in the current or insert row.
updateTimestamp(int, Timestamp) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
updateTimestamp(String, Timestamp) - Method in class org.h2.tools.SimpleResultSet
  INTERNAL
Upgrade - Class in org.h2.tools
  Upgrade utility.
upgrade(String, Properties, int) - Static method in class org.h2.tools.Upgrade
  Performs database upgrade from an older version of H2.
URL_FORMAT - Static variable in class org.h2.engine.Constants
  The database URL format in simplified Backus-Naur form.
URL_FORMAT_ERROR_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90046` is thrown when trying to open a connection to a database using an unsupported URL format.
URL_MAP - Static variable in class org.h2.engine.SysProperties
  System property `h2.urlMap` (default: null).
URL_RELATIVE_TO_CWD - Static variable in class org.h2.api.ErrorCode
  The error with code `90011` is thrown when trying to open a connection to a database using an implicit relative path, such as "jdbc:h2:test" (in which case the database file would be stored in the current working directory of the application).
USE_THREAD_CONTEXT_CLASS_LOADER - Static variable in class org.h2.engine.SysProperties
  System property `h2.useThreadContextClassLoader` (default: false).
USER - Static variable in class org.h2.engine.DbObject
  This object is a user.
User - Class in org.h2.engine
  Represents a user object.
User(Database, int, String, boolean) - Constructor for class org.h2.engine.User
USER_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90033` is thrown when trying to create a user or role if a user with this name already exists.
USER_DATA_TYPE_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  Deprecated.
USER_DATA_TYPE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  Deprecated.
USER_HOME - Static variable in class org.h2.engine.SysProperties
  System property `user.home` (empty string if not set).
USER_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90032` is thrown when trying to drop or alter a user that does not exist.
USER_OR_ROLE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90071` is thrown when trying to grant or revoke if no role or user with that name exists.
USER_PACKAGE - Static variable in class org.h2.engine.Constants
  The package name of user defined classes.
UserBuilder - Class in org.h2.engine
UserBuilder() - Constructor for class org.h2.engine.UserBuilder
UserToRolesMapper - Interface in org.h2.api
  A class that implement this interface can be used during authentication to map external users to database roles.
usesLocalFilePerTable() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if this database use one file per table.
usesLocalFiles() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
  Checks if this database store data in local files.
UUID - Static variable in class org.h2.api.H2Type
  The UUID data type.

## V

validateCredentials(AuthenticationInfo) - Method in interface org.h2.api.CredentialsValidator
  Validate user credential.
VALUE_TOO_LONG_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `22001` is thrown when trying to insert a value that is too long for the column.
valueOf(String) - Static method in enum org.h2.api.IntervalQualifier
  Returns the enum constant of this type with the specified name.
valueOf(int) - Static method in enum org.h2.api.IntervalQualifier
  Returns the interval qualifier with the specified ordinal value.
valueOf(Object) - Static method in class org.h2.engine.GeneratedKeysMode
  Determines mode of generated keys' gathering.
valueOf(String) - Static method in enum org.h2.engine.IsolationLevel
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.engine.Mode.CharPadding
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.engine.Mode.ExpressionNames
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.engine.Mode.ModeEnum
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.engine.Mode.ViewExpressionNames
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.engine.NullsDistinct
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.engine.SessionLocal.State
  Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.h2.jdbc.JdbcLob.State
  Returns the enum constant of this type with the specified name.
values() - Static method in enum org.h2.api.IntervalQualifier
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.IsolationLevel
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.Mode.CharPadding
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.Mode.ExpressionNames
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.Mode.ModeEnum
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.Mode.ViewExpressionNames
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.NullsDistinct
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.engine.SessionLocal.State
  Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.h2.jdbc.JdbcLob.State
  Returns an array containing the constants of this enum type, in the order they are declared.
VARBINARY - Static variable in class org.h2.api.H2Type
  The BINARY VARYING data type.
VARCHAR - Static variable in class org.h2.api.H2Type
  The CHARACTER VARYING data type.
VARCHAR_IGNORECASE - Static variable in class org.h2.api.H2Type
  The VARCHAR_IGNORECASE data type.
verifyMetaLocked(SessionLocal) - Method in class org.h2.engine.Database
  Verify the meta table is locked.
VERSION - Static variable in class org.h2.engine.Constants
  The version of this product, consisting of major version, minor version, and build id.
VERSION_MAJOR - Static variable in class org.h2.engine.Constants
  The major version of this database.
VERSION_MINOR - Static variable in class org.h2.engine.Constants
  The minor version of this database.
VIEW_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90038` is thrown when trying to create a view if a view with this name already exists.
VIEW_COST_CACHE_MAX_AGE - Static variable in class org.h2.engine.Constants
  The maximum time in milliseconds to keep the cost of a view.
VIEW_INDEX_CACHE_SIZE - Static variable in class org.h2.engine.Constants
  The name of the index cache that is used for temporary view (subqueries used as tables).
VIEW_IS_INVALID_2 - Static variable in class org.h2.api.ErrorCode
  The error with code `90109` is thrown when trying to run a query against an invalid view.
VIEW_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90037` is thrown when trying to drop or alter a view that does not exist.
viewExpressionNames - Variable in class org.h2.engine.Mode
  How column names are generated for views.

## W

waitIfExclusiveModeEnabled() - Method in class org.h2.engine.SessionLocal
  Wait if the exclusive mode has been enabled for another session.
wasNull() - Method in class org.h2.jdbc.JdbcCallableStatement
  Returns whether the last column accessed was null.
wasNull() - Method in class org.h2.jdbc.JdbcResultSet
  Returns whether the last column accessed was null.
wasNull() - Method in class org.h2.tools.SimpleResultSet
  Returns whether the last column accessed was null.
WINDOW_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90136` is thrown when trying to reference a window that does not exist.
windowActivated(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
windowClosed(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
windowClosing(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
windowDeactivated(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
windowDeiconified(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
windowIconified(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
windowOpened(WindowEvent) - Method in class org.h2.tools.GUIConsole
  INTERNAL
WITH_TIES_WITHOUT_ORDER_BY - Static variable in class org.h2.api.ErrorCode
  The error with code `90122` is thrown when WITH TIES clause is used without ORDER BY clause.
wrapInputStream(InputStream, String, String) - Static method in class org.h2.tools.CompressTool
  INTERNAL
wrapOutputStream(OutputStream, String, String) - Static method in class org.h2.tools.CompressTool
  INTERNAL
write(Writer, ResultSet) - Method in class org.h2.tools.Csv
  Writes the result set to a file in the CSV format.
write(String, ResultSet, String) - Method in class org.h2.tools.Csv
  Writes the result set to a file in the CSV format.
write(Connection, String, String, String) - Method in class org.h2.tools.Csv
  Writes the result set of a query to a file in the CSV format.
writeVariableInt(byte[], int, int) - Static method in class org.h2.tools.CompressTool
  Write a variable size integer using Rice coding.
WRONG_PASSWORD_FORMAT - Static variable in class org.h2.api.ErrorCode
  The error with code `90050` is thrown when trying to open an encrypted database, but not separating the file password from the user password.
WRONG_USER_OR_PASSWORD - Static variable in class org.h2.api.ErrorCode
  The error with code `28000` is thrown when there is no such user registered in the database, when the user password does not match, or when the database encryption password does not match (if database encryption is used).
WRONG_XID_FORMAT_1 - Static variable in class org.h2.api.ErrorCode
  The error with code `90101` is thrown when the XA API detected unsupported transaction names.

## Z

zeroBasedEnums() - Method in interface org.h2.engine.CastDataProvider
  Returns are ENUM values 0-based.
zeroBasedEnums() - Method in class org.h2.engine.Database
zeroBasedEnums - Variable in class org.h2.engine.DbSettings
  Database setting `ZERO_BASED_ENUMS` (default: false).
zeroBasedEnums() - Method in class org.h2.engine.SessionLocal
zeroBasedEnums() - Method in class org.h2.engine.SessionRemote
zeroBasedEnums() - Method in class org.h2.jdbc.JdbcConnection
zeroExLiteralsAreBinaryStrings - Variable in class org.h2.engine.Mode
  If `true` `0x`-prefixed numbers are parsed as binary string literals, if `false` they are parsed as hexadecimal numeric values.

A B C D E F G H I J K L M N O P Q R S T U V W Z