Constant Field Values

Contents

• org.h2.*

org.h2.*

org.h2.api.DatabaseEventListener

Modifier and Type	Constant Field	Value
public static final int	STATE_BACKUP_FILE	3
public static final int	STATE_CREATE_INDEX	1
public static final int	STATE_RECONNECTED	4
public static final int	STATE_RECOVER	2
public static final int	STATE_SCAN_FILE	0
public static final int	STATE_STATEMENT_END	6
public static final int	STATE_STATEMENT_PROGRESS	7
public static final int	STATE_STATEMENT_START	5

org.h2.api.ErrorCode

Modifier and Type	Constant Field	Value
public static final int	ACCESS_DENIED_TO_CLASS_1	90134
public static final int	ADMIN_RIGHTS_REQUIRED	90040
public static final int	AGGREGATE_NOT_FOUND_1	90132
public static final int	AMBIGUOUS_COLUMN_NAME_1	90059
public static final int	ARRAY_ELEMENT_ERROR_2	22034
public static final int	AUTHENTICATOR_NOT_AVAILABLE	90144
public static final int	CAN_ONLY_ASSIGN_TO_VARIABLE_1	90137
public static final int	CANNOT_CHANGE_SETTING_WHEN_OPEN_1	90133
public static final int	CANNOT_DROP_2	90107
public static final int	CANNOT_DROP_CURRENT_USER	90019
public static final int	CANNOT_DROP_LAST_COLUMN	90084
public static final int	CANNOT_DROP_TABLE_1	90118
public static final int	CANNOT_MIX_INDEXED_AND_UNINDEXED_PARAMS	90123
public static final int	CANNOT_TRUNCATE_1	90106
public static final int	CHECK_CONSTRAINT_INVALID	23514
public static final int	CHECK_CONSTRAINT_VIOLATED_1	23513
public static final int	CLASS_NOT_FOUND_1	90086
public static final int	CLUSTER_ERROR_DATABASE_RUNS_ALONE	90093
public static final int	CLUSTER_ERROR_DATABASE_RUNS_CLUSTERED_1	90094
public static final int	COLLATION_CHANGE_WITH_DATA_TABLE_1	90089
public static final int	COLUMN_ALIAS_IS_NOT_SPECIFIED_1	90156
public static final int	COLUMN_CONTAINS_NULL_VALUES_1	90081
public static final int	COLUMN_COUNT_DOES_NOT_MATCH	21002
public static final int	COLUMN_IS_PART_OF_INDEX_1	90075
public static final int	COLUMN_IS_REFERENCED_1	90083
public static final int	COLUMN_MUST_NOT_BE_NULLABLE_1	90023
public static final int	COLUMN_NOT_FOUND_1	42122
public static final int	COMMIT_ROLLBACK_NOT_ALLOWED	90058
public static final int	COMPRESSION_ERROR	90104
public static final int	CONCURRENT_UPDATE_1	90131
public static final int	CONNECTION_BROKEN_1	90067
public static final int	CONSTANT_ALREADY_EXISTS_1	90114
public static final int	CONSTANT_NOT_FOUND_1	90115
public static final int	CONSTRAINT_ALREADY_EXISTS_1	90045
public static final int	CONSTRAINT_IS_USED_BY_CONSTRAINT_2	90152
public static final int	CONSTRAINT_NOT_FOUND_1	90057
public static final int	CURRENT_SEQUENCE_VALUE_IS_NOT_DEFINED_IN_SESSION_1	90148
public static final int	DATA_CONVERSION_ERROR_1	22018
public static final int	DATABASE_ALREADY_OPEN_1	90020
public static final int	DATABASE_CALLED_AT_SHUTDOWN	90121
public static final int	DATABASE_IS_CLOSED	90098
public static final int	DATABASE_IS_IN_EXCLUSIVE_MODE	90135
public static final int	DATABASE_IS_NOT_PERSISTENT	90126
public static final int	DATABASE_IS_READ_ONLY	90097
public static final int	DATABASE_NOT_FOUND_1	90013
public static final int	DATABASE_NOT_FOUND_WITH_IF_EXISTS_1	90146
public static final int	DEADLOCK_1	40001
public static final int	DESERIALIZATION_FAILED_1	90027
public static final int	DIVISION_BY_ZERO_1	22012
public static final int	DOMAIN_ALREADY_EXISTS_1	90119
public static final int	DOMAIN_NOT_FOUND_1	90120
public static final int	DRIVER_VERSION_ERROR_2	90047
public static final int	DUPLICATE_COLUMN_NAME_1	42121
public static final int	DUPLICATE_KEY_1	23505
public static final int	DUPLICATE_PROPERTY_1	90066
public static final int	ENUM_DUPLICATE	22033
public static final int	ENUM_EMPTY	22032
public static final int	ENUM_VALUE_NOT_PERMITTED	22030
public static final int	ERROR_ACCESSING_LINKED_TABLE_2	90111
public static final int	ERROR_CREATING_TRIGGER_OBJECT_3	90043
public static final int	ERROR_EXECUTING_TRIGGER_3	90044
public static final int	ERROR_OPENING_DATABASE_1	8000
public static final int	ERROR_SETTING_DATABASE_EVENT_LISTENER_2	90099
public static final int	EXCEPTION_IN_FUNCTION_1	90105
public static final int	EXCEPTION_OPENING_PORT_2	90061
public static final int	FEATURE_NOT_SUPPORTED_1	50100
public static final int	FILE_CORRUPTED_1	90030
public static final int	FILE_CREATION_FAILED_1	90062
public static final int	FILE_DELETE_FAILED_1	90025
public static final int	FILE_ENCRYPTION_ERROR_1	90049
public static final int	FILE_NOT_FOUND_1	90124
public static final int	FILE_RENAME_FAILED_2	90024
public static final int	FILE_VERSION_ERROR_1	90048
public static final int	FOR_UPDATE_IS_NOT_ALLOWED_IN_DISTINCT_OR_GROUPED_SELECT	90145
public static final int	FUNCTION_ALIAS_ALREADY_EXISTS_1	90076
public static final int	FUNCTION_ALIAS_NOT_FOUND_1	90077
public static final int	FUNCTION_MUST_RETURN_RESULT_SET_1	90000
public static final int	FUNCTION_NOT_FOUND_1	90022
public static final int	GENERAL_ERROR_1	50000
public static final int	GENERATED_COLUMN_CANNOT_BE_ASSIGNED_1	90154
public static final int	GENERATED_COLUMN_CANNOT_BE_UPDATABLE_BY_CONSTRAINT_2	90155
public static final int	GROUP_BY_NOT_IN_THE_RESULT	90157
public static final int	HEX_STRING_ODD_1	90003
public static final int	HEX_STRING_WRONG_1	90004
public static final int	IDENTICAL_EXPRESSIONS_SHOULD_BE_USED	42131
public static final int	INDEX_ALREADY_EXISTS_1	42111
public static final int	INDEX_BELONGS_TO_CONSTRAINT_2	90085
public static final int	INDEX_NOT_FOUND_1	42112
public static final int	INVALID_CLASS_2	90125
public static final int	INVALID_DATABASE_NAME_1	90138
public static final int	INVALID_DATETIME_CONSTANT_2	22007
public static final int	INVALID_NAME_1	42602
public static final int	INVALID_PARAMETER_COUNT_2	7001
public static final int	INVALID_PRECEDING_OR_FOLLOWING_1	22013
public static final int	INVALID_TO_CHAR_FORMAT	90010
public static final int	INVALID_TO_DATE_FORMAT	90056
public static final int	INVALID_TRIGGER_FLAGS_1	90005
public static final int	INVALID_USE_OF_AGGREGATE_FUNCTION_1	90054
public static final int	INVALID_VALUE_2	90008
public static final int	INVALID_VALUE_PRECISION	90150
public static final int	INVALID_VALUE_SCALE	90151
public static final int	IO_EXCEPTION_1	90028
public static final int	IO_EXCEPTION_2	90031
public static final int	JAVA_OBJECT_SERIALIZER_CHANGE_WITH_DATA_TABLE	90141
public static final int	LIKE_ESCAPE_ERROR_1	22025
public static final int	LITERALS_ARE_NOT_ALLOWED	90116
public static final int	LOB_CLOSED_ON_TIMEOUT_1	90039
public static final int	LOCK_TIMEOUT_1	50200
public static final int	METHOD_DISABLED_ON_AUTOCOMMIT_TRUE	90147
public static final int	METHOD_NOT_ALLOWED_FOR_PREPARED_STATEMENT	90130
public static final int	METHOD_NOT_ALLOWED_FOR_QUERY	90001
public static final int	METHOD_NOT_FOUND_1	90087
public static final int	METHOD_ONLY_ALLOWED_FOR_QUERY	90002
public static final int	METHODS_MUST_HAVE_DIFFERENT_PARAMETER_COUNTS_2	90073
public static final int	MUST_GROUP_BY_COLUMN_1	90016
public static final int	NAME_TOO_LONG_2	42622
public static final int	NO_DATA_AVAILABLE	2000
public static final int	NO_DEFAULT_SET_1	23507
public static final int	NOT_ENOUGH_RIGHTS_FOR_1	90096
public static final int	NOT_ON_UPDATABLE_ROW	90029
public static final int	NULL_NOT_ALLOWED	23502
public static final int	NULL_VALUE_IN_ARRAY_TARGET	22035
public static final int	NUMERIC_VALUE_OUT_OF_RANGE_1	22003
public static final int	NUMERIC_VALUE_OUT_OF_RANGE_2	22004
public static final int	OBJECT_CLOSED	90007
public static final int	ORDER_BY_NOT_IN_RESULT	90068
public static final int	OUT_OF_MEMORY	90108
public static final int	PARAMETER_NOT_SET_1	90012
public static final int	PARSE_ERROR_1	90014
public static final int	PUBLIC_STATIC_JAVA_METHOD_NOT_FOUND_1	90139
public static final int	REFERENTIAL_INTEGRITY_VIOLATED_CHILD_EXISTS_1	23503
public static final int	REFERENTIAL_INTEGRITY_VIOLATED_PARENT_MISSING_1	23506
public static final int	REMOTE_CONNECTION_NOT_ALLOWED	90117
public static final int	REMOTE_DATABASE_NOT_FOUND_1	90149
public static final int	RESULT_SET_NOT_SCROLLABLE	90128
public static final int	RESULT_SET_NOT_UPDATABLE	90127
public static final int	RESULT_SET_READONLY	90140
public static final int	ROLE_ALREADY_EXISTS_1	90069
public static final int	ROLE_ALREADY_GRANTED_1	90074
public static final int	ROLE_CAN_NOT_BE_DROPPED_1	90091
public static final int	ROLE_NOT_FOUND_1	90070
public static final int	ROLES_AND_RIGHT_CANNOT_BE_MIXED	90072
public static final int	ROW_NOT_FOUND_IN_PRIMARY_INDEX	90143
public static final int	ROW_NOT_FOUND_WHEN_DELETING_1	90112
public static final int	SAVEPOINT_IS_INVALID_1	90063
public static final int	SAVEPOINT_IS_NAMED	90065
public static final int	SAVEPOINT_IS_UNNAMED	90064
public static final int	SCALAR_SUBQUERY_CONTAINS_MORE_THAN_ONE_ROW	90053
public static final int	SCHEMA_ALREADY_EXISTS_1	90078
public static final int	SCHEMA_CAN_NOT_BE_DROPPED_1	90090
public static final int	SCHEMA_NAME_MUST_MATCH	90080
public static final int	SCHEMA_NOT_FOUND_1	90079
public static final int	SECOND_PRIMARY_KEY	90017
public static final int	SEQUENCE_ALREADY_EXISTS_1	90035
public static final int	SEQUENCE_ATTRIBUTES_INVALID_7	90009
public static final int	SEQUENCE_BELONGS_TO_A_TABLE_1	90082
public static final int	SEQUENCE_EXHAUSTED	90006
public static final int	SEQUENCE_NOT_FOUND_1	90036
public static final int	SERIALIZATION_FAILED_1	90026
public static final int	STATEMENT_WAS_CANCELED	57014
public static final int	STEP_SIZE_MUST_NOT_BE_ZERO	90142
public static final int	STRING_FORMAT_ERROR_1	90095
public static final int	SUBQUERY_IS_NOT_SINGLE_COLUMN	90052
public static final int	SUM_OR_AVG_ON_WRONG_DATATYPE_1	90015
public static final int	SYNTAX_ERROR_1	42000
public static final int	SYNTAX_ERROR_2	42001
public static final int	TABLE_OR_VIEW_ALREADY_EXISTS_1	42101
public static final int	TABLE_OR_VIEW_NOT_FOUND_1	42102
public static final int	TABLE_OR_VIEW_NOT_FOUND_DATABASE_EMPTY_1	42104
public static final int	TABLE_OR_VIEW_NOT_FOUND_WITH_CANDIDATES_2	42103
public static final int	TOO_MANY_COLUMNS_1	54011
public static final int	TRACE_CONNECTION_NOT_CLOSED	90018
public static final int	TRACE_FILE_ERROR_2	90034
public static final int	TRANSACTION_NOT_FOUND_1	90129
public static final int	TRIGGER_ALREADY_EXISTS_1	90041
public static final int	TRIGGER_NOT_FOUND_1	90042
public static final int	TYPES_ARE_NOT_COMPARABLE_2	90110
public static final int	UNCOMPARABLE_REFERENCED_COLUMN_2	90153
public static final int	UNKNOWN_DATA_TYPE_1	50004
public static final int	UNKNOWN_MODE_1	90088
public static final int	UNSUPPORTED_CIPHER	90055
public static final int	UNSUPPORTED_COMPRESSION_ALGORITHM_1	90103
public static final int	UNSUPPORTED_COMPRESSION_OPTIONS_1	90102
public static final int	UNSUPPORTED_LOCK_METHOD_1	90060
public static final int	UNSUPPORTED_SETTING_1	90113
public static final int	UNSUPPORTED_SETTING_COMBINATION	90021
public static final int	URL_FORMAT_ERROR_2	90046
public static final int	URL_RELATIVE_TO_CWD	90011
public static final int	USER_ALREADY_EXISTS_1	90033
public static final int	USER_DATA_TYPE_ALREADY_EXISTS_1	90119
public static final int	USER_DATA_TYPE_NOT_FOUND_1	90120
public static final int	USER_NOT_FOUND_1	90032
public static final int	USER_OR_ROLE_NOT_FOUND_1	90071
public static final int	VALUE_TOO_LONG_2	22001
public static final int	VIEW_ALREADY_EXISTS_1	90038
public static final int	VIEW_IS_INVALID_2	90109
public static final int	VIEW_NOT_FOUND_1	90037
public static final int	WINDOW_NOT_FOUND_1	90136
public static final int	WITH_TIES_WITHOUT_ORDER_BY	90122
public static final int	WRONG_OBJECT_TYPE	42809
public static final int	WRONG_PASSWORD_FORMAT	90050
public static final int	WRONG_USER_OR_PASSWORD	28000
public static final int	WRONG_XID_FORMAT_1	90101

