|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.ims.db.DLIDatabaseMetaData
Fields inherited from interface java.sql.DatabaseMetaData |
bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown |
Constructor Summary | |
protected |
DLIDatabaseMetaData(java.sql.Connection connection)
|
Method Summary | |
boolean |
allProceduresAreCallable()
|
boolean |
allTablesAreSelectable()
|
boolean |
dataDefinitionCausesTransactionCommit()
|
boolean |
dataDefinitionIgnoredInTransactions()
|
boolean |
deletesAreDetected(int type)
Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted(). |
boolean |
doesMaxRowSizeIncludeBlobs()
|
java.sql.ResultSet |
getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
This function is not supported Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog. |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
|
java.sql.ResultSet |
getCatalogs()
|
java.lang.String |
getCatalogSeparator()
|
java.lang.String |
getCatalogTerm()
|
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
|
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
|
java.sql.Connection |
getConnection()
Retrieves the connection that produced this metadata object. |
java.sql.ResultSet |
getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
|
int |
getDatabaseMajorVersion()
This function is not supported Retrieves the major version number of the underlying database. |
int |
getDatabaseMinorVersion()
This function is not supported Retrieves the minor version number of the underlying database. |
java.lang.String |
getDatabaseProductName()
|
java.lang.String |
getDatabaseProductVersion()
|
int |
getDefaultTransactionIsolation()
|
int |
getDriverMajorVersion()
|
int |
getDriverMinorVersion()
|
java.lang.String |
getDriverName()
|
java.lang.String |
getDriverVersion()
|
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.lang.String |
getExtraNameCharacters()
|
java.lang.String |
getIdentifierQuoteString()
|
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
|
int |
getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver. |
int |
getJDBCMinorVersion()
Retrieves the minor JDBC version number for this driver. |
int |
getMaxBinaryLiteralLength()
|
int |
getMaxCatalogNameLength()
|
int |
getMaxCharLiteralLength()
|
int |
getMaxColumnNameLength()
|
int |
getMaxColumnsInGroupBy()
|
int |
getMaxColumnsInIndex()
|
int |
getMaxColumnsInOrderBy()
|
int |
getMaxColumnsInSelect()
|
int |
getMaxColumnsInTable()
|
int |
getMaxConnections()
|
int |
getMaxCursorNameLength()
|
int |
getMaxIndexLength()
|
int |
getMaxProcedureNameLength()
|
int |
getMaxRowSize()
|
int |
getMaxSchemaNameLength()
|
int |
getMaxStatementLength()
|
int |
getMaxStatements()
|
int |
getMaxTableNameLength()
|
int |
getMaxTablesInSelect()
|
int |
getMaxUserNameLength()
|
java.lang.String |
getNumericFunctions()
|
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
|
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
|
java.lang.String |
getProcedureTerm()
|
int |
getResultSetHoldability()
This function is not supported Retrieves the default holdability of this ResultSet
object. |
java.sql.ResultSet |
getSchemas()
|
java.lang.String |
getSchemaTerm()
|
java.lang.String |
getSearchStringEscape()
|
java.lang.String |
getSQLKeywords()
|
int |
getSQLStateType()
This function is not supported Indicates whether the SQLSTATEs returned by SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99. |
java.lang.String |
getStringFunctions()
|
java.sql.ResultSet |
getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
This function is not supported Retrieves a description of the table hierarchies defined in a particular schema in this database. |
java.sql.ResultSet |
getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
This function is not supported Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database. |
java.lang.String |
getSystemFunctions()
|
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
|
java.sql.ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
|
java.sql.ResultSet |
getTableTypes()
|
java.lang.String |
getTimeDateFunctions()
|
java.sql.ResultSet |
getTypeInfo()
|
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
Gets a description of the user-defined types defined in a particular schema. |
java.lang.String |
getURL()
|
java.lang.String |
getUserName()
|
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
|
boolean |
insertsAreDetected(int type)
Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted(). |
boolean |
isCatalogAtStart()
|
boolean |
isReadOnly()
This function is not supported |
boolean |
locatorsUpdateCopy()
Indicates whether updates made to a LOB are made on a copy or directly to the LOB. |
boolean |
nullPlusNonNullIsNull()
|
boolean |
nullsAreSortedAtEnd()
This function is not supported |
boolean |
nullsAreSortedAtStart()
This function is not supported |
boolean |
nullsAreSortedHigh()
This function is not supported |
boolean |
nullsAreSortedLow()
This function is not supported |
boolean |
othersDeletesAreVisible(int type)
Indicates whether deletes made by others are visible. |
boolean |
othersInsertsAreVisible(int type)
Indicates whether inserts made by others are visible. |
boolean |
othersUpdatesAreVisible(int type)
Indicates whether updates made by others are visible. |
boolean |
ownDeletesAreVisible(int type)
Indicates whether a result set's own deletes are visible. |
boolean |
ownInsertsAreVisible(int type)
Indicates whether a result set's own inserts are visible. |
boolean |
ownUpdatesAreVisible(int type)
Indicates whether a result set's own updates are visible. |
boolean |
storesLowerCaseIdentifiers()
|
boolean |
storesLowerCaseQuotedIdentifiers()
|
boolean |
storesMixedCaseIdentifiers()
|
boolean |
storesMixedCaseQuotedIdentifiers()
|
boolean |
storesUpperCaseIdentifiers()
|
boolean |
storesUpperCaseQuotedIdentifiers()
|
boolean |
supportsAlterTableWithAddColumn()
|
boolean |
supportsAlterTableWithDropColumn()
|
boolean |
supportsANSI92EntryLevelSQL()
|
boolean |
supportsANSI92FullSQL()
|
boolean |
supportsANSI92IntermediateSQL()
|
boolean |
supportsBatchUpdates()
Indicates whether the driver supports batch updates. |
boolean |
supportsCatalogsInDataManipulation()
|
boolean |
supportsCatalogsInIndexDefinitions()
|
boolean |
supportsCatalogsInPrivilegeDefinitions()
|
boolean |
supportsCatalogsInProcedureCalls()
|
boolean |
supportsCatalogsInTableDefinitions()
|
boolean |
supportsColumnAliasing()
|
boolean |
supportsConvert()
|
boolean |
supportsConvert(int fromType,
int toType)
|
boolean |
supportsCoreSQLGrammar()
|
boolean |
supportsCorrelatedSubqueries()
|
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
|
boolean |
supportsDataManipulationTransactionsOnly()
|
boolean |
supportsDifferentTableCorrelationNames()
|
boolean |
supportsExpressionsInOrderBy()
|
boolean |
supportsExtendedSQLGrammar()
|
boolean |
supportsFullOuterJoins()
|
boolean |
supportsGetGeneratedKeys()
Retrieves whether auto-generated keys can be retrieved after a statement has been executed. |
boolean |
supportsGroupBy()
|
boolean |
supportsGroupByBeyondSelect()
|
boolean |
supportsGroupByUnrelated()
|
boolean |
supportsIntegrityEnhancementFacility()
|
boolean |
supportsLikeEscapeClause()
|
boolean |
supportsLimitedOuterJoins()
|
boolean |
supportsMinimumSQLGrammar()
|
boolean |
supportsMixedCaseIdentifiers()
|
boolean |
supportsMixedCaseQuotedIdentifiers()
|
boolean |
supportsMultipleOpenResults()
Retrieves whether it is possible to have multiple ResultSet objects
returned from a CallableStatement object
simultaneously. |
boolean |
supportsMultipleResultSets()
|
boolean |
supportsMultipleTransactions()
|
boolean |
supportsNamedParameters()
Retrieves whether this database supports named parameters to callable statements. |
boolean |
supportsNonNullableColumns()
|
boolean |
supportsOpenCursorsAcrossCommit()
|
boolean |
supportsOpenCursorsAcrossRollback()
|
boolean |
supportsOpenStatementsAcrossCommit()
|
boolean |
supportsOpenStatementsAcrossRollback()
|
boolean |
supportsOrderByUnrelated()
|
boolean |
supportsOuterJoins()
|
boolean |
supportsPositionedDelete()
|
boolean |
supportsPositionedUpdate()
|
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
Does the database support the concurrency type in combination with the given result set type? |
boolean |
supportsResultSetHoldability(int holdability)
This function is not supported Retrieves whether this database supports the given result set holdability. |
boolean |
supportsResultSetType(int type)
Does the database support the given result set type? |
boolean |
supportsSavepoints()
Retrieves whether this database supports savepoints. |
boolean |
supportsSchemasInDataManipulation()
|
boolean |
supportsSchemasInIndexDefinitions()
|
boolean |
supportsSchemasInPrivilegeDefinitions()
|
boolean |
supportsSchemasInProcedureCalls()
|
boolean |
supportsSchemasInTableDefinitions()
|
boolean |
supportsSelectForUpdate()
|
boolean |
supportsStatementPooling()
Retrieves weather this database supports statement pooling. |
boolean |
supportsStoredProcedures()
|
boolean |
supportsSubqueriesInComparisons()
|
boolean |
supportsSubqueriesInExists()
|
boolean |
supportsSubqueriesInIns()
|
boolean |
supportsSubqueriesInQuantifieds()
|
boolean |
supportsTableCorrelationNames()
|
boolean |
supportsTransactionIsolationLevel(int level)
|
boolean |
supportsTransactions()
|
boolean |
supportsUnion()
|
boolean |
supportsUnionAll()
|
boolean |
updatesAreDetected(int type)
Indicates whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated . |
boolean |
usesLocalFilePerTable()
|
boolean |
usesLocalFiles()
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
protected DLIDatabaseMetaData(java.sql.Connection connection)
Method Detail |
public boolean allProceduresAreCallable() throws java.sql.SQLException
allProceduresAreCallable
in interface java.sql.DatabaseMetaData
public boolean allTablesAreSelectable() throws java.sql.SQLException
allTablesAreSelectable
in interface java.sql.DatabaseMetaData
public java.lang.String getURL() throws java.sql.SQLException
getURL
in interface java.sql.DatabaseMetaData
public java.lang.String getUserName() throws java.sql.SQLException
getUserName
in interface java.sql.DatabaseMetaData
public boolean isReadOnly() throws java.sql.SQLException
isReadOnly
in interface java.sql.DatabaseMetaData
public boolean nullsAreSortedHigh() throws java.sql.SQLException
nullsAreSortedHigh
in interface java.sql.DatabaseMetaData
public boolean nullsAreSortedLow() throws java.sql.SQLException
nullsAreSortedLow
in interface java.sql.DatabaseMetaData
public boolean nullsAreSortedAtStart() throws java.sql.SQLException
nullsAreSortedAtStart
in interface java.sql.DatabaseMetaData
public boolean nullsAreSortedAtEnd() throws java.sql.SQLException
nullsAreSortedAtEnd
in interface java.sql.DatabaseMetaData
public java.lang.String getDatabaseProductName() throws java.sql.SQLException
getDatabaseProductName
in interface java.sql.DatabaseMetaData
public java.lang.String getDatabaseProductVersion() throws java.sql.SQLException
getDatabaseProductVersion
in interface java.sql.DatabaseMetaData
public java.lang.String getDriverName() throws java.sql.SQLException
getDriverName
in interface java.sql.DatabaseMetaData
public java.lang.String getDriverVersion() throws java.sql.SQLException
getDriverVersion
in interface java.sql.DatabaseMetaData
public int getDriverMajorVersion()
getDriverMajorVersion
in interface java.sql.DatabaseMetaData
public int getDriverMinorVersion()
getDriverMinorVersion
in interface java.sql.DatabaseMetaData
public boolean usesLocalFiles() throws java.sql.SQLException
usesLocalFiles
in interface java.sql.DatabaseMetaData
public boolean usesLocalFilePerTable() throws java.sql.SQLException
usesLocalFilePerTable
in interface java.sql.DatabaseMetaData
public boolean supportsMixedCaseIdentifiers() throws java.sql.SQLException
supportsMixedCaseIdentifiers
in interface java.sql.DatabaseMetaData
public boolean storesUpperCaseIdentifiers() throws java.sql.SQLException
storesUpperCaseIdentifiers
in interface java.sql.DatabaseMetaData
public boolean storesLowerCaseIdentifiers() throws java.sql.SQLException
storesLowerCaseIdentifiers
in interface java.sql.DatabaseMetaData
public boolean storesMixedCaseIdentifiers() throws java.sql.SQLException
storesMixedCaseIdentifiers
in interface java.sql.DatabaseMetaData
public boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLException
supportsMixedCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
public boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLException
storesUpperCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
public boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLException
storesLowerCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
public boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLException
storesMixedCaseQuotedIdentifiers
in interface java.sql.DatabaseMetaData
public java.lang.String getIdentifierQuoteString() throws java.sql.SQLException
getIdentifierQuoteString
in interface java.sql.DatabaseMetaData
public java.lang.String getSQLKeywords() throws java.sql.SQLException
getSQLKeywords
in interface java.sql.DatabaseMetaData
public java.lang.String getNumericFunctions() throws java.sql.SQLException
getNumericFunctions
in interface java.sql.DatabaseMetaData
public java.lang.String getStringFunctions() throws java.sql.SQLException
getStringFunctions
in interface java.sql.DatabaseMetaData
public java.lang.String getSystemFunctions() throws java.sql.SQLException
getSystemFunctions
in interface java.sql.DatabaseMetaData
public java.lang.String getTimeDateFunctions() throws java.sql.SQLException
getTimeDateFunctions
in interface java.sql.DatabaseMetaData
public java.lang.String getSearchStringEscape() throws java.sql.SQLException
getSearchStringEscape
in interface java.sql.DatabaseMetaData
public java.lang.String getExtraNameCharacters() throws java.sql.SQLException
getExtraNameCharacters
in interface java.sql.DatabaseMetaData
public boolean supportsAlterTableWithAddColumn() throws java.sql.SQLException
supportsAlterTableWithAddColumn
in interface java.sql.DatabaseMetaData
public boolean supportsAlterTableWithDropColumn() throws java.sql.SQLException
supportsAlterTableWithDropColumn
in interface java.sql.DatabaseMetaData
public boolean supportsColumnAliasing() throws java.sql.SQLException
supportsColumnAliasing
in interface java.sql.DatabaseMetaData
public boolean nullPlusNonNullIsNull() throws java.sql.SQLException
nullPlusNonNullIsNull
in interface java.sql.DatabaseMetaData
public boolean supportsConvert() throws java.sql.SQLException
supportsConvert
in interface java.sql.DatabaseMetaData
public boolean supportsConvert(int fromType, int toType) throws java.sql.SQLException
supportsConvert
in interface java.sql.DatabaseMetaData
public boolean supportsTableCorrelationNames() throws java.sql.SQLException
supportsTableCorrelationNames
in interface java.sql.DatabaseMetaData
public boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLException
supportsDifferentTableCorrelationNames
in interface java.sql.DatabaseMetaData
public boolean supportsExpressionsInOrderBy() throws java.sql.SQLException
supportsExpressionsInOrderBy
in interface java.sql.DatabaseMetaData
public boolean supportsOrderByUnrelated() throws java.sql.SQLException
supportsOrderByUnrelated
in interface java.sql.DatabaseMetaData
public boolean supportsGroupBy() throws java.sql.SQLException
supportsGroupBy
in interface java.sql.DatabaseMetaData
public boolean supportsGroupByUnrelated() throws java.sql.SQLException
supportsGroupByUnrelated
in interface java.sql.DatabaseMetaData
public boolean supportsGroupByBeyondSelect() throws java.sql.SQLException
supportsGroupByBeyondSelect
in interface java.sql.DatabaseMetaData
public boolean supportsLikeEscapeClause() throws java.sql.SQLException
supportsLikeEscapeClause
in interface java.sql.DatabaseMetaData
public boolean supportsMultipleResultSets() throws java.sql.SQLException
supportsMultipleResultSets
in interface java.sql.DatabaseMetaData
public boolean supportsMultipleTransactions() throws java.sql.SQLException
supportsMultipleTransactions
in interface java.sql.DatabaseMetaData
public boolean supportsNonNullableColumns() throws java.sql.SQLException
supportsNonNullableColumns
in interface java.sql.DatabaseMetaData
public boolean supportsMinimumSQLGrammar() throws java.sql.SQLException
supportsMinimumSQLGrammar
in interface java.sql.DatabaseMetaData
public boolean supportsCoreSQLGrammar() throws java.sql.SQLException
supportsCoreSQLGrammar
in interface java.sql.DatabaseMetaData
public boolean supportsExtendedSQLGrammar() throws java.sql.SQLException
supportsExtendedSQLGrammar
in interface java.sql.DatabaseMetaData
public boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLException
supportsANSI92EntryLevelSQL
in interface java.sql.DatabaseMetaData
public boolean supportsANSI92IntermediateSQL() throws java.sql.SQLException
supportsANSI92IntermediateSQL
in interface java.sql.DatabaseMetaData
public boolean supportsANSI92FullSQL() throws java.sql.SQLException
supportsANSI92FullSQL
in interface java.sql.DatabaseMetaData
public boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLException
supportsIntegrityEnhancementFacility
in interface java.sql.DatabaseMetaData
public boolean supportsOuterJoins() throws java.sql.SQLException
supportsOuterJoins
in interface java.sql.DatabaseMetaData
public boolean supportsFullOuterJoins() throws java.sql.SQLException
supportsFullOuterJoins
in interface java.sql.DatabaseMetaData
public boolean supportsLimitedOuterJoins() throws java.sql.SQLException
supportsLimitedOuterJoins
in interface java.sql.DatabaseMetaData
public java.lang.String getSchemaTerm() throws java.sql.SQLException
getSchemaTerm
in interface java.sql.DatabaseMetaData
public java.lang.String getProcedureTerm() throws java.sql.SQLException
getProcedureTerm
in interface java.sql.DatabaseMetaData
public java.lang.String getCatalogTerm() throws java.sql.SQLException
getCatalogTerm
in interface java.sql.DatabaseMetaData
public boolean isCatalogAtStart() throws java.sql.SQLException
isCatalogAtStart
in interface java.sql.DatabaseMetaData
public java.lang.String getCatalogSeparator() throws java.sql.SQLException
getCatalogSeparator
in interface java.sql.DatabaseMetaData
public boolean supportsSchemasInDataManipulation() throws java.sql.SQLException
supportsSchemasInDataManipulation
in interface java.sql.DatabaseMetaData
public boolean supportsSchemasInProcedureCalls() throws java.sql.SQLException
supportsSchemasInProcedureCalls
in interface java.sql.DatabaseMetaData
public boolean supportsSchemasInTableDefinitions() throws java.sql.SQLException
supportsSchemasInTableDefinitions
in interface java.sql.DatabaseMetaData
public boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLException
supportsSchemasInIndexDefinitions
in interface java.sql.DatabaseMetaData
public boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLException
supportsSchemasInPrivilegeDefinitions
in interface java.sql.DatabaseMetaData
public boolean supportsCatalogsInDataManipulation() throws java.sql.SQLException
supportsCatalogsInDataManipulation
in interface java.sql.DatabaseMetaData
public boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLException
supportsCatalogsInProcedureCalls
in interface java.sql.DatabaseMetaData
public boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLException
supportsCatalogsInTableDefinitions
in interface java.sql.DatabaseMetaData
public boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLException
supportsCatalogsInIndexDefinitions
in interface java.sql.DatabaseMetaData
public boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLException
supportsCatalogsInPrivilegeDefinitions
in interface java.sql.DatabaseMetaData
public boolean supportsPositionedDelete() throws java.sql.SQLException
supportsPositionedDelete
in interface java.sql.DatabaseMetaData
public boolean supportsPositionedUpdate() throws java.sql.SQLException
supportsPositionedUpdate
in interface java.sql.DatabaseMetaData
public boolean supportsSelectForUpdate() throws java.sql.SQLException
supportsSelectForUpdate
in interface java.sql.DatabaseMetaData
public boolean supportsStoredProcedures() throws java.sql.SQLException
supportsStoredProcedures
in interface java.sql.DatabaseMetaData
public boolean supportsSubqueriesInComparisons() throws java.sql.SQLException
supportsSubqueriesInComparisons
in interface java.sql.DatabaseMetaData
public boolean supportsSubqueriesInExists() throws java.sql.SQLException
supportsSubqueriesInExists
in interface java.sql.DatabaseMetaData
public boolean supportsSubqueriesInIns() throws java.sql.SQLException
supportsSubqueriesInIns
in interface java.sql.DatabaseMetaData
public boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLException
supportsSubqueriesInQuantifieds
in interface java.sql.DatabaseMetaData
public boolean supportsCorrelatedSubqueries() throws java.sql.SQLException
supportsCorrelatedSubqueries
in interface java.sql.DatabaseMetaData
public boolean supportsUnion() throws java.sql.SQLException
supportsUnion
in interface java.sql.DatabaseMetaData
public boolean supportsUnionAll() throws java.sql.SQLException
supportsUnionAll
in interface java.sql.DatabaseMetaData
public boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLException
supportsOpenCursorsAcrossCommit
in interface java.sql.DatabaseMetaData
public boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLException
supportsOpenCursorsAcrossRollback
in interface java.sql.DatabaseMetaData
public boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLException
supportsOpenStatementsAcrossCommit
in interface java.sql.DatabaseMetaData
public boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLException
supportsOpenStatementsAcrossRollback
in interface java.sql.DatabaseMetaData
public int getMaxBinaryLiteralLength() throws java.sql.SQLException
getMaxBinaryLiteralLength
in interface java.sql.DatabaseMetaData
public int getMaxCharLiteralLength() throws java.sql.SQLException
getMaxCharLiteralLength
in interface java.sql.DatabaseMetaData
public int getMaxColumnNameLength() throws java.sql.SQLException
getMaxColumnNameLength
in interface java.sql.DatabaseMetaData
public int getMaxColumnsInGroupBy() throws java.sql.SQLException
getMaxColumnsInGroupBy
in interface java.sql.DatabaseMetaData
public int getMaxColumnsInIndex() throws java.sql.SQLException
getMaxColumnsInIndex
in interface java.sql.DatabaseMetaData
public int getMaxColumnsInOrderBy() throws java.sql.SQLException
getMaxColumnsInOrderBy
in interface java.sql.DatabaseMetaData
public int getMaxColumnsInSelect() throws java.sql.SQLException
getMaxColumnsInSelect
in interface java.sql.DatabaseMetaData
public int getMaxColumnsInTable() throws java.sql.SQLException
getMaxColumnsInTable
in interface java.sql.DatabaseMetaData
public int getMaxConnections() throws java.sql.SQLException
getMaxConnections
in interface java.sql.DatabaseMetaData
public int getMaxCursorNameLength() throws java.sql.SQLException
getMaxCursorNameLength
in interface java.sql.DatabaseMetaData
public int getMaxIndexLength() throws java.sql.SQLException
getMaxIndexLength
in interface java.sql.DatabaseMetaData
public int getMaxSchemaNameLength() throws java.sql.SQLException
getMaxSchemaNameLength
in interface java.sql.DatabaseMetaData
public int getMaxProcedureNameLength() throws java.sql.SQLException
getMaxProcedureNameLength
in interface java.sql.DatabaseMetaData
public int getMaxCatalogNameLength() throws java.sql.SQLException
getMaxCatalogNameLength
in interface java.sql.DatabaseMetaData
public int getMaxRowSize() throws java.sql.SQLException
getMaxRowSize
in interface java.sql.DatabaseMetaData
public boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLException
doesMaxRowSizeIncludeBlobs
in interface java.sql.DatabaseMetaData
public int getMaxStatementLength() throws java.sql.SQLException
getMaxStatementLength
in interface java.sql.DatabaseMetaData
public int getMaxStatements() throws java.sql.SQLException
getMaxStatements
in interface java.sql.DatabaseMetaData
public int getMaxTableNameLength() throws java.sql.SQLException
getMaxTableNameLength
in interface java.sql.DatabaseMetaData
public int getMaxTablesInSelect() throws java.sql.SQLException
getMaxTablesInSelect
in interface java.sql.DatabaseMetaData
public int getMaxUserNameLength() throws java.sql.SQLException
getMaxUserNameLength
in interface java.sql.DatabaseMetaData
public int getDefaultTransactionIsolation() throws java.sql.SQLException
getDefaultTransactionIsolation
in interface java.sql.DatabaseMetaData
public boolean supportsTransactions() throws java.sql.SQLException
supportsTransactions
in interface java.sql.DatabaseMetaData
public boolean supportsTransactionIsolationLevel(int level) throws java.sql.SQLException
supportsTransactionIsolationLevel
in interface java.sql.DatabaseMetaData
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLException
supportsDataDefinitionAndDataManipulationTransactions
in interface java.sql.DatabaseMetaData
public boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLException
supportsDataManipulationTransactionsOnly
in interface java.sql.DatabaseMetaData
public boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLException
dataDefinitionCausesTransactionCommit
in interface java.sql.DatabaseMetaData
public boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLException
dataDefinitionIgnoredInTransactions
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern) throws java.sql.SQLException
getProcedures
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getProcedureColumns
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types) throws java.sql.SQLException
getTables
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getSchemas() throws java.sql.SQLException
getSchemas
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getCatalogs() throws java.sql.SQLException
getCatalogs
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getTableTypes() throws java.sql.SQLException
getTableTypes
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern) throws java.sql.SQLException
getColumns
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern) throws java.sql.SQLException
getColumnPrivileges
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException
getTablePrivileges
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws java.sql.SQLException
getBestRowIdentifier
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getVersionColumns
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getPrimaryKeys
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getImportedKeys
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
getExportedKeys
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getCrossReference(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable) throws java.sql.SQLException
getCrossReference
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getTypeInfo() throws java.sql.SQLException
getTypeInfo
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate) throws java.sql.SQLException
getIndexInfo
in interface java.sql.DatabaseMetaData
public boolean supportsResultSetType(int type) throws java.sql.SQLException
supportsResultSetType
in interface java.sql.DatabaseMetaData
type
- defined in java.sql.ResultSet
true
if so; false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean supportsResultSetConcurrency(int type, int concurrency) throws java.sql.SQLException
supportsResultSetConcurrency
in interface java.sql.DatabaseMetaData
type
- defined in java.sql.ResultSet
concurrency
- type defined in java.sql.ResultSet
true
if so; false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean ownUpdatesAreVisible(int type) throws java.sql.SQLException
ownUpdatesAreVisible
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if updates are visible for the result set type;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean ownDeletesAreVisible(int type) throws java.sql.SQLException
ownDeletesAreVisible
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if deletes are visible for the result set type;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean ownInsertsAreVisible(int type) throws java.sql.SQLException
ownInsertsAreVisible
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if inserts are visible for the result set type;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean othersUpdatesAreVisible(int type) throws java.sql.SQLException
othersUpdatesAreVisible
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if updates made by others
are visible for the result set type;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean othersDeletesAreVisible(int type) throws java.sql.SQLException
othersDeletesAreVisible
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if deletes made by others
are visible for the result set type;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean othersInsertsAreVisible(int type) throws java.sql.SQLException
othersInsertsAreVisible
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXjava.sql.SQLException
- if a database access error occurspublic boolean updatesAreDetected(int type) throws java.sql.SQLException
ResultSet.rowUpdated
.updatesAreDetected
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if changes are detected by the result set type;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean deletesAreDetected(int type) throws java.sql.SQLException
deletesAreDetected
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXjava.sql.SQLException
- if a database access error occurspublic boolean insertsAreDetected(int type) throws java.sql.SQLException
insertsAreDetected
in interface java.sql.DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXjava.sql.SQLException
- if a database access error occurspublic boolean supportsBatchUpdates() throws java.sql.SQLException
supportsBatchUpdates
in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws java.sql.SQLException
Only types matching the catalog, schema, type name and type criteria are returned. They are ordered by DATA_TYPE, TYPE_SCHEM and TYPE_NAME. The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
Note: If the driver does not support UDTs, an empty result set is returned.
getUDTs
in interface java.sql.DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a
catalog; null means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schematypeNamePattern
- a type name pattern; may be a fully-qualified
nametypes
- a list of user-named types to include (JAVA_OBJECT,
STRUCT, or DISTINCT); null returns all typesResultSet
- each row is a type descriptionjava.sql.SQLException
- if a database access error occurspublic java.sql.Connection getConnection() throws java.sql.SQLException
getConnection
in interface java.sql.DatabaseMetaData
public boolean supportsSavepoints() throws java.sql.SQLException
true
if savepoints are supported;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean supportsNamedParameters() throws java.sql.SQLException
true
if named parameters are supported;
false
otherwisejava.sql.SQLException
- if a database access error occurspublic boolean supportsMultipleOpenResults() throws java.sql.SQLException
ResultSet
objects
returned from a CallableStatement
object
simultaneously.true
if a CallableStatement
object
can return multiple ResultSet
objects
simultaneously; false
otherwisejava.sql.SQLException
- if a datanase access error occurspublic boolean supportsGetGeneratedKeys() throws java.sql.SQLException
true
if auto-generated keys can be retrieved
after a statement has executed; false
otherwisejava.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern) throws java.sql.SQLException
Only supertype information for UDTs matching the catalog, schema, and type name is returned. The type name parameter may be a fully-qualified name. When the UDT name supplied is a fully-qualified name, the catalog and schemaPattern parameters are ignored.
If a UDT does not have a direct super type, it is not listed here.
A row of the ResultSet
object returned by this method
describes the designated UDT and a direct supertype. A row has the following
columns:
null
)
null
)
null
)
null
)
Note: If the driver does not support type hierarchies, an empty result set is returned.
catalog
- a catalog name; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schematypeNamePattern
- a UDT name pattern; may be a fully-qualified
nameResultSet
object in which a row gives information
about the designated UDTjava.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern) throws java.sql.SQLException
Only supertable information for tables matching the catalog, schema and table name are returned. The table name parameter may be a fully- qualified name, in which case, the catalog and schemaPattern parameters are ignored. If a table does not have a super table, it is not listed here. Supertables have to be defined in the same catalog and schema as the sub tables. Therefore, the type description does not need to include this information for the supertable.
Each type description has the following columns:
null
)
null
)
Note: If the driver does not support type hierarchies, an empty result set is returned.
catalog
- a catalog name; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those
without a schematableNamePattern
- a table name pattern; may be a fully-qualified
nameResultSet
object in which each row is a type descriptionjava.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern) throws java.sql.SQLException
Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria. They are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description does not contain inherited attributes.
The ResultSet
object that is returned has the following
columns:
null
)
null
)
null
)
null
)
null
if DATA_TYPE isn't REF)
null
if DATA_TYPE isn't REF)
null
if the DATA_TYPE isn't REF)
null
if DATA_TYPE
isn't DISTINCT or user-generated REF)
catalog
- a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow
the searchschemaPattern
- a schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow
the searchtypeNamePattern
- a type name pattern; must match the
type name as it is stored in the databaseattributeNamePattern
- an attribute name pattern; must match the attribute
name as it is declared in the databaseResultSet
object in which each row is an
attribute descriptionjava.sql.SQLException
- if a database access error occurspublic boolean supportsResultSetHoldability(int holdability) throws java.sql.SQLException
holdability
- one of the following constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT
or
ResultSet.CLOSE_CURSORS_AT_COMMIT- Returns:
true
if so; false
otherwise- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
Connection
public int getResultSetHoldability() throws java.sql.SQLException
ResultSet
object.ResultSet.HOLD_CURSORS_OVER_COMMIT
or
ResultSet.CLOSE_CURSORS_AT_COMMIT
java.sql.SQLException
- if a database access error occurspublic int getDatabaseMajorVersion() throws java.sql.SQLException
java.sql.SQLException
- if a database access error occurspublic int getDatabaseMinorVersion() throws java.sql.SQLException
java.sql.SQLException
- if a database access error occurspublic int getJDBCMajorVersion() throws java.sql.SQLException
java.sql.SQLException
- if a database access error occurspublic int getJDBCMinorVersion() throws java.sql.SQLException
java.sql.SQLException
- if a database access error occurspublic int getSQLStateType() throws java.sql.SQLException
SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99.java.sql.SQLException
- if a database access error occurspublic boolean locatorsUpdateCopy() throws java.sql.SQLException
true
if updates are made to a copy of the LOB;
false
if updates are made directly to the LOBjava.sql.SQLException
- if a database access error occurspublic boolean supportsStatementPooling() throws java.sql.SQLException
true
is so;
false
otherwiseSQLExcpetion
- if a database access error occurs
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |