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

Deprecated.

use JdbcCallableStatement.getBigDecimal(int)

getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcResultSet

Deprecated.

use JdbcResultSet.getBigDecimal(int)

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

Deprecated.

use JdbcResultSet.getBigDecimal(String)

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