org.h2.api.Trigger

Modifier and Type	Constant Field	Value
public static final int	DELETE	4
public static final int	INSERT	1
public static final int	SELECT	8
public static final int	UPDATE	2

org.h2.engine.Constants

Modifier and Type	Constant Field	Value
public static final int	ALLOW_LITERALS_ALL	2
public static final int	ALLOW_LITERALS_NONE	0
public static final int	ALLOW_LITERALS_NUMBERS	1
public static final boolean	BLOB_SEARCH	false
public static final String	BUILD_DATE	"2025-09-22"
public static final int	BUILD_ID	240
public static final boolean	BUILD_SNAPSHOT	false
public static final int	CACHE_MIN_RECORDS	16
public static final String	CACHE_TYPE_DEFAULT	"LRU"
public static final String	CLUSTERING_DISABLED	"\'\'"
public static final String	CLUSTERING_ENABLED	"TRUE"
public static final String	CONN_URL_COLUMNLIST	"jdbc:columnlist:connection"
public static final String	CONN_URL_INTERNAL	"jdbc:default:connection"
public static final int	COST_ROW_OFFSET	1000
public static final int	DEADLOCK_CHECK	100
public static final int	DEFAULT_HTTP_PORT	8082
public static final int	DEFAULT_LOCK_MODE	3
public static final int	DEFAULT_MAX_LENGTH_INPLACE_LOB	256
public static final int	DEFAULT_MAX_OPERATION_MEMORY	100000
public static final int	DEFAULT_PAGE_SIZE	16384
public static final int	DEFAULT_RESULT_SET_CONCURRENCY	1007
public static final int	DEFAULT_TCP_PORT	9092
public static final int	DEFAULT_WRITE_DELAY	500
public static final int	ENCRYPTION_KEY_HASH_ITERATIONS	1024
public static final int	FILE_BLOCK_SIZE	16
public static final int	INFORMATION_SCHEMA_ID	-1
public static final int	INITIAL_LOCK_TIMEOUT	2000
public static final int	IO_BUFFER_SIZE	4096
public static final int	IO_BUFFER_SIZE_COMPRESS	131072
public static final int	LOCK_MODE_OFF	0
public static final int	LOCK_MODE_READ_COMMITTED	3
public static final int	LOCK_MODE_TABLE	1
public static final int	LOCK_MODE_TABLE_GC	2
public static final int	LOCK_SLEEP	1000
public static final int	MAIN_SCHEMA_ID	0
public static final int	MAX_ARRAY_CARDINALITY	65536
public static final int	MAX_COLUMNS	16384
public static final int	MAX_IDENTIFIER_LENGTH	256
public static final int	MAX_NUMERIC_PRECISION	100000
public static final int	MAX_PARAMETER_INDEX	100000
public static final int	MAX_STRING_LENGTH	1000000000
public static final int	MEMORY_ARRAY	24
public static final int	MEMORY_OBJECT	24
public static final int	MEMORY_POINTER	8
public static final int	MEMORY_ROW	40
public static final int	MIN_WEB_ADMIN_PASSWORD_LENGTH	12
public static final int	PG_CATALOG_SCHEMA_ID	-1000
public static final String	PG_VERSION	"8.2.23"
public static final String	PREFIX_INDEX	"INDEX_"
public static final String	PREFIX_JOIN	"SYSTEM_JOIN_"
public static final String	PREFIX_PRIMARY_KEY	"PRIMARY_KEY_"
public static final String	PREFIX_QUERY_ALIAS	"QUERY_ALIAS_"
public static final String	PUBLIC_ROLE_NAME	"PUBLIC"
public static final int	QUERY_STATISTICS_MAX_ENTRIES	100
public static final int	SALT_LEN	8
public static final String	SCHEMA_MAIN	"PUBLIC"
public static final String	SCHEMA_PG_CATALOG	"PG_CATALOG"
public static final int	SELECTIVITY_DEFAULT	50
public static final int	SELECTIVITY_DISTINCT_COUNT	10000
public static final String	SERVER_PROPERTIES_DIR	"~"
public static final String	SERVER_PROPERTIES_NAME	".h2.server.properties"
public static final long	SLOW_QUERY_LIMIT_MS	100L
public static final String	START_URL	"jdbc:h2:"
public static final String	SUFFIX_LOCK_FILE	".lock.db"
public static final String	SUFFIX_MV_FILE	".mv.db"
public static final String	SUFFIX_MV_STORE_NEW_FILE	".newFile"
public static final String	SUFFIX_MV_STORE_TEMP_FILE	".tempFile"
public static final String	SUFFIX_OLD_DATABASE_FILE	".data.db"
public static final String	SUFFIX_TEMP_FILE	".temp.db"
public static final String	SUFFIX_TRACE_FILE	".trace.db"
public static final int	TCP_PROTOCOL_VERSION_17	17
public static final int	TCP_PROTOCOL_VERSION_18	18
public static final int	TCP_PROTOCOL_VERSION_19	19
public static final int	TCP_PROTOCOL_VERSION_20	20
public static final int	TCP_PROTOCOL_VERSION_21	21
public static final int	TCP_PROTOCOL_VERSION_MAX_SUPPORTED	21
public static final int	TCP_PROTOCOL_VERSION_MIN_SUPPORTED	17
public static final int	THROTTLE_DELAY	50
public static final int	TRANSACTION_SNAPSHOT	6
public static final String	URL_FORMAT	"jdbc:h2:{ {.|mem:}[name] | [file:]fileName | {tcp|ssl}:[//]server[:port][,server2[:port]]/name }[;key=value...]"
public static final String	USER_PACKAGE	"org.h2.dynamic"
public static final int	VERSION_MAJOR	2
public static final int	VERSION_MINOR	4
public static final int	VIEW_COST_CACHE_MAX_AGE	10000
public static final int	VIEW_INDEX_CACHE_SIZE	64

