| Property Name | Value |
| allProceduresAreCallable | true |
| allTablesAreSelectable | true |
| dataDefinitionCausesTransactionCommit | true |
| dataDefinitionIgnoredInTransactions | false |
| doesMaxRowSizeIncludeBlobs | true |
| getCatalogSeparator | |
| getCatalogTerm | |
| getDatabaseMajorVersion | 1 |
| getDatabaseMinorVersion | 8 |
| getDatabaseProductName | HSQL Database Engine |
| getDatabaseProductVersion | 1.8.0 |
| getDefaultTransactionIsolation | TRANSACTION_READ_UNCOMMITTED |
| getDriverMajorVersion | 1 |
| getDriverMinorVersion | 8 |
| getDriverName | HSQL Database Engine Driver |
| getDriverVersion | 1.8.0 |
| 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 |
| getProcedureTerm | |
| getResultSetHoldability | 1 |
| getSchemaTerm | SCHEMA |
| getSearchStringEscape | \ |
| getSQLStateType | 2 |
| getURL | jdbc:hsqldb:file:/tools/hsqldb-1_8_0_2/data/dbcopysrc |
| getUserName | SA |
| isCatalogAtStart | false |
| isReadOnly | false |
| locatorsUpdateCopy | false |
| nullPlusNonNullIsNull | true |
| nullsAreSortedAtEnd | false |
| nullsAreSortedAtStart | false |
| nullsAreSortedHigh | false |
| nullsAreSortedLow | true |
| storesLowerCaseIdentifiers | false |
| storesLowerCaseQuotedIdentifiers | false |
| storesMixedCaseIdentifiers | false |
| storesMixedCaseQuotedIdentifiers | false |
| storesUpperCaseIdentifiers | true |
| storesUpperCaseQuotedIdentifiers | false |
| supportsAlterTableWithAddColumn | true |
| supportsAlterTableWithDropColumn | true |
| supportsANSI92EntryLevelSQL | false |
| supportsANSI92FullSQL | false |
| supportsANSI92IntermediateSQL | false |
| supportsBatchUpdates | true |
| supportsCatalogsInDataManipulation | false |
| supportsCatalogsInIndexDefinitions | false |
| supportsCatalogsInPrivilegeDefinitions | false |
| supportsCatalogsInProcedureCalls | false |
| supportsCatalogsInTableDefinitions | false |
| supportsColumnAliasing | true |
| supportsConvert | true |
| supportsCoreSQLGrammar | true |
| supportsCorrelatedSubqueries | true |
| supportsDataDefinitionAndDataManipulationTransactions | false |
| supportsDataManipulationTransactionsOnly | true |
| supportsDifferentTableCorrelationNames | true |
| supportsExpressionsInOrderBy | true |
| supportsExtendedSQLGrammar | false |
| supportsFullOuterJoins | false |
| supportsGetGeneratedKeys | false |
| supportsGroupBy | true |
| supportsGroupByBeyondSelect | true |
| supportsGroupByUnrelated | true |
| supportsIntegrityEnhancementFacility | true |
| supportsLikeEscapeClause | true |
| supportsLimitedOuterJoins | true |
| supportsMinimumSQLGrammar | false |
| supportsMixedCaseIdentifiers | false |
| supportsMixedCaseQuotedIdentifiers | true |
| supportsMultipleOpenResults | false |
| supportsMultipleResultSets | false |
| supportsMultipleTransactions | true |
| supportsNamedParameters | true |
| supportsNonNullableColumns | true |
| supportsOpenCursorsAcrossCommit | false |
| supportsOpenCursorsAcrossRollback | false |
| supportsOpenStatementsAcrossCommit | true |
| supportsOpenStatementsAcrossRollback | true |
| supportsOrderByUnrelated | true |
| supportsOuterJoins | true |
| supportsPositionedDelete | false |
| supportsPositionedUpdate | false |
| supportsSavepoints | true |
| supportsSchemasInDataManipulation | false |
| supportsSchemasInIndexDefinitions | true |
| supportsSchemasInPrivilegeDefinitions | true |
| supportsSchemasInProcedureCalls | false |
| supportsSchemasInTableDefinitions | true |
| supportsSelectForUpdate | false |
| supportsStatementPooling | false |
| supportsStoredProcedures | true |
| supportsSubqueriesInComparisons | true |
| supportsSubqueriesInExists | true |
| supportsSubqueriesInIns | true |
| supportsSubqueriesInQuantifieds | true |
| supportsTableCorrelationNames | true |
| supportsTransactions | true |
| supportsUnion | true |
| supportsUnionAll | true |
| usesLocalFilePerTable | false |
| usesLocalFiles | false |