public class DatabaseMetaDataImpl extends WrapperImpl implements DatabaseMetaData
Modifier and Type | Field and Description |
---|---|
static String |
NULL_SORT |
static String |
REPORT_AS_VIEWS |
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
Modifier and Type | Method and Description |
---|---|
boolean |
allProceduresAreCallable() |
boolean |
allTablesAreSelectable() |
boolean |
autoCommitFailureClosesAllResultSets() |
boolean |
dataDefinitionCausesTransactionCommit()
Checks whether a DDL statement within a transaction forces the transaction
to commit.
|
boolean |
dataDefinitionIgnoredInTransactions()
Checks whether a DDL statement within a transaction is ignored.
|
boolean |
deletesAreDetected(int type) |
boolean |
doesMaxRowSizeIncludeBlobs()
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY
blobs?
|
boolean |
generatedKeyAlwaysReturned() |
ResultSet |
getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern) |
ResultSet |
getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable) |
ResultSet |
getCatalogs() |
String |
getCatalogSeparator()
Gets the String object used to separate a catalog name and a table name
|
String |
getCatalogTerm() |
ResultSet |
getClientInfoProperties() |
ResultSet |
getColumnPrivileges(String catalog,
String schema,
String table,
String columnName) |
ResultSet |
getColumns(String catalog,
String schema,
String tableNamePattern,
String columnNamePattern) |
Connection |
getConnection() |
ResultSet |
getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable) |
int |
getDatabaseMajorVersion()
Retrieves the major version number of the underlying database.
|
int |
getDatabaseMinorVersion()
Retrieves the minor version number of the underlying database.
|
String |
getDatabaseProductName()
Gets the product name for this database
|
String |
getDatabaseProductVersion() |
int |
getDefaultTransactionIsolation() |
int |
getDriverMajorVersion()
Gets this drivers major version number
|
int |
getDriverMinorVersion()
Gets this drivers minor version number
|
String |
getDriverName()
Get the name of this JDBC driver
|
String |
getDriverVersion()
This method gets the version of this JDBC driver.
|
ResultSet |
getExportedKeys(String catalog,
String schema,
String table) |
String |
getExtraNameCharacters()
Gets the extra characters that can be used in unquoted identifier names
(those beyond a-z, 0-9, and _)
|
ResultSet |
getFunctionColumns(String catalog,
String schemaPattern,
String functionNamePattern,
String columnNamePattern) |
ResultSet |
getFunctions(String catalog,
String schemaPattern,
String functionNamePattern) |
String |
getIdentifierQuoteString()
Get's the string used to quote SQL identifiers.
|
ResultSet |
getImportedKeys(String catalog,
String schema,
String table) |
ResultSet |
getIndexInfo(String catalog,
String schema,
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()
Gets the maximum number of hexadecimal characters allowed in an inline
binary literal
|
int |
getMaxCatalogNameLength()
Gets the maximum number of characters allowed in a catalog name
|
int |
getMaxCharLiteralLength()
Gets the maximum number of characters allowed in a character literal
|
int |
getMaxColumnNameLength()
Gets the maximum number of characters allowed in a column name
|
int |
getMaxColumnsInGroupBy()
Gets the maximum number of columns allowed in a GROUP BY clause
|
int |
getMaxColumnsInIndex()
Gets the maximum number of columns allowed in an index
|
int |
getMaxColumnsInOrderBy()
Gets the maximum number of columns allowed in a ORDER BY clause
|
int |
getMaxColumnsInSelect()
Gets the maximum number of columns allowed in a SELECT clause
|
int |
getMaxColumnsInTable() |
int |
getMaxConnections() |
int |
getMaxCursorNameLength() |
int |
getMaxIndexLength() |
int |
getMaxProcedureNameLength()
Gets the maximum number of characters allowed in a procedure name
|
int |
getMaxRowSize()
Gets the maximum number of bytes allowed in a single row
|
int |
getMaxSchemaNameLength()
Gets the maximum number of characters allowed in a schema name
|
int |
getMaxStatementLength()
Gets the maximum number of characters allowed in an SQL statement
|
int |
getMaxStatements()
Gets the maximum number of active statements that may be open on one
connection at any time
|
int |
getMaxTableNameLength()
Gets the maximum number of characters allowed in a table name
|
int |
getMaxTablesInSelect()
Gets the maximum number of tables allowed in a SELECT clause
|
int |
getMaxUserNameLength()
Gets the maximum number of characters allowed in a user name
|
String |
getNumericFunctions() |
ResultSet |
getPrimaryKeys(String catalog,
String schema,
String table) |
ResultSet |
getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern) |
ResultSet |
getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern) |
String |
getProcedureTerm() |
ResultSet |
getPseudoColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern) |
int |
getResultSetHoldability() |
RowIdLifetime |
getRowIdLifetime() |
ResultSet |
getSchemas() |
ResultSet |
getSchemas(String catalog,
String schemaPattern) |
String |
getSchemaTerm() |
String |
getSearchStringEscape()
Gets the string that can be used to escape "_" or "%" wildcards in the
string search pattern used for search parameters
|
String |
getSQLKeywords() |
int |
getSQLStateType()
Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open
(now known as Open Group) SQL CLI or SQL99.
|
String |
getStringFunctions() |
ResultSet |
getSuperTables(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the table hierarchies defined in a
particular schema in this database.
|
ResultSet |
getSuperTypes(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies
defined in a particular schema in this database.
|
String |
getSystemFunctions() |
ResultSet |
getTablePrivileges(String catalog,
String schemaPattern,
String tableName) |
ResultSet |
getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types) |
ResultSet |
getTableTypes() |
String |
getTimeDateFunctions() |
ResultSet |
getTypeInfo() |
ResultSet |
getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
Gets a description of the user-defined types defined in a particular
schema.
|
String |
getURL() |
String |
getUserName() |
ResultSet |
getVersionColumns(String catalog,
String schema,
String table) |
boolean |
insertsAreDetected(int type) |
boolean |
isCatalogAtStart()
Checks whether a catalog name appears at the start of a fully qualified table
name.
|
boolean |
isReadOnly() |
boolean |
locatorsUpdateCopy()
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
|
boolean |
nullPlusNonNullIsNull()
Checks whether the concatenation of a NULL value and a non-NULL value results
in a NULL value.
|
boolean |
nullsAreSortedAtEnd()
Checks whether NULL values are sorted at the end regardless of sort order.
|
boolean |
nullsAreSortedAtStart()
Checks whether NULL values are sorted at the start regardless of sort order.
|
boolean |
nullsAreSortedHigh()
Checks whether NULL values are sorted high.
|
boolean |
nullsAreSortedLow()
Checks whether NULL values are sorted low.
|
boolean |
othersDeletesAreVisible(int type) |
boolean |
othersInsertsAreVisible(int type) |
boolean |
othersUpdatesAreVisible(int type) |
boolean |
ownDeletesAreVisible(int type) |
boolean |
ownInsertsAreVisible(int type) |
boolean |
ownUpdatesAreVisible(int type) |
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() |
boolean |
supportsGroupBy() |
boolean |
supportsGroupByBeyondSelect() |
boolean |
supportsGroupByUnrelated() |
boolean |
supportsIntegrityEnhancementFacility() |
boolean |
supportsLikeEscapeClause() |
boolean |
supportsLimitedOuterJoins() |
boolean |
supportsMinimumSQLGrammar() |
boolean |
supportsMixedCaseIdentifiers() |
boolean |
supportsMixedCaseQuotedIdentifiers() |
boolean |
supportsMultipleOpenResults() |
boolean |
supportsMultipleResultSets() |
boolean |
supportsMultipleTransactions() |
boolean |
supportsNamedParameters() |
boolean |
supportsNonNullableColumns() |
boolean |
supportsOpenCursorsAcrossCommit() |
boolean |
supportsOpenCursorsAcrossRollback() |
boolean |
supportsOpenStatementsAcrossCommit() |
boolean |
supportsOpenStatementsAcrossRollback() |
boolean |
supportsOrderByUnrelated() |
boolean |
supportsOuterJoins() |
boolean |
supportsPositionedDelete() |
boolean |
supportsPositionedUpdate() |
boolean |
supportsResultSetConcurrency(int type,
int concurrency) |
boolean |
supportsResultSetHoldability(int holdability) |
boolean |
supportsResultSetType(int type)
Does the database support the given result set type?
|
boolean |
supportsSavepoints() |
boolean |
supportsSchemasInDataManipulation() |
boolean |
supportsSchemasInIndexDefinitions() |
boolean |
supportsSchemasInPrivilegeDefinitions() |
boolean |
supportsSchemasInProcedureCalls() |
boolean |
supportsSchemasInTableDefinitions() |
boolean |
supportsSelectForUpdate() |
boolean |
supportsStatementPooling() |
boolean |
supportsStoredFunctionsUsingCallSyntax() |
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) |
boolean |
usesLocalFilePerTable() |
boolean |
usesLocalFiles() |
isWrapperFor, unwrap
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getMaxLogicalLobSize, supportsRefCursors
isWrapperFor, unwrap
public static final String REPORT_AS_VIEWS
public static final String NULL_SORT
public boolean allProceduresAreCallable() throws SQLException
allProceduresAreCallable
in interface DatabaseMetaData
SQLException
public boolean allTablesAreSelectable() throws SQLException
allTablesAreSelectable
in interface DatabaseMetaData
SQLException
public boolean dataDefinitionCausesTransactionCommit() throws SQLException
Checks whether a DDL statement within a transaction forces the transaction to commit.
dataDefinitionCausesTransactionCommit
in interface DatabaseMetaData
SQLException
- Should never occur.public boolean dataDefinitionIgnoredInTransactions() throws SQLException
Checks whether a DDL statement within a transaction is ignored.
dataDefinitionIgnoredInTransactions
in interface DatabaseMetaData
SQLException
- Should never occur.public boolean deletesAreDetected(int type) throws SQLException
deletesAreDetected
in interface DatabaseMetaData
SQLException
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
doesMaxRowSizeIncludeBlobs
in interface DatabaseMetaData
true
if so; false
otherwiseSQLException
- should never occurpublic ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
getBestRowIdentifier
in interface DatabaseMetaData
SQLException
public ResultSet getCatalogs() throws SQLException
getCatalogs
in interface DatabaseMetaData
SQLException
public String getCatalogSeparator() throws SQLException
Gets the String object used to separate a catalog name and a table name
getCatalogSeparator
in interface DatabaseMetaData
SQLException
- should never occur.public String getCatalogTerm() throws SQLException
getCatalogTerm
in interface DatabaseMetaData
SQLException
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnName) throws SQLException
getColumnPrivileges
in interface DatabaseMetaData
SQLException
public ResultSet getColumns(String catalog, String schema, String tableNamePattern, String columnNamePattern) throws SQLException
getColumns
in interface DatabaseMetaData
SQLException
public ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException
getCrossReference
in interface DatabaseMetaData
SQLException
public int getDatabaseMinorVersion() throws SQLException
getDatabaseMinorVersion
in interface DatabaseMetaData
SQLException
- if a database access error occurs.public int getDatabaseMajorVersion() throws SQLException
getDatabaseMajorVersion
in interface DatabaseMetaData
SQLException
- if a database access error occurs.public int getJDBCMajorVersion() throws SQLException
getJDBCMajorVersion
in interface DatabaseMetaData
SQLException
- should never occur.public int getJDBCMinorVersion() throws SQLException
getJDBCMinorVersion
in interface DatabaseMetaData
SQLException
- should never occur.public String getDatabaseProductName() throws SQLException
Gets the product name for this database
getDatabaseProductName
in interface DatabaseMetaData
SQLException
- should never occur.public String getDatabaseProductVersion() throws SQLException
getDatabaseProductVersion
in interface DatabaseMetaData
SQLException
public int getDefaultTransactionIsolation() throws SQLException
getDefaultTransactionIsolation
in interface DatabaseMetaData
SQLException
public int getDriverMajorVersion()
Gets this drivers major version number
getDriverMajorVersion
in interface DatabaseMetaData
public int getDriverMinorVersion()
Gets this drivers minor version number
getDriverMinorVersion
in interface DatabaseMetaData
public String getDriverName() throws SQLException
Get the name of this JDBC driver
getDriverName
in interface DatabaseMetaData
SQLException
- if the connection is already closed.public String getDriverVersion() throws SQLException
This method gets the version of this JDBC driver. It combines the major and minor version numbers
getDriverVersion
in interface DatabaseMetaData
SQLException
- should never occur.public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException
getExportedKeys
in interface DatabaseMetaData
SQLException
public String getExtraNameCharacters() throws SQLException
Gets the extra characters that can be used in unquoted identifier names (those beyond a-z, 0-9, and _)
getExtraNameCharacters
in interface DatabaseMetaData
SQLException
- should never occurpublic String getIdentifierQuoteString() throws SQLException
Get's the string used to quote SQL identifiers. This returns a " " if identifier quoting is not supported.
getIdentifierQuoteString
in interface DatabaseMetaData
SQLException
- should never occurpublic ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException
getImportedKeys
in interface DatabaseMetaData
SQLException
public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
getIndexInfo
in interface DatabaseMetaData
SQLException
public int getMaxBinaryLiteralLength() throws SQLException
Gets the maximum number of hexadecimal characters allowed in an inline binary literal
getMaxBinaryLiteralLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxCatalogNameLength() throws SQLException
Gets the maximum number of characters allowed in a catalog name
getMaxCatalogNameLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxCharLiteralLength() throws SQLException
Gets the maximum number of characters allowed in a character literal
getMaxCharLiteralLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxColumnNameLength() throws SQLException
Gets the maximum number of characters allowed in a column name
getMaxColumnNameLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxColumnsInGroupBy() throws SQLException
Gets the maximum number of columns allowed in a GROUP BY clause
getMaxColumnsInGroupBy
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxColumnsInIndex() throws SQLException
Gets the maximum number of columns allowed in an index
getMaxColumnsInIndex
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxColumnsInOrderBy() throws SQLException
Gets the maximum number of columns allowed in a ORDER BY clause
getMaxColumnsInOrderBy
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxColumnsInSelect() throws SQLException
Gets the maximum number of columns allowed in a SELECT clause
getMaxColumnsInSelect
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxColumnsInTable() throws SQLException
getMaxColumnsInTable
in interface DatabaseMetaData
SQLException
public int getMaxConnections() throws SQLException
getMaxConnections
in interface DatabaseMetaData
SQLException
public int getMaxCursorNameLength() throws SQLException
getMaxCursorNameLength
in interface DatabaseMetaData
SQLException
public int getMaxIndexLength() throws SQLException
getMaxIndexLength
in interface DatabaseMetaData
SQLException
public int getMaxProcedureNameLength() throws SQLException
Gets the maximum number of characters allowed in a procedure name
getMaxProcedureNameLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxRowSize() throws SQLException
Gets the maximum number of bytes allowed in a single row
getMaxRowSize
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxSchemaNameLength() throws SQLException
Gets the maximum number of characters allowed in a schema name
getMaxSchemaNameLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxStatementLength() throws SQLException
Gets the maximum number of characters allowed in an SQL statement
getMaxStatementLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxStatements() throws SQLException
Gets the maximum number of active statements that may be open on one connection at any time
getMaxStatements
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxTableNameLength() throws SQLException
Gets the maximum number of characters allowed in a table name
getMaxTableNameLength
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxTablesInSelect() throws SQLException
Gets the maximum number of tables allowed in a SELECT clause
getMaxTablesInSelect
in interface DatabaseMetaData
SQLException
- should never occurpublic int getMaxUserNameLength() throws SQLException
Gets the maximum number of characters allowed in a user name
getMaxUserNameLength
in interface DatabaseMetaData
SQLException
- should never occurpublic String getNumericFunctions() throws SQLException
getNumericFunctions
in interface DatabaseMetaData
SQLException
public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException
getPrimaryKeys
in interface DatabaseMetaData
SQLException
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
getProcedureColumns
in interface DatabaseMetaData
SQLException
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException
getProcedures
in interface DatabaseMetaData
SQLException
public String getProcedureTerm() throws SQLException
getProcedureTerm
in interface DatabaseMetaData
SQLException
public ResultSet getSchemas() throws SQLException
getSchemas
in interface DatabaseMetaData
SQLException
public String getSchemaTerm() throws SQLException
getSchemaTerm
in interface DatabaseMetaData
SQLException
public String getSearchStringEscape() throws SQLException
Gets the string that can be used to escape "_" or "%" wildcards in the string search pattern used for search parameters
getSearchStringEscape
in interface DatabaseMetaData
SQLException
- should never occurpublic String getSQLKeywords() throws SQLException
getSQLKeywords
in interface DatabaseMetaData
SQLException
public int getSQLStateType() throws SQLException
getSQLStateType
in interface DatabaseMetaData
SQLException
public String getStringFunctions() throws SQLException
getStringFunctions
in interface DatabaseMetaData
SQLException
public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
getSuperTables
in interface DatabaseMetaData
catalog
- A catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteria.schemaPattern
- A schema name pattern; "" retrieves those without a schema.tableNamePattern
- A table name pattern; may be a fully-qualified name.SQLException
- since not supportedpublic ResultSet getSuperTypes(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
getSuperTypes
in interface DatabaseMetaData
catalog
- A catalog name; "" retrieves those without a catalog;
null means drop catalog name from the selection criteria.schemaPattern
- A schema name pattern; "" retrieves those without a schema.tableNamePattern
- A table name pattern; may be a fully-qualified name.SQLException
public String getSystemFunctions() throws SQLException
getSystemFunctions
in interface DatabaseMetaData
SQLException
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableName) throws SQLException
getTablePrivileges
in interface DatabaseMetaData
SQLException
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
getTables
in interface DatabaseMetaData
SQLException
public ResultSet getTableTypes() throws SQLException
getTableTypes
in interface DatabaseMetaData
SQLException
public String getTimeDateFunctions() throws SQLException
getTimeDateFunctions
in interface DatabaseMetaData
SQLException
public ResultSet getTypeInfo() throws SQLException
getTypeInfo
in interface DatabaseMetaData
SQLException
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
Gets a description of the user-defined types defined in a particular schema. Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT. Supports 1.4
getUDTs
in interface DatabaseMetaData
catalog
- a catalog nameschemaPattern
- a schema name patterntypeNamePattern
- a type name patterntypes
- a list of user-named types to include (JAVA_OBJECT, STRUCT,
or DISTINCT); null returns all typesSQLException
- if catalog/schema info does not match for the given connection.public String getURL() throws SQLException
getURL
in interface DatabaseMetaData
SQLException
public String getUserName() throws SQLException
getUserName
in interface DatabaseMetaData
SQLException
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException
getVersionColumns
in interface DatabaseMetaData
SQLException
public boolean isCatalogAtStart() throws SQLException
Checks whether a catalog name appears at the start of a fully qualified table name. If it is not at the beginning, it appears at the end.
isCatalogAtStart
in interface DatabaseMetaData
SQLException
- should never occur.public boolean insertsAreDetected(int type) throws SQLException
insertsAreDetected
in interface DatabaseMetaData
SQLException
public boolean isReadOnly() throws SQLException
isReadOnly
in interface DatabaseMetaData
SQLException
public boolean locatorsUpdateCopy() throws SQLException
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
locatorsUpdateCopy
in interface DatabaseMetaData
SQLException
- should never occur.public boolean nullPlusNonNullIsNull() throws SQLException
Checks whether the concatenation of a NULL value and a non-NULL value results in a NULL value.
nullPlusNonNullIsNull
in interface DatabaseMetaData
SQLException
- should never occur.public boolean nullsAreSortedAtEnd() throws SQLException
Checks whether NULL values are sorted at the end regardless of sort order.
nullsAreSortedAtEnd
in interface DatabaseMetaData
SQLException
- should never occur.public boolean nullsAreSortedAtStart() throws SQLException
Checks whether NULL values are sorted at the start regardless of sort order.
nullsAreSortedAtStart
in interface DatabaseMetaData
SQLException
- should never occur.public boolean nullsAreSortedHigh() throws SQLException
Checks whether NULL values are sorted high.
nullsAreSortedHigh
in interface DatabaseMetaData
SQLException
- should never occur.public boolean nullsAreSortedLow() throws SQLException
Checks whether NULL values are sorted low.
nullsAreSortedLow
in interface DatabaseMetaData
SQLException
- should never occur.public boolean ownUpdatesAreVisible(int type) throws SQLException
ownUpdatesAreVisible
in interface DatabaseMetaData
SQLException
public boolean ownDeletesAreVisible(int type) throws SQLException
ownDeletesAreVisible
in interface DatabaseMetaData
SQLException
public boolean ownInsertsAreVisible(int type) throws SQLException
ownInsertsAreVisible
in interface DatabaseMetaData
SQLException
public boolean othersUpdatesAreVisible(int type) throws SQLException
othersUpdatesAreVisible
in interface DatabaseMetaData
SQLException
public boolean othersDeletesAreVisible(int type) throws SQLException
othersDeletesAreVisible
in interface DatabaseMetaData
SQLException
public boolean othersInsertsAreVisible(int type) throws SQLException
othersInsertsAreVisible
in interface DatabaseMetaData
SQLException
public boolean storesLowerCaseIdentifiers() throws SQLException
storesLowerCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
storesLowerCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesMixedCaseIdentifiers() throws SQLException
storesMixedCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
storesMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesUpperCaseIdentifiers() throws SQLException
storesUpperCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
storesUpperCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean supportsAlterTableWithAddColumn() throws SQLException
supportsAlterTableWithAddColumn
in interface DatabaseMetaData
SQLException
public boolean supportsAlterTableWithDropColumn() throws SQLException
supportsAlterTableWithDropColumn
in interface DatabaseMetaData
SQLException
public boolean supportsANSI92EntryLevelSQL() throws SQLException
supportsANSI92EntryLevelSQL
in interface DatabaseMetaData
SQLException
public boolean supportsANSI92FullSQL() throws SQLException
supportsANSI92FullSQL
in interface DatabaseMetaData
SQLException
public boolean supportsANSI92IntermediateSQL() throws SQLException
supportsANSI92IntermediateSQL
in interface DatabaseMetaData
SQLException
public boolean supportsBatchUpdates() throws SQLException
Indicates whether the driver supports batch updates.
supportsBatchUpdates
in interface DatabaseMetaData
SQLException
- should never occurpublic boolean supportsCatalogsInDataManipulation() throws SQLException
supportsCatalogsInDataManipulation
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInIndexDefinitions() throws SQLException
supportsCatalogsInIndexDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
supportsCatalogsInPrivilegeDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInProcedureCalls() throws SQLException
supportsCatalogsInProcedureCalls
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInTableDefinitions() throws SQLException
supportsCatalogsInTableDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsColumnAliasing() throws SQLException
supportsColumnAliasing
in interface DatabaseMetaData
SQLException
public boolean supportsConvert() throws SQLException
supportsConvert
in interface DatabaseMetaData
SQLException
public boolean supportsConvert(int fromType, int toType) throws SQLException
supportsConvert
in interface DatabaseMetaData
SQLException
public boolean supportsCorrelatedSubqueries() throws SQLException
supportsCorrelatedSubqueries
in interface DatabaseMetaData
SQLException
public boolean supportsCoreSQLGrammar() throws SQLException
supportsCoreSQLGrammar
in interface DatabaseMetaData
SQLException
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
supportsDataDefinitionAndDataManipulationTransactions
in interface DatabaseMetaData
SQLException
public boolean supportsDataManipulationTransactionsOnly() throws SQLException
supportsDataManipulationTransactionsOnly
in interface DatabaseMetaData
SQLException
public boolean supportsDifferentTableCorrelationNames() throws SQLException
supportsDifferentTableCorrelationNames
in interface DatabaseMetaData
SQLException
public boolean supportsExpressionsInOrderBy() throws SQLException
supportsExpressionsInOrderBy
in interface DatabaseMetaData
SQLException
public boolean supportsExtendedSQLGrammar() throws SQLException
supportsExtendedSQLGrammar
in interface DatabaseMetaData
SQLException
public boolean supportsFullOuterJoins() throws SQLException
supportsFullOuterJoins
in interface DatabaseMetaData
SQLException
public boolean supportsGetGeneratedKeys() throws SQLException
supportsGetGeneratedKeys
in interface DatabaseMetaData
SQLException
public boolean supportsGroupBy() throws SQLException
supportsGroupBy
in interface DatabaseMetaData
SQLException
public boolean supportsGroupByBeyondSelect() throws SQLException
supportsGroupByBeyondSelect
in interface DatabaseMetaData
SQLException
public boolean supportsGroupByUnrelated() throws SQLException
supportsGroupByUnrelated
in interface DatabaseMetaData
SQLException
public boolean supportsIntegrityEnhancementFacility() throws SQLException
supportsIntegrityEnhancementFacility
in interface DatabaseMetaData
SQLException
public boolean supportsLikeEscapeClause() throws SQLException
supportsLikeEscapeClause
in interface DatabaseMetaData
SQLException
public boolean supportsLimitedOuterJoins() throws SQLException
supportsLimitedOuterJoins
in interface DatabaseMetaData
SQLException
public boolean supportsMinimumSQLGrammar() throws SQLException
supportsMinimumSQLGrammar
in interface DatabaseMetaData
SQLException
public boolean supportsMixedCaseIdentifiers() throws SQLException
supportsMixedCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
supportsMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean supportsOpenCursorsAcrossCommit() throws SQLException
supportsOpenCursorsAcrossCommit
in interface DatabaseMetaData
SQLException
public boolean supportsMultipleResultSets() throws SQLException
supportsMultipleResultSets
in interface DatabaseMetaData
SQLException
public boolean supportsMultipleOpenResults() throws SQLException
supportsMultipleOpenResults
in interface DatabaseMetaData
SQLException
public boolean supportsMultipleTransactions() throws SQLException
supportsMultipleTransactions
in interface DatabaseMetaData
SQLException
public boolean supportsNamedParameters() throws SQLException
supportsNamedParameters
in interface DatabaseMetaData
SQLException
public boolean supportsNonNullableColumns() throws SQLException
supportsNonNullableColumns
in interface DatabaseMetaData
SQLException
public boolean supportsOpenCursorsAcrossRollback() throws SQLException
supportsOpenCursorsAcrossRollback
in interface DatabaseMetaData
SQLException
public boolean supportsOpenStatementsAcrossCommit() throws SQLException
supportsOpenStatementsAcrossCommit
in interface DatabaseMetaData
SQLException
public boolean supportsOpenStatementsAcrossRollback() throws SQLException
supportsOpenStatementsAcrossRollback
in interface DatabaseMetaData
SQLException
public boolean supportsOrderByUnrelated() throws SQLException
supportsOrderByUnrelated
in interface DatabaseMetaData
SQLException
public boolean supportsOuterJoins() throws SQLException
supportsOuterJoins
in interface DatabaseMetaData
SQLException
public boolean supportsPositionedDelete() throws SQLException
supportsPositionedDelete
in interface DatabaseMetaData
SQLException
public boolean supportsPositionedUpdate() throws SQLException
supportsPositionedUpdate
in interface DatabaseMetaData
SQLException
public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException
supportsResultSetConcurrency
in interface DatabaseMetaData
SQLException
public boolean supportsResultSetHoldability(int holdability) throws SQLException
supportsResultSetHoldability
in interface DatabaseMetaData
SQLException
public boolean supportsResultSetType(int type) throws SQLException
Does the database support the given result set type?
supportsResultSetType
in interface DatabaseMetaData
type
- defined in java.sql.ResultSet
true
if so; false
otherwiseSQLException
- should never occurConnection
public boolean supportsSavepoints() throws SQLException
supportsSavepoints
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInDataManipulation() throws SQLException
supportsSchemasInDataManipulation
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInIndexDefinitions() throws SQLException
supportsSchemasInIndexDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
supportsSchemasInPrivilegeDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInProcedureCalls() throws SQLException
supportsSchemasInProcedureCalls
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInTableDefinitions() throws SQLException
supportsSchemasInTableDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsSelectForUpdate() throws SQLException
supportsSelectForUpdate
in interface DatabaseMetaData
SQLException
public boolean supportsStatementPooling() throws SQLException
supportsStatementPooling
in interface DatabaseMetaData
SQLException
public boolean supportsStoredProcedures() throws SQLException
supportsStoredProcedures
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInComparisons() throws SQLException
supportsSubqueriesInComparisons
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInExists() throws SQLException
supportsSubqueriesInExists
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInIns() throws SQLException
supportsSubqueriesInIns
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInQuantifieds() throws SQLException
supportsSubqueriesInQuantifieds
in interface DatabaseMetaData
SQLException
public boolean supportsTableCorrelationNames() throws SQLException
supportsTableCorrelationNames
in interface DatabaseMetaData
SQLException
public boolean supportsTransactionIsolationLevel(int level) throws SQLException
supportsTransactionIsolationLevel
in interface DatabaseMetaData
SQLException
public boolean supportsTransactions() throws SQLException
supportsTransactions
in interface DatabaseMetaData
SQLException
public boolean supportsUnion() throws SQLException
supportsUnion
in interface DatabaseMetaData
SQLException
public boolean supportsUnionAll() throws SQLException
supportsUnionAll
in interface DatabaseMetaData
SQLException
public boolean updatesAreDetected(int type) throws SQLException
updatesAreDetected
in interface DatabaseMetaData
SQLException
public boolean usesLocalFilePerTable() throws SQLException
usesLocalFilePerTable
in interface DatabaseMetaData
SQLException
public boolean usesLocalFiles() throws SQLException
usesLocalFiles
in interface DatabaseMetaData
SQLException
public boolean autoCommitFailureClosesAllResultSets() throws SQLException
autoCommitFailureClosesAllResultSets
in interface DatabaseMetaData
SQLException
public int getResultSetHoldability() throws SQLException
getResultSetHoldability
in interface DatabaseMetaData
SQLException
public Connection getConnection() throws SQLException
getConnection
in interface DatabaseMetaData
SQLException
public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException
supportsStoredFunctionsUsingCallSyntax
in interface DatabaseMetaData
SQLException
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
getAttributes
in interface DatabaseMetaData
SQLException
public ResultSet getClientInfoProperties() throws SQLException
getClientInfoProperties
in interface DatabaseMetaData
SQLException
public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException
getFunctionColumns
in interface DatabaseMetaData
SQLException
public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException
getFunctions
in interface DatabaseMetaData
SQLException
public RowIdLifetime getRowIdLifetime() throws SQLException
getRowIdLifetime
in interface DatabaseMetaData
SQLException
public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException
getSchemas
in interface DatabaseMetaData
SQLException
public boolean generatedKeyAlwaysReturned() throws SQLException
generatedKeyAlwaysReturned
in interface DatabaseMetaData
SQLException
public ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
getPseudoColumns
in interface DatabaseMetaData
SQLException
Copyright © 2020. All rights reserved.