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 |