Database

Database

Schemas

Catalog Name
TESTH2 INFORMATION_SCHEMA
TESTH2 PUBLIC

Validator

Database has been checked upon validators, check results.

Information

Properties

Name Value
getCatalogSeparator .
getCatalogTerm catalog
getDatabaseMajorVersion 1
getDatabaseMinorVersion 1
getDatabaseProductName H2
getDatabaseProductVersion 1.1.111 (2009-04-10)
getDefaultTransactionIsolation 2
getDriverMajorVersion 1
getDriverMinorVersion 1
getDriverName H2 JDBC Driver
getDriverVersion 1.1.111 (2009-04-10)
getExtraNameCharacters
getIdentifierQuoteString "
getJDBCMajorVersion 3
getJDBCMinorVersion 0
getMaxBinaryLiteralLength 0
getMaxCatalogNameLength 0
getMaxCharLiteralLength 0
getMaxColumnNameLength 0
getMaxColumnsInGroupBy 0
getMaxColumnsInIndex 0
getMaxColumnsInOrderBy 0
getMaxColumnsInSelect 0
getMaxColumnsInTable 0
getMaxConnections 0
getMaxCursorNameLength 0
getMaxIndexLength 0
getMaxProcedureNameLength 0
getMaxRowSize 0
getMaxSchemaNameLength 0
getMaxStatementLength 0
getMaxStatements 0
getMaxTableNameLength 0
getMaxTablesInSelect 0
getMaxUserNameLength 0
getNumericFunctions ABS, ACOS, ASIN, ATAN, COS, COT, SIN, TAN, ATAN2, BITAND, BITOR, BITXOR, MOD, CEILING, DEGREES, EXP, FLOOR, LOG, LOG10, RADIANS, SQRT, PI, POWER, RAND, RANDOM_UUID, ROUND, ROUNDMAGIC, SECURE_RAND, SIGN, ENCRYPT, DECRYPT, HASH, TRUNCATE, COMPRESS, EXPAND, ZERO
getProcedureTerm procedure
getResultSetHoldability 2
getSchemaTerm schema
getSearchStringEscape \
getSQLKeywords LIMIT, MINUS, ROWNUM, SYSDATE, SYSTIME, SYSTIMESTAMP, TODAY
getSQLStateType 2
getStringFunctions ASCII, BIT_LENGTH, LENGTH, OCTET_LENGTH, CHAR, CONCAT, DIFFERENCE, HEXTORAW, RAWTOHEX, INSTR, INSERT, LOWER, UPPER, LEFT, RIGHT, LOCATE, POSITION, LPAD, RPAD, LTRIM, RTRIM, TRIM, REGEXP_REPLACE, REPEAT, REPLACE, SOUNDEX, SPACE, STRINGDECODE, STRINGENCODE, STRINGTOUTF8, SUBSTRING, UTF8TOSTRING, XMLATTR, XMLNODE, XMLCOMMENT, XMLCDATA, XMLSTARTDOC, XMLTEXT
getSystemFunctions ARRAY_GET, ARRAY_LENGTH, AUTOCOMMIT, CANCEL_SESSION, CASEWHEN, CAST, COALESCE, CONVERT, CURRVAL, CSVREAD, CSVWRITE, DATABASE, DATABASE_PATH, FILE_READ, GREATEST, IDENTITY, IFNULL, LEAST, LOCK_MODE, LOCK_TIMEOUT, LINK_SCHEMA, MEMORY_FREE, MEMORY_USED, NEXTVAL, NULLIF, READONLY, ROWNUM, SCHEMA, SESSION_ID, SET, TABLE, TRANSACTION_ID, USER
getTimeDateFunctions CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DATEADD, DATEDIFF, DAYNAME, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_YEAR, EXTRACT, FORMATDATETIME, HOUR, MINUTE, MONTH, MONTHNAME, PARSEDATETIME, QUARTER, SECOND, WEEK, YEAR
getURL jdbc:h2:../TestH2
getUserName SA
isCatalogAtStart true
isReadOnly false

Features

Name Value
allProceduresAreCallable true
allTablesAreSelectable true
autoCommitFailureClosesAllResultSets false
dataDefinitionCausesTransactionCommit true
dataDefinitionIgnoredInTransactions false
doesMaxRowSizeIncludeBlobs false
locatorsUpdateCopy false
nullPlusNonNullIsNull true
nullsAreSortedAtEnd false
nullsAreSortedAtStart false
nullsAreSortedHigh false
nullsAreSortedLow true
storesLowerCaseIdentifiers false
storesLowerCaseQuotedIdentifiers false
storesMixedCaseIdentifiers false
storesMixedCaseQuotedIdentifiers true
storesUpperCaseIdentifiers true
storesUpperCaseQuotedIdentifiers false
supportsAlterTableWithAddColumn true
supportsAlterTableWithDropColumn true
supportsANSI92EntryLevelSQL true
supportsANSI92FullSQL false
supportsANSI92IntermediateSQL false
supportsBatchUpdates true
supportsCatalogsInDataManipulation true
supportsCatalogsInIndexDefinitions true
supportsCatalogsInPrivilegeDefinitions true
supportsCatalogsInProcedureCalls false
supportsCatalogsInTableDefinitions true
supportsColumnAliasing true
supportsConvert true
supportsCoreSQLGrammar true
supportsCorrelatedSubqueries true
supportsDataDefinitionAndDataManipulationTransactions false
supportsDataManipulationTransactionsOnly true
supportsDifferentTableCorrelationNames false
supportsExpressionsInOrderBy true
supportsExtendedSQLGrammar false
supportsFullOuterJoins false
supportsGetGeneratedKeys true
supportsGroupBy true
supportsGroupByBeyondSelect true
supportsGroupByUnrelated true
supportsIntegrityEnhancementFacility true
supportsLikeEscapeClause true
supportsLimitedOuterJoins true
supportsMinimumSQLGrammar true
supportsMixedCaseIdentifiers false
supportsMixedCaseQuotedIdentifiers true
supportsMultipleOpenResults true
supportsMultipleResultSets false
supportsMultipleTransactions true
supportsNamedParameters false
supportsNonNullableColumns true
supportsOpenCursorsAcrossCommit false
supportsOpenCursorsAcrossRollback false
supportsOpenStatementsAcrossCommit true
supportsOpenStatementsAcrossRollback true
supportsOrderByUnrelated true
supportsOuterJoins true
supportsPositionedDelete true
supportsPositionedUpdate true
supportsSavepoints true
supportsSchemasInDataManipulation true
supportsSchemasInIndexDefinitions true
supportsSchemasInPrivilegeDefinitions true
supportsSchemasInProcedureCalls true
supportsSchemasInTableDefinitions true
supportsSelectForUpdate true
supportsStatementPooling false
supportsStoredFunctionsUsingCallSyntax true
supportsStoredProcedures false
supportsSubqueriesInComparisons true
supportsSubqueriesInExists true
supportsSubqueriesInIns true
supportsSubqueriesInQuantifieds true
supportsTableCorrelationNames true
supportsTransactions true
supportsUnion true
supportsUnionAll true
usesLocalFilePerTable false
usesLocalFiles true

Other

Name Value
tableTypes SYSTEM TABLE, TABLE, TABLE LINK, VIEW