Property Name | Value
--- | ---
usesLocalFiles | true
usesLocalFilePerTable | false
supportsUnionAll | true
supportsUnion | true
supportsTransactions | true
supportsTableCorrelationNames | true
supportsSubqueriesInQuantifieds | true
supportsSubqueriesInIns | true
supportsSubqueriesInExists | true
supportsSubqueriesInComparisons | true
supportsStoredProcedures | false
supportsStatementPooling | false
supportsSelectForUpdate | true
supportsSchemasInTableDefinitions | true
supportsSchemasInProcedureCalls | true
supportsSchemasInPrivilegeDefinitions | true
supportsSchemasInIndexDefinitions | true
supportsSchemasInDataManipulation | true
supportsSavepoints | true
supportsPositionedUpdate | true
supportsPositionedDelete | true
supportsOuterJoins | true
supportsOrderByUnrelated | true
supportsOpenStatementsAcrossRollback | true
supportsOpenStatementsAcrossCommit | true
supportsOpenCursorsAcrossRollback | false
supportsOpenCursorsAcrossCommit | false
supportsNonNullableColumns | true
supportsNamedParameters | false
supportsMultipleTransactions | true
supportsMultipleResultSets | false
supportsMultipleOpenResults | true
supportsMixedCaseQuotedIdentifiers | true
supportsMixedCaseIdentifiers | false
supportsMinimumSQLGrammar | true
supportsLimitedOuterJoins | true
supportsLikeEscapeClause | true
supportsIntegrityEnhancementFacility | true
supportsGroupByUnrelated | true
supportsGroupByBeyondSelect | true
supportsGroupBy | true
supportsGetGeneratedKeys | true
supportsFullOuterJoins | false
supportsExtendedSQLGrammar | false
supportsExpressionsInOrderBy | true
supportsDifferentTableCorrelationNames | false
supportsDataManipulationTransactionsOnly | true
supportsDataDefinitionAndDataManipulationTransactions | false
supportsCorrelatedSubqueries | true
supportsCoreSQLGrammar | true
supportsConvert | true
supportsColumnAliasing | true
supportsCatalogsInTableDefinitions | false
supportsCatalogsInProcedureCalls | false
supportsCatalogsInPrivilegeDefinitions | false
supportsCatalogsInIndexDefinitions | false
supportsCatalogsInDataManipulation | false
supportsBatchUpdates | true
supportsANSI92IntermediateSQL | false
supportsANSI92FullSQL | false
supportsANSI92EntryLevelSQL | true
supportsAlterTableWithDropColumn | true
supportsAlterTableWithAddColumn | true
storesUpperCaseQuotedIdentifiers | false
storesUpperCaseIdentifiers | true
storesMixedCaseQuotedIdentifiers | true
storesMixedCaseIdentifiers | false
storesLowerCaseQuotedIdentifiers | false
storesLowerCaseIdentifiers | false
nullsAreSortedLow | true
nullsAreSortedHigh | false
nullsAreSortedAtStart | false
nullsAreSortedAtEnd | false
nullPlusNonNullIsNull | true
locatorsUpdateCopy | false
isReadOnly | false
isCatalogAtStart | true
getUserName | DBCOPY
getURL | jdbc:h2:tcp://localhost:9094/dbcopysrc
getSQLStateType | 2
getSearchStringEscape | \
getSchemaTerm | schema
getResultSetHoldability | 2
getProcedureTerm | procedure
getMaxUserNameLength | 0
getMaxTablesInSelect | 0
getMaxTableNameLength | 0
getMaxStatements | 0
getMaxStatementLength | 0
getMaxSchemaNameLength | 0
getMaxRowSize | 0
getMaxProcedureNameLength | 0
getMaxIndexLength | 0
getMaxCursorNameLength | 0
getMaxConnections | 0
getMaxColumnsInTable | 0
getMaxColumnsInSelect | 0
getMaxColumnsInOrderBy | 0
getMaxColumnsInIndex | 0
getMaxColumnsInGroupBy | 0
getMaxColumnNameLength | 0
getMaxCharLiteralLength | 0
getMaxCatalogNameLength | 0
getMaxBinaryLiteralLength | 0
getJDBCMinorVersion | 0
getJDBCMajorVersion | 3
getIdentifierQuoteString | "
getExtraNameCharacters |
getDriverVersion | 0.9 (2006-04-08 / Alpha)
getDriverName | H2 JDBC Driver
getDriverMinorVersion | 9
getDriverMajorVersion | 0
getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED
getDatabaseProductVersion | 0.9 (2006-04-08 / Alpha)
getDatabaseProductName | H2
getDatabaseMinorVersion | 9
getDatabaseMajorVersion | 0
getCatalogTerm | catalog
getCatalogSeparator | .
doesMaxRowSizeIncludeBlobs | false
dataDefinitionIgnoredInTransactions | false
dataDefinitionCausesTransactionCommit | true
allTablesAreSelectable | true
allProceduresAreCallable | true