All Classes and Interfaces
Class
Description
Utility to detect AB-BA deadlocks.
Utility to detect AB-BA deadlocks.
A base class for aggregate functions.
An implementation of the AES block cipher algorithm,
also known as Rijndael.
A user-defined aggregate function needs to implement this interface.
Implements the integrated aggregate functions, such as COUNT, MAX, SUM.
Abstract class for the computation of an aggregate.
Data stored while calculating an AVG aggregate.
Aggregate data of binary set functions.
Data stored while calculating an aggregate that needs collecting of all
values or a distinct aggregate.
NULL values collection mode.
Data stored while calculating a CORR, REG_SLOPE, REG_INTERCEPT, or REGR_R2
aggregate.
Data stored while calculating a COUNT aggregate.
Data stored while calculating a COVAR_POP, COVAR_SAMP, or REGR_SXY aggregate.
Data stored while calculating an aggregate.
Data stored while calculating an aggregate that needs distinct values with
their counts.
Data stored while calculating an aggregate.
Data stored while calculating a STDDEV_POP, STDDEV_SAMP, VAR_SAMP, VAR_POP,
REGR_SXX, or REGR_SYY aggregate.
A user-defined aggregate function needs to implement this interface.
The type of an aggregate function.
A column alias as in SELECT 'Hello' AS NAME ...
This information is expensive to compute for large queries, so do so
on-demand.
The base class for ALTER DOMAIN commands.
This class represents the statement ALTER DOMAIN ADD CONSTRAINT
This class represents the statement ALTER DOMAIN DROP CONSTRAINT
This class represents the statements
ALTER DOMAIN SET DEFAULT
ALTER DOMAIN DROP DEFAULT
ALTER DOMAIN SET ON UPDATE
ALTER DOMAIN DROP ON UPDATE
This class represents the statement
ALTER DOMAIN RENAME
This class represents the statement
ALTER DOMAIN RENAME CONSTRAINT
This class represents the statement
ALTER INDEX RENAME
This class represents the statement
ALTER SCHEMA RENAME
This class represents the statement ALTER SEQUENCE.
The base class for ALTER TABLE commands.
This class represents the statement
ALTER TABLE ADD CONSTRAINT
This class represents the statements
ALTER TABLE ADD,
ALTER TABLE ADD IF NOT EXISTS,
ALTER TABLE ALTER COLUMN,
ALTER TABLE ALTER COLUMN SELECTIVITY,
ALTER TABLE ALTER COLUMN SET DEFAULT,
ALTER TABLE ALTER COLUMN DROP DEFAULT,
ALTER TABLE ALTER COLUMN DROP EXPRESSION,
ALTER TABLE ALTER COLUMN SET NULL,
ALTER TABLE ALTER COLUMN DROP NULL,
ALTER TABLE ALTER COLUMN SET VISIBLE,
ALTER TABLE ALTER COLUMN SET INVISIBLE,
ALTER TABLE DROP COLUMN
This class represents the statement
ALTER TABLE DROP CONSTRAINT
This class represents the statement
ALTER TABLE RENAME
This class represents the statement
ALTER TABLE ALTER COLUMN RENAME
This class represents the statement
ALTER TABLE RENAME CONSTRAINT
This class represents the statement
ALTER TABLE SET
This class represents the statements
ALTER USER ADMIN,
ALTER USER RENAME,
ALTER USER SET PASSWORD
This class represents the statement
ALTER VIEW
This class represents the statements
ANALYZE and ANALYZE TABLE
Array value constructor by query.
Array element reference.
An array function.
A table value function.
Assign to user a role based on realm name
*
Exception thrown when an issue occurs during the authentication configuration
Exception thrown in case of errors during authentication
Input data for authenticators; it wraps ConnectionInfo
Low level interface to implement full authentication process.
Authenticator factory
Creates a backup of a database.
This class represents the statement
BACKUP
The base class for data type implementations.
BETWEEN predicate.
A mathematical expression, or string concatenation.
A bitwise function.
Manipulations with bytes and arrays.
A block cipher is a data encryption algorithm that operates on blocks.
This class can read a file that is similar to BNF (Backus-Naur form).
The visitor interface for BNF rules.
Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).
Maintains the list of built-in functions.
Class ByteArrayDataType.
The stack of byte values.
The cache keeps frequently used objects in the main memory.
The head element of the linked list.
A scan resistant cache that uses keys of type long.
The cache configuration.
A cache entry.
A cache segment
A cache implementation based on the last recently used (LRU) algorithm.
The base object for all cached objects.
Cache which wraps another cache (proxy pattern) and adds caching using map.
An alternative cache implementation.
The cache writer is called by the cache to persist changed data that needs to
be removed from the cache.
This class represents the statement
CALL.
Cardinality expression.
A concurrent hash map with case-insensitive string keys.
A hash map with a case-insensitive string key.
Provides information for type casts and comparison operations.
A cast specification.
Allows changing the database file encryption password or algorithm.
The charset collator sorts strings according to the order in the given charset.
A chunk of data, containing one or multiple pages.
A factory to create new block cipher objects.
A phantom reference to watch for unclosed objects.
A COALESCE, GREATEST, or LEAST function.
This class represents a column in a table.
A column resolver is list of column (for example, a table) that can map a
column name to an actual column.
Column or domain.
Represents a SQL statement.
Represents a single SQL statements.
Collector of generated keys.
Represents a SQL statement.
Represents a list of SQL statements.
Represents the client-side part of a SQL statement.
Command that supports VALUES clause.
Represents a database object comment.
Class CommitDecisionMaker makes a decision during post-commit processing
about how to transform uncommitted map entry into committed one,
based on undo log information.
Pattern matching comparison expression: WHERE NAME LIKE ?
The type of comparison.
Instances of this class can compare strings.
The default implementation of CompareMode.
An implementation of CompareMode that uses the ICU4J Collator.
Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.
A compatibility mathematical operation with datetime values.
NEXTVAL() and CURRVAL() compatibility functions.
This is a wrapper class for the Deflater class.
A COMPRESS or EXPAND function.
This class implements the LZF lossless data compression algorithm.
This class implements a data compression algorithm that does in fact not
compress.
Each data compression algorithm must implement this interface.
A tool to losslessly compress data, and expand the compressed data again.
Character string concatenation as in
'Hello' || 'World', binary
string concatenation as in X'01' || X'AB' or an array concatenation
as in ARRAY[1, 2] || 3.A CONCAT or CONCAT_WS function.
Represents a condition returning a boolean value, or NULL.
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.
An 'in' condition with a list of values, as in WHERE NAME IN(...)
Used for optimised IN(...) queries where the contents of the IN list are all
constant and of the same type.
A condition with parameter as
= ANY(?).An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)
A global condition or combination of local and global conditions.
A NOT condition.
wrapper for configuration properties
describe how to perform objects runtime configuration
Encapsulates the connection settings, including user name and password.
The connection info object is a wrapper for database connection information
such as the database URL, user name and password.
Starts the H2 Console (web-) server, as well as the TCP and PG server.
A user-defined constant as created by the SQL statement
CREATE CONSTANT
Constants are fixed values that are used in the whole database code.
The base class for constraint checking.
A check constraint.
A domain constraint.
A referential constraint.
A unique constraint.
Converts a .trace.db file to a SQL script and Java source code.
This class holds statistics about a SQL statement.
An input stream that reads the data from a reader and limits the number of
bytes that can be read.
This class represents the statement
CREATE AGGREGATE
Creates a cluster from a stand-alone database.
This class represents the statement
CREATE CONSTANT
This class represents the statement
CREATE DOMAIN
This class represents the statement
CREATE ALIAS
This class represents the statement
CREATE INDEX
This class represents the statement
CREATE LINKED TABLE
This class represents the statement
CREATE ROLE
This class represents the statement
CREATE SCHEMA
This class represents the statement CREATE SEQUENCE.
This class represents the statement
CREATE SYNONYM
The data required to create a synonym.
This class represents the statement
CREATE TABLE
The data required to create a table.
This class represents the statement
CREATE TRIGGER
This class represents the statement
CREATE USER
This class represents the statement
CREATE VIEW
A class that implement this interface can be used to validate credentials
provided by client.
An ENCRYPT or DECRYPT function.
A facility to read from and write to CSV (comma separated values) files.
A CSVREAD function.
A CSVWRITE function.
Current datetime value function.
Simple general value specifications.
A cursor is a helper object to iterate through an index.
A cursor to iterate over elements in ascending or descending order.
A position in a cursor.
This class represents a byte buffer that contains persistent data of a page.
A base class for data analysis operations such as aggregates and window
functions.
There is one database object per open database.
A class that implements this interface can get notified about exceptions
and other events.
The MBean implementation.
Information and management operations for the given database.
Database meta information.
Legacy implementation of database meta information.
Local implementation of database meta information.
Base implementation of database meta information.
Remote implementation of database meta information.
Server side support of database meta information.
A data change delta table.
Result option.
Data change statement.
A data handler contains a number of callback methods, mostly related to CLOB
and BLOB handling.
This class is backed by an input stream and supports reading values and
variable size data.
Constructing such an EOF exception is fast, because the stack trace is
not filled in.
A data type.
This class contains meta data information about data types,
and can convert between Java objects and Values.
DATA_TYPE_SQL() function.
Utility methods
A date-time format function.
A date-time function.
This utility class contains time conversion functions.
A DAYNAME() or MONTHNAME() function.
Keeps the meta data information of a column.
Keeps meta data information about a database.
A BNF terminal rule that is linked to the database context information.
The driver activator loads the H2 driver when starting the bundle.
This exception wraps a checked exception.
A database object such as a table, an index, or a user.
DB_OBJECT_ID() and DB_OBJECT_SQL() functions.
Contains meta data information about a procedure.
Contains meta data information about a database schema.
This class contains various database-level settings.
This class can be used to start the H2 TCP server (or other H2 servers, for
example the PG server) inside a web application container such as Tomcat or
Jetty.
Contains meta data information about a table or a view.
This class represents the statement
DEALLOCATE
Similar to ThreadLocal, except that it allows its data to be read from other
threads - useful for debugging info.
Default authenticator implementation.
Default ordering of NULL values.
The default implementation of a row in a table.
Class BasicSpatialImpl.
This class represents a non-transaction statement, for example a CREATE or
DROP.
This class is responsible to close a database after the specified delay.
This class represents the statement
DELETE
Deletes all files belonging to a database.
An MBean that reads the documentation from a resource file.
Represents a domain.
The single column resolver resolves the VALUE column.
An expression representing a value for domain constraint.
The database driver.
This class represents the statement
DROP AGGREGATE
This class represents the statement
DROP CONSTANT
This class represents the statement
DROP ALL OBJECTS
This class represents the statement DROP DOMAIN
This class represents the statement
DROP ALIAS
This class represents the statement
DROP INDEX
This class represents the statement
DROP ROLE
This class represents the statement
DROP SCHEMA
This class represents the statement
DROP SEQUENCE
This class represents the statement
DROP SYNONYM
This class represents the statement
DROP TABLE
This class represents the statement
DROP TRIGGER
This class represents the statement
DROP USER
This class represents the statement
DROP VIEW
The cursor implementation for the DUAL index.
An index for the DUAL table.
The DUAL table for selects without a FROM clause.
The engine contains a map of all open databases.
This class defines the error codes used for SQL exceptions.
EWKB format support for GEOMETRY data type.
Helper source object for EWKB reading.
Converter output target that writes a EWKB.
EWKT format support for GEOMETRY data type.
Helper source object for EWKT reading.
Converter output target that writes a EWKT.
This class represents the statement
EXECUTE IMMEDIATE.
This class represents the statement
EXECUTE
Exists predicate as in EXISTS(SELECT ...)
This class represents the statement
EXPLAIN
An expression is a operation, a value, or a function in a query.
A column reference expression that represents a column of a table or view.
A list of expressions, as in (ID, NAME).
The visitor pattern is used to iterate through all expressions of a query
to optimize a statement.
Expression with flags.
An expression with variable number of parameters.
Extended parameters of a data type.
Extended parameters of the ENUM data type.
Extended parameters of the GEOMETRY data type.
Extended parameters of the NUMERIC data type.
Extended parameters of the ROW data type.
Fake file channel to use by in-memory and ZIP file systems.
Abstract fetched result.
Field reference.
File which uses NIO2 AsynchronousFileChannel.
The base class for file implementations.
Default implementation of the slow operations that need synchronization because they
involve the file position.
Allows to read from a file channel like an input stream.
An encrypted file with a read cache.
A FILE_READ or FILE_WRITE function.
Utility class to list the files of a database.
The file lock is used to lock a database so that only one process can write
to it.
This class represents an in-memory file.
This class contains the data of an in-memory random access file.
This small cache compresses the data if an element leaves the cache.
Points to a block of bytes that needs to be compressed.
Uses memory mapped files.
This class represents an in-memory file.
This class contains the data of an in-memory random access file.
Represents a compressed item.
This small cache compresses the data if an element leaves the cache.
A path to a file.
This file system stores files on disk and uses
java.nio.channels.AsynchronousFileChannel to access the files.
A file with a read cache.
A file with a read cache.
This file system stores files on disk.
An encrypted file.
This file system keeps files fully in memory.
A memory file system that compresses blocks to conserve memory.
This file system stores files on disk and uses java.nio to access the files.
This file system keeps files fully in off-java-heap memory.
A memory file system that compresses blocks to conserve memory.
A file system that records all write operations and can re-play them.
A file system that re-opens and re-tries the operation if the file was
closed, because a thread was interrupted.
A file system that may split files into multiple smaller files.
The base class for wrapping / delegating file systems such as
the split file system.
This is a read-only file system that allows
to access databases stored in a .zip or .jar file.
A file object that records all write operations and can re-play them.
A file object that re-opens and re-tries the operation if the file was
closed.
A wrapped file lock.
A file that may be split into multiple smaller files.
The default storage mechanism of the MVStore.
This class is an abstraction of a random access file.
An input stream that is backed by a file store.
An output stream that is backed by a file store.
This utility class contains utility functions that use the file system
abstraction.
The file is read from a stream.
Data change statement with WHERE criteria and possibly limited number of
rows.
A pseudo-encryption algorithm that makes the data appear to be
encrypted.
A format clause such as FORMAT JSON.
Supported formats.
A free space bit set.
This class implements the native full text search.
Trigger updates the index when a inserting, updating, or deleting a row.
This class implements the full text search based on Apache Lucene.
Trigger updates the index when a inserting, updating, or deleting a row.
A wrapper for the Lucene writer and searcher.
The global settings of a full text search.
Function with one optional argument.
Function with one argument.
Function with two arguments.
Function with two arguments.
Represents a user-defined function, or alias.
There may be multiple Java methods that match a function name.
This class contains information about a built-in function.
Function with many arguments.
Functions for
Mode.ModeEnum.DB2 and
Mode.ModeEnum.Derby compatibility modes.This class implements some legacy functions not available in Regular mode.
Functions for
Mode.ModeEnum.MSSQLServer compatibility
mode.This class implements some MySQL-specific functions.
Functions for
Mode.ModeEnum.Oracle compatibility mode.Functions for
Mode.ModeEnum.PostgreSQL compatibility
mode.A table backed by a system or user-defined function that returns a result
set.
Column resolver for generated columns.
Modes of generated keys' gathering.
GeoJson format support for GEOMETRY data type.
Converter output target that writes a GeoJson.
Utilities for GEOMETRY data type.
Converter output target that determines minimal dimension system for a
geometry.
Converter output target that calculates an envelope.
Converter output target.
This class represents the statements
GRANT RIGHT,
GRANT ROLE,
REVOKE RIGHT,
REVOKE ROLE
Console for environments with AWT support.
Describe configuration of H2 DefaultAuthenticator.
Parser of external authentication XML configuration file
Data types of H2.
Interface for objects with configuration properties.
A HASH or ORA_HASH function.
An object that has an SQL representation.
This class represents the statement CALL.
An index.
This represents a column item of an index.
A index condition object is made for each condition that can potentially use
an index.
The filter used to walk through an index.
Contains the hints for which index to use for a specific table.
The settings of one full text search index.
Represents information about the properties of an index
Represents an in-doubt transaction (a transaction in the prepare phase).
Information schema.
This class is responsible to build the INFORMATION_SCHEMA tables.
Data type information.
This class is responsible to build the legacy variant of INFORMATION_SCHEMA
tables.
This class represents the statement
INSERT
An array with integer element.
INTERVAL representation for result sets.
A mathematical operation with intervals.
Interval qualifier.
This utility class contains interval conversion functions.
This utility class contains input/output functions.
IS JSON predicate.
Level of isolation.
Validate credentials by using standard Java Authentication and Authorization Service
This class can be used to start the H2 TCP server (or other H2 servers, for
example the PG server) inside a Jakarta web application container such as
Tomcat or Jetty.
This servlet lets the H2 Console be used in a Jakarta servlet container
such as Tomcat or Jetty.
This class wraps a user-defined aggregate.
This class wraps a user-defined function.
Custom serialization mechanism for java objects being stored in column of
type OTHER.
This class wraps a user-defined function.
Represents an ARRAY value.
Represents a batch update database exception.
Represents a BLOB value.
Represents a callable statement.
Represents a CLOB value.
Represents a connection (session) to a database.
Allows us to compile on older platforms, while still implementing the methods
from the newer JDBC API.
A simple standalone JDBC connection pool.
Allows us to compile on older platforms, while still implementing the methods
from the newer JDBC API.
Represents the meta data for a database.
Allows us to compile on older platforms, while still implementing the methods
from the newer JDBC API.
A data source for H2 database connections.
Allows us to compile on older platforms, while still implementing the methods
from the newer JDBC API.
This class is used to create new DataSource objects.
Allows us to compile on older platforms, while still implementing the methods
from the newer JDBC API.
This interface contains additional methods for database exceptions.
Represents a large object value.
State of the object.
Information about the parameters of a prepared statement.
Represents a prepared statement.
Represents a result set.
Represents the meta data for a ResultSet.
A savepoint is a point inside a transaction to where a transaction can be
rolled back.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a database exception.
Represents a SQLXML value.
Represents a statement.
Allows us to compile on older platforms, while still implementing the methods
from the newer JDBC API.
This is a utility class with JDBC helper functions.
This class provides support for distributed transactions.
An object of this class represents a transaction id.
JSON array.
JSON boolean.
JSON byte array target.
JSON byte array source.
JSON constructor function.
Utilities for JSON constructors.
JSON item type.
JSON null.
JSON number.
JSON object.
JSON string.
JSON string source.
JSON String target.
Abstract JSON output target.
JSON text source.
JSON validation target.
JSON validation target without unique keys.
JSON validation target with unique keys.
JSON value.
JSON value target.
This utility class provides access to JSR 310 classes.
Utilities for Geometry data type from JTS library.
Converter output target that creates a JTS Geometry.
Lazy execution support for queries.
Validate credentials by performing an LDAP bind
CHAR_LENGTH(), or OCTET_LENGTH() function.
The cursor implementation for the linked index.
A linked index is a index for a linked (remote) table.
A LINK_SCHEMA function.
Additional arguments of LISTAGG aggregate function.
LOB data.
LOB data stored in database.
A implementation of the LOB data used on the client side of a remote H2
connection.
LOB data stored in a temporary file.
LOB data stored in memory.
This factory creates in-memory objects and temporary files.
A mechanism to store and retrieve lob data.
This class stores LOB objects in the database, in maps.
An input stream used by the client side of a tcp connection to fetch LOB data
on demand from the server.
A local result set contains all row data of a result set.
Counter.
Class LongDataType.
An input stream to read from an LZF stream.
An output stream to write an LZF stream.
A math function.
A math function with one argument and DOUBLE PRECISION result.
A math function with two arguments and DOUBLE PRECISION result.
This is a utility class with mathematical helper functions.
Class MemoryEstimator.
Unsafe memory unmapper.
This class represents the statement
MERGE
or the MySQL compatibility statement
REPLACE
Merged result.
This class represents the statement syntax
MERGE INTO table alias USING...
An index for a meta data table.
The index implementation for meta data tables.
A record in the system table of the database.
Meta data schema.
This class is responsible to build the database meta data pseudo tables.
Class DBMetaType is a type for values in the type registry map.
The compatibility modes.
When CHAR values are right-padded with spaces.
Generation of column names for expressions.
Determines how rows with
NULL values in indexed columns are handled
in unique indexes.Generation of column names for expressions to be used in a view.
Base class for mode-specific functions.
A tool to help an application execute multi-dimensional range queries.
An index that delegates indexing to another index.
An index that stores the data in an MVStore.
An in-doubt transaction.
A stored map.
A builder for this class.
A builder for this class.
The decision on what to do on an update.
Class DecisionMaker provides callback interface (and should become a such in Java 8)
for MVMap.operate method.
A builder for maps.
Plain temporary result.
A table stored in a MVStore.
A cursor.
An r-tree implementation.
A builder for this class.
A cursor to iterate over a subset of the keys.
An index stored in a MVStore.
A cursor.
Sorted temporary result.
This is an index based on a MVRTreeMap.
A cursor.
A persistent storage for maps.
A background writer thread to automatically store changes from time to
time.
A builder for an MVStore.
Class TxCounter is a simple data structure to hold version of the store
along with the counter of open transactions,
which are still operating on this version.
Various kinds of MVStore problems, along with associated error code.
Utility methods used in combination with the MVStore.
A data type that can read any data that is persisted, and converts it to
a byte array.
A table stored in a MVStore.
The type of trace lock events
Temporary result.
A function-like expression with a name.
This utility class contains socket helper functions.
Network connection information.
Represents an empty statement or a statement that has no effect.
A NULLIF function.
Null predicate (IS [NOT] NULL).
Dummy data type used when no value is required.
A data type implementation for the most common data types, including
serializable objects.
The base class for auto-detect data types.
The type for BigDecimal objects.
The type for BigInteger objects.
The type for boolean true and false.
The type for byte objects.
The type for character objects.
The type for java.util.Date objects.
The type for double objects.
The type for float objects.
The type for integer objects.
The type for long objects.
The type for the null value
The type for object arrays.
The type for serialized objects.
The type for short objects.
The type for string objects.
The type for UUID objects.
A storage mechanism that "persists" data in the off-heap area of the main
memory.
VALUES(column) function for ON DUPLICATE KEY UPDATE clause.
This class is responsible to close a database on JVM shutdown.
Operation without subexpressions.
Operation with one argument.
Operation with one or two arguments.
Operation with two arguments.
Operation with many arguments.
The optimizer is responsible to find the best execution plan
for a given query.
This class implements the OSGi DataSourceFactory interface for the H2 JDBC
driver.
A page (a node or a leaf).
A pointer to a page, either in-memory or using a page position.
A page parser can parse an HTML page and replace the tags there.
A parameter of a prepared statement.
The interface for client side (remote) and server side parameters.
A client side (remote) parameter.
The parser is used to convert a SQL statement string to an command object.
Enumeration describing null constraints
Partition data of a window aggregate.
PERCENTILE_CONT, PERCENTILE_DISC, and MEDIAN inverse distribution functions.
A class to iterate over all permutations of an array.
pg_catalog schema.This class is responsible to build the pg_catalog tables.
This class implements a subset of the PostgreSQL protocol as described here:
https://www.postgresql.org/docs/devel/protocol.html
The PostgreSQL catalog is described here:
https://www.postgresql.org/docs/7.4/catalogs.html
One server thread is opened for each client.
Represents a PostgreSQL Portal object.
Represents a PostgreSQL Prepared object.
A possible query execution plan.
The plan item describes the index to be used, and the estimated cost when
using it.
Base class for predicates with a subquery.
A prepared statement.
This class represents the statement
PREPARE
Represents a procedure.
A simple CPU profiling tool similar to java -Xrunhprof.
Configuration property
Represents a SELECT statement (simple, or union).
Evaluated values of OFFSET and FETCH clauses.
Describes one element of the ORDER BY clause of a query.
Maintains query statistics.
The collected statistics for one query.
A RAND, SECURE_RAND, or RANDOM_UUID function.
The cursor implementation for the range index.
An index for the SYSTEM_RANGE table.
Input stream that reads only a specified range from the source stream.
Reader that reads only a specified range from the source reader.
The table SYSTEM_RANGE is a virtual table that generates incrementing numbers
with a given start end point.
Configuration for authentication realm.
Class Record is a value for undoLog.
A data type for undo log values
A recorder for the recording file system.
Helps recovering a corrupted database.
A tool that simulates a crash while writing to the database, and then
verifies the database doesn't get corrupt.
A ::regclass expression.
A regular expression function.
Restores a H2 database by extracting the database files from a .zip file.
A result set column of a remote result.
This interface is used to extend the LocalResult class, if data does not fit
in memory.
The result interface is used by the LocalResult and ResultRemote class.
The client side part of a result set that is kept on the server.
A object where rows are written to.
Result of update command with optional generated keys.
Result of update command with generated keys;
Result with padded fixed length strings.
An access right.
A right owner (sometimes called principal).
Represents a role.
Class RollbackDecisionMaker process undo log record during transaction rollback.
Class RootReference is an immutable structure to represent state of the MVMap as a whole
(not related to a particular B-Tree node).
Represents a row in a table.
The data type for rows.
Creates rows.
Default implementation of row factory.
Represents the ROWNUM function.
Represents a BNF rule.
A single terminal rule in a BNF object.
Represents a non-standard syntax.
Represents a hard coded terminal rule in a BNF object.
Represents the head of a BNF rule.
Represents a sequence of BNF rules, or a list of alternative rules.
Represents an optional BNF rule.
Represents a loop in a BNF object.
Runs a SQL script against a database.
This class represents the statement
RUNSCRIPT
A schema as created by the SQL statement
CREATE SCHEMA
This class represents a non-transaction statement that involves a schema.
Any database object that is stored in a schema.
This class represents a non-transaction statement that involves a schema and
requires schema owner rights.
Creates a SQL script file by extracting the schema and data of a database.
This class is the base for RunScriptCommand and ScriptCommand.
This class represents the statement
SCRIPT
This class can split SQL scripts to single SQL statements.
A searched case.
The base class for rows stored in a table, and for partial rows stored in the
index.
A file store that encrypts all data before writing, and decrypts all data
after reading.
This class represents a simple SELECT statement.
Grouped data for aggregates.
This class represents a column resolver for the column list of a SELECT
statement.
Represents a union SELECT statement.
A query context object.
A sequence is created using the statement
CREATE SEQUENCE
CYCLE clause and sequence state.
Sequence options.
Wraps a sequence when used in a statement.
Starts the H2 Console (web-) server, TCP, and PG server.
Classes implementing this interface usually provide a
TCP/IP listener such as an FTP server.
A local or remote session.
Dynamic settings.
Static settings.
An ABORT_SESSION() or CANCEL_SESSION() function.
A session represents an embedded database connection.
Represents a savepoint (a position in a transaction to where one can roll
back to).
An LOB object with a timeout.
The client side part of a session when using the server mode.
This class represents the statement
SET
Set clause list.
This class represents the statement
COMMENT
A SET function.
This class represents the statement SET SESSION CHARACTERISTICS
A persistent database setting.
The base class for settings.
The list of setting for a SET statement.
This class implements the cryptographic hash function SHA-256.
SHA-3 message digest family.
Interactive command line tool to access a database using JDBC.
A shutdown handler is a listener for shutdown events.
A SIGNAL function.
A simple case.
Metadata of a column.
Base class for simple predicates.
Simple in-memory result.
Column info for the simple result.
This class is a simple result set and meta data implementation.
A simple array implementation,
backed by an object array
This interface is for classes that create rows on demand.
A simple row that contains data for only one column.
A cursor with at most one row.
This class implements a small LRU object cache.
A simple hash table with an optimization for the last recently used object.
Snapshot of the map root and committing transactions.
Map which stores items using SoftReference.
A soft reference that has a hard reference to the key.
Sorted properties file.
A sort order represents an ORDER BY clause in a query.
A SOUNDEX or DIFFERENCE function.
This class allows to convert source code to a class.
An in-memory class file manager.
Access the Groovy compiler using reflection, so that we do not gain a
compile-time dependency unnecessarily.
An in-memory java class object.
An in-memory java source file object.
Class Sparse.
Interface Spatial represents boxes in 2+ dimensional space,
where total ordering is not that straight-forward.
A spatial data type.
A spatial index.
A unique spatial key.
A data type that allows to save its state.
A factory for data types.
Assign static roles to authenticated users
This credentials validator matches the user and password with the configured
Usage should be limited to test purposes
A store with open tables.
A facility to store streams in a map.
A stream backed by a map.
A string type.
An string function with multiple arguments.
A string function with one argument.
A string function with two arguments.
A few String utility functions.
A query returning a single value.
A SUBSTRING function.
Database or session information function.
The constants defined in this class are initialized from system properties.
This is the base class for most tables.
The base class of a regular table, or a user defined table.
A class that implements this interface can create custom table
implementations.
A table filter represents a table that is used in a query.
A visitor that maps columns.
A visitor for table filters.
A table value function.
A table information function.
A linked table contains connection information for a table accessible by
JDBC.
A connection for a linked table.
Synonym for an existing table or view.
The table types.
Table value constructor.
A table for table value constructor.
A view is a virtual table that is defined by a query.
The key of the index cache for views.
A method call that is executed in a separate thread.
The TCP server implements the native H2 database server protocol.
One server thread is opened per client connection.
An input stream with a position.
This class deletes temporary files when they are not used any longer.
Detects deadlocks between threads.
A time zone specification (AT { TIME ZONE | LOCAL }).
Provides access to time zone API.
Time zone provider with offset.
Time zone provider with time zone.
Emulates Oracle's TO_CHAR function.
Represents a capitalization / casing strategy.
Emulates Oracle's TO_DATE function.
This class holds and handles the input data form the TO_DATE-method
This class holds and handles the input data form the TO_DATE-method
The configuration of the date parser.
Emulates Oracle's TO_DATE function.
Parslet responsible for parsing day parameter
The format tokens.
Parslet responsible for parsing year parameter
Parslet responsible for parsing month parameter
Parslet responsible for parsing time parameter
Interface of the classes that can parse a specialized small bit of the
TO_DATE format-string.
Parslet responsible for parsing year parameter
Token.
Tokenizer.
Command line tools implement the tool interface so that they can be used in
the H2 Console.
This class represents a trace module.
The base class for objects that can print trace information about themselves.
The trace mechanism is the logging facility of this database.
The backend of the trace system must implement this interface.
This adapter sends log output to SLF4J.
A transaction.
Represents a transactional statement.
A map that supports transactions.
The iterator for read committed isolation level.
The iterator for repeatable read and serializable isolation levels.
The iterator for read uncommitted isolation level.
A store that supports concurrent MVCC read-committed transactions.
A change in a map.
This listener can be registered with the transaction to be notified of
every compensating change during transaction rollback.
The transfer class is used to send and receive Value objects.
A class that implements this interface can be used as a trigger.
An adapter for the trigger interface that allows to use the ResultSet
interface instead of a row array.
A trigger is created using the statement
CREATE TRIGGER
A TRIM function.
This class represents the statement
TRUNCATE TABLE
A TRUNCATE_VALUE function.
Class TxDecisionMaker is a base implementation of MVMap.DecisionMaker
to be used for TransactionMap modification.
An object with data type.
An expression representing a constant value with a type cast.
Data type with parameters.
Type predicate (IS [NOT] OF).
Unary operation.
Unique predicate as in UNIQUE(SELECT ...)
This class is used for updatable result sets.
This class represents the statement
UPDATE
Upgrade utility.
Represents a user object.
Represents a user-defined aggregate function.
Wrap
AggregateFunction in order to behave as
AggregateUser-defined Java function or aggregate function.
A class that implement this interface can be used during authentication to
map external users to database roles.
Configuration for class that maps users to their roles.
This utility class contains miscellaneous functions.
The utility methods will try to use the provided class factories to
convert binary name of class to Class object.
Utilities with specialized implementations for Java 10 and later versions.
This is the base class for all value classes.
Implementation of the ARRAY data type.
Base class for BigDecimal-based values.
Implementation of the BIGINT data type.
Implementation of the BINARY data type.
Implementation of the BINARY LARGE OBJECT data type.
Implementation of the BOOLEAN data type.
Base implementation of byte array based data types.
Implementation of the CHARACTER data type.
Implementation of the CHARACTER LARGE OBJECT data type.
Base class for ARRAY and ROW values.
A row type.
Implementation of the DATE data type.
Implementation of the DECFLOAT data type.
Implementation of the DOUBLE PRECISION data type.
ENUM value.
Base implementation of the ENUM data type.
An expression representing a constant value.
Implementation of the GEOMETRY data type.
Implementation of the INTEGER data type.
Implementation of the INTERVAL data type.
Implementation of the JAVA_OBJECT data type.
Implementation of the JSON data type.
A implementation of the BINARY LARGE OBJECT and CHARACTER LARGE OBJECT data
types.
Implementation of NULL.
Implementation of the NUMERIC data type.
Implementation of the REAL data type.
Row value.
Implementation of the SMALLINT data type.
Base implementation of String based data types.
Implementation of the TIME data type.
Implementation of the TIMESTAMP data type.
Implementation of the TIMESTAMP WITH TIME ZONE data type.
Implementation of the TIME WITH TIME ZONE data type.
Implementation of the TINYINT data type.
Data type conversion methods between values and Java objects.
Data type conversion methods between values and Java objects to use on the
server side on H2 only.
Implementation of the UUID data type.
Implementation of the BINARY VARYING data type.
Implementation of the CHARACTER VARYING data type.
Implementation of the VARCHAR_IGNORECASE data type.
A user-defined variable, for example: @ID.
Class VersionedBitSet extends standard BitSet to add a version field.
A versioned value (possibly null).
Class CommittedVersionedValue.
The value type for a versioned value.
Class VersionedValueUncommitted.
The cursor implementation of a view index.
This object represents a virtual index for a query.
A base class for virtual tables that construct all their content at once.
An index for a virtual table that returns a result set.
A base class for virtual tables.
A cursor for a virtual table.
An base class for indexes of virtual tables.
For each connection to a session, an object of this class is created.
This class represents index information for the GUI.
The web server is a simple standalone HTTP server that implements the H2
Console application.
This servlet lets the H2 Console be used in a standard servlet container
such as Tomcat or Jetty.
The web session keeps all data of a user session.
For each connection to a session, an object of this class is created.
A wildcard expression as in SELECT * FROM TEST.
Window clause.
Window frame clause.
Window frame bound.
Window frame bound type.
Window frame exclusion clause.
Window frame units.
A window function.
A type of a window function.
An auto-resize buffer to write data into a ByteBuffer.
An XML function.
An implementation of the XTEA block cipher algorithm.
An XTS implementation as described in
IEEE P1619 (Standard Architecture for Encrypted Shared Storage Media).