public class JdbcDatabaseMetadata extends Object implements DatabaseMetaData
Modifier and Type | Field and Description |
---|---|
static String |
DRIVER_NAME
Driver name.
|
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getMaxLogicalLobSize, supportsRefCursors
public static final String DRIVER_NAME
public boolean allProceduresAreCallable()
allProceduresAreCallable
in interface DatabaseMetaData
public boolean allTablesAreSelectable()
allTablesAreSelectable
in interface DatabaseMetaData
public String getURL()
getURL
in interface DatabaseMetaData
public String getUserName()
getUserName
in interface DatabaseMetaData
public boolean isReadOnly()
isReadOnly
in interface DatabaseMetaData
public boolean nullsAreSortedHigh()
nullsAreSortedHigh
in interface DatabaseMetaData
public boolean nullsAreSortedLow()
nullsAreSortedLow
in interface DatabaseMetaData
public boolean nullsAreSortedAtStart()
nullsAreSortedAtStart
in interface DatabaseMetaData
public boolean nullsAreSortedAtEnd()
nullsAreSortedAtEnd
in interface DatabaseMetaData
public String getDatabaseProductName()
getDatabaseProductName
in interface DatabaseMetaData
public String getDatabaseProductVersion()
getDatabaseProductVersion
in interface DatabaseMetaData
public int getDatabaseMajorVersion()
getDatabaseMajorVersion
in interface DatabaseMetaData
public int getDatabaseMinorVersion()
getDatabaseMinorVersion
in interface DatabaseMetaData
public String getDriverName()
getDriverName
in interface DatabaseMetaData
public String getDriverVersion()
getDriverVersion
in interface DatabaseMetaData
public int getDriverMajorVersion()
getDriverMajorVersion
in interface DatabaseMetaData
public int getDriverMinorVersion()
getDriverMinorVersion
in interface DatabaseMetaData
public boolean usesLocalFiles()
usesLocalFiles
in interface DatabaseMetaData
public boolean usesLocalFilePerTable()
usesLocalFilePerTable
in interface DatabaseMetaData
public boolean supportsMixedCaseIdentifiers()
supportsMixedCaseIdentifiers
in interface DatabaseMetaData
public boolean storesUpperCaseIdentifiers()
storesUpperCaseIdentifiers
in interface DatabaseMetaData
public boolean storesLowerCaseIdentifiers()
storesLowerCaseIdentifiers
in interface DatabaseMetaData
public boolean storesMixedCaseIdentifiers()
storesMixedCaseIdentifiers
in interface DatabaseMetaData
public boolean supportsMixedCaseQuotedIdentifiers()
supportsMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
public boolean storesUpperCaseQuotedIdentifiers()
storesUpperCaseQuotedIdentifiers
in interface DatabaseMetaData
public boolean storesLowerCaseQuotedIdentifiers()
storesLowerCaseQuotedIdentifiers
in interface DatabaseMetaData
public boolean storesMixedCaseQuotedIdentifiers()
storesMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
public String getIdentifierQuoteString()
getIdentifierQuoteString
in interface DatabaseMetaData
public String getSQLKeywords()
getSQLKeywords
in interface DatabaseMetaData
public String getNumericFunctions()
getNumericFunctions
in interface DatabaseMetaData
public String getStringFunctions()
getStringFunctions
in interface DatabaseMetaData
public String getSystemFunctions()
getSystemFunctions
in interface DatabaseMetaData
public String getTimeDateFunctions()
getTimeDateFunctions
in interface DatabaseMetaData
public String getSearchStringEscape()
getSearchStringEscape
in interface DatabaseMetaData
public String getExtraNameCharacters()
getExtraNameCharacters
in interface DatabaseMetaData
public boolean supportsAlterTableWithAddColumn()
supportsAlterTableWithAddColumn
in interface DatabaseMetaData
public boolean supportsAlterTableWithDropColumn()
supportsAlterTableWithDropColumn
in interface DatabaseMetaData
public boolean supportsColumnAliasing()
supportsColumnAliasing
in interface DatabaseMetaData
public boolean nullPlusNonNullIsNull()
nullPlusNonNullIsNull
in interface DatabaseMetaData
public boolean supportsConvert()
supportsConvert
in interface DatabaseMetaData
public boolean supportsConvert(int fromType, int toType)
supportsConvert
in interface DatabaseMetaData
public boolean supportsTableCorrelationNames()
supportsTableCorrelationNames
in interface DatabaseMetaData
public boolean supportsDifferentTableCorrelationNames()
supportsDifferentTableCorrelationNames
in interface DatabaseMetaData
public boolean supportsExpressionsInOrderBy()
supportsExpressionsInOrderBy
in interface DatabaseMetaData
public boolean supportsOrderByUnrelated()
supportsOrderByUnrelated
in interface DatabaseMetaData
public boolean supportsGroupBy()
supportsGroupBy
in interface DatabaseMetaData
public boolean supportsGroupByUnrelated()
supportsGroupByUnrelated
in interface DatabaseMetaData
public boolean supportsGroupByBeyondSelect()
supportsGroupByBeyondSelect
in interface DatabaseMetaData
public boolean supportsLikeEscapeClause()
supportsLikeEscapeClause
in interface DatabaseMetaData
public boolean supportsMultipleResultSets()
supportsMultipleResultSets
in interface DatabaseMetaData
public boolean supportsMultipleTransactions()
supportsMultipleTransactions
in interface DatabaseMetaData
public boolean supportsNonNullableColumns()
supportsNonNullableColumns
in interface DatabaseMetaData
public boolean supportsMinimumSQLGrammar()
supportsMinimumSQLGrammar
in interface DatabaseMetaData
public boolean supportsCoreSQLGrammar()
supportsCoreSQLGrammar
in interface DatabaseMetaData
public boolean supportsExtendedSQLGrammar()
supportsExtendedSQLGrammar
in interface DatabaseMetaData
public boolean supportsANSI92EntryLevelSQL()
supportsANSI92EntryLevelSQL
in interface DatabaseMetaData
public boolean supportsANSI92IntermediateSQL()
supportsANSI92IntermediateSQL
in interface DatabaseMetaData
public boolean supportsANSI92FullSQL()
supportsANSI92FullSQL
in interface DatabaseMetaData
public boolean supportsIntegrityEnhancementFacility()
supportsIntegrityEnhancementFacility
in interface DatabaseMetaData
public boolean supportsOuterJoins()
supportsOuterJoins
in interface DatabaseMetaData
public boolean supportsFullOuterJoins()
supportsFullOuterJoins
in interface DatabaseMetaData
public boolean supportsLimitedOuterJoins()
supportsLimitedOuterJoins
in interface DatabaseMetaData
public String getSchemaTerm()
getSchemaTerm
in interface DatabaseMetaData
public String getProcedureTerm()
getProcedureTerm
in interface DatabaseMetaData
public String getCatalogTerm()
getCatalogTerm
in interface DatabaseMetaData
public boolean isCatalogAtStart()
isCatalogAtStart
in interface DatabaseMetaData
public String getCatalogSeparator()
getCatalogSeparator
in interface DatabaseMetaData
public boolean supportsSchemasInDataManipulation()
supportsSchemasInDataManipulation
in interface DatabaseMetaData
public boolean supportsSchemasInProcedureCalls()
supportsSchemasInProcedureCalls
in interface DatabaseMetaData
public boolean supportsSchemasInTableDefinitions()
supportsSchemasInTableDefinitions
in interface DatabaseMetaData
public boolean supportsSchemasInIndexDefinitions()
supportsSchemasInIndexDefinitions
in interface DatabaseMetaData
public boolean supportsSchemasInPrivilegeDefinitions()
supportsSchemasInPrivilegeDefinitions
in interface DatabaseMetaData
public boolean supportsCatalogsInDataManipulation()
supportsCatalogsInDataManipulation
in interface DatabaseMetaData
public boolean supportsCatalogsInProcedureCalls()
supportsCatalogsInProcedureCalls
in interface DatabaseMetaData
public boolean supportsCatalogsInTableDefinitions()
supportsCatalogsInTableDefinitions
in interface DatabaseMetaData
public boolean supportsCatalogsInIndexDefinitions()
supportsCatalogsInIndexDefinitions
in interface DatabaseMetaData
public boolean supportsCatalogsInPrivilegeDefinitions()
supportsCatalogsInPrivilegeDefinitions
in interface DatabaseMetaData
public boolean supportsPositionedDelete()
supportsPositionedDelete
in interface DatabaseMetaData
public boolean supportsPositionedUpdate()
supportsPositionedUpdate
in interface DatabaseMetaData
public boolean supportsSelectForUpdate()
supportsSelectForUpdate
in interface DatabaseMetaData
public boolean supportsStoredProcedures()
supportsStoredProcedures
in interface DatabaseMetaData
public boolean supportsSubqueriesInComparisons()
supportsSubqueriesInComparisons
in interface DatabaseMetaData
public boolean supportsSubqueriesInExists()
supportsSubqueriesInExists
in interface DatabaseMetaData
public boolean supportsSubqueriesInIns()
supportsSubqueriesInIns
in interface DatabaseMetaData
public boolean supportsSubqueriesInQuantifieds()
supportsSubqueriesInQuantifieds
in interface DatabaseMetaData
public boolean supportsCorrelatedSubqueries()
supportsCorrelatedSubqueries
in interface DatabaseMetaData
public boolean supportsUnion()
supportsUnion
in interface DatabaseMetaData
public boolean supportsUnionAll()
supportsUnionAll
in interface DatabaseMetaData
public boolean supportsOpenCursorsAcrossCommit()
supportsOpenCursorsAcrossCommit
in interface DatabaseMetaData
public boolean supportsOpenCursorsAcrossRollback()
supportsOpenCursorsAcrossRollback
in interface DatabaseMetaData
public boolean supportsOpenStatementsAcrossCommit()
supportsOpenStatementsAcrossCommit
in interface DatabaseMetaData
public boolean supportsOpenStatementsAcrossRollback()
supportsOpenStatementsAcrossRollback
in interface DatabaseMetaData
public int getMaxBinaryLiteralLength()
getMaxBinaryLiteralLength
in interface DatabaseMetaData
public int getMaxCharLiteralLength()
getMaxCharLiteralLength
in interface DatabaseMetaData
public int getMaxColumnNameLength()
getMaxColumnNameLength
in interface DatabaseMetaData
public int getMaxColumnsInGroupBy()
getMaxColumnsInGroupBy
in interface DatabaseMetaData
public int getMaxColumnsInIndex()
getMaxColumnsInIndex
in interface DatabaseMetaData
public int getMaxColumnsInOrderBy()
getMaxColumnsInOrderBy
in interface DatabaseMetaData
public int getMaxColumnsInSelect()
getMaxColumnsInSelect
in interface DatabaseMetaData
public int getMaxColumnsInTable()
getMaxColumnsInTable
in interface DatabaseMetaData
public int getMaxConnections()
getMaxConnections
in interface DatabaseMetaData
public int getMaxCursorNameLength()
getMaxCursorNameLength
in interface DatabaseMetaData
public int getMaxIndexLength()
getMaxIndexLength
in interface DatabaseMetaData
public int getMaxSchemaNameLength()
getMaxSchemaNameLength
in interface DatabaseMetaData
public int getMaxProcedureNameLength()
getMaxProcedureNameLength
in interface DatabaseMetaData
public int getMaxCatalogNameLength()
getMaxCatalogNameLength
in interface DatabaseMetaData
public int getMaxRowSize()
getMaxRowSize
in interface DatabaseMetaData
public boolean doesMaxRowSizeIncludeBlobs()
doesMaxRowSizeIncludeBlobs
in interface DatabaseMetaData
public int getMaxStatementLength()
getMaxStatementLength
in interface DatabaseMetaData
public int getMaxStatements()
getMaxStatements
in interface DatabaseMetaData
public int getMaxTableNameLength()
getMaxTableNameLength
in interface DatabaseMetaData
public int getMaxTablesInSelect()
getMaxTablesInSelect
in interface DatabaseMetaData
public int getMaxUserNameLength()
getMaxUserNameLength
in interface DatabaseMetaData
public int getDefaultTransactionIsolation()
getDefaultTransactionIsolation
in interface DatabaseMetaData
public boolean supportsTransactions()
supportsTransactions
in interface DatabaseMetaData
public boolean supportsTransactionIsolationLevel(int level)
supportsTransactionIsolationLevel
in interface DatabaseMetaData
public boolean supportsDataDefinitionAndDataManipulationTransactions()
supportsDataDefinitionAndDataManipulationTransactions
in interface DatabaseMetaData
public boolean supportsDataManipulationTransactionsOnly()
supportsDataManipulationTransactionsOnly
in interface DatabaseMetaData
public boolean dataDefinitionCausesTransactionCommit()
dataDefinitionCausesTransactionCommit
in interface DatabaseMetaData
public boolean dataDefinitionIgnoredInTransactions()
dataDefinitionIgnoredInTransactions
in interface DatabaseMetaData
public ResultSet getProcedures(String catalog, String schemaPtrn, String procedureNamePtrn) throws SQLException
getProcedures
in interface DatabaseMetaData
SQLException
public ResultSet getProcedureColumns(String catalog, String schemaPtrn, String procedureNamePtrn, String colNamePtrn) throws SQLException
getProcedureColumns
in interface DatabaseMetaData
SQLException
public ResultSet getTables(String catalog, String schemaPtrn, String tblNamePtrn, String[] tblTypes) throws SQLException
getTables
in interface DatabaseMetaData
SQLException
public ResultSet getSchemas() throws SQLException
getSchemas
in interface DatabaseMetaData
SQLException
public ResultSet getCatalogs() throws SQLException
getCatalogs
in interface DatabaseMetaData
SQLException
public ResultSet getTableTypes() throws SQLException
getTableTypes
in interface DatabaseMetaData
SQLException
public ResultSet getColumns(String catalog, String schemaPtrn, String tblNamePtrn, String colNamePtrn) throws SQLException
getColumns
in interface DatabaseMetaData
SQLException
public ResultSet getColumnPrivileges(String catalog, String schema, String tbl, String colNamePtrn) throws SQLException
getColumnPrivileges
in interface DatabaseMetaData
SQLException
public ResultSet getTablePrivileges(String catalog, String schemaPtrn, String tblNamePtrn) throws SQLException
getTablePrivileges
in interface DatabaseMetaData
SQLException
public ResultSet getBestRowIdentifier(String catalog, String schema, String tbl, int scope, boolean nullable) throws SQLException
getBestRowIdentifier
in interface DatabaseMetaData
SQLException
public ResultSet getVersionColumns(String catalog, String schema, String tbl) throws SQLException
getVersionColumns
in interface DatabaseMetaData
SQLException
public ResultSet getPrimaryKeys(String catalog, String schemaPtrn, String tblNamePtrn) throws SQLException
getPrimaryKeys
in interface DatabaseMetaData
SQLException
public ResultSet getImportedKeys(String catalog, String schema, String tbl) throws SQLException
getImportedKeys
in interface DatabaseMetaData
SQLException
public ResultSet getExportedKeys(String catalog, String schema, String tbl) throws SQLException
getExportedKeys
in interface DatabaseMetaData
SQLException
public ResultSet getCrossReference(String parentCatalog, String parentSchema, String parentTbl, String foreignCatalog, String foreignSchema, String foreignTbl) throws SQLException
getCrossReference
in interface DatabaseMetaData
SQLException
public ResultSet getTypeInfo() throws SQLException
getTypeInfo
in interface DatabaseMetaData
SQLException
public ResultSet getIndexInfo(String catalog, String schema, String tbl, boolean unique, boolean approximate) throws SQLException
getIndexInfo
in interface DatabaseMetaData
SQLException
public boolean supportsResultSetType(int type)
supportsResultSetType
in interface DatabaseMetaData
public boolean supportsResultSetConcurrency(int type, int concurrency)
supportsResultSetConcurrency
in interface DatabaseMetaData
public boolean ownUpdatesAreVisible(int type)
ownUpdatesAreVisible
in interface DatabaseMetaData
public boolean ownDeletesAreVisible(int type)
ownDeletesAreVisible
in interface DatabaseMetaData
public boolean ownInsertsAreVisible(int type)
ownInsertsAreVisible
in interface DatabaseMetaData
public boolean othersUpdatesAreVisible(int type)
othersUpdatesAreVisible
in interface DatabaseMetaData
public boolean othersDeletesAreVisible(int type)
othersDeletesAreVisible
in interface DatabaseMetaData
public boolean othersInsertsAreVisible(int type)
othersInsertsAreVisible
in interface DatabaseMetaData
public boolean updatesAreDetected(int type)
updatesAreDetected
in interface DatabaseMetaData
public boolean deletesAreDetected(int type)
deletesAreDetected
in interface DatabaseMetaData
public boolean insertsAreDetected(int type)
insertsAreDetected
in interface DatabaseMetaData
public boolean supportsBatchUpdates()
supportsBatchUpdates
in interface DatabaseMetaData
public ResultSet getUDTs(String catalog, String schemaPtrn, String typeNamePtrn, int[] types) throws SQLException
getUDTs
in interface DatabaseMetaData
SQLException
public Connection getConnection()
getConnection
in interface DatabaseMetaData
public boolean supportsSavepoints()
supportsSavepoints
in interface DatabaseMetaData
public boolean supportsNamedParameters()
supportsNamedParameters
in interface DatabaseMetaData
public boolean supportsMultipleOpenResults()
supportsMultipleOpenResults
in interface DatabaseMetaData
public boolean supportsGetGeneratedKeys()
supportsGetGeneratedKeys
in interface DatabaseMetaData
public ResultSet getSuperTypes(String catalog, String schemaPtrn, String typeNamePtrn) throws SQLException
getSuperTypes
in interface DatabaseMetaData
SQLException
public ResultSet getSuperTables(String catalog, String schemaPtrn, String tblNamePtrn) throws SQLException
getSuperTables
in interface DatabaseMetaData
SQLException
public ResultSet getAttributes(String catalog, String schemaPtrn, String typeNamePtrn, String attributeNamePtrn) throws SQLException
getAttributes
in interface DatabaseMetaData
SQLException
public boolean supportsResultSetHoldability(int holdability)
supportsResultSetHoldability
in interface DatabaseMetaData
public int getResultSetHoldability()
getResultSetHoldability
in interface DatabaseMetaData
public int getJDBCMajorVersion()
getJDBCMajorVersion
in interface DatabaseMetaData
public int getJDBCMinorVersion()
getJDBCMinorVersion
in interface DatabaseMetaData
public int getSQLStateType()
getSQLStateType
in interface DatabaseMetaData
public boolean locatorsUpdateCopy()
locatorsUpdateCopy
in interface DatabaseMetaData
public boolean supportsStatementPooling()
supportsStatementPooling
in interface DatabaseMetaData
public RowIdLifetime getRowIdLifetime()
getRowIdLifetime
in interface DatabaseMetaData
public ResultSet getSchemas(String catalog, String schemaPtrn) throws SQLException
getSchemas
in interface DatabaseMetaData
SQLException
public boolean supportsStoredFunctionsUsingCallSyntax()
supportsStoredFunctionsUsingCallSyntax
in interface DatabaseMetaData
public boolean autoCommitFailureClosesAllResultSets()
autoCommitFailureClosesAllResultSets
in interface DatabaseMetaData
public boolean generatedKeyAlwaysReturned()
generatedKeyAlwaysReturned
in interface DatabaseMetaData
public ResultSet getClientInfoProperties() throws SQLException
getClientInfoProperties
in interface DatabaseMetaData
SQLException
public ResultSet getFunctions(String catalog, String schemaPtrn, String functionNamePtrn) throws SQLException
getFunctions
in interface DatabaseMetaData
SQLException
public ResultSet getFunctionColumns(String catalog, String schemaPtrn, String functionNamePtrn, String colNamePtrn) throws SQLException
getFunctionColumns
in interface DatabaseMetaData
SQLException
public ResultSet getPseudoColumns(String catalog, String schemaPtrn, String tblNamePtrn, String colNamePtrn) throws SQLException
getPseudoColumns
in interface DatabaseMetaData
SQLException
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
SQLException
public boolean isWrapperFor(Class<?> iface)
isWrapperFor
in interface Wrapper
Follow @ApacheIgnite
Ignite Database and Caching Platform : ver. 2.10.0 Release Date : March 10 2021