Property NameValue
usesLocalFilestrue
usesLocalFilePerTablefalse
supportsUnionAlltrue
supportsUniontrue
supportsTransactionstrue
supportsTableCorrelationNamestrue
supportsSubqueriesInQuantifiedstrue
supportsSubqueriesInInstrue
supportsSubqueriesInExiststrue
supportsSubqueriesInComparisonstrue
supportsStoredProceduresfalse
supportsStatementPoolingfalse
supportsSelectForUpdatetrue
supportsSchemasInTableDefinitionstrue
supportsSchemasInProcedureCallstrue
supportsSchemasInPrivilegeDefinitionstrue
supportsSchemasInIndexDefinitionstrue
supportsSchemasInDataManipulationtrue
supportsSavepointstrue
supportsPositionedUpdatetrue
supportsPositionedDeletetrue
supportsOuterJoinstrue
supportsOrderByUnrelatedtrue
supportsOpenStatementsAcrossRollbacktrue
supportsOpenStatementsAcrossCommittrue
supportsOpenCursorsAcrossRollbackfalse
supportsOpenCursorsAcrossCommitfalse
supportsNonNullableColumnstrue
supportsNamedParametersfalse
supportsMultipleTransactionstrue
supportsMultipleResultSetsfalse
supportsMultipleOpenResultstrue
supportsMixedCaseQuotedIdentifierstrue
supportsMixedCaseIdentifiersfalse
supportsMinimumSQLGrammartrue
supportsLimitedOuterJoinstrue
supportsLikeEscapeClausetrue
supportsIntegrityEnhancementFacilitytrue
supportsGroupByUnrelatedtrue
supportsGroupByBeyondSelecttrue
supportsGroupBytrue
supportsGetGeneratedKeystrue
supportsFullOuterJoinsfalse
supportsExtendedSQLGrammarfalse
supportsExpressionsInOrderBytrue
supportsDifferentTableCorrelationNamesfalse
supportsDataManipulationTransactionsOnlytrue
supportsDataDefinitionAndDataManipulationTransactionsfalse
supportsCorrelatedSubqueriestrue
supportsCoreSQLGrammartrue
supportsConverttrue
supportsColumnAliasingtrue
supportsCatalogsInTableDefinitionsfalse
supportsCatalogsInProcedureCallsfalse
supportsCatalogsInPrivilegeDefinitionsfalse
supportsCatalogsInIndexDefinitionsfalse
supportsCatalogsInDataManipulationfalse
supportsBatchUpdatestrue
supportsANSI92IntermediateSQLfalse
supportsANSI92FullSQLfalse
supportsANSI92EntryLevelSQLtrue
supportsAlterTableWithDropColumntrue
supportsAlterTableWithAddColumntrue
storesUpperCaseQuotedIdentifiersfalse
storesUpperCaseIdentifierstrue
storesMixedCaseQuotedIdentifierstrue
storesMixedCaseIdentifiersfalse
storesLowerCaseQuotedIdentifiersfalse
storesLowerCaseIdentifiersfalse
nullsAreSortedLowtrue
nullsAreSortedHighfalse
nullsAreSortedAtStartfalse
nullsAreSortedAtEndfalse
nullPlusNonNullIsNulltrue
locatorsUpdateCopyfalse
isReadOnlyfalse
isCatalogAtStarttrue
getUserNameDBCOPY
getURLjdbc:h2:tcp://localhost:9094/dbcopysrc
getSQLStateType2
getSearchStringEscape\
getSchemaTermschema
getResultSetHoldability2
getProcedureTermprocedure
getMaxUserNameLength0
getMaxTablesInSelect0
getMaxTableNameLength0
getMaxStatements0
getMaxStatementLength0
getMaxSchemaNameLength0
getMaxRowSize0
getMaxProcedureNameLength0
getMaxIndexLength0
getMaxCursorNameLength0
getMaxConnections0
getMaxColumnsInTable0
getMaxColumnsInSelect0
getMaxColumnsInOrderBy0
getMaxColumnsInIndex0
getMaxColumnsInGroupBy0
getMaxColumnNameLength0
getMaxCharLiteralLength0
getMaxCatalogNameLength0
getMaxBinaryLiteralLength0
getJDBCMinorVersion0
getJDBCMajorVersion3
getIdentifierQuoteString"
getExtraNameCharacters 
getDriverVersion0.9 (2006-04-08 / Alpha)
getDriverNameH2 JDBC Driver
getDriverMinorVersion9
getDriverMajorVersion0
getDefaultTransactionIsolationTRANSACTION_READ_COMMITTED
getDatabaseProductVersion0.9 (2006-04-08 / Alpha)
getDatabaseProductNameH2
getDatabaseMinorVersion9
getDatabaseMajorVersion0
getCatalogTermcatalog
getCatalogSeparator.
doesMaxRowSizeIncludeBlobsfalse
dataDefinitionIgnoredInTransactionsfalse
dataDefinitionCausesTransactionCommittrue
allTablesAreSelectabletrue
allProceduresAreCallabletrue