Table 16-30 lists limitations to the returned contents of methods in the DatabaseMetaData class that are defined in the JDBC1.0 standard, while Table 16-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 16-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.00.0000.
getDriverMajorVersion	8
getDriverMinorVersion	0
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: Setting of COMMIT_BEHAVIOR in URL Setting of COMMIT_BEHAVIOR in Properties info Argument when the setCommit_Behavior method is executed
supportsOpenCursorsAcrossRollback	Unconditionally returns false.
supportsOpenStatementsAcrossCommit	Returns true if any of the following values is PRESERVE or CLOSE: Setting of COMMIT_BEHAVIOR in URL Setting of COMMIT_BEHAVIOR in Properties info Argument when the setCommit_Behavior method is executed
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: TRANSACTION_READ_COMMITTED TRANSACTION_READ_UNCOMMITTED TRANSACTION_REPEATABLE_READ
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 16-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.