Index

A B C D E F G H I J K L M N O P Q R S T U V W Y Z 
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form

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() - Method in class org.h2.jdbc.JdbcPreparedStatement
Adds the current settings to the batch.
addBatch(String) - Method in class org.h2.jdbc.JdbcPreparedStatement
Calling this method is not legal on a PreparedStatement.
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.
ALL_DISTINCT - Enum constant in enum class org.h2.engine.NullsDistinct
NULL values of columns are distinct only if all columns have null values.
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 class 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.
ALWAYS - Enum constant in enum class org.h2.engine.Mode.CharPadding
CHAR values are always right-padded with spaces.
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.
AS_IS - Enum constant in enum class org.h2.engine.Mode.ViewExpressionNames
Use both specified and generated names as is.
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.
BLOCKED - Enum constant in enum class org.h2.engine.SessionLocal.State
 
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

C_NUMBER - Enum constant in enum class org.h2.engine.Mode.ExpressionNames
Use ordinal number of a column with C prefix.
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.
CLOSED - Enum constant in enum class org.h2.engine.SessionLocal.State
 
CLOSED - Enum constant in enum class org.h2.jdbc.JdbcLob.State
Object is closed.
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_BATCH_UPDATE - 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 - Variable in class org.h2.engine.DbObject
The comment (if set).
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.
commit() - Method in class org.h2.jdbc.JdbcConnection
Commits the current transaction.
commit(boolean) - Method in class org.h2.engine.SessionLocal
Commit 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(long[], long[]) - Method in class org.h2.tools.MultiDimension
 
compare(Value, Value) - Method in class org.h2.engine.SessionLocal
Compare two values with the current comparison mode.
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(String, String, String) - Static method in class org.h2.jdbcx.JdbcConnectionPool
Constructs a new connection pool for H2 databases.
create(ConnectionPoolDataSource) - Static method in class org.h2.jdbcx.JdbcConnectionPool
Constructs a new connection pool.
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 - Variable in class org.h2.engine.DbObject
The database.
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_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.
DAY - Enum constant in enum class org.h2.api.IntervalQualifier
DAY
DAY_TO_HOUR - Enum constant in enum class org.h2.api.IntervalQualifier
DAY TO HOUR
DAY_TO_MINUTE - Enum constant in enum class org.h2.api.IntervalQualifier
DAY TO MINUTE
DAY_TO_SECOND - Enum constant in enum class org.h2.api.IntervalQualifier
DAY TO SECOND
DB2 - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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.
Derby - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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.
DISTINCT - Enum constant in enum class org.h2.engine.NullsDistinct
NULL values of columns are distinct.
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

