| Property Name | Value |
| allProceduresAreCallable | true |
| allTablesAreSelectable | true |
| dataDefinitionCausesTransactionCommit | false |
| dataDefinitionIgnoredInTransactions | false |
| doesMaxRowSizeIncludeBlobs | true |
| getCatalogSeparator | |
| getCatalogTerm | CATALOG |
| getDatabaseMajorVersion | 10 |
| getDatabaseMinorVersion | 1 |
| getDatabaseProductName | Apache Derby |
| getDatabaseProductVersion | 10.1.1.1 |
| getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED |
| getDriverMajorVersion | 10 |
| getDriverMinorVersion | 1 |
| getDriverName | Apache Derby Network Client JDBC Driver |
| getDriverVersion | 10.1.1.1 |
| getExtraNameCharacters | |
| getIdentifierQuoteString | " |
| getJDBCMajorVersion | 3 |
| getJDBCMinorVersion | 0 |
| getMaxBinaryLiteralLength | 0 |
| getMaxCatalogNameLength | 0 |
| getMaxCharLiteralLength | 0 |
| getMaxColumnNameLength | 128 |
| getMaxColumnsInGroupBy | 0 |
| getMaxColumnsInIndex | 0 |
| getMaxColumnsInOrderBy | 0 |
| getMaxColumnsInSelect | 0 |
| getMaxColumnsInTable | 0 |
| getMaxConnections | 0 |
| getMaxCursorNameLength | 128 |
| getMaxIndexLength | 0 |
| getMaxProcedureNameLength | 128 |
| getMaxRowSize | 0 |
| getMaxSchemaNameLength | 128 |
| getMaxStatementLength | 0 |
| getMaxStatements | 0 |
| getMaxTableNameLength | 128 |
| getMaxTablesInSelect | 0 |
| getMaxUserNameLength | 30 |
| getProcedureTerm | PROCEDURE |
| getResultSetHoldability | 1 |
| getSchemaTerm | SCHEMA |
| getSearchStringEscape | |
| getSQLStateType | 2 |
| getURL | jdbc:derby://localhost:1527/dbcopy |
| getUserName | dbcopysrc |
| isCatalogAtStart | false |
| isReadOnly | false |
| locatorsUpdateCopy | false |
| nullPlusNonNullIsNull | true |
| nullsAreSortedAtEnd | false |
| nullsAreSortedAtStart | false |
| nullsAreSortedHigh | true |
| nullsAreSortedLow | false |
| 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 | false |
| supportsCatalogsInIndexDefinitions | false |
| supportsCatalogsInPrivilegeDefinitions | false |
| supportsCatalogsInProcedureCalls | false |
| supportsCatalogsInTableDefinitions | false |
| supportsColumnAliasing | true |
| supportsConvert | true |
| supportsCoreSQLGrammar | false |
| supportsCorrelatedSubqueries | true |
| supportsDataDefinitionAndDataManipulationTransactions | true |
| supportsDataManipulationTransactionsOnly | false |
| supportsDifferentTableCorrelationNames | true |
| supportsExpressionsInOrderBy | false |
| supportsExtendedSQLGrammar | false |
| supportsFullOuterJoins | false |
| supportsGetGeneratedKeys | false |
| supportsGroupBy | true |
| supportsGroupByBeyondSelect | true |
| supportsGroupByUnrelated | true |
| supportsIntegrityEnhancementFacility | false |
| supportsLikeEscapeClause | true |
| supportsLimitedOuterJoins | true |
| supportsMinimumSQLGrammar | true |
| supportsMixedCaseIdentifiers | false |
| supportsMixedCaseQuotedIdentifiers | true |
| supportsMultipleOpenResults | true |
| supportsMultipleResultSets | true |
| supportsMultipleTransactions | true |
| supportsNamedParameters | false |
| supportsNonNullableColumns | true |
| supportsOpenCursorsAcrossCommit | false |
| supportsOpenCursorsAcrossRollback | false |
| supportsOpenStatementsAcrossCommit | true |
| supportsOpenStatementsAcrossRollback | false |
| supportsOrderByUnrelated | false |
| supportsOuterJoins | true |
| supportsPositionedDelete | true |
| supportsPositionedUpdate | true |
| supportsSavepoints | true |
| supportsSchemasInDataManipulation | true |
| supportsSchemasInIndexDefinitions | true |
| supportsSchemasInPrivilegeDefinitions | true |
| supportsSchemasInProcedureCalls | true |
| supportsSchemasInTableDefinitions | true |
| supportsSelectForUpdate | true |
| supportsStatementPooling | false |
| supportsStoredProcedures | true |
| supportsSubqueriesInComparisons | true |
| supportsSubqueriesInExists | true |
| supportsSubqueriesInIns | true |
| supportsSubqueriesInQuantifieds | true |
| supportsTableCorrelationNames | true |
| supportsTransactions | true |
| supportsUnion | true |
| supportsUnionAll | true |
| usesLocalFilePerTable | true |
| usesLocalFiles | true |