Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

17.4.6 DatabaseMetaData interface

Organization of this subsection
(1) Overview
(2) Methods
(3) Package and class names

(1) Overview

The DatabaseMetaData interface provides the following principal functions:

(2) Methods

Table 17-19 lists the methods of the DatabaseMetaData interface. The interface does not support methods that are not listed in the table. If an unsupported method is specified, the interface throws an SQLException.

Table 17-19 DatabaseMetaData interface methods

Method Remarks
allProceduresAreCallable() --
allTablesAreSelectable() --
dataDefinitionCausesTransactionCommit() --
dataDefinitionIgnoredInTransactions() --
deletesAreDetected(int type) --
doesMaxRowSizeIncludeBlobs() --
getBestRowIdentifier (String catalog,String schema,String table,int scope,boolean nullable) The JDBC driver ignores the catalog argument.
The JDBC driver returns a result set that has 0 retrieved rows.
getCatalogs() Returns a result set that has 0 retrieved rows.
getCatalogSeparator() Returns the null value.
getCatalogTerm() Returns the null value.
getColumns (String catalog,String schemaPattern,String tableNamePattern,String columnNamePattern) The JDBC driver ignores the catalog argument.
getConnection --
getDatabaseMajorVersion() --
getDatabaseMinorVersion() --
getDatabaseProductName() Returns HiRDB.
getDatabaseProductVersion() --
getDefaultTransactionIsolation() --
getDriverMajorVersion() --
getDriverMinorVersion() --
getDriverName() --
getDriverVersion() --
getExtraNameCharacters() --
getIdentifierQuoteString() --
getIndexInfo (String catalog,String schema,String table,boolean unique,boolean approximate) The JDBC driver ignores the catalog argument.
getMaxBinaryLiteralLength() --
getMaxCatalogNameLength() --
getMaxCharLiteralLength() --
getMaxColumnNameLength() --
getMaxColumnsInGroupBy() --
getMaxColumnsInIndex() --
getMaxColumnsInOrderBy() --
getMaxColumnsInSelect() --
getMaxColumnsInTable() --
getMaxConnections() --
getMaxCursorNameLength() --
getMaxIndexLength() --
getMaxProcedureNameLength() --
getMaxRowSize() --
getMaxSchemaNameLength() --
getMaxStatementLength() --
getMaxStatements() --
getMaxTableNameLength() --
getMaxTablesInSelect() --
getMaxUserNameLength() --
getNumericFunctions() --
getPrimaryKeys() --
getProcedureTerm() --
getSchemas() --
getSchemaTerm() Returns schema.
getSearchStringEscape() Returns \.
getSQLKeywords() --
getStringFunctions() --
getSystemFunctions() --
getTables(String catalog,String schemaPattern,String tableNamePattern,String[] types) The JDBC driver ignores the catalog argument.
getTimeDateFunctions() --
getTypeInfo() --
insertsAreDetected(int type) --
isCatalogAtStart() --
isReadOnly() --
nullPlusNonNullIsNull() --
nullsAreSortedAtEnd() --
nullsAreSortedAtStart() --
nullsAreSortedHigh() --
nullsAreSortedLow() --
othersDeletesAreVisible() --
othersInsertsAreVisible() --
othersUpdatesAreVisible() --
ownDeletesAreVisible() --
ownInsertsAreVisible() --
ownUpdatesAreVisible() --
storesLowerCaseIdentifiers() --
storesLowerCaseQuotedIdentifiers() --
storesMixedCaseIdentifiers() --
storesMixedCaseQuotedIdentifiers() --
storesUpperCaseIdentifiers() --
storesUpperCaseQuotedIdentifiers() --
supportsAlterTableWithAddColumn() --
supportsAlterTableWithDropColumn() --
supportsANSI92EntryLevelSQL() --
supportsANSI92FullSQL() --
supportsANSI92IntermediateSQL() --
supportsBatchUpdates() --
supportsCatalogsInDataManipulation() --
supportsCatalogsInIndexDefinitions() --
supportsCatalogsInPrivilegeDefinitions() --
supportsCatalogsInProcedureCalls() --
supportsCatalogsInTableDefinitions() --
supportsColumnAliasing() --
supportsConvert() --
supportsConvert(int fromType,int toType) --
supportsCoreSQLGrammar() --
supportsCorrelatedSubqueries() --
supportsDataDefinitionAndDataManipulationTransactions() --
supportsDataManipulationTransactionsOnly() --
supportsDifferentTableCorrelationNames() --
supportsExpressionsInOrderBy() --
supportsExtendedSQLGrammar() --
supportsFullOuterJoins() --
supportsGroupBy() --
supportsGroupByBeyondSelect() --
supportsGroupByUnrelated() --
supportsIntegrityEnhancementFacility() --
supportsLikeEscapeClause() --
supportsLimitedOuterJoins() --
supportsMinimumSQLGrammar() --
supportsMixedCaseIdentifiers() --
supportsMixedCaseQuotedIdentifiers() --
supportsMultipleResultSets() --
supportsMultipleTransactions() --
supportsNonNullableColumns() --
supportsOpenCursorsAcrossCommit() --
supportsOpenCursorsAcrossRollback() --
supportsOpenStatementsAcrossCommit() --
supportsOpenStatementsAcrossRollback() --
supportsOrderByUnrelated() --
supportsOuterJoins() --
supportsPositionedDelete() --
supportsPositionedUpdate() --
supportsResultSetConcurrency(int type, int concurrency) --
supportsResultSetType(int type) --
supportsSchemasInDataManipulation() --
supportsSchemasInIndexDefinitions() --
supportsSchemasInPrivilegeDefinitions() --
supportsSchemasInProcedureCalls() --
supportsSchemasInTableDefinitions() --
supportsSelectForUpdate() --
supportsStoredProcedures() --
supportsSubqueriesInComparisons() --
supportsSubqueriesInExists() --
supportsSubqueriesInIns() --
supportsSubqueriesInQuantifieds() --
supportsTableCorrelationNames() --
supportsTransactionIsolationLevel(int level) Returns true if the provided transaction level is TRANSACTION_REPEATABLE_READ.
supportsTransactions() --
supportsUnion() --
supportsUnionAll() --
updatesAreDetected() --
usesLocalFilePerTable() --
usesLocalFiles() --

Legend:
--: None

(3) Package and class names

The names of the package and class for installing this interface are as follows:

Package name: JP.co.Hitachi.soft.HiRDB.JDBC

Class name: PrdbDatabaseMetaData