EMPTY - Enum constant in enum class org.h2.engine.Mode.ExpressionNames
Generate empty name.
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
 
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 - Enum constant in enum class org.h2.engine.Mode.ViewExpressionNames
Throw exception for unspecified names.
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) - Static method in class org.h2.tools.Recover
Dumps the contents of a database to a SQL script file.
execute(String, String[]) - Method in class org.h2.jdbc.JdbcStatement
Executes a statement and returns type of its result.
execute(String, String, boolean) - Static method in class org.h2.tools.DeleteDbFiles
Deletes the database files.
execute(String, String, String) - Static method in class org.h2.tools.Restore
Restores database files.
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, String, String, Charset, boolean) - Static method in class org.h2.tools.RunScript
Executes the SQL commands in a script file against a database.
execute(Connection, Reader) - Static method in class org.h2.tools.RunScript
Executes the SQL commands read from the reader 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 class 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 class 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 class 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() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
Get the object array.
getArray(int) - 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(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.sql.Array.
getArray(long, int) - Method in class org.h2.jdbc.JdbcArray
Returns the value as a Java array.
getArray(long, int) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
INTERNAL
getArray(long, int, Map<String, Class<?>>) - 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.tools.SimpleResultSet.SimpleArray
INTERNAL
getArray(String) - 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.JdbcResultSet
Returns the value of the specified column as an Array.
getArray(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.sql.Array.
getArray(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
Returns the value as a Java array.
getArray(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(int) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getAsciiStream(String) - 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.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) - 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(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.math.BigDecimal.
getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcResultSet
getBigDecimal(int, int) - Method in class org.h2.tools.SimpleResultSet
Deprecated.
INTERNAL
getBigDecimal(String) - 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.JdbcResultSet
Returns the value of the specified column as a BigDecimal.
getBigDecimal(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.math.BigDecimal.
getBigDecimal(String, int) - Method in class org.h2.jdbc.JdbcResultSet
getBigDecimal(String, int) - Method in class org.h2.tools.SimpleResultSet
Deprecated.
INTERNAL
getBinaryStream() - Method in class org.h2.jdbc.JdbcBlob
 
getBinaryStream() - Method in class org.h2.jdbc.JdbcSQLXML
 
getBinaryStream(int) - Method in class org.h2.jdbc.JdbcResultSet
Returns the value of the specified column as an input stream.
getBinaryStream(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.io.InputStream.
getBinaryStream(long, long) - Method in class org.h2.jdbc.JdbcBlob
Returns the input stream, starting from an offset.
getBinaryStream(String) - 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.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(int) - 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.jdbc.JdbcCallableStatement
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(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(int) - 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.jdbc.JdbcCallableStatement
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(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(int) - 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.jdbc.JdbcCallableStatement
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(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a byte.
getBytes(int) - 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(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a byte array.
getBytes(long, int) - Method in class org.h2.jdbc.JdbcBlob
Returns some bytes of the object.
getBytes(String) - 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.JdbcResultSet
Returns the value of the specified column 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() - Method in class org.h2.jdbc.JdbcClob
 
getCharacterStream() - Method in class org.h2.jdbc.JdbcSQLXML
 
getCharacterStream(int) - Method in class org.h2.jdbc.JdbcCallableStatement
Returns the value of the specified column as a reader.
getCharacterStream(int) - Method in class org.h2.jdbc.JdbcResultSet
Returns the value of the specified column as a reader.
getCharacterStream(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.io.Reader.
getCharacterStream(long, long) - Method in class org.h2.jdbc.JdbcClob
Returns the reader, starting from an offset.
getCharacterStream(String) - 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.JdbcResultSet
Returns the value of the specified column as a 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(int) - 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.jdbc.JdbcCallableStatement
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(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() - Method in class org.h2.jdbcx.JdbcDataSource
Open a new connection using the current URL, user name and password.
getConnection() - Method in class org.h2.jdbcx.JdbcXAConnection
Get a connection that is a handle to the physical connection.
getConnection(String, String) - Method in class org.h2.jdbcx.JdbcConnectionPool
INTERNAL
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.
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() - 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.Role
Get the CREATE SQL statement for this object.
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) - Method in class org.h2.jdbc.JdbcResultSet
Returns the value of the specified column as a java.sql.Date.
getDate(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as an 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(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(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getDate(String) - Method in class org.h2.jdbc.JdbcCallableStatement
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(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.sql.Date.
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, 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.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(int) - 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.jdbc.JdbcCallableStatement
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(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(int) - 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.jdbc.JdbcCallableStatement
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(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.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() - Static method in class org.h2.tools.CompressTool
Get a new instance.
getInstance() - Static method in class org.h2.tools.MultiDimension
Get the singleton.
getInstance(String) - Static method in class org.h2.engine.Mode
Get the mode with the given name.
getInt(int) - 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(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as an int.
getInt(String) - 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.JdbcResultSet
Returns the value of the specified column 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 class 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 class 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(int) - 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.jdbc.JdbcCallableStatement
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(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a long.
getMainClassName() - Method in class org.h2.tools.GUIConsole
 
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(int) - 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.jdbc.JdbcCallableStatement
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(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(int) - 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.jdbc.JdbcCallableStatement
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(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(int) - 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.jdbc.JdbcCallableStatement
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(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) - Method in class org.h2.jdbc.JdbcResultSet
Returns a column value as a Java object.
getObject(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as an 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(int, Class<T>) - Method in class org.h2.jdbc.JdbcResultSet
Returns a column value as a Java object of the specified type.
getObject(int, 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.jdbc.JdbcCallableStatement
[Not supported] Gets a column as a object using the specified type mapping.
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(int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getObject(String) - Method in class org.h2.jdbc.JdbcCallableStatement
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(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as an Object.
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(String, 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.tools.SimpleResultSet
Returns the value as an Object of the specified type.
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, 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.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(int) - 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.jdbc.JdbcCallableStatement
[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(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() - 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(long, int) - Method in class org.h2.jdbc.JdbcArray
Returns the value as a result set.
getResultSet(long, int) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
INTERNAL
getResultSet(long, int, Map<String, Class<?>>) - 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.tools.SimpleResultSet.SimpleArray
INTERNAL
getResultSet(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
Returns the value as a result set.
getResultSet(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(int) - 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.jdbc.JdbcCallableStatement
[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(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() - Method in class org.h2.jdbc.JdbcConnection
Retrieves this current schema name for this connection.
getSchema(String) - Method in class org.h2.engine.Database
Get the schema.
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(int) - 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.jdbc.JdbcCallableStatement
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(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() - Method in enum class org.h2.engine.IsolationLevel
Returns the SQL representation of this isolation level.
getSQL() - Method in class org.h2.engine.MetaRecord
 
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
 
getSQL(int) - Method in class org.h2.engine.DbObject
 
getSQL(int) - Method in class org.h2.engine.Setting
 
getSQL(StringBuilder, int) - Method in class org.h2.engine.DbObject
 
getSQL(StringBuilder, int) - Method in enum class org.h2.engine.NullsDistinct
 
getSQL(StringBuilder, int) - Method in class org.h2.engine.Setting
 
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(int) - 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.jdbc.JdbcCallableStatement
Returns the value of the specified column as a SQLXML object.
getSQLXML(String) - Method in class org.h2.jdbc.JdbcResultSet
Returns the value of the specified column as a SQLXML.
getSQLXML(String) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getState() - Method in class org.h2.engine.SessionLocal
 
getState(int) - Static method in class org.h2.api.ErrorCode
INTERNAL
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.
getStatementModificationDataId() - Method in class org.h2.engine.SessionLocal
Returns database data modification id on start of the current command.
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() - Method in class org.h2.jdbc.JdbcSQLXML
 
getString(int) - 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(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a String.
getString(String) - 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.JdbcResultSet
Returns the value of the specified column 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) - Method in class org.h2.jdbc.JdbcResultSet
Returns the value of the specified column as a java.sql.Time.
getTime(int) - Method in class org.h2.tools.SimpleResultSet
Returns the value as an 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(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(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getTime(String) - Method in class org.h2.jdbc.JdbcCallableStatement
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(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.sql.Time.
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, 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.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) - 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(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(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(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getTimestamp(String) - Method in class org.h2.jdbc.JdbcCallableStatement
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(String) - Method in class org.h2.tools.SimpleResultSet
Returns the value as a java.sql.Timestamp.
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, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
Returns the value of the specified column as a java.sql.Timestamp.
getTimestamp(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getTimeZone() - Method in class org.h2.engine.ConnectionInfo
Returns the time zone.
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
 
getTrace(int) - Method in class org.h2.engine.Database
Get the trace object for the given module id.
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() - 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.
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.
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 class org.h2.api.IntervalQualifier
Returns full type name.
getTypeName(StringBuilder, int, int, boolean) - Method in enum class 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(int) - Method in class org.h2.tools.SimpleResultSet
Deprecated.
INTERNAL
getUnicodeStream(String) - Method in class org.h2.jdbc.JdbcResultSet
Deprecated.
since JDBC 2.0, use setCharacterStream
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.jdbcx.JdbcDataSource
Get the current URL.
getURL() - Method in class org.h2.engine.ConnectionInfo
Get the database URL.
getURL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
Returns the database URL for this connection.
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.jdbc.JdbcCallableStatement
[Not supported]
getURL(int) - Method in class org.h2.jdbc.JdbcResultSet
[Not supported]
getURL(int) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getURL(String) - Method in class org.h2.jdbc.JdbcCallableStatement
[Not supported]
getURL(String) - Method in class org.h2.jdbc.JdbcResultSet
[Not supported]
getURL(String) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
getUser() - Method in class org.h2.engine.SessionLocal
 
getUser() - Method in class org.h2.jdbcx.JdbcDataSource
Get the current user name.
getUser(String) - Method in class org.h2.engine.Database
Get user with the given 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.
getWriteDelay() - Method in class org.h2.engine.Database
 
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.
greatestLeastIgnoreNulls - Variable in class org.h2.engine.Mode
If true GREATEST and LEAST ignore nulls
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 class 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 class org.h2.api.IntervalQualifier
Returns whether interval with this qualifier has hours.
hasMinutes() - Method in enum class org.h2.api.IntervalQualifier
Returns whether interval with this qualifier has minutes.
hasMonths() - Method in enum class org.h2.api.IntervalQualifier
Returns whether interval with this qualifier has months.
hasMultipleFields() - Method in enum class 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 class 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 class 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.
HOUR - Enum constant in enum class org.h2.api.IntervalQualifier
HOUR
HOUR_TO_MINUTE - Enum constant in enum class org.h2.api.IntervalQualifier
HOUR TO MINUTE
HOUR_TO_SECOND - Enum constant in enum class org.h2.api.IntervalQualifier
HOUR TO SECOND
HSQLDB - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 

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).
IN_RESULT_SETS - Enum constant in enum class org.h2.engine.Mode.CharPadding
Spaces are trimmed from the right side of CHAR values, but CHAR values in result sets are right-padded with spaces to the declared length
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(String) - Method in interface org.h2.api.DatabaseEventListener
This method is called just after creating the object.
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(Connection) - Static method in class org.h2.fulltext.FullText
Initializes full text search functionality for this database.
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 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, String, String, String, boolean, int) - Method in class org.h2.fulltext.FullTextLucene.FullTextTrigger
INTERNAL
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.
INIT - Enum constant in enum class org.h2.engine.SessionLocal.State
 
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 Class 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 class 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
 
isLockedByCurrentThread() - Method in class org.h2.engine.Session
Returns whether this session is locked by the current thread.
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 Class 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.
isQuotedNulls() - Method in class org.h2.tools.Csv
Returns true if the null values are quoted.
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
 
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 class 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(Session, String, String) - Constructor for class org.h2.jdbc.JdbcConnection
INTERNAL
JdbcConnection(JdbcConnection) - Constructor for class org.h2.jdbc.JdbcConnection
INTERNAL
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.
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 Class 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.
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.
LEGACY - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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() - Method in class org.h2.engine.Session
Locks this session with a reentrant lock.
lock() - Method in class org.h2.jdbc.JdbcConnection
Locks this connection with a reentrant lock.
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.
MariaDB - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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.
MINUTE - Enum constant in enum class org.h2.api.IntervalQualifier
MINUTE
MINUTE_TO_SECOND - Enum constant in enum class org.h2.api.IntervalQualifier
MINUTE TO SECOND
mode - Variable in class org.h2.engine.Session.DynamicSettings
The database mode.
Mode - Class in org.h2.engine
The compatibility modes.
Mode.CharPadding - Enum Class in org.h2.engine
When CHAR values are right-padded with spaces.
Mode.ExpressionNames - Enum Class in org.h2.engine
Generation of column names for expressions.
Mode.ModeEnum - Enum Class in org.h2.engine
 
Mode.ViewExpressionNames - Enum Class in org.h2.engine
Generation of column names for expressions to be used in a view.
MONTH - Enum constant in enum class org.h2.api.IntervalQualifier
MONTH
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
MSSQLServer - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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
Protected constructor
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).
MySQL - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
MYSQL_STYLE - Enum constant in enum class org.h2.engine.Mode.ViewExpressionNames
Use both specified and generated names as is, but replace too long generated names with Name_exp_###.
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.
NEVER - Enum constant in enum class org.h2.engine.Mode.CharPadding
Spaces are trimmed from the right side of CHAR values.
NEW - Enum constant in enum class org.h2.jdbc.JdbcLob.State
New object without a value.
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_DISTINCT - Enum constant in enum class org.h2.engine.NullsDistinct
NULL values of columns are never distinct.
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 Class in org.h2.engine
Determines how rows with NULL values in indexed columns are handled in unique indexes, unique constraints, or by unique predicate.
NUMBER - Enum constant in enum class org.h2.engine.Mode.ExpressionNames
Use ordinal number of a column.
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
OPTIMIZED_SQL - Enum constant in enum class org.h2.engine.Mode.ExpressionNames
Use optimized SQL representation of expression.
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).
Oracle - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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.
ORIGINAL_SQL - Enum constant in enum class org.h2.engine.Mode.ExpressionNames
Use original SQL representation of expression.
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(String, long) - Method in class org.h2.jdbc.JdbcClob
[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(Clob, long) - Method in class org.h2.jdbc.JdbcClob
[Not supported] Searches a pattern and return the position.
PostgreSQL - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
POSTGRESQL_STYLE - Enum constant in enum class org.h2.engine.Mode.ExpressionNames
Use function name for functions and ?column? for other expressions
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, QueryScope) - 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, QueryScope) - 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) - 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, 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, 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(PrintStream) - Method in exception org.h2.jdbc.JdbcBatchUpdateException
INTERNAL
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLDataException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
 
printStackTrace(PrintStream) - Method in exception org.h2.jdbc.JdbcSQLTransientException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcBatchUpdateException
INTERNAL
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLDataException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
 
printStackTrace(PrintWriter) - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
 
printStackTrace(PrintWriter) - 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(Reader, String[]) - Method in class org.h2.tools.Csv
Reads CSV data from a reader and returns a result set.
read(String, String[], String) - Method in class org.h2.tools.Csv
Reads from the CSV file and returns a result set.
READ_COMMITTED - Enum constant in enum class org.h2.engine.IsolationLevel
Dirty reads aren't allowed; non-repeatable reads and phantom reads are allowed.
READ_UNCOMMITTED - Enum constant in enum class org.h2.engine.IsolationLevel
Dirty reads, non-repeatable reads and phantom reads are allowed.
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.
readSQLException(Transfer) - Static method in class org.h2.engine.SessionRemote
Reads an exception as SQL exception.
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, 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(String, int) - 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, String) - 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.
REGULAR - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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.
REPEATABLE_READ - Enum constant in enum class org.h2.engine.IsolationLevel
Dirty reads and non-repeatable reads aren't allowed; phantom reads are allowed.
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 - Class in org.h2.engine
An access right.
Right(Database, int, RightOwner, int, DbObject) - Constructor for class org.h2.engine.Right
 
Right(Database, int, RightOwner, Role) - Constructor for class org.h2.engine.Right
 
RIGHT - Static variable in class org.h2.engine.DbObject
This object is a 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 - Class in org.h2.engine
Represents a role.
Role(Database, int, String, boolean) - Constructor for class org.h2.engine.Role
 
ROLE - Static variable in class org.h2.engine.DbObject
This object is a 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.
RUNNING - Enum constant in enum class org.h2.engine.SessionLocal.State
 
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 - Variable in class org.h2.fulltext.IndexInfo
The schema name.
SCHEMA - Static variable in class org.h2.engine.DbObject
This object is a schema.
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) - 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.FullText
Do the search.
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 - Enum constant in enum class org.h2.api.IntervalQualifier
SECOND
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.
SERIALIZABLE - Enum constant in enum class org.h2.engine.IsolationLevel
Dirty reads, non-repeatable reads and phantom reads are'n allowed.
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
Generic constructor
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 - Variable in class org.h2.jdbc.JdbcStatement
 
Session - Class in org.h2.engine
A local or remote session.
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
 
Session.DynamicSettings - Class in org.h2.engine
Dynamic settings.
Session.StaticSettings - Class in org.h2.engine
Static settings.
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 Class 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
 
SET_CALLED - Enum constant in enum class org.h2.jdbc.JdbcLob.State
One of setter methods is invoked, but stream is not closed yet.
setAdmin(boolean) - Method in class org.h2.engine.User
 
setAllowBuiltinAliasOverride(boolean) - Method in class org.h2.engine.Database
 
setAllowLiterals(boolean) - Method in class org.h2.engine.SessionLocal
 
setAllowLiterals(int) - Method in class org.h2.engine.Database
 
setArray(int, Array) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter as an Array.
setAsciiStream(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter as an ASCII 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(long) - Method in class org.h2.jdbc.JdbcClob
[Not supported] Returns an output 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(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, BigDecimal) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setBigDecimal(String, BigDecimal) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter.
setBinaryStream() - Method in class org.h2.jdbc.JdbcSQLXML
 
setBinaryStream(int, InputStream) - 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, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter as an input stream.
setBinaryStream(long) - Method in class org.h2.jdbc.JdbcBlob
Get a writer to update the Blob.
setBinaryStream(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter as an input stream.
setBinaryStream(String, InputStream, int) - 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.
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.
setBlob(int, Blob) - Method in class org.h2.jdbc.JdbcPreparedStatement
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(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.
setBoolean(int, boolean) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setBoolean(String, boolean) - 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.
setByte(String, byte) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter.
setBytes(int, byte[]) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter as a byte array.
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.
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() - Method in class org.h2.jdbc.JdbcSQLXML
 
setCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter as a character stream.
setCharacterStream(int, Reader, int) - 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(long) - Method in class org.h2.jdbc.JdbcClob
Get a writer to update the Clob.
setCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter as a character stream.
setCharacterStream(String, Reader, int) - 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.
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(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.
setClob(int, Clob) - Method in class org.h2.jdbc.JdbcPreparedStatement
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(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.
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(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.
setDate(String, Date) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter.
setDate(String, Date, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, double) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setDouble(String, double) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, float) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setFloat(String, float) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setInt(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setLong(String, long) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
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(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter as a character stream.
setNCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter as a character stream.
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.
setNClob(int, NClob) - Method in class org.h2.jdbc.JdbcPreparedStatement
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(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter as a Clob.
setNClob(String, NClob) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setNString(String, String) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter.
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.
setNull(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets a parameter to null.
setNull(String, int, String) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets a parameter to null.
setNullString(String) - Method in class org.h2.tools.Csv
Set the value that represents NULL.
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.
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.
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.
setQuotedNulls(boolean) - Method in class org.h2.tools.Csv
Defines if the null values must be quoted.
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(int, RowId) - Method in class org.h2.jdbc.JdbcPreparedStatement
[Not supported] Sets the value of a parameter as a row id.
setRowId(String, RowId) - Method in class org.h2.jdbc.JdbcCallableStatement
[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(int, short) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter.
setShort(String, short) - Method in class org.h2.jdbc.JdbcCallableStatement
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(int, SQLXML) - Method in class org.h2.jdbc.JdbcPreparedStatement
Sets the value of a parameter as a SQLXML.
setSQLXML(String, SQLXML) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter as a SQLXML object.
setString(int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
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(String) - Method in class org.h2.jdbc.JdbcSQLXML
 
setString(String, String) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter.
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(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.
setTime(String, Time) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the time using a specified time zone.
setTime(String, Time, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the time using a specified time zone.
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.
setTimestamp(String, Timestamp) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the value of a parameter.
setTimestamp(String, Timestamp, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
Sets the timestamp using a specified time zone.
setTimeZone(TimeZoneProvider) - Method in class org.h2.engine.SessionLocal
Sets current time zone.
Setting - Class in org.h2.engine
A persistent database setting.
Setting(Database, int, String) - Constructor for class org.h2.engine.Setting
 
SETTING - Static variable in class org.h2.engine.DbObject
This object is a 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) - Method in class org.h2.jdbcx.JdbcDataSource
Set the current URL.
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, URL) - Method in class org.h2.jdbc.JdbcCallableStatement
[Not supported]
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.
SLEEP - Enum constant in enum class org.h2.engine.SessionLocal.State
 
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.
SNAPSHOT - Enum constant in enum class org.h2.engine.IsolationLevel
Dirty reads, non-repeatable reads and phantom reads are'n allowed.
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() - Method in class org.h2.tools.Server
Tries to start the server.
start(Xid, int) - Method in class org.h2.jdbcx.JdbcXAConnection
Start or continue to work on a transaction.
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.
STRICT - Enum constant in enum class org.h2.engine.Mode.ModeEnum
 
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.
SUSPENDED - Enum constant in enum class org.h2.engine.SessionLocal.State
 
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_21 - Static variable in class org.h2.engine.Constants
The TCP protocol version number 21.
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.
THROTTLED - Enum constant in enum class org.h2.engine.SessionLocal.State
 
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 class 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.
unlock() - Method in class org.h2.engine.Session
Unlocks this session.
unlock() - Method in class org.h2.jdbc.JdbcConnection
Unlocks this connection.
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(String, long, long) - Method in class org.h2.engine.QueryStatisticsData
Update query statistics.
UPDATE - Static variable in interface org.h2.api.Trigger
The trigger is called for UPDATE statements.
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(int, Array) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateArray(String, 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.tools.SimpleResultSet
INTERNAL
updateAsciiStream(int, InputStream) - 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(int, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateAsciiStream(int, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateAsciiStream(int, InputStream, long) - 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.tools.SimpleResultSet
INTERNAL
updateAsciiStream(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateAsciiStream(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateAsciiStream(String, InputStream, int) - 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.tools.SimpleResultSet
INTERNAL
updateAsciiStream(String, InputStream, long) - 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.tools.SimpleResultSet
INTERNAL
updateBigDecimal(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateBigDecimal(String, BigDecimal) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateBinaryStream(int, InputStream) - 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(int, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateBinaryStream(int, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateBinaryStream(int, InputStream, long) - 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.tools.SimpleResultSet
INTERNAL
updateBinaryStream(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateBinaryStream(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateBinaryStream(String, InputStream, int) - 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.tools.SimpleResultSet
INTERNAL
updateBinaryStream(String, InputStream, long) - 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.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) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateBlob(int, InputStream, long) - 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.tools.SimpleResultSet
INTERNAL
updateBlob(int, Blob) - 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, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateBlob(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateBlob(String, InputStream, long) - 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.tools.SimpleResultSet
INTERNAL
updateBlob(String, 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.tools.SimpleResultSet
INTERNAL
updateBoolean(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
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(int, byte) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateByte(String, 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.tools.SimpleResultSet
INTERNAL
updateBytes(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateBytes(String, byte[]) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateCharacterStream(int, Reader) - 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(int, Reader, int) - 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.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, long) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateCharacterStream(String, Reader) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateCharacterStream(String, Reader, int) - 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.tools.SimpleResultSet
INTERNAL
updateCharacterStream(String, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateClob(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateClob(int, Reader) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateClob(int, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateClob(int, Clob) - 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, Reader) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateClob(String, Reader) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateClob(String, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateClob(String, Clob) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateClob(String, Clob) - 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(int, Date) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateDate(String, 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.tools.SimpleResultSet
INTERNAL
updateDouble(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
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(int, float) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateFloat(String, 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.tools.SimpleResultSet
INTERNAL
updateInt(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
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(int, long) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateLong(String, 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.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) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateNCharacterStream(int, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateNCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateNCharacterStream(String, Reader) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateNCharacterStream(String, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateNClob(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateNClob(int, Reader) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateNClob(int, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateNClob(int, 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, Reader) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateNClob(String, Reader) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateNClob(String, Reader, long) - 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.tools.SimpleResultSet
INTERNAL
updateNClob(String, NClob) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateNClob(String, NClob) - 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(int, String) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateNString(String, 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.tools.SimpleResultSet
INTERNAL
updateNull(int) - 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateNull(String) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateObject(int, Object) - 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(int, Object, int) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateObject(int, Object, int) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
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) - Method in class org.h2.jdbc.JdbcResultSet
Updates a column in the current or insert row.
updateObject(String, Object) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateObject(String, 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.tools.SimpleResultSet
INTERNAL
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.
updateRef(int, 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.jdbc.JdbcResultSet
[Not supported]
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(int, RowId) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateRowId(String, 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.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(int, short) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateShort(String, 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.tools.SimpleResultSet
INTERNAL
updateSQLXML(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
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(int, String) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateString(String, 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.tools.SimpleResultSet
INTERNAL
updateTime(int, 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.jdbc.JdbcResultSet
Updates a column in the current or insert row.
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(int, Timestamp) - Method in class org.h2.tools.SimpleResultSet
INTERNAL
updateTimestamp(String, 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.tools.SimpleResultSet
INTERNAL
upgrade(String, Properties, int) - Static method in class org.h2.tools.Upgrade
Performs database upgrade from an older version of H2.
Upgrade - Class in org.h2.tools
Upgrade utility.
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 - Class in org.h2.engine
Represents a user object.
User(Database, int, String, boolean) - Constructor for class org.h2.engine.User
 
USER - Static variable in class org.h2.engine.DbObject
This object is a 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(int) - Static method in enum class 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 class org.h2.api.IntervalQualifier
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.IsolationLevel
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.Mode.CharPadding
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.Mode.ExpressionNames
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.Mode.ModeEnum
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.Mode.ViewExpressionNames
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.NullsDistinct
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.engine.SessionLocal.State
Returns the enum constant of this class with the specified name.
valueOf(String) - Static method in enum class org.h2.jdbc.JdbcLob.State
Returns the enum constant of this class with the specified name.
values() - Static method in enum class org.h2.api.IntervalQualifier
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.IsolationLevel
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.Mode.CharPadding
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.Mode.ExpressionNames
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.Mode.ModeEnum
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.Mode.ViewExpressionNames
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.NullsDistinct
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.engine.SessionLocal.State
Returns an array containing the constants of this enum class, in the order they are declared.
values() - Static method in enum class org.h2.jdbc.JdbcLob.State
Returns an array containing the constants of this enum class, 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.
WITH_VALUE - Enum constant in enum class org.h2.jdbc.JdbcLob.State
A value is set.
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.

Y

YEAR - Enum constant in enum class org.h2.api.IntervalQualifier
YEAR
YEAR_TO_MONTH - Enum constant in enum class org.h2.api.IntervalQualifier
YEAR TO MONTH

Z

zeroBasedEnums - Variable in class org.h2.engine.DbSettings
Database setting ZERO_BASED_ENUMS (default: false).
zeroBasedEnums() - Method in interface org.h2.engine.CastDataProvider
Returns are ENUM values 0-based.
zeroBasedEnums() - Method in class org.h2.engine.Database
 
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 Y Z 
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form