org.h2.engine.DbObject

Modifier and Type	Constant Field	Value
public static final int	AGGREGATE	14
public static final int	COMMENT	13
public static final int	CONSTANT	11
public static final int	CONSTRAINT	5
public static final int	DOMAIN	12
public static final int	FUNCTION_ALIAS	9
public static final int	INDEX	1
public static final int	RIGHT	8
public static final int	ROLE	7
public static final int	SCHEMA	10
public static final int	SEQUENCE	3
public static final int	SETTING	6
public static final int	SYNONYM	15
public static final int	TABLE_OR_VIEW	0
public static final int	TRIGGER	4
public static final int	USER	2

org.h2.engine.GeneratedKeysMode

Modifier and Type	Constant Field	Value
public static final int	AUTO	1
public static final int	COLUMN_NAMES	3
public static final int	COLUMN_NUMBERS	2
public static final int	NONE	0

org.h2.engine.Right

Modifier and Type	Constant Field	Value
public static final int	ALL	15
public static final int	ALTER_ANY_SCHEMA	16
public static final int	DELETE	2
public static final int	INSERT	4
public static final int	SCHEMA_OWNER	32
public static final int	SELECT	1
public static final int	UPDATE	8

org.h2.engine.SessionRemote

Modifier and Type	Constant Field	Value
public static final int	CHANGE_ID	9
public static final int	COMMAND_CLOSE	4
public static final int	COMMAND_COMMIT	8
public static final int	COMMAND_EXECUTE_BATCH_UPDATE	20
public static final int	COMMAND_EXECUTE_QUERY	2
public static final int	COMMAND_EXECUTE_UPDATE	3
public static final int	COMMAND_GET_META_DATA	10
public static final int	GET_JDBC_META	19
public static final int	LOB_READ	17
public static final int	RESULT_CLOSE	7
public static final int	RESULT_FETCH_ROWS	5
public static final int	RESULT_RESET	6
public static final int	SESSION_CANCEL_STATEMENT	13
public static final int	SESSION_CHECK_KEY	14
public static final int	SESSION_CLOSE	1
public static final int	SESSION_HAS_PENDING_TRANSACTION	16
public static final int	SESSION_PREPARE	0
public static final int	SESSION_PREPARE_READ_PARAMS2	18
public static final int	SESSION_SET_AUTOCOMMIT	15
public static final int	SESSION_SET_ID	12
public static final int	STATUS_CLOSED	2
public static final int	STATUS_ERROR	0
public static final int	STATUS_OK	1
public static final int	STATUS_OK_STATE_CHANGED	3

org.h2.engine.SysProperties

Modifier and Type	Constant Field	Value
public static final String	H2_BROWSER	"h2.browser"
public static final String	H2_SCRIPT_DIRECTORY	"h2.scriptDirectory"

org.h2.tools.CompressTool

Modifier and Type	Constant Field	Value
public static final String	BZIP2_INPUT_CLASS_NAME	"org.apache.commons.compress.compressors.bzip2.BZip2CompressorInputStream"
public static final String	BZIP2_OUTPUT_CLASS_NAME	"org.apache.commons.compress.compressors.bzip2.BZip2CompressorOutputStream"
public static final String	KANZI_INPUT_CLASS_NAME	"io.github.flanglet.kanzi.io.CompressedInputStream"
public static final String	KANZI_OUTPUT_CLASS_NAME	"io.github.flanglet.kanzi.io.CompressedOutputStream"