- CACHE_MIN_RECORDS - Static variable in class org.h2.engine.Constants
-
The minimum number of entries to keep in the cache.
- CACHE_TYPE_DEFAULT - Static variable in class org.h2.engine.Constants
-
The default cache type.
- CAN_ONLY_ASSIGN_TO_VARIABLE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90137
is thrown when
trying to assign a value to something that is not a variable.
- cancel() - Method in class org.h2.engine.Session
-
Cancel the current or next command (called when closing a connection).
- cancel() - Method in class org.h2.engine.SessionLocal
-
- cancel() - Method in class org.h2.engine.SessionRemote
-
- cancel() - Method in class org.h2.jdbc.JdbcStatement
-
Cancels a currently running statement.
- cancelRowUpdates() - Method in class org.h2.jdbc.JdbcResultSet
-
Cancels updating a row.
- cancelRowUpdates() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- cancelStatement(int) - Method in class org.h2.engine.SessionRemote
-
Cancel the statement with the given id.
- CANNOT_CHANGE_SETTING_WHEN_OPEN_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90133
is thrown when
trying to change a specific database property while the database is
already open.
- CANNOT_DROP_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90107
is thrown when
trying to drop an object because another object would become invalid.
- CANNOT_DROP_CURRENT_USER - Static variable in class org.h2.api.ErrorCode
-
The error with code 90019
is thrown when
trying to drop the current user, if there are no other admin users.
- CANNOT_DROP_LAST_COLUMN - Static variable in class org.h2.api.ErrorCode
-
The error with code 90084
is thrown when
trying to drop the last column of a table.
- CANNOT_DROP_TABLE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90118
is thrown when
trying to drop a table can not be dropped.
- CANNOT_MIX_INDEXED_AND_UNINDEXED_PARAMS - Static variable in class org.h2.api.ErrorCode
-
The error with code 90123
is thrown when
trying mix regular parameters and indexed parameters in the same
statement.
- CANNOT_TRUNCATE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90106
is thrown when
trying to truncate a table that can not be truncated.
- caseInsensitiveIdentifiers - Variable in class org.h2.engine.DbSettings
-
Database setting CASE_INSENSITIVE_IDENTIFIERS
(default:
false).
- caseInsensitiveIdentifiers - Variable in class org.h2.engine.Session.StaticSettings
-
Whether all identifiers are case insensitive.
- CastDataProvider - Interface in org.h2.engine
-
Provides information for type casts and comparison operations.
- CHANGE_ID - Static variable in class org.h2.engine.SessionRemote
-
- ChangeFileEncryption - Class in org.h2.tools
-
Allows changing the database file encryption password or algorithm.
- ChangeFileEncryption() - Constructor for class org.h2.tools.ChangeFileEncryption
-
- CHAR - Static variable in class org.h2.api.H2Type
-
The CHARACTER data type.
- charAndByteLengthUnits - Variable in class org.h2.engine.Mode
-
If true
'CHAR' and 'BYTE' length units are allowed.
- charPadding - Variable in class org.h2.engine.Mode
-
How to pad or trim CHAR values.
- CHECK - Static variable in class org.h2.engine.SysProperties
-
System property h2.check
(default: true for JDK/JRE, false for Android).
- CHECK_CONSTRAINT_INVALID - Static variable in class org.h2.api.ErrorCode
-
The error with code 23514
is thrown when
evaluation of a check constraint resulted in an error.
- CHECK_CONSTRAINT_VIOLATED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 23513
is thrown when
a check constraint is violated.
- checkAdmin() - Method in class org.h2.engine.User
-
Checks if this user has admin rights.
- checkCanceled() - Method in class org.h2.engine.SessionLocal
-
Check if the current transaction is canceled by calling
Statement.cancel() or because a session timeout was set and expired.
- checkClosed() - Method in class org.h2.engine.SessionRemote
-
Check if this session is closed and throws an exception if so.
- checkClosed() - Method in class org.h2.jdbc.JdbcConnection
-
INTERNAL.
- checkOwnsNoSchemas() - Method in class org.h2.engine.RightOwner
-
Check that this right owner does not own any schema.
- checkpoint() - Method in class org.h2.engine.Database
-
Flush all changes and open a new transaction log.
- checkPowerOff() - Method in class org.h2.engine.Database
-
- checkPowerOff() - Method in class org.h2.engine.SessionRemote
-
- checkPowerOff() - Method in class org.h2.tools.Recover
-
INTERNAL
- checkRename() - Method in class org.h2.engine.Comment
-
- checkRename() - Method in class org.h2.engine.DbObject
-
Check if renaming is allowed.
- checkRename() - Method in class org.h2.engine.Right
-
- checkRename() - Method in class org.h2.engine.Setting
-
- checkSchemaAdmin() - Method in class org.h2.engine.User
-
Checks if this user has schema admin rights for every schema.
- checkSchemaOwner(Schema) - Method in class org.h2.engine.User
-
Checks if this user has schema owner rights for the specified schema.
- checkTableRight(Table, int) - Method in class org.h2.engine.User
-
Checks that this user has the given rights for the specified table.
- checkWritingAllowed() - Method in class org.h2.engine.Database
-
- checkWritingAllowed() - Method in class org.h2.engine.SessionRemote
-
- checkWritingAllowed() - Method in class org.h2.tools.Recover
-
INTERNAL
- CLASS_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90086
is thrown when
a class can not be loaded because it is not in the classpath
or because a related class is not in the classpath.
- cleanAuthenticationInfo() - Method in class org.h2.engine.ConnectionInfo
-
Clear authentication properties.
- clearBatch() - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Clears the batch.
- clearBatch() - Method in class org.h2.jdbc.JdbcStatement
-
Clears the batch.
- clearParameters() - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Clears all parameters.
- clearViewIndexCache() - Method in class org.h2.engine.SessionLocal
-
Clear the view cache for this session.
- clearWarnings() - Method in class org.h2.jdbc.JdbcConnection
-
Clears all warnings.
- clearWarnings() - Method in class org.h2.jdbc.JdbcResultSet
-
Clears all warnings.
- clearWarnings() - Method in class org.h2.jdbc.JdbcStatement
-
Clears all warnings.
- clearWarnings() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- CLIENT_TRACE_DIRECTORY - Static variable in class org.h2.engine.SysProperties
-
System property h2.clientTraceDirectory
(default:
trace.db/).
- CLOB - Static variable in class org.h2.api.H2Type
-
The CHARACTER LARGE OBJECT data type.
- clone() - Method in class org.h2.engine.ConnectionInfo
-
- close() - Method in interface org.h2.api.Trigger
-
This method is called when the database is closed.
- close() - Method in class org.h2.engine.Session
-
Roll back pending transactions and close the session.
- close() - Method in class org.h2.engine.SessionLocal
-
- close() - Method in class org.h2.engine.SessionRemote
-
- close() - Method in class org.h2.fulltext.FullText.FullTextTrigger
-
INTERNAL
- close() - Method in class org.h2.fulltext.FullTextLucene.FullTextTrigger
-
INTERNAL
- close() - Method in class org.h2.jdbc.JdbcConnection
-
Closes this connection.
- close() - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Closes this statement.
- close() - Method in class org.h2.jdbc.JdbcResultSet
-
Closes the result set.
- close() - Method in class org.h2.jdbc.JdbcStatement
-
Closes this statement.
- close() - Method in class org.h2.jdbcx.JdbcXAConnection
-
Close the physical connection.
- close() - Method in class org.h2.tools.Csv
-
INTERNAL
- close() - Method in class org.h2.tools.SimpleResultSet
-
Closes the result set and releases the resources.
- close() - Method in interface org.h2.tools.SimpleRowSource
-
Close the row source.
- closeAll() - Static method in class org.h2.fulltext.FullText
-
INTERNAL
Close all fulltext settings, freeing up memory.
- closeOldResultSet() - Method in class org.h2.jdbc.JdbcStatement
-
INTERNAL.
- closeOnCompletion() - Method in class org.h2.jdbc.JdbcStatement
-
Specifies that this statement will be closed when its dependent result
set is closed.
- closingDatabase() - Method in interface org.h2.api.DatabaseEventListener
-
This method is called before the database is closed normally.
- CLUSTER_ERROR_DATABASE_RUNS_ALONE - Static variable in class org.h2.api.ErrorCode
-
The error with code 90093
is thrown when
trying to connect to a clustered database that runs in standalone
mode.
- CLUSTER_ERROR_DATABASE_RUNS_CLUSTERED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90094
is thrown when
trying to connect to a clustered database that runs together with a
different cluster node setting than what is used when trying to connect.
- CLUSTERING_DISABLED - Static variable in class org.h2.engine.Constants
-
The value of the cluster setting if clustering is disabled.
- CLUSTERING_ENABLED - Static variable in class org.h2.engine.Constants
-
The value of the cluster setting if clustering is enabled (the actual
value is checked later).
- COLLATION_CHANGE_WITH_DATA_TABLE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90089
is thrown when
trying to change the collation while there was already data in
the database.
- COLLATOR_CACHE_SIZE - Static variable in class org.h2.engine.SysProperties
-
System property h2.collatorCacheSize
(default: 3
2000).
- COLUMN_ALIAS_IS_NOT_SPECIFIED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90156
is thrown when trying to create a
view or a table from a select and some expression doesn't have a column
name or alias when it is required by a compatibility mode.
- COLUMN_CONTAINS_NULL_VALUES_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90081
is thrown when
trying to alter a column to not allow NULL, if there
is already data in the table where this column is NULL.
- COLUMN_COUNT_DOES_NOT_MATCH - Static variable in class org.h2.api.ErrorCode
-
The error with code 21002
is thrown when the number of
columns does not match.
- COLUMN_IS_PART_OF_INDEX_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90075
is thrown when
trying to alter a table and allow null for a column that is part of a
primary key or hash index.
- COLUMN_IS_REFERENCED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90083
is thrown when
trying to drop a column that is part of a constraint.
- COLUMN_MUST_NOT_BE_NULLABLE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90023
is thrown when trying to set a
primary key on a nullable column or when trying to drop NOT NULL
constraint on primary key or identity column.
- COLUMN_NAMES - Static variable in class org.h2.engine.GeneratedKeysMode
-
Use specified column names to return generated keys from.
- COLUMN_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42122
is thrown when
referencing an non-existing column.
- COLUMN_NUMBERS - Static variable in class org.h2.engine.GeneratedKeysMode
-
Use specified column indices to return generated keys from.
- columns - Variable in class org.h2.fulltext.IndexInfo
-
The column names.
- command - Variable in class org.h2.jdbc.JdbcPreparedStatement
-
- COMMAND_CLOSE - Static variable in class org.h2.engine.SessionRemote
-
- COMMAND_COMMIT - Static variable in class org.h2.engine.SessionRemote
-
- COMMAND_EXECUTE_QUERY - Static variable in class org.h2.engine.SessionRemote
-
- COMMAND_EXECUTE_UPDATE - Static variable in class org.h2.engine.SessionRemote
-
- COMMAND_GET_META_DATA - Static variable in class org.h2.engine.SessionRemote
-
- Comment - Class in org.h2.engine
-
Represents a database object comment.
- Comment(Database, int, DbObject) - Constructor for class org.h2.engine.Comment
-
- COMMENT - Static variable in class org.h2.engine.DbObject
-
This object is a comment.
- comment - Variable in class org.h2.engine.DbObject
-
The comment (if set).
- commit(boolean) - Method in class org.h2.engine.SessionLocal
-
Commit the current transaction.
- commit() - Method in class org.h2.jdbc.JdbcConnection
-
Commits the current transaction.
- commit(Xid, boolean) - Method in class org.h2.jdbcx.JdbcXAConnection
-
Commit a transaction.
- COMMIT_ROLLBACK_NOT_ALLOWED - Static variable in class org.h2.api.ErrorCode
-
The error with code 90058
is thrown when trying to call
commit or rollback inside a trigger, or when trying to call a method
inside a trigger that implicitly commits the current transaction, if an
object is locked.
- compare(Value, Value) - Method in class org.h2.engine.SessionLocal
-
Compare two values with the current comparison mode.
- compare(long[], long[]) - Method in class org.h2.tools.MultiDimension
-
- compareTo(MetaRecord) - Method in class org.h2.engine.MetaRecord
-
Sort the list of meta records by 'create order'.
- compareTypeSafe(Value, Value) - Method in class org.h2.engine.SessionLocal
-
Compare two values with the current comparison mode.
- compareWithNull(Value, Value, boolean) - Method in class org.h2.engine.SessionLocal
-
Compare two values with the current comparison mode.
- compress(byte[], String) - Method in class org.h2.tools.CompressTool
-
Compressed the data using the specified algorithm.
- compressData - Variable in class org.h2.engine.DbSettings
-
Database setting COMPRESS
(default: false).
- COMPRESSION_ERROR - Static variable in class org.h2.api.ErrorCode
-
The error with code 90104
is thrown when
the data can not be de-compressed.
- CompressTool - Class in org.h2.tools
-
A tool to losslessly compress data, and expand the compressed data again.
- CONCURRENT_UPDATE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90131
is thrown when using multi version
concurrency control, and trying to update the same row from within two
connections at the same time, or trying to insert two rows with the same
key from two connections.
- conn - Variable in class org.h2.jdbc.JdbcStatement
-
- CONN_URL_COLUMNLIST - Static variable in class org.h2.engine.Constants
-
The database URL used when calling a function if only the column list
should be returned.
- CONN_URL_INTERNAL - Static variable in class org.h2.engine.Constants
-
The database URL used when calling a function if the data should be
returned.
- connectEmbeddedOrServer(boolean) - Method in class org.h2.engine.SessionRemote
-
Open a new (remote or embedded) session.
- CONNECTION_BROKEN_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90067
is thrown when the client could
not connect to the database, or if the connection was lost.
- connectionClosed(ConnectionEvent) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
INTERNAL
- connectionErrorOccurred(ConnectionEvent) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
INTERNAL
- ConnectionInfo - Class in org.h2.engine
-
Encapsulates the connection settings, including user name and password.
- ConnectionInfo(String) - Constructor for class org.h2.engine.ConnectionInfo
-
Create a connection info object.
- ConnectionInfo(String, Properties, String, Object) - Constructor for class org.h2.engine.ConnectionInfo
-
Create a connection info object.
- Console - Class in org.h2.tools
-
Starts the H2 Console (web-) server, as well as the TCP and PG server.
- Console() - Constructor for class org.h2.tools.Console
-
- CONSOLE_MAX_PROCEDURES_LIST_COLUMNS - Static variable in class org.h2.engine.SysProperties
-
System property h2.consoleProcedureColumns
(default: 500).
- CONSOLE_MAX_TABLES_LIST_COLUMNS - Static variable in class org.h2.engine.SysProperties
-
System property h2.consoleTableColumns
(default: 500).
- CONSOLE_MAX_TABLES_LIST_INDEXES - Static variable in class org.h2.engine.SysProperties
-
System property h2.consoleTableIndexes
(default: 100).
- CONSOLE_STREAM - Static variable in class org.h2.engine.SysProperties
-
System property h2.consoleStream
(default: true).
- CONSOLE_TIMEOUT - Static variable in class org.h2.engine.SysProperties
-
System property h2.consoleTimeout
(default: 1800000).
- CONSTANT - Static variable in class org.h2.engine.DbObject
-
This object is a constant.
- CONSTANT_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90114
is thrown when
trying to create a constant if a constant with this name already exists.
- CONSTANT_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90115
is thrown when
trying to drop a constant that does not exists.
- Constants - Class in org.h2.engine
-
Constants are fixed values that are used in the whole database code.
- CONSTRAINT - Static variable in class org.h2.engine.DbObject
-
This object is a constraint (check constraint, unique constraint, or
referential constraint).
- CONSTRAINT_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90045
is thrown when trying to create a
constraint if an object with this name already exists.
- CONSTRAINT_IS_USED_BY_CONSTRAINT_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90152
is thrown when trying to manually
drop a unique or primary key constraint that is referenced by a foreign
key constraint without a CASCADE clause.
- CONSTRAINT_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90057
is thrown when
trying to drop a constraint that does not exist.
- containsKey(String) - Method in class org.h2.engine.SettingsBase
-
Check if the settings contains the given key.
- containsUncommitted() - Method in class org.h2.engine.SessionLocal
-
Whether the session contains any uncommitted changes.
- convertException(Exception) - Static method in class org.h2.fulltext.FullTextLucene
-
Convert an exception to a fulltext exception.
- convertOnlyToSmallerScale - Variable in class org.h2.engine.Mode
-
When converting the scale of decimal data, the number is only converted
if the new scale is smaller than the current scale.
- ConvertTraceFile - Class in org.h2.tools
-
Converts a .trace.db file to a SQL script and Java source code.
- ConvertTraceFile() - Constructor for class org.h2.tools.ConvertTraceFile
-
- COST_ROW_OFFSET - Static variable in class org.h2.engine.Constants
-
The cost is calculated on rowcount + this offset,
to avoid using the wrong or no index if the table
contains no rows _currently_ (when preparing the statement)
- count - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
-
The number of times the statement was executed.
- create(ConnectionPoolDataSource) - Static method in class org.h2.jdbcx.JdbcConnectionPool
-
Constructs a new connection pool.
- create(String, String, String) - Static method in class org.h2.jdbcx.JdbcConnectionPool
-
Constructs a new connection pool for H2 databases.
- createArrayOf(String, Object[]) - Method in class org.h2.jdbc.JdbcConnection
-
Create a new Array object.
- createBlob() - Method in class org.h2.jdbc.JdbcConnection
-
Create a new empty Blob object.
- createClob() - Method in class org.h2.jdbc.JdbcConnection
-
Create a new empty Clob object.
- CreateCluster - Class in org.h2.tools
-
Creates a cluster from a stand-alone database.
- CreateCluster() - Constructor for class org.h2.tools.CreateCluster
-
- createConnection(boolean) - Method in class org.h2.engine.SessionLocal
-
Create an internal connection.
- createIndex(Connection, String, String, String) - Static method in class org.h2.fulltext.FullText
-
Create a new full text index for a table and column list.
- createIndex(Connection, String, String, String) - Static method in class org.h2.fulltext.FullTextLucene
-
Create a new full text index for a table and column list.
- createNClob() - Method in class org.h2.jdbc.JdbcConnection
-
Create a new empty NClob object.
- createPgServer(String...) - Static method in class org.h2.tools.Server
-
Create a new PG server, but does not start it yet.
- createResultSet(boolean) - Static method in class org.h2.fulltext.FullText
-
Create an empty search result and initialize the columns.
- createSession(ConnectionInfo) - Static method in class org.h2.engine.Engine
-
Open a database connection with the given connection information.
- createSQLXML() - Method in class org.h2.jdbc.JdbcConnection
-
Create a new SQLXML object with no data.
- createStatement() - Method in class org.h2.jdbc.JdbcConnection
-
Creates a new statement.
- createStatement(int, int) - Method in class org.h2.jdbc.JdbcConnection
-
Creates a statement with the specified result set type and concurrency.
- createStatement(int, int, int) - Method in class org.h2.jdbc.JdbcConnection
-
Creates a statement with the specified result set type, concurrency, and
holdability.
- createStruct(String, Object[]) - Method in class org.h2.jdbc.JdbcConnection
-
[Not supported] Create a new empty Struct object.
- createTable(CreateTableData) - Method in interface org.h2.api.TableEngine
-
Create new table.
- createTcpServer(String...) - Static method in class org.h2.tools.Server
-
Create a new TCP server, but does not start it yet.
- createUniqueConstraintForReferencedColumns - Variable in class org.h2.engine.Mode
-
If true
, referential constraints will create a unique constraint
on referenced columns if it doesn't exist instead of throwing an
exception.
- createWebServer(String...) - Static method in class org.h2.tools.Server
-
Create a new web server, but does not start it yet.
- CredentialsValidator - Interface in org.h2.api
-
A class that implement this interface can be used to validate credentials
provided by client.
- Csv - Class in org.h2.tools
-
A facility to read from and write to CSV (comma separated values) files.
- Csv() - Constructor for class org.h2.tools.Csv
-
- CURRENT_SEQUENCE_VALUE_IS_NOT_DEFINED_IN_SESSION_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90148
is thrown when trying to access
the current value of a sequence before execution of NEXT VALUE FOR
sequenceName in the current session.
- currentTimestamp() - Method in interface org.h2.engine.CastDataProvider
-
Returns the current timestamp with maximum resolution.
- currentTimestamp() - Method in class org.h2.engine.Database
-
- currentTimestamp() - Method in class org.h2.engine.SessionLocal
-
- currentTimestamp() - Method in class org.h2.engine.SessionRemote
-
- currentTimestamp() - Method in class org.h2.jdbc.JdbcConnection
-
- currentTimeZone() - Method in interface org.h2.engine.CastDataProvider
-
Returns the current time zone.
- currentTimeZone() - Method in class org.h2.engine.Database
-
- currentTimeZone() - Method in class org.h2.engine.SessionLocal
-
- currentTimeZone() - Method in class org.h2.engine.SessionRemote
-
- currentTimeZone() - Method in class org.h2.jdbc.JdbcConnection
-
- DATA_CONVERSION_ERROR_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 22018
is thrown when
trying to convert a value to a data type where the conversion is
undefined, or when an error occurred trying to convert.
- Database - Class in org.h2.engine
-
There is one database object per open database.
- Database(ConnectionInfo, String) - Constructor for class org.h2.engine.Database
-
- database - Variable in class org.h2.engine.DbObject
-
The database.
- DATABASE_ALREADY_OPEN_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90020
is thrown when trying to open a
database in embedded mode if this database is already in use in another
process (or in a different class loader).
- DATABASE_CALLED_AT_SHUTDOWN - Static variable in class org.h2.api.ErrorCode
-
The error with code 90121
is thrown when
a database operation is started while the virtual machine exits
(for example in a shutdown hook), or when the session is closed.
- DATABASE_IS_CLOSED - Static variable in class org.h2.api.ErrorCode
-
The error with code 90098
is thrown when the database has
been closed, for example because the system ran out of memory or because
the self-destruction counter has reached zero.
- DATABASE_IS_IN_EXCLUSIVE_MODE - Static variable in class org.h2.api.ErrorCode
-
The error with code 90135
is thrown when
trying to open a connection to a database that is currently open
in exclusive mode.
- DATABASE_IS_NOT_PERSISTENT - Static variable in class org.h2.api.ErrorCode
-
The error with code 90126
is thrown when
trying to call the BACKUP statement for an in-memory database.
- DATABASE_IS_READ_ONLY - Static variable in class org.h2.api.ErrorCode
-
The error with code 90097
is thrown when
trying to delete or update a database if it is open in read-only mode.
- DATABASE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90013
is thrown when when trying to access
a database object with a catalog name that does not match the database
name.
- DATABASE_NOT_FOUND_WITH_IF_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90146
is thrown when trying to open a
database that does not exist using the flag IFEXISTS=TRUE
- DatabaseEventListener - Interface in org.h2.api
-
A class that implements this interface can get notified about exceptions
and other events.
- databaseToLower - Variable in class org.h2.engine.DbSettings
-
Database setting DATABASE_TO_LOWER
(default: false).
- databaseToLower - Variable in class org.h2.engine.Session.StaticSettings
-
Whether unquoted identifiers are converted to lower case.
- databaseToUpper - Variable in class org.h2.engine.DbSettings
-
Database setting DATABASE_TO_UPPER
(default: true).
- databaseToUpper - Variable in class org.h2.engine.Session.StaticSettings
-
Whether unquoted identifiers are converted to upper case.
- dataDefinitionCausesTransactionCommit() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether CREATE/DROP commit an open transaction.
- dataDefinitionIgnoredInTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether CREATE/DROP do not affect transactions.
- DATASOURCE_TRACE_LEVEL - Static variable in class org.h2.engine.SysProperties
-
System property h2.dataSourceTraceLevel
(default: 1).
- DATE - Static variable in class org.h2.api.H2Type
-
The DATE data type.
- dateIsTimestamp0 - Variable in class org.h2.engine.Mode
-
Whether DATE data type is parsed as TIMESTAMP(0).
- dateTimeValueWithinTransaction - Variable in class org.h2.engine.Mode
-
If true
, datetime value function return the same value within a
transaction, if false
datetime value functions return the same
value within a command.
- DbObject - Class in org.h2.engine
-
A database object such as a table, an index, or a user.
- DbObject(Database, int, String, int) - Constructor for class org.h2.engine.DbObject
-
Initialize some attributes of this object.
- DbSettings - Class in org.h2.engine
-
This class contains various database-level settings.
- DEADLOCK_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 40001
is thrown when
the database engine has detected a deadlock.
- DEADLOCK_CHECK - Static variable in class org.h2.engine.Constants
-
The number of milliseconds after which to check for a deadlock if locking
is not successful.
- DECFLOAT - Static variable in class org.h2.api.H2Type
-
The DECFLOAT data type.
- decimalSequences - Variable in class org.h2.engine.Mode
-
If true
NEXT VALUE FOR SEQUENCE, CURRENT VALUE FOR SEQUENCE,
SEQUENCE.NEXTVAL, and SEQUENCE.CURRVAL return values with DECIMAL/NUMERIC
data type instead of BIGINT.
- DEFAULT - Static variable in class org.h2.engine.DbSettings
-
INTERNAL.
- DEFAULT_HTTP_PORT - Static variable in class org.h2.engine.Constants
-
The default port number of the HTTP server (for the H2 Console).
- DEFAULT_LOCK_MODE - Static variable in class org.h2.engine.Constants
-
The default value for the LOCK_MODE setting.
- DEFAULT_MAX_LENGTH_INPLACE_LOB - Static variable in class org.h2.engine.Constants
-
The default maximum length of an LOB that is stored with the record
itself, and not in a separate place.
- DEFAULT_MAX_OPERATION_MEMORY - Static variable in class org.h2.engine.Constants
-
The default for the setting MAX_OPERATION_MEMORY.
- DEFAULT_PAGE_SIZE - Static variable in class org.h2.engine.Constants
-
The default page size to use for new databases.
- DEFAULT_RESULT_SET_CONCURRENCY - Static variable in class org.h2.engine.Constants
-
The default result set concurrency for statements created with
Connection.createStatement() or prepareStatement(String sql).
- DEFAULT_TCP_PORT - Static variable in class org.h2.engine.Constants
-
The default port of the TCP server.
- DEFAULT_WRITE_DELAY - Static variable in class org.h2.engine.Constants
-
The default delay in milliseconds before the transaction log is written.
- defaultConnection - Variable in class org.h2.engine.DbSettings
-
Database setting DEFAULT_CONNECTION
(default: false).
- defaultEscape - Variable in class org.h2.engine.DbSettings
-
Database setting DEFAULT_ESCAPE
(default: \).
- defaultTableEngine - Variable in class org.h2.engine.DbSettings
-
Database setting DEFAULT_TABLE_ENGINE
(default: null).
- defragAlways - Variable in class org.h2.engine.DbSettings
-
Database setting DEFRAG_ALWAYS
(default: false)
Each time the database is closed normally, it is fully defragmented (the
same as SHUTDOWN DEFRAG).
- deinterleave(int, long, int) - Method in class org.h2.tools.MultiDimension
-
Gets one of the original multi-dimensional values from a scalar value.
- DELAY_WRONG_PASSWORD_MAX - Static variable in class org.h2.engine.SysProperties
-
System property h2.delayWrongPasswordMax
(default: 4000).
- DELAY_WRONG_PASSWORD_MIN - Static variable in class org.h2.engine.SysProperties
-
System property h2.delayWrongPasswordMin
(default: 250).
- DELETE - Static variable in interface org.h2.api.Trigger
-
The trigger is called for DELETE statements.
- DELETE - Static variable in class org.h2.engine.Right
-
The right bit mask that means: deleting rows from a table is allowed.
- DeleteDbFiles - Class in org.h2.tools
-
Deletes all files belonging to a database.
- DeleteDbFiles() - Constructor for class org.h2.tools.DeleteDbFiles
-
- deleteIdentifierFrom - Variable in class org.h2.engine.Mode
-
If true
DELETE identifier FROM is allowed
- deleteRow() - Method in class org.h2.jdbc.JdbcResultSet
-
Deletes the current row.
- deleteRow() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- deletesAreDetected(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether deletes are detected.
- DESERIALIZATION_FAILED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90027
is thrown when
an object could not be de-serialized.
- deserialize(byte[]) - Method in interface org.h2.api.JavaObjectSerializer
-
Deserialize object from byte array.
- disallowedTypes - Variable in class org.h2.engine.Mode
-
An optional Set of hidden/disallowed column types.
- discardWithTableHints - Variable in class org.h2.engine.Mode
-
Discard SQLServer table hints (e.g.
- dispose() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Closes all unused pooled connections.
- DIVISION_BY_ZERO_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 22012
is thrown when trying to divide
a value by zero.
- doesMaxRowSizeIncludeBlobs() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the maximum row size includes blobs.
- DOMAIN - Static variable in class org.h2.engine.DbObject
-
This object is a domain.
- DOMAIN_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90119
is thrown when
trying to create a domain if an object with this name already exists,
or when trying to overload a built-in data type.
- DOMAIN_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90120
is thrown when
trying to drop a domain that doesn't exist.
- done(Transfer) - Method in class org.h2.engine.SessionRemote
-
Called to flush the output after data has been sent to the server and
just before receiving data.
- DOUBLE_PRECISION - Static variable in class org.h2.api.H2Type
-
The DOUBLE PRECISION data type.
- DRIVER_VERSION_ERROR_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90047
is thrown when
trying to connect to a TCP server with an incompatible client.
- dropAll(Connection) - Static method in class org.h2.fulltext.FullText
-
Drops all full text indexes from the database.
- dropAll(Connection) - Static method in class org.h2.fulltext.FullTextLucene
-
Drops all full text indexes from the database.
- dropIndex(Connection, String, String) - Static method in class org.h2.fulltext.FullText
-
Drop an existing full text index for a table.
- dropIndex(Connection, String, String) - Static method in class org.h2.fulltext.FullTextLucene
-
Drop an existing full text index for a table.
- dropRestrict - Variable in class org.h2.engine.DbSettings
-
Database setting DROP_RESTRICT
(default: true)
Whether the default action for DROP TABLE, DROP VIEW, DROP SCHEMA, DROP
DOMAIN, and DROP CONSTRAINT is RESTRICT.
- DUPLICATE_COLUMN_NAME_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42121
is thrown when trying to create
a table or insert into a table and use the same column name twice.
- DUPLICATE_KEY_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 23505
is thrown when trying to insert
a row that would violate a unique index or primary key.
- DUPLICATE_PROPERTY_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90066
is thrown when
the same property appears twice in the database URL or in
the connection properties.
- DynamicSettings(Mode, TimeZoneProvider) - Constructor for class org.h2.engine.Session.DynamicSettings
-
Creates new instance of dynamic settings.
- GENERAL_ERROR_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 50000
is thrown when
something unexpected occurs, for example an internal stack
overflow.
- GENERATED_COLUMN_CANNOT_BE_ASSIGNED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90154
is thrown when trying to assign a
value to a generated column.
- GENERATED_COLUMN_CANNOT_BE_UPDATABLE_BY_CONSTRAINT_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90155
is thrown when trying to create a
referential constraint that can update a referenced generated column.
- generatedKeyAlwaysReturned() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether database always returns generated keys if valid names or
indexes of columns were specified and command was completed successfully.
- generatedKeys - Variable in class org.h2.jdbc.JdbcStatement
-
- GeneratedKeysMode - Class in org.h2.engine
-
Modes of generated keys' gathering.
- generatePreparedQuery(String, String, String[]) - Method in class org.h2.tools.MultiDimension
-
Generates an optimized multi-dimensional range query.
- GEOMETRY - Static variable in class org.h2.api.H2Type
-
The GEOMETRY data type.
- get(String, boolean) - Method in class org.h2.engine.SettingsBase
-
Get the setting for the given key.
- get(String, int) - Method in class org.h2.engine.SettingsBase
-
Get the setting for the given key.
- get(String, String) - Method in class org.h2.engine.SettingsBase
-
Get the setting for the given key.
- GET_JDBC_META - Static variable in class org.h2.engine.SessionRemote
-
- getActiveConnections() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Returns the number of active (open) connections of this pool.
- getAllComments() - Method in class org.h2.engine.Database
-
- getAllowLiterals() - Method in class org.h2.engine.Database
-
- getAllowLiterals() - Method in class org.h2.engine.SessionLocal
-
- getAllRights() - Method in class org.h2.engine.Database
-
- getAllSchemas() - Method in class org.h2.engine.Database
-
- getAllSchemasNoMeta() - Method in class org.h2.engine.Database
-
- getAllSettings() - Method in class org.h2.engine.Database
-
- getAllSynonyms() - Method in class org.h2.engine.Database
-
Get all synonyms.
- getAllTablesAndViews() - Method in class org.h2.engine.Database
-
Get all tables and views.
- getAllUsersAndRoles() - Method in class org.h2.engine.Database
-
- getArray() - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a Java array.
- getArray(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a Java array.
- getArray(long, int) - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a Java array.
- getArray(long, int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a Java array.
- getArray(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as an Array.
- getArray(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as an Array.
- getArray(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an Array.
- getArray(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an Array.
- getArray(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Array.
- getArray(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Array.
- getArray() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
Get the object array.
- getArray(Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getArray(long, int) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getArray(long, int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getAsciiStream() - Method in class org.h2.jdbc.JdbcClob
-
Returns the input stream.
- getAsciiStream(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an input stream.
- getAsciiStream(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an input stream.
- getAsciiStream(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getAsciiStream(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getAttributes(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
[Not supported]
- getAuthenticator() - Method in class org.h2.engine.Database
-
get authenticator for database users
- getAutoClose() - Method in class org.h2.tools.SimpleResultSet
-
Get the current auto-close behavior.
- getAutoCommit() - Method in class org.h2.engine.Session
-
Check if this session is in auto-commit mode.
- getAutoCommit() - Method in class org.h2.engine.SessionLocal
-
- getAutoCommit() - Method in class org.h2.engine.SessionRemote
-
- getAutoCommit() - Method in class org.h2.jdbc.JdbcConnection
-
Gets the current setting for auto commit.
- getBackgroundException() - Method in class org.h2.engine.Database
-
- getBaseDir() - Static method in class org.h2.engine.SysProperties
-
INTERNAL
- getBaseType() - Method in class org.h2.jdbc.JdbcArray
-
Returns the base type of the array.
- getBaseType() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
Get the base type of this array.
- getBaseTypeName() - Method in class org.h2.jdbc.JdbcArray
-
Returns the base type name of the array.
- getBaseTypeName() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
Get the base type name of this array.
- getBestRowIdentifier(String, String, String, int, boolean) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of columns that best identifier a row in a table.
- getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
- getBigDecimal(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a BigDecimal.
- getBigDecimal(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a BigDecimal.
- getBigDecimal(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a BigDecimal.
- getBigDecimal(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a BigDecimal.
- getBigDecimal(String, int) - Method in class org.h2.jdbc.JdbcResultSet
-
- getBigDecimal(int, int) - Method in class org.h2.jdbc.JdbcResultSet
-
- getBigDecimal(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.math.BigDecimal.
- getBigDecimal(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.math.BigDecimal.
- getBigDecimal(int, int) - Method in class org.h2.tools.SimpleResultSet
-
- getBigDecimal(String, int) - Method in class org.h2.tools.SimpleResultSet
-
- getBinaryStream() - Method in class org.h2.jdbc.JdbcBlob
-
- getBinaryStream(long, long) - Method in class org.h2.jdbc.JdbcBlob
-
Returns the input stream, starting from an offset.
- getBinaryStream(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an input stream.
- getBinaryStream(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an input stream.
- getBinaryStream() - Method in class org.h2.jdbc.JdbcSQLXML
-
- getBinaryStream(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.io.InputStream.
- getBinaryStream(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.io.InputStream.
- getBlob(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Blob.
- getBlob(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Blob.
- getBlob(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a Blob.
- getBlob(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a Blob.
- getBlob(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Blob.
- getBlob(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Blob.
- getBlockingSessionId() - Method in class org.h2.engine.SessionLocal
-
- getBoolean(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a boolean.
- getBoolean(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a boolean.
- getBoolean(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a boolean.
- getBoolean(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a boolean.
- getBoolean(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a boolean.
- getBoolean(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a boolean.
- getBranchQualifier() - Method in class org.h2.jdbcx.JdbcXid
-
The transaction branch identifier.
- getByte(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a byte.
- getByte(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a byte.
- getByte(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a byte.
- getByte(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a byte.
- getByte(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a byte.
- getByte(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a byte.
- getBytes(long, int) - Method in class org.h2.jdbc.JdbcBlob
-
Returns some bytes of the object.
- getBytes(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a byte array.
- getBytes(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a byte array.
- getBytes(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a byte array.
- getBytes(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a byte array.
- getBytes(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a byte array.
- getBytes(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a byte array.
- getCacheType() - Method in class org.h2.engine.Database
-
- getCancel() - Method in class org.h2.engine.SessionLocal
-
Get the cancel time.
- getCaseSensitiveColumnNames() - Method in class org.h2.tools.Csv
-
Get the current case sensitive column names setting.
- getCatalog() - Method in class org.h2.jdbc.JdbcConnection
-
Gets the current catalog name.
- getCatalogName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the catalog name.
- getCatalogName(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns empty string.
- getCatalogs() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of catalogs.
- getCatalogSeparator() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the catalog separator.
- getCatalogTerm() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the term for "catalog".
- getCharacterStream(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a reader.
- getCharacterStream(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a reader.
- getCharacterStream() - Method in class org.h2.jdbc.JdbcClob
-
- getCharacterStream(long, long) - Method in class org.h2.jdbc.JdbcClob
-
Returns the reader, starting from an offset.
- getCharacterStream(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a reader.
- getCharacterStream(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a reader.
- getCharacterStream() - Method in class org.h2.jdbc.JdbcSQLXML
-
- getCharacterStream(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.io.Reader.
- getCharacterStream(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.io.Reader.
- getChildren() - Method in class org.h2.engine.DbObject
-
Get the list of dependent children (for tables, this includes indexes and
so on).
- getChildren() - Method in class org.h2.engine.Role
-
- getChildren() - Method in class org.h2.engine.User
-
- getClientInfo() - Method in class org.h2.jdbc.JdbcConnection
-
Get the client properties.
- getClientInfo(String) - Method in class org.h2.jdbc.JdbcConnection
-
Get a client property.
- getClientInfoProperties() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
- getClientVersion() - Method in class org.h2.engine.SessionRemote
-
Returns the TCP protocol version of remote connection.
- getClob(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Clob.
- getClob(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Clob.
- getClob(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a Clob.
- getClob(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a Clob.
- getClob(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Clob.
- getClob(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Clob.
- getCluster() - Method in class org.h2.engine.Database
-
- getClusterServers() - Method in class org.h2.engine.Session
-
Get the list of the cluster servers for this session.
- getClusterServers() - Method in class org.h2.engine.SessionLocal
-
- getClusterServers() - Method in class org.h2.engine.SessionRemote
-
- getColumnClassName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Gets the Java class name of the object that will be returned
if ResultSet.getObject is called.
- getColumnClassName(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the Java class name if this column.
- getColumnCount() - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the number of columns.
- getColumnCount() - Method in class org.h2.tools.SimpleResultSet
-
Returns the column count.
- getColumnDisplaySize(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Gets the maximum display size for this column.
- getColumnDisplaySize(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns 15.
- getColumnLabel(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the column label.
- getColumnLabel(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the column label.
- getColumnName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the column name.
- getColumnName(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the column name.
- getColumnPrivileges(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of column privileges.
- getColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of columns.
- getColumnType(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the data type of a column.
- getColumnType(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the SQL type.
- getColumnTypeName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the data type name of a column.
- getColumnTypeName(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the data type name of a column.
- getCommandStartOrEnd() - Method in class org.h2.engine.SessionLocal
-
- getComment() - Method in class org.h2.engine.DbObject
-
Get the current comment of this object.
- getCompareMode() - Method in class org.h2.engine.Database
-
- getCompareMode() - Method in class org.h2.engine.SessionRemote
-
- getCompareMode() - Method in class org.h2.tools.Recover
-
- getCompiler() - Method in class org.h2.engine.Database
-
- getConcurrency() - Method in class org.h2.jdbc.JdbcResultSet
-
Gets the result set concurrency.
- getConcurrency() - Method in class org.h2.tools.SimpleResultSet
-
Returns ResultSet.CONCUR_READ_ONLY.
- getConnection() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the connection that created this object.
- getConnection() - Method in class org.h2.jdbc.JdbcStatement
-
Returns the connection that created this object.
- getConnection() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Retrieves a connection from the connection pool.
- getConnection(String, String) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
INTERNAL
- getConnection() - Method in class org.h2.jdbcx.JdbcDataSource
-
Open a new connection using the current URL, user name and password.
- getConnection(String, String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Open a new connection using the current URL and the specified user name
and password.
- getConnection() - Method in class org.h2.jdbcx.JdbcXAConnection
-
Get a connection that is a handle to the physical connection.
- getCreateSQL() - Method in class org.h2.engine.Comment
-
- getCreateSQL() - Method in class org.h2.engine.DbObject
-
Construct the CREATE ...
- getCreateSQL() - Method in class org.h2.engine.Right
-
- getCreateSQL(boolean) - Method in class org.h2.engine.Role
-
Get the CREATE SQL statement for this object.
- getCreateSQL() - Method in class org.h2.engine.Role
-
- getCreateSQL() - Method in class org.h2.engine.Setting
-
- getCreateSQL() - Method in class org.h2.engine.User
-
- getCreateSQL(boolean) - Method in class org.h2.engine.User
-
Get the CREATE SQL statement for this object.
- getCreateSQLForCopy(Table, String) - Method in class org.h2.engine.DbObject
-
Build a SQL statement to re-create the object, or to create a copy of the
object with a different name or referencing a different table
- getCreateSQLForCopy(Table, String) - Method in class org.h2.engine.Right
-
- getCreateSQLForMeta() - Method in class org.h2.engine.DbObject
-
Construct the CREATE ...
- getCrossReference(String, String, String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of foreign key columns that references a table, as well as
the list of primary key columns that are references by a table.
- getCurrentCommand() - Method in class org.h2.engine.SessionLocal
-
- getCurrentId() - Method in class org.h2.engine.SessionRemote
-
- getCurrentSchemaName() - Method in class org.h2.engine.Session
-
Get current schema.
- getCurrentSchemaName() - Method in class org.h2.engine.SessionLocal
-
- getCurrentSchemaName() - Method in class org.h2.engine.SessionRemote
-
- getCurrentValueFor(Sequence) - Method in class org.h2.engine.SessionLocal
-
Returns the current value of the sequence in this session.
- getCursorName() - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Gets the cursor name if it was defined.
- getCursorName() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getDatabase() - Method in class org.h2.engine.DbObject
-
Get the database.
- getDatabase() - Method in class org.h2.engine.SessionLocal
-
- getDatabaseMajorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the major version of the database.
- getDatabaseMeta() - Method in class org.h2.engine.Session
-
Returns database meta information.
- getDatabaseMeta() - Method in class org.h2.engine.SessionLocal
-
- getDatabaseMeta() - Method in class org.h2.engine.SessionRemote
-
- getDatabaseMinorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the minor version of the database.
- getDatabasePath() - Method in class org.h2.engine.Database
-
- getDatabasePath() - Method in class org.h2.engine.SessionRemote
-
- getDatabasePath() - Method in class org.h2.tools.Recover
-
INTERNAL
- getDatabaseProductName() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the database product name.
- getDatabaseProductVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the product version of the database.
- getDataHandler() - Method in class org.h2.engine.Session
-
Get the data handler object.
- getDataHandler() - Method in class org.h2.engine.SessionLocal
-
- getDataHandler() - Method in class org.h2.engine.SessionRemote
-
- getDate(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Date.
- getDate(int, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
- getDate(String, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
- getDate(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Date.
- getDate(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Date.
- getDate(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Date.
- getDate(int, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
- getDate(String, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
- getDate(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an java.sql.Date.
- getDate(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Date.
- getDate(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getDate(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getDays() - Method in class org.h2.api.Interval
-
Returns days value, if any.
- getDbSettings() - Method in class org.h2.engine.ConnectionInfo
-
- getDefaultNullOrdering() - Method in class org.h2.engine.Database
-
- getDefaultTableType() - Method in class org.h2.engine.Database
-
- getDefaultTransactionIsolation() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the default transaction isolation level.
- getDependentTable(SchemaObject, Table) - Method in class org.h2.engine.Database
-
Get the first table that depends on this object.
- getDescription() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the current description.
- getDouble(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a double.
- getDouble(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a double.
- getDouble(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a double.
- getDouble(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a double.
- getDouble(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an double.
- getDouble(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a double.
- getDriverMajorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the major version of this driver.
- getDriverMinorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the minor version of this driver.
- getDriverName() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the name of the JDBC driver.
- getDriverVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the version number of the driver.
- getDropSQL() - Method in class org.h2.engine.DbObject
-
Construct a DROP ...
- getDynamicSettings() - Method in class org.h2.engine.Session
-
Returns dynamic settings.
- getDynamicSettings() - Method in class org.h2.engine.SessionLocal
-
- getDynamicSettings() - Method in class org.h2.engine.SessionRemote
-
- getEnum() - Method in class org.h2.engine.Mode
-
- getErrorCode() - Method in interface org.h2.jdbc.JdbcException
-
Returns the H2-specific error code.
- getEscapeCharacter() - Method in class org.h2.tools.Csv
-
Get the current escape character.
- getExclusiveSession() - Method in class org.h2.engine.Database
-
- getExecutionTimeStandardDeviation() - Method in class org.h2.engine.QueryStatisticsData.QueryEntry
-
- getExportedKeys(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of foreign key columns that reference a table.
- getExtraNameCharacters() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the characters that are allowed for identifiers in addiction to
A-Z, a-z, 0-9 and '_'.
- getFetchDirection() - Method in class org.h2.jdbc.JdbcResultSet
-
Gets the fetch direction.
- getFetchDirection() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the fetch direction.
- getFetchDirection() - Method in class org.h2.tools.SimpleResultSet
-
Returns ResultSet.FETCH_FORWARD.
- getFetchSize() - Method in class org.h2.jdbc.JdbcResultSet
-
Gets the number of rows suggested to read in one step.
- getFetchSize() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the number of rows suggested to read in one step.
- getFetchSize() - Method in class org.h2.tools.SimpleResultSet
-
Returns 0.
- getFieldDelimiter() - Method in class org.h2.tools.Csv
-
Get the current field delimiter.
- getFieldSeparatorRead() - Method in class org.h2.tools.Csv
-
Get the current field separator for reading.
- getFieldSeparatorWrite() - Method in class org.h2.tools.Csv
-
Get the current field separator for writing.
- getFilePasswordHash() - Method in class org.h2.engine.ConnectionInfo
-
Get the file password hash if it is set.
- getFirstUserTable() - Method in class org.h2.engine.Database
-
Get the first user defined table, excluding the LOB_BLOCKS table that the
Recover tool creates.
- getFloat(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a float.
- getFloat(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a float.
- getFloat(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a float.
- getFloat(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a float.
- getFloat(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a float.
- getFloat(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a float.
- getFormatId() - Method in class org.h2.jdbcx.JdbcXid
-
Get the format id.
- getFunctionColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
[Not supported] Gets the list of function columns.
- getFunctions(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
[Not supported] Gets the list of functions.
- getGeneratedKeys() - Method in class org.h2.jdbc.JdbcPreparedStatement
-
- getGeneratedKeys() - Method in class org.h2.jdbc.JdbcStatement
-
Return a result set with generated keys from the latest executed command
or an empty result set if keys were not generated or were not requested
with Statement.RETURN_GENERATED_KEYS
, column indexes, or column
names.
- getGlobalTransactionId() - Method in class org.h2.jdbcx.JdbcXid
-
The global transaction identifier.
- getGrantedObject() - Method in class org.h2.engine.Right
-
- getGrantedRole() - Method in class org.h2.engine.Right
-
- getGrantee() - Method in class org.h2.engine.Right
-
- getHoldability() - Method in class org.h2.jdbc.JdbcConnection
-
Returns the current result set holdability.
- getHoldability() - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the current result set holdability.
- getHoldability() - Method in class org.h2.tools.SimpleResultSet
-
Returns the current result set holdability.
- getHours() - Method in class org.h2.api.Interval
-
Returns hours value, if any.
- getId() - Method in class org.h2.engine.DbObject
-
Get the unique object id.
- getId() - Method in class org.h2.engine.MetaRecord
-
- getId() - Method in class org.h2.engine.SessionLocal
-
- getIdentifierQuoteString() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the string used to quote identifiers.
- getIgnoreCase() - Method in class org.h2.engine.Database
-
- getIgnoreCatalogs() - Method in class org.h2.engine.Database
-
- getImportedKeys(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of primary key columns that are referenced by a table.
- getIndexAccess(Connection) - Static method in class org.h2.fulltext.FullTextLucene
-
Get the index writer/searcher wrapper for the given connection.
- getIndexInfo(String, String, String, boolean, boolean) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of indexes for this database.
- getIndexPath(Connection) - Static method in class org.h2.fulltext.FullTextLucene
-
Get the path of the Lucene index for this database.
- getInDoubtTransactions() - Method in class org.h2.engine.Database
-
Get the list of in-doubt transactions.
- getInstance(String) - Static method in class org.h2.engine.Mode
-
Get the mode with the given name.
- getInstance() - Static method in class org.h2.tools.CompressTool
-
Get a new instance.
- getInstance() - Static method in class org.h2.tools.MultiDimension
-
Get the singleton.
- getInt(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as an int.
- getInt(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as an int.
- getInt(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an int.
- getInt(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as an int.
- getInt(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an int.
- getInt(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an int.
- getInternal(int) - Method in class org.h2.jdbc.JdbcResultSet
-
INTERNAL
- getInternalType(int[]) - Method in interface org.h2.api.Aggregate
-
This method must return the H2 data type, Value
,
of the aggregate function, given the H2 data type of the input data.
- getIntValue() - Method in class org.h2.engine.Setting
-
- getIsolationLevel() - Method in class org.h2.engine.Session
-
Returns the isolation level.
- getIsolationLevel() - Method in class org.h2.engine.SessionLocal
-
- getIsolationLevel() - Method in class org.h2.engine.SessionRemote
-
- getJavaObjectSerializer() - Method in interface org.h2.engine.CastDataProvider
-
Returns the custom Java object serializer, or null
.
- getJavaObjectSerializer() - Method in class org.h2.engine.Database
-
- getJavaObjectSerializer() - Method in class org.h2.engine.SessionLocal
-
- getJavaObjectSerializer() - Method in class org.h2.engine.SessionRemote
-
- getJavaObjectSerializer() - Method in class org.h2.jdbc.JdbcConnection
-
- getJdbc() - Method in enum org.h2.engine.IsolationLevel
-
Returns the JDBC constant for this isolation level.
- getJDBCMajorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the major version of the supported JDBC API.
- getJDBCMinorVersion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the minor version of the supported JDBC API.
- getLargeMaxRows() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the maximum number of rows for a ResultSet.
- getLargeUpdateCount() - Method in class org.h2.jdbc.JdbcStatement
-
Returns the last update count of this statement.
- getLastIdentity() - Method in class org.h2.engine.SessionLocal
-
- getLastReconnect() - Method in class org.h2.engine.SessionRemote
-
- getLeading() - Method in class org.h2.api.Interval
-
Returns value of leading field of this interval.
- getLineCommentCharacter() - Method in class org.h2.tools.Csv
-
Get the line comment character.
- getLineSeparator() - Method in class org.h2.tools.Csv
-
Get the line separator used for writing.
- getLinkConnection(String, String, String, String) - Method in class org.h2.engine.Database
-
Open a new connection or get an existing connection to another database.
- getLobFileListCache() - Method in class org.h2.engine.Database
-
- getLobFileListCache() - Method in class org.h2.engine.SessionRemote
-
- getLobFileListCache() - Method in class org.h2.tools.Recover
-
INTERNAL
- getLobSession() - Method in class org.h2.engine.Database
-
- getLobStorage() - Method in class org.h2.engine.Database
-
- getLobStorage() - Method in class org.h2.engine.SessionRemote
-
- getLobStorage() - Method in class org.h2.tools.Recover
-
INTERNAL
- getLobSyncObject() - Method in class org.h2.engine.Database
-
- getLobSyncObject() - Method in class org.h2.engine.SessionRemote
-
- getLobSyncObject() - Method in class org.h2.tools.Recover
-
INTERNAL
- getLocalTempTableConstraints() - Method in class org.h2.engine.SessionLocal
-
Get the map of constraints for all constraints on local, temporary
tables, if any.
- getLocalTempTableIndexes() - Method in class org.h2.engine.SessionLocal
-
- getLocalTempTables() - Method in class org.h2.engine.SessionLocal
-
- getLockMode() - Method in class org.h2.engine.Database
-
- getLockMode() - Method in enum org.h2.engine.IsolationLevel
-
Returns the LOCK_MODE equivalent for PageStore and old versions of H2.
- getLocks() - Method in class org.h2.engine.SessionLocal
-
- getLockTimeout() - Method in class org.h2.engine.Database
-
- getLockTimeout() - Method in class org.h2.engine.SessionLocal
-
- getLoginTimeout() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Gets the maximum time in seconds to wait for a free connection.
- getLoginTimeout() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the login timeout in seconds, 0 meaning no timeout.
- getLogWriter() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
INTERNAL
- getLogWriter() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the current log writer for this object.
- getLong(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a long.
- getLong(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a long.
- getLong(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a long.
- getLong(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a long.
- getLong(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a long.
- getLong(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a long.
- getMainSchema() - Method in class org.h2.engine.Database
-
Returns main schema (usually PUBLIC).
- getMaxBinaryLiteralLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for hex values (characters).
- getMaxCatalogNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for a catalog name.
- getMaxCharLiteralLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for literals.
- getMaxColumnNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for column names.
- getMaxColumnsInGroupBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of columns in GROUP BY.
- getMaxColumnsInIndex() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of columns in CREATE INDEX.
- getMaxColumnsInOrderBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of columns in ORDER BY.
- getMaxColumnsInSelect() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of columns in SELECT.
- getMaxColumnsInTable() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of columns in CREATE TABLE.
- getMaxConnections() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of open connection.
- getMaxConnections() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Gets the maximum number of connections to use.
- getMaxCursorNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for a cursor name.
- getMaxFieldSize() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the maximum number of bytes for a result set column.
- getMaxIndexLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for an index (in bytes).
- getMaxLengthInplaceLob() - Method in class org.h2.engine.Database
-
- getMaxLengthInplaceLob() - Method in class org.h2.engine.SessionRemote
-
- getMaxLengthInplaceLob() - Method in class org.h2.tools.Recover
-
INTERNAL
- getMaxMemoryRows() - Method in class org.h2.engine.Database
-
- getMaxOperationMemory() - Method in class org.h2.engine.Database
-
- getMaxProcedureNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for a procedure name.
- getMaxRows() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the maximum number of rows for a ResultSet.
- getMaxRowSize() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum size of a row (in bytes).
- getMaxSchemaNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for a schema name.
- getMaxStatementLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length of a statement.
- getMaxStatements() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of open statements.
- getMaxTableNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for a table name.
- getMaxTablesInSelect() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum number of tables in a SELECT.
- getMaxUserNameLength() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the maximum length for a user name.
- getMaxValue(int) - Method in class org.h2.tools.MultiDimension
-
Get the maximum value for the given dimension count.
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLDataException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
-
- getMessage() - Method in exception org.h2.jdbc.JdbcSQLTransientException
-
- getMetaData() - Method in class org.h2.jdbc.JdbcConnection
-
Gets the database meta data for this database.
- getMetaData() - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Gets the result set metadata of the query returned when the statement is
executed.
- getMetaData() - Method in class org.h2.jdbc.JdbcResultSet
-
Gets the meta data of this result set.
- getMetaData() - Method in class org.h2.tools.SimpleResultSet
-
Returns a reference to itself.
- getMinutes() - Method in class org.h2.api.Interval
-
Returns minutes value, if any.
- getMode() - Method in interface org.h2.engine.CastDataProvider
-
Returns the database mode.
- getMode() - Method in class org.h2.engine.Database
-
- getMode() - Method in class org.h2.engine.SessionLocal
-
- getMode() - Method in class org.h2.engine.SessionRemote
-
- getMode() - Method in class org.h2.jdbc.JdbcConnection
-
- getModificationDataId() - Method in class org.h2.engine.Database
-
- getModificationId() - Method in class org.h2.engine.DbObject
-
- getModificationId() - Method in class org.h2.engine.SessionLocal
-
- getModificationMetaId() - Method in class org.h2.engine.Database
-
- getMonths() - Method in class org.h2.api.Interval
-
Returns months value, if any.
- getMoreResults() - Method in class org.h2.jdbc.JdbcStatement
-
Moves to the next result set - however there is always only one result
set.
- getMoreResults(int) - Method in class org.h2.jdbc.JdbcStatement
-
Move to the next result set.
- getName() - Method in class org.h2.api.H2Type
-
- getName() - Method in class org.h2.engine.ConnectionInfo
-
Get the unique and normalized database name (excluding settings).
- getName() - Method in class org.h2.engine.Database
-
- getName() - Method in class org.h2.engine.DbObject
-
Get the name.
- getName() - Method in class org.h2.engine.Mode
-
- getName() - Method in class org.h2.engine.Procedure
-
- getNanosOfSecond() - Method in class org.h2.api.Interval
-
Returns value of fractional part of seconds (in nanoseconds), if any.
- getNCharacterStream(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a reader.
- getNCharacterStream(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a reader.
- getNCharacterStream(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a reader.
- getNCharacterStream(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a reader.
- getNCharacterStream(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getNCharacterStream(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getNClob(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Clob.
- getNClob(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Clob.
- getNClob(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a Clob.
- getNClob(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a Clob.
- getNClob(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getNClob(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getNetworkConnectionInfo() - Method in class org.h2.engine.ConnectionInfo
-
Returns the network connection information, or null
.
- getNetworkConnectionInfo() - Method in class org.h2.engine.SessionLocal
-
Returns the network connection information, or null
.
- getNetworkTimeout() - Method in class org.h2.jdbc.JdbcConnection
-
[Not supported]
- getNextId() - Method in class org.h2.engine.SessionRemote
-
- getNextModificationDataId() - Method in class org.h2.engine.Database
-
- getNextModificationMetaId() - Method in class org.h2.engine.Database
-
- getNextRemoteSettingsId() - Method in class org.h2.engine.Database
-
- getNextSystemIdentifier(String) - Method in class org.h2.engine.SessionLocal
-
Get the next system generated identifiers.
- getNextValueFor(Sequence, Prepared) - Method in class org.h2.engine.SessionLocal
-
Returns the next value of the sequence in this session.
- getNonKeywords() - Method in class org.h2.engine.SessionLocal
-
Gets bit set of non-keywords.
- getNString(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a String.
- getNString(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a String.
- getNString(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a String.
- getNString(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a String.
- getNString(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getNString(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getNullString() - Method in class org.h2.tools.Csv
-
Get the current null string.
- getNumericFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the list of numeric functions supported by this database.
- getObject(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns a column value as a Java object.
- getObject(int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Gets a column as a object using the specified type
mapping.
- getObject(String, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Gets a column as a object using the specified type
mapping.
- getObject(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns a column value as a Java object.
- getObject(int, Class<T>) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Java object of the
specified type.
- getObject(String, Class<T>) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a Java object of the
specified type.
- getObject(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns a column value as a Java object.
- getObject(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns a column value as a Java object.
- getObject(int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Gets a column as a object using the specified type
mapping.
- getObject(String, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Gets a column as a object using the specified type
mapping.
- getObject(int, Class<T>) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns a column value as a Java object of the specified type.
- getObject(String, Class<T>) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns a column value as a Java object of the specified type.
- getObject(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an Object.
- getObject(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an Object.
- getObject(int, Class<T>) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an Object of the specified type.
- getObject(String, Class<T>) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an Object of the specified type.
- getObject(int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getObject(String, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getObjectInstance(Object, Name, Context, Hashtable<?, ?>) - Method in class org.h2.jdbcx.JdbcDataSourceFactory
-
Creates a new object using the specified location or reference
information.
- getObjectType() - Method in class org.h2.engine.MetaRecord
-
- getOptimizeReuseResults() - Method in class org.h2.engine.Database
-
- getOriginalMessage() - Method in interface org.h2.jdbc.JdbcException
-
INTERNAL
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLDataException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
-
- getOriginalMessage() - Method in exception org.h2.jdbc.JdbcSQLTransientException
-
- getOriginalURL() - Method in class org.h2.engine.ConnectionInfo
-
Get the complete original database URL.
- getPageSize() - Method in class org.h2.engine.Database
-
- getParameterClassName(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the Java class name of the parameter.
- getParameterCount() - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the number of parameters.
- getParameterMetaData() - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Get the parameter meta data of this prepared statement.
- getParameterMode(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the parameter mode.
- getParameterType(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the parameter type.
- getParameterTypeName(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the parameter type name.
- getParentLogger() - Method in class org.h2.jdbcx.JdbcConnectionPool
-
[Not supported]
- getParentLogger() - Method in class org.h2.jdbcx.JdbcDataSource
-
[Not supported]
- getPassword() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the current password.
- getPooledConnection() - Method in class org.h2.jdbcx.JdbcDataSource
-
Open a new pooled connection using the current URL, user name and
password.
- getPooledConnection(String, String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Open a new pooled connection using the current URL and the specified user
name and password.
- getPort() - Method in class org.h2.tools.Server
-
Gets the port this server is listening on.
- getPowerOffCount() - Method in class org.h2.engine.Database
-
- getPrecision(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the parameter precision.
- getPrecision(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Gets the precision for this column.
- getPrecision(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the precision.
- getPrepared() - Method in class org.h2.engine.Procedure
-
- getPreserveWhitespace() - Method in class org.h2.tools.Csv
-
Whether whitespace in unquoted text is preserved.
- getPrimaryKeys(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the primary key columns for a table.
- getProcedure(String) - Method in class org.h2.engine.SessionLocal
-
Get the procedure with the given name, or null
if none exists.
- getProcedureColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of procedure columns.
- getProcedures(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of procedures.
- getProcedureTerm() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the term for "procedure".
- getProperty(String, boolean) - Method in class org.h2.engine.ConnectionInfo
-
Get a boolean property if it is set and return the value.
- getProperty(String, String) - Method in class org.h2.engine.ConnectionInfo
-
Get the value of the given property.
- getPseudoColumns(String, String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of pseudo and invisible columns.
- getPublicRole() - Method in class org.h2.engine.Database
-
- getQualifier() - Method in class org.h2.api.Interval
-
Returns qualifier of this interval.
- getQueries() - Method in class org.h2.engine.QueryStatisticsData
-
- getQueryStatistics() - Method in class org.h2.engine.Database
-
- getQueryStatisticsData() - Method in class org.h2.engine.Database
-
- getQueryTimeout() - Method in class org.h2.engine.SessionLocal
-
- getQueryTimeout() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the current query timeout in seconds.
- getRandom() - Method in class org.h2.engine.SessionLocal
-
- getRef(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Gets a column as a reference.
- getRef(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Gets a column as a reference.
- getRef(int) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Gets a column as a reference.
- getRef(String) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Gets a column as a reference.
- getRef(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getRef(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getReference() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get a new reference for this object, using the current settings.
- getReferentialIntegrity() - Method in class org.h2.engine.Database
-
- getRegular() - Static method in class org.h2.engine.Mode
-
- getRemaining() - Method in class org.h2.api.Interval
-
Returns combined value of remaining fields of this interval.
- getRemoteSettingsId() - Method in class org.h2.engine.Database
-
- getResult() - Method in interface org.h2.api.Aggregate
-
This method returns the computed aggregate value.
- getResult() - Method in interface org.h2.api.AggregateFunction
-
This method returns the computed aggregate value.
- getResult() - Method in class org.h2.jdbc.JdbcResultSet
-
INTERNAL
- getResult(PreparedStatement, int[], int[]) - Method in class org.h2.tools.MultiDimension
-
Executes a prepared query that was generated using generatePreparedQuery.
- getResultSet() - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a result set.
- getResultSet(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a result set.
- getResultSet(long, int) - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a result set.
- getResultSet(long, int, Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcArray
-
Returns the value as a result set.
- getResultSet() - Method in class org.h2.jdbc.JdbcStatement
-
Returns the last result set produces by this statement.
- getResultSet() - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getResultSet(Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getResultSet(long, int) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getResultSet(long, int, Map<String, Class<?>>) - Method in class org.h2.tools.SimpleResultSet.SimpleArray
-
INTERNAL
- getResultSetConcurrency() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the result set concurrency created by this object.
- getResultSetHoldability() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the result set holdability.
- getResultSetHoldability() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the result set holdability.
- getResultSetType() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the result set type.
- getRetentionTime() - Method in class org.h2.engine.Database
-
- getRightForObject(DbObject) - Method in class org.h2.engine.RightOwner
-
Get the 'grant schema' right of this object.
- getRightForRole(Role) - Method in class org.h2.engine.RightOwner
-
Get the 'grant role' right of this object.
- getRightMask() - Method in class org.h2.engine.Right
-
- getRights() - Method in class org.h2.engine.Right
-
- getRow() - Method in class org.h2.jdbc.JdbcResultSet
-
Gets the current row number.
- getRow() - Method in class org.h2.tools.SimpleResultSet
-
Returns the row number (1, 2,...) or 0 for no row.
- getRowCountStandardDeviation() - Method in class org.h2.engine.QueryStatisticsData.QueryEntry
-
- getRowFactory() - Method in class org.h2.engine.Database
-
- getRowId(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Returns the value of the specified column as a row id.
- getRowId(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Returns the value of the specified column as a row id.
- getRowId(int) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Returns the value of the specified column as a row id.
- getRowId(String) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Returns the value of the specified column as a row id.
- getRowId(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getRowId(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getRowIdLifetime() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Get the lifetime of a rowid.
- getSavepointId() - Method in class org.h2.jdbc.JdbcSavepoint
-
Get the generated id of this savepoint.
- getSavepointName() - Method in class org.h2.jdbc.JdbcSavepoint
-
Get the name of this savepoint.
- getScale(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Returns the parameter scale.
- getScale(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Gets the scale for this column.
- getScale(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the scale.
- getSchema(String) - Method in class org.h2.engine.Database
-
Get the schema.
- getSchema() - Method in class org.h2.jdbc.JdbcConnection
-
Retrieves this current schema name for this connection.
- getSchemaName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the schema name.
- getSchemaName(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns empty string.
- getSchemas() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of schemas.
- getSchemas(String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of schemas in the database.
- getSchemaSearchPath() - Method in class org.h2.engine.SessionLocal
-
- getSchemaTerm() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the term for "schema".
- getScriptDirectory() - Static method in class org.h2.engine.SysProperties
-
System property h2.scriptDirectory
(default: empty
string).
- getSearchStringEscape() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the default escape character for DatabaseMetaData search
patterns.
- getSeconds() - Method in class org.h2.api.Interval
-
Returns value of integer part of seconds, if any.
- getSecondsAndNanos() - Method in class org.h2.api.Interval
-
Returns seconds value measured in nanoseconds, if any.
- getService() - Method in class org.h2.tools.Server
-
Get the service attached to this server.
- getSession() - Method in class org.h2.jdbc.JdbcConnection
-
INTERNAL
- getSessionCount() - Method in class org.h2.engine.Database
-
- getSessions(boolean) - Method in class org.h2.engine.Database
-
Get all sessions that are currently connected to the database.
- getSessionStart() - Method in class org.h2.engine.SessionLocal
-
- getSettings() - Method in class org.h2.engine.Database
-
- getSettings() - Method in class org.h2.engine.SettingsBase
-
Get all settings.
- getShort(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a short.
- getShort(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a short.
- getShort(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a short.
- getShort(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a short.
- getShort(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a short.
- getShort(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a short.
- getShortName() - Method in class org.h2.engine.Database
-
- getSnapshotDataModificationId() - Method in class org.h2.engine.SessionLocal
-
Returns the data modification id of transaction's snapshot, or 0 if
isolation level doesn't use snapshots.
- getSortedSettings() - Method in class org.h2.engine.SettingsBase
-
Get all settings in alphabetical order.
- getSource(Class<T>) - Method in class org.h2.jdbc.JdbcSQLXML
-
- getSQL(int) - Method in class org.h2.engine.DbObject
-
- getSQL(StringBuilder, int) - Method in class org.h2.engine.DbObject
-
- getSQL() - Method in enum org.h2.engine.IsolationLevel
-
Returns the SQL representation of this isolation level.
- getSQL() - Method in class org.h2.engine.MetaRecord
-
- getSQL(StringBuilder, int) - Method in enum org.h2.engine.NullsDistinct
-
- getSQL(int) - Method in class org.h2.engine.Setting
-
- getSQL(StringBuilder, int) - Method in class org.h2.engine.Setting
-
- getSQL() - Method in interface org.h2.jdbc.JdbcException
-
Returns the SQL statement.
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLDataException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
-
- getSQL() - Method in exception org.h2.jdbc.JdbcSQLTransientException
-
- getSQLKeywords() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the comma-separated list of all SQL keywords that are not supported
as unquoted identifiers, in addition to the SQL:2003 reserved words.
- getSQLStateType() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the SQL State type.
- getSQLXML(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a SQLXML object.
- getSQLXML(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a SQLXML object.
- getSQLXML(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a SQLXML.
- getSQLXML(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a SQLXML.
- getSQLXML(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getSQLXML(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getState(int) - Static method in class org.h2.api.ErrorCode
-
INTERNAL
- getState() - Method in class org.h2.engine.SessionLocal
-
- getStatement() - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the statement that created this object.
- getStatement() - Method in class org.h2.tools.SimpleResultSet
-
Returns null.
- getStaticSettings() - Method in class org.h2.engine.Session
-
Returns static settings.
- getStaticSettings() - Method in class org.h2.engine.SessionLocal
-
- getStaticSettings() - Method in class org.h2.engine.SessionRemote
-
- getStaticSettings() - Method in class org.h2.jdbc.JdbcConnection
-
INTERNAL
- getStatus() - Method in class org.h2.tools.Server
-
Get the status of this server.
- getStore() - Method in class org.h2.engine.Database
-
- getString(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a String.
- getString(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a String.
- getString(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a String.
- getString(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a String.
- getString() - Method in class org.h2.jdbc.JdbcSQLXML
-
- getString(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a String.
- getString(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a String.
- getStringFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the list of string functions supported by this database.
- getStringValue() - Method in class org.h2.engine.Setting
-
- getSubString(long, int) - Method in class org.h2.jdbc.JdbcClob
-
Returns a substring.
- getSuperTables(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Get the list of super tables of a table.
- getSuperTypes(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
[Not supported]
- getSystemFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the list of system functions supported by this database.
- getSystemSession() - Method in class org.h2.engine.Database
-
- getSystemUser() - Method in class org.h2.engine.Database
-
Returns system user.
- getTableEngine(String) - Method in class org.h2.engine.Database
-
Get the table engine class, loading it if needed.
- getTableName(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Returns the table name.
- getTableName(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns empty string.
- getTablePrivileges(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of table privileges.
- getTables(String, String, String, String[]) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of tables in the database.
- getTableTypes() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of table types.
- getTempFileDeleter() - Method in class org.h2.engine.Database
-
- getTempFileDeleter() - Method in class org.h2.engine.SessionRemote
-
- getTempFileDeleter() - Method in class org.h2.tools.Recover
-
INTERNAL
- getTempTableName(String, SessionLocal) - Method in class org.h2.engine.Database
-
Get a unique temporary table name.
- getTime(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Time.
- getTime(int, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
- getTime(String, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
- getTime(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Time.
- getTime(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Time.
- getTime(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Time.
- getTime(int, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
- getTime(String, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
- getTime(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an java.sql.Time.
- getTime(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Time.
- getTime(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getTime(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getTimeDateFunctions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the list of date and time functions supported by this database.
- getTimestamp(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Timestamp.
- getTimestamp(int, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
- getTimestamp(String, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
- getTimestamp(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Returns the value of the specified column as a java.sql.Timestamp.
- getTimestamp(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Timestamp.
- getTimestamp(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Timestamp.
- getTimestamp(int, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
- getTimestamp(String, Calendar) - Method in class org.h2.jdbc.JdbcResultSet
-
Returns the value of the specified column as a java.sql.Timestamp.
- getTimestamp(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as an java.sql.Timestamp.
- getTimestamp(String) - Method in class org.h2.tools.SimpleResultSet
-
Returns the value as a java.sql.Timestamp.
- getTimestamp(int, Calendar) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getTimestamp(String, Calendar) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getTimeZone() - Method in class org.h2.engine.ConnectionInfo
-
Returns the time zone.
- getTrace(int) - Method in class org.h2.engine.Database
-
Get the trace object for the given module id.
- getTrace() - Method in class org.h2.engine.Session
-
Get the trace object
- getTrace() - Method in class org.h2.engine.SessionLocal
-
- getTrace() - Method in class org.h2.engine.SessionRemote
-
- getTraceSystem() - Method in class org.h2.engine.Database
-
- getTraceSystem() - Static method in class org.h2.jdbcx.JdbcDataSourceFactory
-
INTERNAL
- getTransaction() - Method in class org.h2.engine.SessionLocal
-
Get the transaction to use for this session.
- getTransactionId() - Method in class org.h2.engine.SessionLocal
-
- getTransactionIsolation() - Method in class org.h2.jdbc.JdbcConnection
-
Returns the current transaction isolation level.
- getTransactionTimeout() - Method in class org.h2.jdbcx.JdbcXAConnection
-
Get the transaction timeout.
- getType(int[]) - Method in interface org.h2.api.AggregateFunction
-
This method must return the SQL type of the method, given the SQL type of
the input data.
- getType() - Method in class org.h2.engine.Comment
-
- getType() - Method in class org.h2.engine.DbObject
-
Get the object type.
- getType() - Method in class org.h2.engine.Right
-
- getType() - Method in class org.h2.engine.Role
-
- getType() - Method in class org.h2.engine.Setting
-
- getType() - Method in class org.h2.engine.User
-
- getType() - Method in class org.h2.jdbc.JdbcResultSet
-
Get the result set type.
- getType() - Method in class org.h2.tools.SimpleResultSet
-
Returns the result set type.
- getTypeInfo() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of data types.
- getTypeMap() - Method in class org.h2.jdbc.JdbcConnection
-
Gets the type map.
- getTypeName(int, int) - Method in enum org.h2.api.IntervalQualifier
-
Returns full type name.
- getTypeName(StringBuilder, int, int, boolean) - Method in enum org.h2.api.IntervalQualifier
-
Appends full type name to the specified string builder.
- getUDTs(String, String, String, int[]) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Gets the list of user-defined data types.
- getUnicodeStream(int) - Method in class org.h2.jdbc.JdbcResultSet
-
- getUnicodeStream(String) - Method in class org.h2.jdbc.JdbcResultSet
-
- getUnicodeStream(int) - Method in class org.h2.tools.SimpleResultSet
-
- getUnicodeStream(String) - Method in class org.h2.tools.SimpleResultSet
-
- getUpdateCount() - Method in class org.h2.jdbc.JdbcStatement
-
Returns the last update count of this statement.
- getUpdateRow() - Method in class org.h2.jdbc.JdbcResultSet
-
INTERNAL
- getURL() - Method in class org.h2.engine.ConnectionInfo
-
Get the database URL.
- getURL(int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported]
- getURL(String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported]
- getURL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the database URL for this connection.
- getURL(int) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported]
- getURL(String) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported]
- getURL() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the current URL.
- getUrl() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the current URL.
- getURL() - Method in class org.h2.tools.Server
-
Gets the URL of this server.
- getURL(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getURL(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- getUser(String) - Method in class org.h2.engine.Database
-
Get user with the given name.
- getUser() - Method in class org.h2.engine.SessionLocal
-
- getUser() - Method in class org.h2.jdbcx.JdbcDataSource
-
Get the current user name.
- getUserName() - Method in class org.h2.engine.ConnectionInfo
-
Get the name of the user.
- getUserName() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the user name as passed to DriverManager.getConnection(url, user,
password).
- getVariable(String) - Method in class org.h2.engine.SessionLocal
-
Get the value of the specified user defined variable.
- getVariableIntLength(int) - Static method in class org.h2.tools.CompressTool
-
Get a variable size integer length using Rice coding.
- getVariableNames() - Method in class org.h2.engine.SessionLocal
-
Get the list of variable names that are set for this session.
- getVendor() - Method in class org.h2.api.H2Type
-
- getVendorTypeNumber() - Method in class org.h2.api.H2Type
-
Returns the vendor specific type number for the data type.
- getVersionColumns(String, String, String) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Get the list of columns that are update when any value is updated.
- getViewIndexCache(boolean) - Method in class org.h2.engine.SessionLocal
-
Get the view cache for this session.
- getWaitForLock() - Method in class org.h2.engine.SessionLocal
-
- getWaitForLockThread() - Method in class org.h2.engine.SessionLocal
-
- getWarnings() - Method in class org.h2.jdbc.JdbcConnection
-
Gets the first warning reported by calls on this object.
- getWarnings() - Method in class org.h2.jdbc.JdbcResultSet
-
Gets the first warning reported by calls on this object.
- getWarnings() - Method in class org.h2.jdbc.JdbcStatement
-
Gets the first warning reported by calls on this object.
- getWarnings() - Method in class org.h2.tools.SimpleResultSet
-
Returns null.
- getWriteColumnHeader() - Method in class org.h2.tools.Csv
-
Whether the column header is written.
- 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
-
- id - Variable in class org.h2.fulltext.IndexInfo
-
The index id.
- IDENTICAL_EXPRESSIONS_SHOULD_BE_USED - Static variable in class org.h2.api.ErrorCode
-
The error with code 42131
is thrown when
identical expressions should be used, but different
expressions were found.
- identityClause - Variable in class org.h2.engine.Mode
-
Whether SQL Server-style IDENTITY clause is supported.
- identityColumnsHaveDefaultOnNull - Variable in class org.h2.engine.Mode
-
If true
, identity columns have DEFAULT ON NULL clause.
- identityDataType - Variable in class org.h2.engine.Mode
-
Whether IDENTITY pseudo data type is supported.
- ignoreCatalogs - Variable in class org.h2.engine.DbSettings
-
Database setting IGNORE_CATALOGS
(default: false).
- INDEX - Static variable in class org.h2.engine.DbObject
-
This object is an index.
- INDEX_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42111
is thrown when
trying to create an index if an index with the same name already exists.
- INDEX_BELONGS_TO_CONSTRAINT_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90085
is thrown when
trying to manually drop an index that was generated by the system
because of a unique or referential constraint.
- INDEX_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42112
is thrown when
trying to drop or reference an index that does not exist.
- indexColumns - Variable in class org.h2.fulltext.IndexInfo
-
The column indexes of the index columns.
- indexDefinitionInCreateTable - Variable in class org.h2.engine.Mode
-
Creating indexes in the CREATE TABLE statement is allowed using
INDEX(..)
or KEY(..)
.
- IndexInfo - Class in org.h2.fulltext
-
The settings of one full text search index.
- IndexInfo() - Constructor for class org.h2.fulltext.IndexInfo
-
- INFORMATION_SCHEMA_ID - Static variable in class org.h2.engine.Constants
-
The identity of INFORMATION_SCHEMA.
- init(Connection) - Method in interface org.h2.api.Aggregate
-
This method is called when the aggregate function is used.
- init(Connection) - Method in interface org.h2.api.AggregateFunction
-
This method is called when the aggregate function is used.
- init(String) - Method in interface org.h2.api.DatabaseEventListener
-
This method is called just after creating the object.
- init(Connection, String, String, String, boolean, int) - Method in interface org.h2.api.Trigger
-
This method is called by the database engine once when initializing the
trigger.
- init(Connection, String, String, String, boolean, int) - Method in class org.h2.fulltext.FullText.FullTextTrigger
-
INTERNAL
- init(Connection) - Static method in class org.h2.fulltext.FullText
-
Initializes full text search functionality for this database.
- init(Connection, String, String, String, boolean, int) - Method in class org.h2.fulltext.FullTextLucene.FullTextTrigger
-
INTERNAL
- init(Connection) - Static method in class org.h2.fulltext.FullTextLucene
-
Initializes full text search functionality for this database.
- init(Connection, String, String, String, boolean, int) - Method in class org.h2.tools.TriggerAdapter
-
This method is called by the database engine once when initializing the
trigger.
- INITIAL_LOCK_TIMEOUT - Static variable in class org.h2.engine.Constants
-
For testing, the lock timeout is smaller than for interactive use cases.
- INSERT - Static variable in interface org.h2.api.Trigger
-
The trigger is called for INSERT statements.
- INSERT - Static variable in class org.h2.engine.Right
-
The right bit mask that means: inserting rows into a table is allowed.
- insertOnConflict - Variable in class org.h2.engine.Mode
-
PostgreSQL style INSERT ...
- insertRow() - Method in class org.h2.jdbc.JdbcResultSet
-
Inserts the current row.
- insertRow() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- insertsAreDetected(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether inserts are detected.
- INTEGER - Static variable in class org.h2.api.H2Type
-
The INTEGER data type.
- interleave(int...) - Method in class org.h2.tools.MultiDimension
-
Convert the multi-dimensional value into a one-dimensional (scalar)
value.
- interleave(int, int) - Method in class org.h2.tools.MultiDimension
-
Convert the two-dimensional value into a one-dimensional (scalar) value.
- Interval - Class in org.h2.api
-
INTERVAL representation for result sets.
- Interval(IntervalQualifier, boolean, long, long) - Constructor for class org.h2.api.Interval
-
Creates a new interval.
- INTERVAL_DAY - Static variable in class org.h2.api.H2Type
-
The INTERVAL DAY data type.
- INTERVAL_DAY_TO_HOUR - Static variable in class org.h2.api.H2Type
-
The INTERVAL DAY TO HOUR data type.
- INTERVAL_DAY_TO_MINUTE - Static variable in class org.h2.api.H2Type
-
The INTERVAL DAY TO MINUTE data type.
- INTERVAL_DAY_TO_SECOND - Static variable in class org.h2.api.H2Type
-
The INTERVAL DAY TO SECOND data type.
- INTERVAL_HOUR - Static variable in class org.h2.api.H2Type
-
The INTERVAL HOUR data type.
- INTERVAL_HOUR_TO_MINUTE - Static variable in class org.h2.api.H2Type
-
The INTERVAL HOUR TO MINUTE data type.
- INTERVAL_HOUR_TO_SECOND - Static variable in class org.h2.api.H2Type
-
The INTERVAL HOUR TO SECOND data type.
- INTERVAL_MINUTE - Static variable in class org.h2.api.H2Type
-
The INTERVAL MINUTE data type.
- INTERVAL_MINUTE_TO_SECOND - Static variable in class org.h2.api.H2Type
-
The INTERVAL MINUTE TO SECOND data type.
- INTERVAL_MONTH - Static variable in class org.h2.api.H2Type
-
The INTERVAL MONTH data type.
- INTERVAL_SECOND - Static variable in class org.h2.api.H2Type
-
The INTERVAL SECOND data type.
- INTERVAL_YEAR - Static variable in class org.h2.api.H2Type
-
The INTERVAL YEAR data type.
- INTERVAL_YEAR_TO_MONTH - Static variable in class org.h2.api.H2Type
-
The INTERVAL YEAR TO MONTH data type.
- IntervalQualifier - Enum in org.h2.api
-
Interval qualifier.
- INVALID_CLASS_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90125
is thrown when
PreparedStatement.setBigDecimal is called with object that extends the
class BigDecimal.
- INVALID_DATABASE_NAME_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90138
is thrown when
trying to open a persistent database using an incorrect database name.
- INVALID_DATETIME_CONSTANT_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 22007
is thrown when
a text can not be converted to a date, time, or timestamp constant.
- INVALID_NAME_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42602
is thrown when
invalid name of identifier is used.
- INVALID_PARAMETER_COUNT_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 7001
is thrown when
trying to call a function with the wrong number of parameters.
- INVALID_PRECEDING_OR_FOLLOWING_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 22013
is thrown when preceding or
following size in a window function is null or negative.
- INVALID_TO_CHAR_FORMAT - Static variable in class org.h2.api.ErrorCode
-
The error with code 90010
is thrown when
trying to format a timestamp or number using TO_CHAR
with an invalid format.
- INVALID_TO_DATE_FORMAT - Static variable in class org.h2.api.ErrorCode
-
The error with code 90056
is thrown when trying to format a
timestamp using TO_DATE and TO_TIMESTAMP with an invalid format.
- INVALID_TRIGGER_FLAGS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90005
is thrown when
trying to create a trigger with invalid combination of flags.
- INVALID_USE_OF_AGGREGATE_FUNCTION_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90054
is thrown when
an aggregate function is used where it is not allowed.
- INVALID_VALUE_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90008
is thrown when
trying to use a value that is not valid for the given operation.
- INVALID_VALUE_PRECISION - Static variable in class org.h2.api.ErrorCode
-
The error with code 90150
is thrown when
trying to use an invalid precision.
- INVALID_VALUE_SCALE - Static variable in class org.h2.api.ErrorCode
-
The error with code 90151
is thrown when
trying to use an invalid scale or fractional seconds precision.
- invalidate() - Method in class org.h2.engine.DbObject
-
Set the main attributes to null to make sure the object is no longer
used.
- IO_BUFFER_SIZE - Static variable in class org.h2.engine.Constants
-
The block size for I/O operations.
- IO_BUFFER_SIZE_COMPRESS - Static variable in class org.h2.engine.Constants
-
The block size used to compress data in the LZFOutputStream.
- IO_EXCEPTION_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90028
is thrown when
an input / output error occurred.
- IO_EXCEPTION_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90031
is thrown when
an input / output error occurred.
- isAdmin() - Method in class org.h2.engine.User
-
- isAfterLast() - Method in class org.h2.jdbc.JdbcResultSet
-
Checks if the current position is after the last row, that means next()
was called and returned false, and there was at least one row.
- isAfterLast() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- isAllowBuiltinAliasOverride() - Method in class org.h2.engine.Database
-
- isAutoIncrement(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if this an autoincrement column.
- isAutoIncrement(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns false.
- isBeforeFirst() - Method in class org.h2.jdbc.JdbcResultSet
-
Checks if the current position is before the first row, that means next()
was not called yet, and there is at least one row.
- isBeforeFirst() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- isCancelled() - Method in class org.h2.jdbc.JdbcStatement
-
Check whether the statement was cancelled.
- isCaseSensitive(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if this column is case sensitive.
- isCaseSensitive(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns true.
- isCatalogAtStart() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the catalog is at the beginning.
- isClosed() - Method in class org.h2.engine.Session
-
Check if close was called.
- isClosed() - Method in class org.h2.engine.SessionLocal
-
- isClosed() - Method in class org.h2.engine.SessionRemote
-
- isClosed() - Method in class org.h2.jdbc.JdbcConnection
-
Returns true if this connection has been closed.
- isClosed() - Method in class org.h2.jdbc.JdbcResultSet
-
Returns whether this result set is closed.
- isClosed() - Method in class org.h2.jdbc.JdbcStatement
-
Returns whether this statement is closed.
- isClosed() - Method in class org.h2.tools.SimpleResultSet
-
Returns whether this result set has been closed.
- isCloseOnCompletion() - Method in class org.h2.jdbc.JdbcStatement
-
Returns whether this statement will be closed when its dependent result
set is closed.
- isClosing() - Method in class org.h2.engine.Database
-
Check if the database is in the process of closing.
- isClustered() - Method in class org.h2.engine.SessionRemote
-
Returns true if the connection was opened in cluster mode.
- isCommon(int) - Static method in class org.h2.api.ErrorCode
-
INTERNAL
- isCurrency(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if this is a currency column.
- isCurrency(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns false.
- isDayTime() - Method in enum org.h2.api.IntervalQualifier
-
Returns whether interval with this qualifier is a day-time interval.
- isDefinitelyWritable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks whether a write on this column will definitely succeed.
- isDefinitelyWritable(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns false.
- isFirst() - Method in class org.h2.jdbc.JdbcResultSet
-
Checks if the current position is row 1, that means next() was called
once and returned true.
- isFirst() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- isIgnoredByParser(String) - Static method in class org.h2.engine.ConnectionInfo
-
Returns whether setting with the specified name should be ignored by
parser.
- isLast() - Method in class org.h2.jdbc.JdbcResultSet
-
Checks if the current position is the last row, that means next() was
called and did not yet returned false, but will in the next call.
- isLast() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- isLazyQueryExecution() - Method in class org.h2.engine.SessionLocal
-
- 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 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
-
- isReadOnly() - Method in class org.h2.engine.Database
-
- isReadOnly() - Method in class org.h2.jdbc.JdbcConnection
-
Returns true if the database is read-only.
- isReadOnly() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns the same as Connection.isReadOnly().
- isReadOnly(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if this column is read only.
- isReadOnly(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns true.
- isRemote() - Method in class org.h2.engine.ConnectionInfo
-
Check if this is a remote connection.
- isRemote() - Method in class org.h2.engine.Session
-
Check if this session is remote or embedded.
- isRemote() - Method in class org.h2.engine.SessionLocal
-
- isRemote() - Method in class org.h2.engine.SessionRemote
-
- isRoleGranted(Role) - Method in class org.h2.engine.RightOwner
-
Check if a role has been granted for this right owner.
- isRunning(boolean) - Method in class org.h2.tools.Server
-
Checks if the server is running.
- isSameRM(XAResource) - Method in class org.h2.jdbcx.JdbcXAConnection
-
Checks if this is the same XAResource.
- isSearchable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if this column is searchable.
- isSearchable(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns true.
- isSigned(int) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Checks if this parameter is signed.
- isSigned(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if this column is signed.
- isSigned(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns true.
- isSimpleIdentifier(String) - Method in class org.h2.jdbc.JdbcStatement
-
- isSimpleIdentifier(String) - Method in interface org.h2.jdbc.JdbcStatementBackwardsCompat
-
Checks if specified identifier may be used without quotes.
- isStarting() - Method in class org.h2.engine.Database
-
Check if the database is currently opening.
- isSysTableLocked() - Method in class org.h2.engine.Database
-
Checks if the system table (containing the catalog) is locked.
- isSysTableLockedBy(SessionLocal) - Method in class org.h2.engine.Database
-
Checks if the system table (containing the catalog) is locked by the
given session.
- isTemporary() - Method in class org.h2.engine.DbObject
-
Check if this object is temporary (for example, a temporary table).
- isTruncateLargeLength() - Method in class org.h2.engine.SessionLocal
-
Returns parsing mode of data types with too large length.
- isValid() - Method in class org.h2.engine.DbObject
-
- isValid(int) - Method in class org.h2.jdbc.JdbcConnection
-
Returns true if this connection is still valid.
- isVariableBinary() - Method in class org.h2.engine.SessionLocal
-
Returns BINARY data type parsing mode.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcConnection
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcParameterMetaData
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcResultSet
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbc.JdbcStatement
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.jdbcx.JdbcDataSource
-
Checks if unwrap can return an object of this class.
- isWrapperFor(Class<?>) - Method in class org.h2.tools.SimpleResultSet
-
Checks if unwrap can return an object of this class.
- isWritable(int) - Method in class org.h2.jdbc.JdbcResultSetMetaData
-
Checks whether it is possible for a write on this column to succeed.
- isWritable(int) - Method in class org.h2.tools.SimpleResultSet
-
Returns false.
- isYearMonth() - Method in enum org.h2.api.IntervalQualifier
-
Returns whether interval with this qualifier is a year-month interval.
- SALT_LEN - Static variable in class org.h2.engine.Constants
-
The number of bytes in random salt that is used to hash passwords.
- Savepoint() - Constructor for class org.h2.engine.SessionLocal.Savepoint
-
- SAVEPOINT_IS_INVALID_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90063
is thrown when
trying to rollback to a savepoint that is not defined.
- SAVEPOINT_IS_NAMED - Static variable in class org.h2.api.ErrorCode
-
The error with code 90065
is thrown when
Savepoint.getSavepointId() is called on a named savepoint.
- SAVEPOINT_IS_UNNAMED - Static variable in class org.h2.api.ErrorCode
-
The error with code 90064
is thrown when
Savepoint.getSavepointName() is called on an unnamed savepoint.
- SCALAR_SUBQUERY_CONTAINS_MORE_THAN_ONE_ROW - Static variable in class org.h2.api.ErrorCode
-
The error with code 90053
is thrown when
a subquery that is used as a value contains more than one row.
- SCHEMA - Static variable in class org.h2.engine.DbObject
-
This object is a schema.
- schema - Variable in class org.h2.fulltext.IndexInfo
-
The schema name.
- SCHEMA_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90078
is thrown when
trying to create a schema if an object with this name already exists.
- SCHEMA_CAN_NOT_BE_DROPPED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90090
is thrown when
trying to drop a schema that may not be dropped (the schema PUBLIC
and the schema INFORMATION_SCHEMA).
- SCHEMA_MAIN - Static variable in class org.h2.engine.Constants
-
The name of the default schema.
- SCHEMA_NAME_MUST_MATCH - Static variable in class org.h2.api.ErrorCode
-
The error with code 90080
is thrown when
trying to rename a object to a different schema, or when trying to
create a related object in another schema.
- SCHEMA_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90079
is thrown when
trying to drop a schema that does not exist.
- SCHEMA_OWNER - Static variable in class org.h2.engine.Right
-
The right bit mask that means: user is a schema owner.
- SCHEMA_PG_CATALOG - Static variable in class org.h2.engine.Constants
-
The name of the pg_catalog schema.
- schemaName - Variable in class org.h2.tools.TriggerAdapter
-
The schema name.
- Script - Class in org.h2.tools
-
Creates a SQL script file by extracting the schema and data of a database.
- Script() - Constructor for class org.h2.tools.Script
-
- search(Connection, String, int, int) - Static method in class org.h2.fulltext.FullText
-
Searches from the full text index for this database.
- search(Connection, String, int, int, boolean) - Static method in class org.h2.fulltext.FullText
-
Do the search.
- search(Connection, String, int, int) - Static method in class org.h2.fulltext.FullTextLucene
-
Searches from the full text index for this database.
- search(Connection, String, int, int, boolean) - Static method in class org.h2.fulltext.FullTextLucene
-
Do the search.
- searchData(Connection, String, int, int) - Static method in class org.h2.fulltext.FullText
-
Searches from the full text index for this database.
- searchData(Connection, String, int, int) - Static method in class org.h2.fulltext.FullTextLucene
-
Searches from the full text index for this database.
- SECOND_PRIMARY_KEY - Static variable in class org.h2.api.ErrorCode
-
The error with code 90017
is thrown when
trying to define a second primary key constraint for this table.
- SELECT - Static variable in interface org.h2.api.Trigger
-
The trigger is called for SELECT statements.
- SELECT - Static variable in class org.h2.engine.Right
-
The right bit mask that means: selecting from a table is allowed.
- SELECTIVITY_DEFAULT - Static variable in class org.h2.engine.Constants
-
The default selectivity (used if the selectivity is not calculated).
- SELECTIVITY_DISTINCT_COUNT - Static variable in class org.h2.engine.Constants
-
The number of distinct values to keep in memory when running ANALYZE.
- SEQUENCE - Static variable in class org.h2.engine.DbObject
-
This object is a sequence.
- SEQUENCE_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90035
is thrown when
trying to create a sequence if a sequence with this name already
exists.
- SEQUENCE_ATTRIBUTES_INVALID_7 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90009
is thrown when
trying to create a sequence with an invalid combination
of attributes (min value, max value, start value, etc).
- SEQUENCE_BELONGS_TO_A_TABLE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90082
is thrown when
trying to drop a system generated sequence.
- SEQUENCE_EXHAUSTED - Static variable in class org.h2.api.ErrorCode
-
The error with code 90006
is thrown when
trying to get a value from a sequence that has run out of numbers
and does not have cycling enabled.
- SEQUENCE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90036
is thrown when
trying to access a sequence that does not exist.
- serialDataTypes - Variable in class org.h2.engine.Mode
-
Whether SERIAL and BIGSERIAL pseudo data types are supported.
- SERIALIZATION_FAILED_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90026
is thrown when
an object could not be serialized.
- serialize(Object) - Method in interface org.h2.api.JavaObjectSerializer
-
Serialize object to byte array.
- Server - Class in org.h2.tools
-
Starts the H2 Console (web-) server, TCP, and PG server.
- Server() - Constructor for class org.h2.tools.Server
-
- Server(Service, String...) - Constructor for class org.h2.tools.Server
-
Create a new server for the given service.
- SERVER_CACHED_OBJECTS - Static variable in class org.h2.engine.SysProperties
-
System property h2.serverCachedObjects
(default: 64).
- SERVER_PROPERTIES_DIR - Static variable in class org.h2.engine.Constants
-
The default directory name of the server properties file for the H2
Console.
- SERVER_PROPERTIES_NAME - Static variable in class org.h2.engine.Constants
-
The name of the server properties file for the H2 Console.
- SERVER_RESULT_SET_FETCH_SIZE - Static variable in class org.h2.engine.SysProperties
-
System property h2.serverResultSetFetchSize
(default: 100).
- Session - Class in org.h2.engine
-
A local or remote session.
- session - Variable in class org.h2.jdbc.JdbcStatement
-
- Session.DynamicSettings - Class in org.h2.engine
-
Dynamic settings.
- Session.StaticSettings - Class in org.h2.engine
-
Static settings.
- SESSION_CANCEL_STATEMENT - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_CHECK_KEY - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_CLOSE - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_HAS_PENDING_TRANSACTION - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_PREPARE - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_PREPARE_READ_PARAMS2 - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_SET_AUTOCOMMIT - Static variable in class org.h2.engine.SessionRemote
-
- SESSION_SET_ID - Static variable in class org.h2.engine.SessionRemote
-
- SessionLocal - Class in org.h2.engine
-
A session represents an embedded database connection.
- SessionLocal(Database, User, int) - Constructor for class org.h2.engine.SessionLocal
-
- SessionLocal.Savepoint - Class in org.h2.engine
-
Represents a savepoint (a position in a transaction to where one can roll
back to).
- SessionLocal.State - Enum in org.h2.engine
-
- SessionLocal.TimeoutValue - Class in org.h2.engine
-
An LOB object with a timeout.
- SessionRemote - Class in org.h2.engine
-
The client side part of a session when using the server mode.
- SessionRemote(ConnectionInfo) - Constructor for class org.h2.engine.SessionRemote
-
- setAdmin(boolean) - Method in class org.h2.engine.User
-
- setAllowBuiltinAliasOverride(boolean) - Method in class org.h2.engine.Database
-
- setAllowLiterals(int) - Method in class org.h2.engine.Database
-
- setAllowLiterals(boolean) - Method in class org.h2.engine.SessionLocal
-
- setArray(int, Array) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an Array.
- setAsciiStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as an ASCII stream.
- setAsciiStream(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as an ASCII stream.
- setAsciiStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as an ASCII stream.
- setAsciiStream(long) - Method in class org.h2.jdbc.JdbcClob
-
[Not supported] Returns an output stream.
- setAsciiStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an ASCII stream.
- setAsciiStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an ASCII stream.
- setAsciiStream(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an ASCII stream.
- setAuthenticator(Authenticator) - Method in class org.h2.engine.Database
-
Set current database authenticator
- setAutoClose(boolean) - Method in class org.h2.tools.SimpleResultSet
-
Set the auto-close behavior.
- setAutoCommit(boolean) - Method in class org.h2.engine.Session
-
Set the auto-commit mode.
- setAutoCommit(boolean) - Method in class org.h2.engine.SessionLocal
-
- setAutoCommit(boolean) - Method in class org.h2.engine.SessionRemote
-
- setAutoCommit(boolean) - Method in class org.h2.jdbc.JdbcConnection
-
Switches auto commit on or off.
- setAutoCommitFromServer(boolean) - Method in class org.h2.engine.SessionRemote
-
- setBackgroundException(DbException) - Method in class org.h2.engine.Database
-
- setBaseDir(String) - Method in class org.h2.engine.ConnectionInfo
-
Set the base directory of persistent databases, unless the database is in
the user home folder (~).
- setBaseDir(String) - Static method in class org.h2.engine.SysProperties
-
INTERNAL
- setBigDecimal(String, BigDecimal) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setBigDecimal(int, BigDecimal) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setBinaryStream(long) - Method in class org.h2.jdbc.JdbcBlob
-
Get a writer to update the Blob.
- setBinaryStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as an input stream.
- setBinaryStream(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as an input stream.
- setBinaryStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as an input stream.
- setBinaryStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an input stream.
- setBinaryStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an input stream.
- setBinaryStream(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as an input stream.
- setBinaryStream() - Method in class org.h2.jdbc.JdbcSQLXML
-
- setBlob(String, InputStream, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Blob.
- setBlob(String, Blob) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Blob.
- setBlob(String, InputStream) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Blob.
- setBlob(int, Blob) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Blob.
- setBlob(int, InputStream) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Blob.
- setBlob(int, InputStream, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Blob.
- setBoolean(String, boolean) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setBoolean(int, boolean) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setByte(String, byte) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setByte(int, byte) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setBytes(long, byte[]) - Method in class org.h2.jdbc.JdbcBlob
-
Fills the Blob.
- setBytes(long, byte[], int, int) - Method in class org.h2.jdbc.JdbcBlob
-
Sets some bytes of the object.
- setBytes(String, byte[]) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a byte array.
- setBytes(int, byte[]) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a byte array.
- setCacheSize(int) - Method in class org.h2.engine.Database
-
- setCaseSensitiveColumnNames(boolean) - Method in class org.h2.tools.Csv
-
Override the case sensitive column names setting.
- setCatalog(String) - Method in class org.h2.jdbc.JdbcConnection
-
Set the default catalog name.
- setCharacterStream(String, Reader, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a character stream.
- setCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a character stream.
- setCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a character stream.
- setCharacterStream(long) - Method in class org.h2.jdbc.JdbcClob
-
Get a writer to update the Clob.
- setCharacterStream(int, Reader, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a character stream.
- setCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a character stream.
- setCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a character stream.
- setCharacterStream() - Method in class org.h2.jdbc.JdbcSQLXML
-
- setClientInfo(String, String) - Method in class org.h2.jdbc.JdbcConnection
-
Set a client property.
- setClientInfo(Properties) - Method in class org.h2.jdbc.JdbcConnection
-
Set the client properties.
- setClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Clob.
- setClob(String, Clob) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Clob.
- setClob(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a character stream.
- setClob(int, Clob) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Clob.
- setClob(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Clob.
- setClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Clob.
- setCloseDelay(int) - Method in class org.h2.engine.Database
-
- setCluster(String) - Method in class org.h2.engine.Database
-
- setColumns(int[], ArrayList<String>, ArrayList<String>) - Static method in class org.h2.fulltext.FullText
-
Set the column indices of a set of keys.
- setComment(String) - Method in class org.h2.engine.DbObject
-
Change the comment of this object.
- setCommentText(String) - Method in class org.h2.engine.Comment
-
Set the comment text.
- setCommitOrRollbackDisabled(boolean) - Method in class org.h2.engine.SessionLocal
-
- setCompactMode(int) - Method in class org.h2.engine.Database
-
- setCompareMode(CompareMode) - Method in class org.h2.engine.Database
-
- setCurrentSchema(Schema) - Method in class org.h2.engine.SessionLocal
-
- setCurrentSchemaName(String) - Method in class org.h2.engine.Session
-
Set current schema.
- setCurrentSchemaName(String) - Method in class org.h2.engine.SessionLocal
-
- setCurrentSchemaName(String) - Method in class org.h2.engine.SessionRemote
-
- setCursorName(String) - Method in class org.h2.jdbc.JdbcStatement
-
Sets the name of the cursor.
- setDate(String, Date, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the date using a specified time zone.
- setDate(String, Date) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setDate(int, Date) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setDate(int, Date, Calendar) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the date using a specified time zone.
- setDefaultNullOrdering(DefaultNullOrdering) - Method in class org.h2.engine.Database
-
- setDefaultTableType(int) - Method in class org.h2.engine.Database
-
- setDeleteFilesOnDisconnect(boolean) - Method in class org.h2.engine.Database
-
- setDescription(String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the description.
- setDouble(String, double) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setDouble(int, double) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setErr(PrintStream) - Method in class org.h2.tools.Shell
-
Sets the standard error stream.
- setEscapeCharacter(char) - Method in class org.h2.tools.Csv
-
Set the escape character.
- setEscapeProcessing(boolean) - Method in class org.h2.jdbc.JdbcStatement
-
Enables or disables processing or JDBC escape syntax.
- setEventListener(DatabaseEventListener) - Method in class org.h2.engine.Database
-
- setEventListenerClass(String) - Method in class org.h2.engine.Database
-
- setExclusiveSession(SessionLocal, boolean) - Method in class org.h2.engine.Database
-
Set the session that can exclusively access the database.
- setFetchDirection(int) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported]
Sets (changes) the fetch direction for this result set.
- setFetchDirection(int) - Method in class org.h2.jdbc.JdbcStatement
-
Sets the fetch direction.
- setFetchDirection(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- setFetchSize(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Sets the number of rows suggested to read in one step.
- setFetchSize(int) - Method in class org.h2.jdbc.JdbcStatement
-
Sets the number of rows suggested to read in one step.
- setFetchSize(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- setFieldDelimiter(char) - Method in class org.h2.tools.Csv
-
Set the field delimiter.
- setFieldSeparatorRead(char) - Method in class org.h2.tools.Csv
-
Override the field separator for reading.
- setFieldSeparatorWrite(String) - Method in class org.h2.tools.Csv
-
Override the field separator for writing.
- setFileEncryptionKey(byte[]) - Method in class org.h2.engine.ConnectionInfo
-
- setFilePasswordHash(byte[]) - Method in class org.h2.engine.ConnectionInfo
-
Set the file password hash.
- setFloat(String, float) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setFloat(int, float) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setHoldability(int) - Method in class org.h2.jdbc.JdbcConnection
-
Changes the current result set holdability.
- setIgnoreCase(boolean) - Method in class org.h2.engine.Database
-
- setIgnoreCatalogs(boolean) - Method in class org.h2.engine.Database
-
- setIgnoreList(Connection, String) - Static method in class org.h2.fulltext.FullText
-
Change the ignore list.
- setIn(InputStream) - Method in class org.h2.tools.Shell
-
Redirects the standard input.
- setInitialPowerOffCount(int) - Static method in class org.h2.engine.Database
-
- setInReader(BufferedReader) - Method in class org.h2.tools.Shell
-
Redirects the standard input.
- setInt(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setInt(int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setIntValue(int) - Method in class org.h2.engine.Setting
-
- setIsolationLevel(IsolationLevel) - Method in class org.h2.engine.Session
-
Sets the isolation level.
- setIsolationLevel(IsolationLevel) - Method in class org.h2.engine.SessionLocal
-
- setIsolationLevel(IsolationLevel) - Method in class org.h2.engine.SessionRemote
-
- setJavaObjectSerializerName(String) - Method in class org.h2.engine.Database
-
- setLargeMaxRows(long) - Method in class org.h2.jdbc.JdbcStatement
-
Gets the maximum number of rows for a ResultSet.
- setLastIdentity(Value) - Method in class org.h2.engine.SessionLocal
-
- setLazyQueryExecution(boolean) - Method in class org.h2.engine.SessionLocal
-
- setLineCommentCharacter(char) - Method in class org.h2.tools.Csv
-
Set the line comment character.
- setLineSeparator(String) - Method in class org.h2.tools.Csv
-
Set the line separator used for writing.
- setLockMode(int) - Method in class org.h2.engine.Database
-
- setLockTimeout(int) - Method in class org.h2.engine.SessionLocal
-
- setLoginTimeout(int) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Sets the maximum time in seconds to wait for a free connection.
- setLoginTimeout(int) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the login timeout in seconds, 0 meaning no timeout.
- setLogWriter(PrintWriter) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
INTERNAL
- setLogWriter(PrintWriter) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the current log writer for this object.
- setLong(String, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setLong(int, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setMasterUser(User) - Method in class org.h2.engine.Database
-
- setMaxConnections(int) - Method in class org.h2.jdbcx.JdbcConnectionPool
-
Sets the maximum number of connections to use from now on.
- setMaxFieldSize(int) - Method in class org.h2.jdbc.JdbcStatement
-
Sets the maximum number of bytes for a result set column.
- setMaxLengthInplaceLob(int) - Method in class org.h2.engine.Database
-
- setMaxMemoryRows(int) - Method in class org.h2.engine.Database
-
- setMaxOperationMemory(int) - Method in class org.h2.engine.Database
-
- setMaxQueryEntries(int) - Method in class org.h2.engine.QueryStatisticsData
-
- setMaxRows(int) - Method in class org.h2.jdbc.JdbcStatement
-
Gets the maximum number of rows for a ResultSet.
- setMode(Mode) - Method in class org.h2.engine.Database
-
- setModified() - Method in class org.h2.engine.DbObject
-
Tell the object that is was modified.
- setNCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a character stream.
- setNCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a character stream.
- setNCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a character stream.
- setNCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a character stream.
- setNClob(String, NClob) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Clob.
- setNClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Clob.
- setNClob(String, Reader) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a Clob.
- setNClob(int, NClob) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Clob.
- setNClob(int, Reader) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Clob.
- setNClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a Clob.
- setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.ConnectionInfo
-
Sets the network connection information.
- setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.Session
-
Sets the network connection information if possible.
- setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.SessionLocal
-
- setNetworkConnectionInfo(NetworkConnectionInfo) - Method in class org.h2.engine.SessionRemote
-
- setNetworkTimeout(Executor, int) - Method in class org.h2.jdbc.JdbcConnection
-
[Not supported]
- setNonKeywords(BitSet) - Method in class org.h2.engine.SessionLocal
-
Sets bit set of non-keywords.
- setNString(String, String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setNString(int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setNull(String, int, String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets a parameter to null.
- setNull(String, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets a parameter to null.
- setNull(int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets a parameter to null.
- setNull(int, int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets a parameter to null.
- setNullString(String) - Method in class org.h2.tools.Csv
-
Set the value that represents NULL.
- setObject(String, Object) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setObject(String, Object, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setObject(String, Object, int, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setObject(String, Object, SQLType) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setObject(String, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setObject(int, Object) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setObject(int, Object, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setObject(int, Object, int, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setObject(int, Object, SQLType) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setObject(int, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setObjectName(String) - Method in class org.h2.engine.DbObject
-
- setOldInformationSchema(boolean) - Method in class org.h2.engine.SessionLocal
-
Changes INFORMATION_SCHEMA content.
- setOptimizeReuseResults(boolean) - Method in class org.h2.engine.Database
-
- setOptions(String) - Method in class org.h2.tools.Csv
-
INTERNAL.
- setOriginalURL(String) - Method in class org.h2.engine.ConnectionInfo
-
Set the original database URL.
- setParsingCreateView(boolean) - Method in class org.h2.engine.SessionLocal
-
This method is called before and after parsing of view definition and may
be called recursively.
- setPassword(String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the current password.
- setPasswordChars(char[]) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the current password in the form of a char array.
- setPoolable(boolean) - Method in class org.h2.jdbc.JdbcStatement
-
Requests that this object should be pooled or not.
- setPowerOffCount(int) - Method in class org.h2.engine.Database
-
- setPreparedTransaction(String, boolean) - Method in class org.h2.engine.SessionLocal
-
Commit or roll back the given transaction.
- setPreserveWhitespace(boolean) - Method in class org.h2.tools.Csv
-
Enable or disable preserving whitespace in unquoted text.
- setProgress(int, String, long, long) - Method in interface org.h2.api.DatabaseEventListener
-
This method is called for long running events, such as recovering,
scanning a file or building an index.
- setProgress(int, String, long, long) - Method in class org.h2.engine.Database
-
Set the progress of a long running operation.
- setProperty(String, String) - Method in class org.h2.engine.ConnectionInfo
-
Overwrite a property.
- setQueryStatistics(boolean) - Method in class org.h2.engine.Database
-
- setQueryStatisticsMaxEntries(int) - Method in class org.h2.engine.Database
-
- setQueryTimeout(int) - Method in class org.h2.engine.SessionLocal
-
- setQueryTimeout(int) - Method in class org.h2.jdbc.JdbcStatement
-
Sets the current query timeout in seconds.
- setQuirksMode(boolean) - Method in class org.h2.engine.SessionLocal
-
Enables or disables the quirks mode.
- setQuotedNulls(boolean) - Method in class org.h2.tools.Csv
-
- setReadOnly(boolean) - Method in class org.h2.engine.Database
-
Switch the database to read-only mode.
- setReadOnly(boolean) - Method in class org.h2.jdbc.JdbcConnection
-
According to the JDBC specs, this setting is only a hint to the database
to enable optimizations - it does not cause writes to be prohibited.
- setRef(int, Ref) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
[Not supported] Sets the value of a column as a reference.
- setReferentialIntegrity(boolean) - Method in class org.h2.engine.Database
-
- setResult(Class<T>) - Method in class org.h2.jdbc.JdbcSQLXML
-
- setRetentionTime(int) - Method in class org.h2.engine.Database
-
- setRightMask(int) - Method in class org.h2.engine.Right
-
- setRowFactory(RowFactory) - Method in class org.h2.engine.Database
-
- setRowId(String, RowId) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported] Sets the value of a parameter as a row id.
- setRowId(int, RowId) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
[Not supported] Sets the value of a parameter as a row id.
- setSaltAndHash(byte[], byte[]) - Method in class org.h2.engine.User
-
Set the salt and hash of the password for this user.
- setSavepoint() - Method in class org.h2.engine.SessionLocal
-
Create a savepoint to allow rolling back to this state.
- setSavepoint() - Method in class org.h2.jdbc.JdbcConnection
-
Creates a new unnamed savepoint.
- setSavepoint(String) - Method in class org.h2.jdbc.JdbcConnection
-
Creates a new named savepoint.
- setSchema(String) - Method in class org.h2.jdbc.JdbcConnection
-
Sets the given schema name to access.
- setSchemaSearchPath(String[]) - Method in class org.h2.engine.SessionLocal
-
- setServerKey(String) - Method in class org.h2.engine.ConnectionInfo
-
Switch to server mode, and set the server name and database key.
- setShort(String, short) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setShort(int, short) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setShutdownHandler(ShutdownHandler) - Method in class org.h2.tools.Server
-
INTERNAL
- setSQL(String) - Method in interface org.h2.jdbc.JdbcException
-
INTERNAL
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLDataException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLFeatureNotSupportedException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLNonTransientConnectionException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLNonTransientException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLSyntaxErrorException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLTimeoutException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLTransactionRollbackException
-
- setSQL(String) - Method in exception org.h2.jdbc.JdbcSQLTransientException
-
- setSQLXML(String, SQLXML) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter as a SQLXML object.
- setSQLXML(int, SQLXML) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter as a SQLXML.
- setString(String, String) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setString(long, String) - Method in class org.h2.jdbc.JdbcClob
-
Fills the Clob.
- setString(long, String, int, int) - Method in class org.h2.jdbc.JdbcClob
-
Fills the Clob.
- setString(int, String) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setString(String) - Method in class org.h2.jdbc.JdbcSQLXML
-
- setStringValue(String) - Method in class org.h2.engine.Setting
-
- setTemporary(boolean) - Method in class org.h2.engine.DbObject
-
Tell this object that it is temporary or not.
- setThreadLocalSession() - Method in class org.h2.engine.Session
-
Sets this session as thread local session, if this session is a local
session.
- setThreadLocalSession() - Method in class org.h2.engine.SessionLocal
-
- setThrottle(int) - Method in class org.h2.engine.SessionLocal
-
- setTime(String, Time, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the time using a specified time zone.
- setTime(String, Time) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the time using a specified time zone.
- setTime(int, Time) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setTime(int, Time, Calendar) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the time using a specified time zone.
- setTimestamp(String, Timestamp, Calendar) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the timestamp using a specified time zone.
- setTimestamp(String, Timestamp) - Method in class org.h2.jdbc.JdbcCallableStatement
-
Sets the value of a parameter.
- setTimestamp(int, Timestamp) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the value of a parameter.
- setTimestamp(int, Timestamp, Calendar) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
Sets the timestamp using a specified time zone.
- setTimeZone(TimeZoneProvider) - Method in class org.h2.engine.SessionLocal
-
Sets current time zone.
- SETTING - Static variable in class org.h2.engine.DbObject
-
This object is a setting.
- Setting - Class in org.h2.engine
-
A persistent database setting.
- Setting(Database, int, String) - Constructor for class org.h2.engine.Setting
-
- SettingsBase - Class in org.h2.engine
-
The base class for settings.
- SettingsBase(HashMap<String, String>) - Constructor for class org.h2.engine.SettingsBase
-
- setTransactionIsolation(int) - Method in class org.h2.jdbc.JdbcConnection
-
Changes the current transaction isolation level.
- setTransactionTimeout(int) - Method in class org.h2.jdbcx.JdbcXAConnection
-
Set the transaction timeout.
- setTruncateLargeLength(boolean) - Method in class org.h2.engine.SessionLocal
-
Changes parsing mode of data types with too large length.
- setTypeMap(Map<String, Class<?>>) - Method in class org.h2.jdbc.JdbcConnection
-
[Partially supported] Sets the type map.
- setUnicodeStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
- setURL(String, URL) - Method in class org.h2.jdbc.JdbcCallableStatement
-
[Not supported]
- setURL(int, URL) - Method in class org.h2.jdbc.JdbcPreparedStatement
-
[Not supported]
- setURL(String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the current URL.
- setUrl(String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the current URL.
- setUser(String) - Method in class org.h2.jdbcx.JdbcDataSource
-
Set the current user name.
- setUserName(String) - Method in class org.h2.engine.ConnectionInfo
-
Overwrite the user name.
- setUserPasswordHash(byte[]) - Method in class org.h2.engine.ConnectionInfo
-
Set the user password hash.
- setUserPasswordHash(byte[]) - Method in class org.h2.engine.User
-
Set the user name password hash.
- setVariable(String, Value) - Method in class org.h2.engine.SessionLocal
-
Set the value of the given variable for this session.
- setVariableBinary(boolean) - Method in class org.h2.engine.SessionLocal
-
Changes parsing of a BINARY data type.
- setWaitForLock(Table, Thread) - Method in class org.h2.engine.SessionLocal
-
Set the table this session is waiting for, and the thread that is
waiting.
- setWhitespaceChars(Connection, String) - Static method in class org.h2.fulltext.FullText
-
Change the whitespace characters.
- setWriteColumnHeader(boolean) - Method in class org.h2.tools.Csv
-
Enable or disable writing the column header.
- setWriteDelay(int) - Method in class org.h2.engine.Database
-
- shareLinkedConnections - Variable in class org.h2.engine.DbSettings
-
Database setting SHARE_LINKED_CONNECTIONS
(default: true).
- Shell - Class in org.h2.tools
-
Interactive command line tool to access a database using JDBC.
- Shell() - Constructor for class org.h2.tools.Shell
-
- shutdown() - Method in class org.h2.tools.Console
-
INTERNAL.
- shutdown() - Method in class org.h2.tools.GUIConsole
-
- shutdown() - Method in class org.h2.tools.Server
-
INTERNAL
- shutdownImmediately() - Method in class org.h2.engine.Database
-
Immediately close the database.
- shutdownTcpServer(String, String, boolean, boolean) - Static method in class org.h2.tools.Server
-
Shutdown one or all TCP server.
- SimpleResultSet - Class in org.h2.tools
-
This class is a simple result set and meta data implementation.
- SimpleResultSet() - Constructor for class org.h2.tools.SimpleResultSet
-
This constructor is used if the result set is later populated with
addRow.
- SimpleResultSet(SimpleRowSource) - Constructor for class org.h2.tools.SimpleResultSet
-
This constructor is used if the result set should retrieve the rows using
the specified row source object.
- SimpleResultSet.SimpleArray - Class in org.h2.tools
-
A simple array implementation,
backed by an object array
- SimpleRowSource - Interface in org.h2.tools
-
This interface is for classes that create rows on demand.
- SLOW_QUERY_LIMIT_MS - Static variable in class org.h2.engine.Constants
-
Queries that take longer than this number of milliseconds are written to
the trace file with the level info.
- SMALLINT - Static variable in class org.h2.api.H2Type
-
The SMALLINT data type.
- SOCKET_CONNECT_RETRY - Static variable in class org.h2.engine.SysProperties
-
System property h2.socketConnectRetry
(default: 16).
- SOCKET_CONNECT_TIMEOUT - Static variable in class org.h2.engine.SysProperties
-
System property h2.socketConnectTimeout
(default: 2000).
- SPLIT_FILE_SIZE_SHIFT - Static variable in class org.h2.engine.SysProperties
-
System property h2.splitFileSizeShift
(default: 30).
- sqlStatement - Variable in class org.h2.engine.QueryStatisticsData.QueryEntry
-
The SQL statement.
- squareBracketQuotedNames - Variable in class org.h2.engine.Mode
-
Identifiers may be quoted using square brackets as in [Test].
- start(Xid, int) - Method in class org.h2.jdbcx.JdbcXAConnection
-
Start or continue to work on a transaction.
- start() - Method in class org.h2.tools.Server
-
Tries to start the server.
- START_URL - Static variable in class org.h2.engine.Constants
-
The database URL prefix of this database.
- startStatementWithinTransaction(Command) - Method in class org.h2.engine.SessionLocal
-
Start a new statement within a transaction.
- startWebServer(Connection) - Static method in class org.h2.tools.Server
-
Start a web server and a browser that uses the given connection.
- startWebServer(Connection, boolean) - Static method in class org.h2.tools.Server
-
Start a web server and a browser that uses the given connection.
- STATE_BACKUP_FILE - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used during the BACKUP command.
- STATE_CREATE_INDEX - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used when re-creating an index.
- STATE_RECONNECTED - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used after re-connecting to a database (if auto-reconnect
is enabled).
- STATE_RECOVER - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used when re-applying the transaction log or rolling back
uncommitted transactions.
- STATE_SCAN_FILE - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used when scanning the database file.
- STATE_STATEMENT_END - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used when a query ends.
- STATE_STATEMENT_PROGRESS - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used for periodic notification during long-running queries.
- STATE_STATEMENT_START - Static variable in interface org.h2.api.DatabaseEventListener
-
This state is used when a query starts.
- STATEMENT_WAS_CANCELED - Static variable in class org.h2.api.ErrorCode
-
The error with code 57014
is thrown when
a statement was canceled using Statement.cancel() or
when the query timeout has been reached.
- StaticSettings(boolean, boolean, boolean) - Constructor for class org.h2.engine.Session.StaticSettings
-
Creates new instance of static settings.
- STATUS_CLOSED - Static variable in class org.h2.engine.SessionRemote
-
- STATUS_ERROR - Static variable in class org.h2.engine.SessionRemote
-
- STATUS_OK - Static variable in class org.h2.engine.SessionRemote
-
- STATUS_OK_STATE_CHANGED - Static variable in class org.h2.engine.SessionRemote
-
- STEP_SIZE_MUST_NOT_BE_ZERO - Static variable in class org.h2.api.ErrorCode
-
The error with code 90142
is thrown when
trying to set zero for step size.
- stop() - Method in class org.h2.tools.Server
-
Stops the server.
- STORE_DOCUMENT_TEXT_IN_INDEX - Static variable in class org.h2.fulltext.FullTextLucene
-
Whether the text content should be stored in the Lucene index.
- storesLowerCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE Test(ID INT), getTables returns test as the
table name.
- storesLowerCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the
table name.
- storesMixedCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the
table name and identifiers are not case sensitive.
- storesMixedCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the
table name and identifiers are case insensitive.
- storesUpperCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the
table name.
- storesUpperCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the
table name.
- STRING_FORMAT_ERROR_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90095
is thrown when
calling the method STRINGDECODE with an invalid escape sequence.
- SUBQUERY_IS_NOT_SINGLE_COLUMN - Static variable in class org.h2.api.ErrorCode
-
The error with code 90052
is thrown when a single-column
subquery is expected but a subquery with other number of columns was
specified.
- SUFFIX_LOCK_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of file lock files that are used to make sure a
database is open by only one process at any time.
- SUFFIX_MV_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of a MVStore file.
- SUFFIX_MV_STORE_NEW_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of a new MVStore file, used when compacting a store.
- SUFFIX_MV_STORE_TEMP_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of a temporary MVStore file, used when compacting a
store.
- SUFFIX_OLD_DATABASE_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of a H2 version 1.1 database file.
- SUFFIX_TEMP_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of temporary files.
- SUFFIX_TRACE_FILE - Static variable in class org.h2.engine.Constants
-
The file name suffix of trace files.
- SUM_OR_AVG_ON_WRONG_DATATYPE_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90015
is thrown when
using an aggregate function with a data type that is not supported.
- supportedClientInfoPropertiesRegEx - Variable in class org.h2.engine.Mode
-
Pattern describing the keys the java.sql.Connection.setClientInfo()
method accepts.
- supportPoundSymbolForColumnNames - Variable in class org.h2.engine.Mode
-
Support the # for column names
- supportsAlterTableWithAddColumn() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether alter table with add column is supported.
- supportsAlterTableWithDropColumn() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether alter table with drop column is supported.
- supportsANSI92EntryLevelSQL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether SQL-92 entry level grammar is supported.
- supportsANSI92FullSQL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether SQL-92 full level grammar is supported.
- supportsANSI92IntermediateSQL() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether SQL-92 intermediate level grammar is supported.
- supportsBatchUpdates() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether batch updates are supported.
- supportsCatalogsInDataManipulation() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.
- supportsCatalogsInIndexDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the catalog name in CREATE INDEX is supported.
- supportsCatalogsInPrivilegeDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the catalog name in GRANT is supported.
- supportsCatalogsInProcedureCalls() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the catalog name in procedure calls is supported.
- supportsCatalogsInTableDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the catalog name in CREATE TABLE is supported.
- supportsColumnAliasing() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether column aliasing is supported.
- supportsConvert() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether CONVERT is supported.
- supportsConvert(int, int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether CONVERT is supported for one datatype to another.
- supportsCoreSQLGrammar() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether ODBC Core SQL grammar is supported.
- supportsCorrelatedSubqueries() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether correlated subqueries are supported.
- supportsDataDefinitionAndDataManipulationTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether data manipulation and CREATE/DROP is supported in
transactions.
- supportsDataManipulationTransactionsOnly() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether only data manipulations are supported in transactions.
- supportsDifferentTableCorrelationNames() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether table correlation names (table alias) are restricted to
be different than table names.
- supportsExpressionsInOrderBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether expression in ORDER BY are supported.
- supportsExtendedSQLGrammar() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether ODBC Extended SQL grammar is supported.
- supportsFullOuterJoins() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether full outer joins are supported.
- supportsGetGeneratedKeys() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Does the database support getGeneratedKeys.
- supportsGroupBy() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether GROUP BY is supported.
- supportsGroupByBeyondSelect() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks whether a GROUP BY clause can use columns that are not in the
SELECT clause, provided that it specifies all the columns in the SELECT
clause.
- supportsGroupByUnrelated() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether GROUP BY is supported if the column is not in the SELECT
list.
- supportsIntegrityEnhancementFacility() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether referential integrity is supported.
- supportsLikeEscapeClause() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether LIKE...
- supportsLimitedOuterJoins() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether limited outer joins are supported.
- supportsMinimumSQLGrammar() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether ODBC Minimum SQL grammar is supported.
- supportsMixedCaseIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the
table name and identifiers are case sensitive.
- supportsMixedCaseQuotedIdentifiers() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if a table created with CREATE TABLE "Test"(ID INT) is a different
table than a table created with CREATE TABLE "TEST"(ID INT).
- supportsMultipleOpenResults() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Does the database support multiple open result sets returned from a
CallableStatement
.
- supportsMultipleResultSets() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether multiple result sets are supported.
- supportsMultipleTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether multiple transactions (on different connections) are
supported.
- supportsNamedParameters() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Does the database support named parameters.
- supportsNonNullableColumns() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether columns with NOT NULL are supported.
- supportsOpenCursorsAcrossCommit() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether open result sets across commits are supported.
- supportsOpenCursorsAcrossRollback() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether open result sets across rollback are supported.
- supportsOpenStatementsAcrossCommit() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether open statements across commit are supported.
- supportsOpenStatementsAcrossRollback() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether open statements across rollback are supported.
- supportsOrderByUnrelated() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether ORDER BY is supported if the column is not in the SELECT
list.
- supportsOuterJoins() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether outer joins are supported.
- supportsPositionedDelete() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether positioned deletes are supported.
- supportsPositionedUpdate() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether positioned updates are supported.
- supportsResultSetConcurrency(int, int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether a specific result set concurrency is supported.
- supportsResultSetHoldability(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Does this database supports a result set holdability.
- supportsResultSetType(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether a specific result set type is supported.
- supportsSavepoints() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Does the database support savepoints.
- supportsSchemasInDataManipulation() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the schema name in INSERT, UPDATE, DELETE is supported.
- supportsSchemasInIndexDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the schema name in CREATE INDEX is supported.
- supportsSchemasInPrivilegeDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the schema name in GRANT is supported.
- supportsSchemasInProcedureCalls() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the schema name in procedure calls is supported.
- supportsSchemasInTableDefinitions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the schema name in CREATE TABLE is supported.
- supportsSelectForUpdate() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether SELECT ...
- supportsStatementPooling() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Does the database support statement pooling.
- supportsStoredFunctionsUsingCallSyntax() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether the database supports calling functions using the call
syntax.
- supportsStoredProcedures() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether stored procedures are supported.
- supportsSubqueriesInComparisons() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether subqueries (SELECT) in comparisons are supported.
- supportsSubqueriesInExists() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether SELECT in EXISTS is supported.
- supportsSubqueriesInIns() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether IN(SELECT...) is supported.
- supportsSubqueriesInQuantifieds() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether subqueries in quantified expression are supported.
- supportsTableCorrelationNames() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether table correlation names (table alias) are supported.
- supportsTransactionIsolationLevel(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether a specific transaction isolation level is supported.
- supportsTransactions() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether transactions are supported.
- supportsUnion() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether UNION SELECT is supported.
- supportsUnionAll() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether UNION ALL SELECT is supported.
- swapConvertFunctionParameters - Variable in class org.h2.engine.Mode
-
Swap the parameters of the CONVERT function.
- swapLogFunctionParameters - Variable in class org.h2.engine.Mode
-
Swap the parameters of LOG() function.
- sync() - Method in class org.h2.engine.Database
-
Synchronize the files with the file system.
- SYNONYM - Static variable in class org.h2.engine.DbObject
-
This object is a synonym.
- SYNTAX_ERROR_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42000
is thrown when
trying to execute an invalid SQL statement.
- SYNTAX_ERROR_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 42001
is thrown when
trying to execute an invalid SQL statement.
- sysDummy1 - Variable in class org.h2.engine.Mode
-
Support the pseudo-table SYSIBM.SYSDUMMY1.
- sysIdentifier(String) - Method in class org.h2.engine.Database
-
Returns identifier in upper or lower case depending on database settings.
- SysProperties - Class in org.h2.engine
-
The constants defined in this class are initialized from system properties.
- systemColumns - Variable in class org.h2.engine.Mode
-
The system columns 'ctid' and 'oid' are supported.
- 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 - Static variable in interface org.h2.api.Trigger
-
The trigger is called for UPDATE statements.
- update(String, long, long) - Method in class org.h2.engine.QueryStatisticsData
-
Update query statistics.
- UPDATE - Static variable in class org.h2.engine.Right
-
The right bit mask that means: updating data is allowed.
- updateArray(int, Array) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateArray(String, Array) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateArray(int, Array) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateArray(String, Array) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateAsciiStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateAsciiStream(int, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateAsciiStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateAsciiStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateAsciiStream(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateAsciiStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateAsciiStream(int, InputStream) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateAsciiStream(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateAsciiStream(int, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateAsciiStream(String, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateAsciiStream(int, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateAsciiStream(String, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBigDecimal(int, BigDecimal) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBigDecimal(String, BigDecimal) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBigDecimal(int, BigDecimal) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBigDecimal(String, BigDecimal) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBinaryStream(int, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBinaryStream(int, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBinaryStream(int, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBinaryStream(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBinaryStream(String, InputStream, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBinaryStream(String, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBinaryStream(int, InputStream) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBinaryStream(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBinaryStream(int, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBinaryStream(String, InputStream, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBinaryStream(int, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBinaryStream(String, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBlob(int, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBlob(int, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBlob(int, Blob) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBlob(String, Blob) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBlob(String, InputStream) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBlob(String, InputStream, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBlob(int, Blob) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBlob(String, Blob) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBlob(int, InputStream) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBlob(String, InputStream) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBlob(int, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBlob(String, InputStream, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBoolean(int, boolean) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBoolean(String, boolean) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBoolean(int, boolean) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBoolean(String, boolean) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateByte(int, byte) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateByte(String, byte) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateByte(int, byte) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateByte(String, byte) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBytes(int, byte[]) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBytes(String, byte[]) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateBytes(int, byte[]) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateBytes(String, byte[]) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateCharacterStream(int, Reader, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateCharacterStream(String, Reader, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateCharacterStream(int, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCharacterStream(String, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCharacterStream(int, Reader, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCharacterStream(String, Reader, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCharacterStream(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCharacterStream(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateClob(int, Clob) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateClob(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateClob(String, Clob) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateClob(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateClob(int, Clob) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateClob(String, Clob) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateClob(int, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateClob(String, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateClob(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateClob(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateCount - Variable in class org.h2.jdbc.JdbcStatement
-
- updateDate(int, Date) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateDate(String, Date) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateDate(int, Date) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateDate(String, Date) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateDouble(int, double) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateDouble(String, double) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateDouble(int, double) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateDouble(String, double) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateFloat(int, float) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateFloat(String, float) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateFloat(int, float) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateFloat(String, float) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateInt(int, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateInt(String, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateInt(int, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateInt(String, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateLong(int, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateLong(String, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateLong(int, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateLong(String, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateMeta(SessionLocal, DbObject) - Method in class org.h2.engine.Database
-
Update an object in the system table.
- updateNCharacterStream(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNCharacterStream(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNCharacterStream(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNCharacterStream(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNCharacterStream(int, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNCharacterStream(String, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNCharacterStream(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNCharacterStream(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNClob(int, NClob) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNClob(int, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNClob(int, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNClob(String, Reader) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNClob(String, Reader, long) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNClob(String, NClob) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNClob(int, NClob) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNClob(String, NClob) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNClob(int, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNClob(String, Reader) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNClob(int, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNClob(String, Reader, long) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNString(int, String) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNString(String, String) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNString(int, String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNString(String, String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNull(int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNull(String) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateNull(int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateNull(String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateObject(int, Object, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(String, Object, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(int, Object) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(String, Object) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(int, Object, SQLType) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(int, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(String, Object, SQLType) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(String, Object, SQLType, int) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateObject(int, Object) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateObject(String, Object) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateObject(int, Object, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateObject(String, Object, int) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateRef(int, Ref) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported]
- updateRef(String, Ref) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported]
- updateRef(int, Ref) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateRef(String, Ref) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateRow() - Method in class org.h2.jdbc.JdbcResultSet
-
Updates the current row.
- updateRow() - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateRowId(int, RowId) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Updates a column in the current or insert row.
- updateRowId(String, RowId) - Method in class org.h2.jdbc.JdbcResultSet
-
[Not supported] Updates a column in the current or insert row.
- updateRowId(int, RowId) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateRowId(String, RowId) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updatesAreDetected(int) - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Returns whether updates are detected.
- updateSequenceOnManualIdentityInsertion - Variable in class org.h2.engine.Mode
-
If true
, sequences of generated by default identity columns are
updated when value is provided by user.
- updateShort(int, short) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateShort(String, short) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateShort(int, short) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateShort(String, short) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateSQLXML(int, SQLXML) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateSQLXML(String, SQLXML) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateSQLXML(int, SQLXML) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateSQLXML(String, SQLXML) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateString(int, String) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateString(String, String) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateString(int, String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateString(String, String) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateTime(int, Time) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateTime(String, Time) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateTime(int, Time) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateTime(String, Time) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateTimestamp(int, Timestamp) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateTimestamp(String, Timestamp) - Method in class org.h2.jdbc.JdbcResultSet
-
Updates a column in the current or insert row.
- updateTimestamp(int, Timestamp) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- updateTimestamp(String, Timestamp) - Method in class org.h2.tools.SimpleResultSet
-
INTERNAL
- Upgrade - Class in org.h2.tools
-
Upgrade utility.
- upgrade(String, Properties, int) - Static method in class org.h2.tools.Upgrade
-
Performs database upgrade from an older version of H2.
- URL_FORMAT - Static variable in class org.h2.engine.Constants
-
The database URL format in simplified Backus-Naur form.
- URL_FORMAT_ERROR_2 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90046
is thrown when
trying to open a connection to a database using an unsupported URL
format.
- URL_MAP - Static variable in class org.h2.engine.SysProperties
-
System property h2.urlMap
(default: null).
- URL_RELATIVE_TO_CWD - Static variable in class org.h2.api.ErrorCode
-
The error with code 90011
is thrown when
trying to open a connection to a database using an implicit relative
path, such as "jdbc:h2:test" (in which case the database file would be
stored in the current working directory of the application).
- USE_THREAD_CONTEXT_CLASS_LOADER - Static variable in class org.h2.engine.SysProperties
-
System property h2.useThreadContextClassLoader
(default: false).
- USER - Static variable in class org.h2.engine.DbObject
-
This object is a user.
- User - Class in org.h2.engine
-
Represents a user object.
- User(Database, int, String, boolean) - Constructor for class org.h2.engine.User
-
- USER_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90033
is thrown when
trying to create a user or role if a user with this name already exists.
- USER_DATA_TYPE_ALREADY_EXISTS_1 - Static variable in class org.h2.api.ErrorCode
-
Deprecated.
- USER_DATA_TYPE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
Deprecated.
- USER_HOME - Static variable in class org.h2.engine.SysProperties
-
System property user.home
(empty string if not set).
- USER_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90032
is thrown when
trying to drop or alter a user that does not exist.
- USER_OR_ROLE_NOT_FOUND_1 - Static variable in class org.h2.api.ErrorCode
-
The error with code 90071
is thrown when
trying to grant or revoke if no role or user with that name exists.
- USER_PACKAGE - Static variable in class org.h2.engine.Constants
-
The package name of user defined classes.
- UserBuilder - Class in org.h2.engine
-
- UserBuilder() - Constructor for class org.h2.engine.UserBuilder
-
- UserToRolesMapper - Interface in org.h2.api
-
A class that implement this interface can be used during authentication to
map external users to database roles.
- usesLocalFilePerTable() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if this database use one file per table.
- usesLocalFiles() - Method in class org.h2.jdbc.JdbcDatabaseMetaData
-
Checks if this database store data in local files.
- UUID - Static variable in class org.h2.api.H2Type
-
The UUID data type.