Nonstop Database, HiRDB Version 9 UAP Development Guide
Table 17-30 lists limitations to the returned contents of methods in the DatabaseMetaData class that are defined in the JDBC1.0 standard, while Table 17-31 lists limitations to the returned contents of the methods added by the JDBC2.0 basic standard. Note that the value returned by each method is information related to the HiRDB server, whose version has to be the same as the JDBC driver being used.
Table 17-30 Limitations to the methods in the DatabaseMetaData class that are defined in the JDBC1.0 standard
Method defined in JDBC1.0 standard | Limitation or return value |
---|---|
allProceduresAreCallable | Returns false. |
allTablesAreSelectable | Returns false. |
getURL | Returns the JDBC URL of the connected database. |
getUserName | Returns the authorization identifier used when connecting to the database. |
isReadOnly | Unconditionally returns false because the access mode cannot be changed. |
nullsAreSortedHigh | Returns true. |
nullsAreSortedLow | Returns false. |
nullsAreSortedAtStart | Returns false. |
nullsAreSortedAtEnd | Unconditionally returns false. |
getDatabaseProductName | Returns HiRDB. |
getDatabaseProductVersion | Returns null. |
getDriverName | Returns HiRDB_for_JDBC. |
getDriverVersion | Returns 08.02.0000. |
getDriverMajorVersion | 8 |
getDriverMinorVersion | 2 |
usesLocalFiles | Unconditionally returns false. |
usesLocalFilePerTable | Unconditionally returns false. |
supportsMixedCaseIdentifiers | Unconditionally returns false. |
storesUpperCaseIdentifiers | Returns true. |
storesLowerCaseIdentifiers | Unconditionally returns false. |
storesMixedCaseIdentifiers | Returns false. |
supportsMixedCaseQuotedIdentifiers | Returns true. |
storesUpperCaseQuotedIdentifiers | Returns false. |
storesLowerCaseQuotedIdentifiers | Unconditionally returns false. |
storesMixedCaseQuotedIdentifiers | Returns true. |
getIdentifierQuoteString | Unconditionally returns a quotation mark. |
getSQLKeywords | Returns a HiRDB-specific SQL keyword. |
getNumericFunctions | Returns a list of mathematical functions. |
getStringFunctions | Returns a list of character string functions. |
getSystemFunctions | Returns a list of system functions. |
getTimeDateFunctions | Returns a list of time and date functions. |
getSearchStringEscape | Returns \. |
getExtraNameCharacters | Returns a special character that can be used as an SQL identification name. |
supportsAlterTableWithAddColumn | Returns true. |
supportsAlterTableWithDropColumn | |
supportsColumnAliasing | |
nullPlusNonNullIsNull | |
supportsConvert (no argument) | Returns true. |
supportsConvert (with arguments) | Returns either true or false depending on the combination of data types specified in arguments. |
supportsTableCorrelationNames | Returns true. |
supportsDifferentTableCorrelationNames | |
supportsExpressionsInOrderBy | Returns false. |
supportsOrderByUnrelated | Returns true. |
supportsGroupBy | |
supportsGroupByUnrelated | |
supportsGroupByBeyondSelect | |
supportsLikeEscapeClause | |
supportsMultipleResultSets | Unconditionally returns true. |
supportsMultipleTransactions | |
supportsNonNullableColumns | Returns true. |
supportsMinimumSQLGrammar | Unconditionally returns true. |
supportsCoreSQLGrammar | |
supportsExtendedSQLGrammar | Returns false. |
supportsANSI92EntryLevelSQL | Unconditionally returns true. |
supportsANSI92IntermediateSQL | Unconditionally returns false. |
supportsANSI92FullSQL | |
supportsIntegrityEnhancementFacility | Returns false. |
supportsOuterJoins | Returns true. |
supportsFullOuterJoins | Returns false. |
supportsLimitedOuterJoins | Returns true. |
getSchemaTerm | Returns schema. |
getProcedureTerm | Returns procedure. |
getCatalogTerm | Returns null. |
isCatalogAtStart | Returns false. |
getCatalogSeparator | Returns null. |
supportsSchemasInDataManipulation | Unconditionally returns true. |
supportsSchemasInProcedureCalls | Returns true. |
supportsSchemasInTableDefinitions | |
supportsSchemasInIndexDefinitions | |
supportsSchemasInPrivilegeDefinitions | |
supportsCatalogsInDataManipulation | Returns false. |
supportsCatalogsInProcedureCalls | |
supportsCatalogsInTableDefinitions | |
supportsCatalogsInIndexDefinitions | Unconditionally returns false. |
supportsCatalogsInPrivilegeDefinitions | |
supportsPositionedDelete | |
supportsPositionedUpdate | |
supportsSelectForUpdate | |
supportsStoredProcedures | Returns true. |
supportsSubqueriesInComparisons | |
supportsSubqueriesInExists | |
supportsSubqueriesInIns | |
supportsSubqueriesInQuantifieds | |
supportsCorrelatedSubqueries | |
supportsUnion | |
supportsUnionAll | |
supportsOpenCursorsAcrossCommit | Returns true if any of the following values is PRESERVE:
|
supportsOpenCursorsAcrossRollback | Unconditionally returns false. |
supportsOpenStatementsAcrossCommit | Returns true if any of the following values is PRESERVE or CLOSE:
|
supportsOpenStatementsAcrossRollback | Unconditionally returns false. |
getMaxBinaryLiteralLength | Returns a value of 64000. |
getMaxCharLiteralLength | Returns a value of 32000. |
getMaxColumnNameLength | Returns a value of 30. |
getMaxColumnsInGroupBy | Returns a value of 255. |
getMaxColumnsInIndex | Returns a value of 16. |
getMaxColumnsInOrderBy | Returns a value of 255. |
getMaxColumnsInSelect | Returns a value of 30000. |
getMaxColumnsInTable | |
getMaxConnections | Returns a value of 0. |
getMaxCursorNameLength | Returns a value of 30. |
getMaxIndexLength | Returns a value of 4036. |
getMaxSchemaNameLength | Returns a value of 8. |
getMaxProcedureNameLength | Returns a value of 30. |
getMaxCatalogNameLength | Returns a value of 0. |
getMaxRowSize | |
doesMaxRowSizeIncludeBlobs | Returns false. |
getMaxStatementLength | Returns a value of 2000000. |
getMaxStatements | Returns a value of 64. |
getMaxTableNameLength | Returns a value of 30. |
getMaxTablesInSelect | Returns a value of 64. |
getMaxUserNameLength | Returns a value of 8. |
getDefaultTransactionIsolation | Unconditionally returns TRANSACTION_REPEATABLE_READ. |
supportsTransactions | Unconditionally returns true. |
supportsTransactionIsolationLevel | Returns true when the given transaction isolation level is any of the following:
|
SupportsDataDefinitionAndDataManipulation Transactions |
Returns false. |
supportsDataManipulationTransactionsOnly | Returns false. |
dataDefinitionCausesTransactionCommit | Returns true. |
dataDefinitionIgnoredInTransactions | Unconditionally returns false. |
getProcedures | Returns information about the Java stored routines. |
getProcedureColumns | Returns information about the parameters of the Java stored routines. |
getTables | Returns information about tables. Only the table types returned by getTableTypes can be specified in the list of table types to be obtained (types). |
getSchemas | Returns information about schemas. |
getCatalogs | Always returns a 0 result. |
getTableTypes | Returns information about table types. The following values are returned: "SYSTEM TABLE": System table "BASE TABLE": Base table "VIEW": View table "READ ONLY VIEW": Read-only view table "ALIAS": Another table |
getColumns | Returns information about columns. |
getColumnPrivileges | Returns information about column privileges. |
getTablePrivileges | Returns information about table privileges. |
getBestRowIdentifier | Always returns a 0 result. |
getVersionColumns | |
getPrimaryKeys | Returns information about primary key columns (always returns a 0 result). |
getImportedKeys | Always returns a 0 result. |
getExportedKeys | Returns information about external key columns that reference the primary key columns (always returns a 0 result). |
getCrossReference | Returns information about the external key columns in the table with external keys that reference the primary key columns in the table with the primary key (always returns a 0 result). |
getTypeInfo | Returns information about the standard SQL types supported for the database. |
getIndexInfo | Returns information about indexes. |
Table 17-31 Limitations to the methods in the DatabaseMetaData class that are added in the JDBC2.0 basic standard
Method added in JDBC2.0 basic standard | Limitation or return value |
---|---|
supportsResultSetType | Returns true if the result set type is TYPE_FORWARD_ONLY or TYPE_SCROLL_INSENSITIVE. |
SupportsResultSet Concurrency |
Returns true if the result set type is TYPE_FORWARD_ONLY or TYPE_SCROLL_INSENSITIVE and the parallel processing type is CONCUR_READ_ONLY. |
ownUpdatesAreVisible | Unconditionally returns false. |
ownDeletesAreVisible | |
ownInsertsAreVisible | |
othersUpdatesAreVisible | |
othersDeletesAreVisible | |
othersInsertsAreVisible | |
updatesAreDetected | |
deletesAreDetected | |
insertsAreDetected | |
supportsBatchUpdates | Unconditionally returns true. |
getUDTs | Always returns a 0 result. |
getConnection | Returns the Connection instance that is the DatabaseMetaData instance generation source. |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.