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