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, unwrapclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitgetMaxLogicalLobSize, supportsRefCursorsisWrapperFor, unwrappublic static final String REPORT_AS_VIEWS
public static final String NULL_SORT
public boolean allProceduresAreCallable()
throws SQLException
allProceduresAreCallable in interface DatabaseMetaDataSQLExceptionpublic boolean allTablesAreSelectable()
throws SQLException
allTablesAreSelectable in interface DatabaseMetaDataSQLExceptionpublic boolean dataDefinitionCausesTransactionCommit()
throws SQLException
Checks whether a DDL statement within a transaction forces the transaction to commit.
dataDefinitionCausesTransactionCommit in interface DatabaseMetaDataSQLException - Should never occur.public boolean dataDefinitionIgnoredInTransactions()
throws SQLException
Checks whether a DDL statement within a transaction is ignored.
dataDefinitionIgnoredInTransactions in interface DatabaseMetaDataSQLException - Should never occur.public boolean deletesAreDetected(int type)
throws SQLException
deletesAreDetected in interface DatabaseMetaDataSQLExceptionpublic boolean doesMaxRowSizeIncludeBlobs()
throws SQLException
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
doesMaxRowSizeIncludeBlobs in interface DatabaseMetaDatatrue if so; false otherwiseSQLException - should never occurpublic ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
getBestRowIdentifier in interface DatabaseMetaDataSQLExceptionpublic ResultSet getCatalogs() throws SQLException
getCatalogs in interface DatabaseMetaDataSQLExceptionpublic String getCatalogSeparator() throws SQLException
Gets the String object used to separate a catalog name and a table name
getCatalogSeparator in interface DatabaseMetaDataSQLException - should never occur.public String getCatalogTerm() throws SQLException
getCatalogTerm in interface DatabaseMetaDataSQLExceptionpublic ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnName) throws SQLException
getColumnPrivileges in interface DatabaseMetaDataSQLExceptionpublic ResultSet getColumns(String catalog, String schema, String tableNamePattern, String columnNamePattern) throws SQLException
getColumns in interface DatabaseMetaDataSQLExceptionpublic ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException
getCrossReference in interface DatabaseMetaDataSQLExceptionpublic int getDatabaseMinorVersion()
throws SQLException
getDatabaseMinorVersion in interface DatabaseMetaDataSQLException - if a database access error occurs.public int getDatabaseMajorVersion()
throws SQLException
getDatabaseMajorVersion in interface DatabaseMetaDataSQLException - if a database access error occurs.public int getJDBCMajorVersion()
throws SQLException
getJDBCMajorVersion in interface DatabaseMetaDataSQLException - should never occur.public int getJDBCMinorVersion()
throws SQLException
getJDBCMinorVersion in interface DatabaseMetaDataSQLException - should never occur.public String getDatabaseProductName() throws SQLException
Gets the product name for this database
getDatabaseProductName in interface DatabaseMetaDataSQLException - should never occur.public String getDatabaseProductVersion() throws SQLException
getDatabaseProductVersion in interface DatabaseMetaDataSQLExceptionpublic int getDefaultTransactionIsolation()
throws SQLException
getDefaultTransactionIsolation in interface DatabaseMetaDataSQLExceptionpublic int getDriverMajorVersion()
Gets this drivers major version number
getDriverMajorVersion in interface DatabaseMetaDatapublic int getDriverMinorVersion()
Gets this drivers minor version number
getDriverMinorVersion in interface DatabaseMetaDatapublic String getDriverName() throws SQLException
Get the name of this JDBC driver
getDriverName in interface DatabaseMetaDataSQLException - 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 DatabaseMetaDataSQLException - should never occur.public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException
getExportedKeys in interface DatabaseMetaDataSQLExceptionpublic 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 DatabaseMetaDataSQLException - 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 DatabaseMetaDataSQLException - should never occurpublic ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException
getImportedKeys in interface DatabaseMetaDataSQLExceptionpublic ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
getIndexInfo in interface DatabaseMetaDataSQLExceptionpublic int getMaxBinaryLiteralLength()
throws SQLException
Gets the maximum number of hexadecimal characters allowed in an inline binary literal
getMaxBinaryLiteralLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxCatalogNameLength()
throws SQLException
Gets the maximum number of characters allowed in a catalog name
getMaxCatalogNameLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxCharLiteralLength()
throws SQLException
Gets the maximum number of characters allowed in a character literal
getMaxCharLiteralLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxColumnNameLength()
throws SQLException
Gets the maximum number of characters allowed in a column name
getMaxColumnNameLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxColumnsInGroupBy()
throws SQLException
Gets the maximum number of columns allowed in a GROUP BY clause
getMaxColumnsInGroupBy in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxColumnsInIndex()
throws SQLException
Gets the maximum number of columns allowed in an index
getMaxColumnsInIndex in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxColumnsInOrderBy()
throws SQLException
Gets the maximum number of columns allowed in a ORDER BY clause
getMaxColumnsInOrderBy in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxColumnsInSelect()
throws SQLException
Gets the maximum number of columns allowed in a SELECT clause
getMaxColumnsInSelect in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxColumnsInTable()
throws SQLException
getMaxColumnsInTable in interface DatabaseMetaDataSQLExceptionpublic int getMaxConnections()
throws SQLException
getMaxConnections in interface DatabaseMetaDataSQLExceptionpublic int getMaxCursorNameLength()
throws SQLException
getMaxCursorNameLength in interface DatabaseMetaDataSQLExceptionpublic int getMaxIndexLength()
throws SQLException
getMaxIndexLength in interface DatabaseMetaDataSQLExceptionpublic int getMaxProcedureNameLength()
throws SQLException
Gets the maximum number of characters allowed in a procedure name
getMaxProcedureNameLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxRowSize()
throws SQLException
Gets the maximum number of bytes allowed in a single row
getMaxRowSize in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxSchemaNameLength()
throws SQLException
Gets the maximum number of characters allowed in a schema name
getMaxSchemaNameLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxStatementLength()
throws SQLException
Gets the maximum number of characters allowed in an SQL statement
getMaxStatementLength in interface DatabaseMetaDataSQLException - 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 DatabaseMetaDataSQLException - should never occurpublic int getMaxTableNameLength()
throws SQLException
Gets the maximum number of characters allowed in a table name
getMaxTableNameLength in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxTablesInSelect()
throws SQLException
Gets the maximum number of tables allowed in a SELECT clause
getMaxTablesInSelect in interface DatabaseMetaDataSQLException - should never occurpublic int getMaxUserNameLength()
throws SQLException
Gets the maximum number of characters allowed in a user name
getMaxUserNameLength in interface DatabaseMetaDataSQLException - should never occurpublic String getNumericFunctions() throws SQLException
getNumericFunctions in interface DatabaseMetaDataSQLExceptionpublic ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException
getPrimaryKeys in interface DatabaseMetaDataSQLExceptionpublic ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
getProcedureColumns in interface DatabaseMetaDataSQLExceptionpublic ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException
getProcedures in interface DatabaseMetaDataSQLExceptionpublic String getProcedureTerm() throws SQLException
getProcedureTerm in interface DatabaseMetaDataSQLExceptionpublic ResultSet getSchemas() throws SQLException
getSchemas in interface DatabaseMetaDataSQLExceptionpublic String getSchemaTerm() throws SQLException
getSchemaTerm in interface DatabaseMetaDataSQLExceptionpublic 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 DatabaseMetaDataSQLException - should never occurpublic String getSQLKeywords() throws SQLException
getSQLKeywords in interface DatabaseMetaDataSQLExceptionpublic int getSQLStateType()
throws SQLException
getSQLStateType in interface DatabaseMetaDataSQLExceptionpublic String getStringFunctions() throws SQLException
getStringFunctions in interface DatabaseMetaDataSQLExceptionpublic ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
getSuperTables in interface DatabaseMetaDatacatalog - 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 DatabaseMetaDatacatalog - 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.SQLExceptionpublic String getSystemFunctions() throws SQLException
getSystemFunctions in interface DatabaseMetaDataSQLExceptionpublic ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableName) throws SQLException
getTablePrivileges in interface DatabaseMetaDataSQLExceptionpublic ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
getTables in interface DatabaseMetaDataSQLExceptionpublic ResultSet getTableTypes() throws SQLException
getTableTypes in interface DatabaseMetaDataSQLExceptionpublic String getTimeDateFunctions() throws SQLException
getTimeDateFunctions in interface DatabaseMetaDataSQLExceptionpublic ResultSet getTypeInfo() throws SQLException
getTypeInfo in interface DatabaseMetaDataSQLExceptionpublic 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 DatabaseMetaDatacatalog - 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 DatabaseMetaDataSQLExceptionpublic String getUserName() throws SQLException
getUserName in interface DatabaseMetaDataSQLExceptionpublic ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException
getVersionColumns in interface DatabaseMetaDataSQLExceptionpublic 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 DatabaseMetaDataSQLException - should never occur.public boolean insertsAreDetected(int type)
throws SQLException
insertsAreDetected in interface DatabaseMetaDataSQLExceptionpublic boolean isReadOnly()
throws SQLException
isReadOnly in interface DatabaseMetaDataSQLExceptionpublic boolean locatorsUpdateCopy()
throws SQLException
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
locatorsUpdateCopy in interface DatabaseMetaDataSQLException - 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 DatabaseMetaDataSQLException - should never occur.public boolean nullsAreSortedAtEnd()
throws SQLException
Checks whether NULL values are sorted at the end regardless of sort order.
nullsAreSortedAtEnd in interface DatabaseMetaDataSQLException - should never occur.public boolean nullsAreSortedAtStart()
throws SQLException
Checks whether NULL values are sorted at the start regardless of sort order.
nullsAreSortedAtStart in interface DatabaseMetaDataSQLException - should never occur.public boolean nullsAreSortedHigh()
throws SQLException
Checks whether NULL values are sorted high.
nullsAreSortedHigh in interface DatabaseMetaDataSQLException - should never occur.public boolean nullsAreSortedLow()
throws SQLException
Checks whether NULL values are sorted low.
nullsAreSortedLow in interface DatabaseMetaDataSQLException - should never occur.public boolean ownUpdatesAreVisible(int type)
throws SQLException
ownUpdatesAreVisible in interface DatabaseMetaDataSQLExceptionpublic boolean ownDeletesAreVisible(int type)
throws SQLException
ownDeletesAreVisible in interface DatabaseMetaDataSQLExceptionpublic boolean ownInsertsAreVisible(int type)
throws SQLException
ownInsertsAreVisible in interface DatabaseMetaDataSQLExceptionpublic boolean othersUpdatesAreVisible(int type)
throws SQLException
othersUpdatesAreVisible in interface DatabaseMetaDataSQLExceptionpublic boolean othersDeletesAreVisible(int type)
throws SQLException
othersDeletesAreVisible in interface DatabaseMetaDataSQLExceptionpublic boolean othersInsertsAreVisible(int type)
throws SQLException
othersInsertsAreVisible in interface DatabaseMetaDataSQLExceptionpublic boolean storesLowerCaseIdentifiers()
throws SQLException
storesLowerCaseIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean storesLowerCaseQuotedIdentifiers()
throws SQLException
storesLowerCaseQuotedIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean storesMixedCaseIdentifiers()
throws SQLException
storesMixedCaseIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean storesMixedCaseQuotedIdentifiers()
throws SQLException
storesMixedCaseQuotedIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean storesUpperCaseIdentifiers()
throws SQLException
storesUpperCaseIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean storesUpperCaseQuotedIdentifiers()
throws SQLException
storesUpperCaseQuotedIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean supportsAlterTableWithAddColumn()
throws SQLException
supportsAlterTableWithAddColumn in interface DatabaseMetaDataSQLExceptionpublic boolean supportsAlterTableWithDropColumn()
throws SQLException
supportsAlterTableWithDropColumn in interface DatabaseMetaDataSQLExceptionpublic boolean supportsANSI92EntryLevelSQL()
throws SQLException
supportsANSI92EntryLevelSQL in interface DatabaseMetaDataSQLExceptionpublic boolean supportsANSI92FullSQL()
throws SQLException
supportsANSI92FullSQL in interface DatabaseMetaDataSQLExceptionpublic boolean supportsANSI92IntermediateSQL()
throws SQLException
supportsANSI92IntermediateSQL in interface DatabaseMetaDataSQLExceptionpublic boolean supportsBatchUpdates()
throws SQLException
Indicates whether the driver supports batch updates.
supportsBatchUpdates in interface DatabaseMetaDataSQLException - should never occurpublic boolean supportsCatalogsInDataManipulation()
throws SQLException
supportsCatalogsInDataManipulation in interface DatabaseMetaDataSQLExceptionpublic boolean supportsCatalogsInIndexDefinitions()
throws SQLException
supportsCatalogsInIndexDefinitions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsCatalogsInPrivilegeDefinitions()
throws SQLException
supportsCatalogsInPrivilegeDefinitions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsCatalogsInProcedureCalls()
throws SQLException
supportsCatalogsInProcedureCalls in interface DatabaseMetaDataSQLExceptionpublic boolean supportsCatalogsInTableDefinitions()
throws SQLException
supportsCatalogsInTableDefinitions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsColumnAliasing()
throws SQLException
supportsColumnAliasing in interface DatabaseMetaDataSQLExceptionpublic boolean supportsConvert()
throws SQLException
supportsConvert in interface DatabaseMetaDataSQLExceptionpublic boolean supportsConvert(int fromType,
int toType)
throws SQLException
supportsConvert in interface DatabaseMetaDataSQLExceptionpublic boolean supportsCorrelatedSubqueries()
throws SQLException
supportsCorrelatedSubqueries in interface DatabaseMetaDataSQLExceptionpublic boolean supportsCoreSQLGrammar()
throws SQLException
supportsCoreSQLGrammar in interface DatabaseMetaDataSQLExceptionpublic boolean supportsDataDefinitionAndDataManipulationTransactions()
throws SQLException
supportsDataDefinitionAndDataManipulationTransactions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsDataManipulationTransactionsOnly()
throws SQLException
supportsDataManipulationTransactionsOnly in interface DatabaseMetaDataSQLExceptionpublic boolean supportsDifferentTableCorrelationNames()
throws SQLException
supportsDifferentTableCorrelationNames in interface DatabaseMetaDataSQLExceptionpublic boolean supportsExpressionsInOrderBy()
throws SQLException
supportsExpressionsInOrderBy in interface DatabaseMetaDataSQLExceptionpublic boolean supportsExtendedSQLGrammar()
throws SQLException
supportsExtendedSQLGrammar in interface DatabaseMetaDataSQLExceptionpublic boolean supportsFullOuterJoins()
throws SQLException
supportsFullOuterJoins in interface DatabaseMetaDataSQLExceptionpublic boolean supportsGetGeneratedKeys()
throws SQLException
supportsGetGeneratedKeys in interface DatabaseMetaDataSQLExceptionpublic boolean supportsGroupBy()
throws SQLException
supportsGroupBy in interface DatabaseMetaDataSQLExceptionpublic boolean supportsGroupByBeyondSelect()
throws SQLException
supportsGroupByBeyondSelect in interface DatabaseMetaDataSQLExceptionpublic boolean supportsGroupByUnrelated()
throws SQLException
supportsGroupByUnrelated in interface DatabaseMetaDataSQLExceptionpublic boolean supportsIntegrityEnhancementFacility()
throws SQLException
supportsIntegrityEnhancementFacility in interface DatabaseMetaDataSQLExceptionpublic boolean supportsLikeEscapeClause()
throws SQLException
supportsLikeEscapeClause in interface DatabaseMetaDataSQLExceptionpublic boolean supportsLimitedOuterJoins()
throws SQLException
supportsLimitedOuterJoins in interface DatabaseMetaDataSQLExceptionpublic boolean supportsMinimumSQLGrammar()
throws SQLException
supportsMinimumSQLGrammar in interface DatabaseMetaDataSQLExceptionpublic boolean supportsMixedCaseIdentifiers()
throws SQLException
supportsMixedCaseIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean supportsMixedCaseQuotedIdentifiers()
throws SQLException
supportsMixedCaseQuotedIdentifiers in interface DatabaseMetaDataSQLExceptionpublic boolean supportsOpenCursorsAcrossCommit()
throws SQLException
supportsOpenCursorsAcrossCommit in interface DatabaseMetaDataSQLExceptionpublic boolean supportsMultipleResultSets()
throws SQLException
supportsMultipleResultSets in interface DatabaseMetaDataSQLExceptionpublic boolean supportsMultipleOpenResults()
throws SQLException
supportsMultipleOpenResults in interface DatabaseMetaDataSQLExceptionpublic boolean supportsMultipleTransactions()
throws SQLException
supportsMultipleTransactions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsNamedParameters()
throws SQLException
supportsNamedParameters in interface DatabaseMetaDataSQLExceptionpublic boolean supportsNonNullableColumns()
throws SQLException
supportsNonNullableColumns in interface DatabaseMetaDataSQLExceptionpublic boolean supportsOpenCursorsAcrossRollback()
throws SQLException
supportsOpenCursorsAcrossRollback in interface DatabaseMetaDataSQLExceptionpublic boolean supportsOpenStatementsAcrossCommit()
throws SQLException
supportsOpenStatementsAcrossCommit in interface DatabaseMetaDataSQLExceptionpublic boolean supportsOpenStatementsAcrossRollback()
throws SQLException
supportsOpenStatementsAcrossRollback in interface DatabaseMetaDataSQLExceptionpublic boolean supportsOrderByUnrelated()
throws SQLException
supportsOrderByUnrelated in interface DatabaseMetaDataSQLExceptionpublic boolean supportsOuterJoins()
throws SQLException
supportsOuterJoins in interface DatabaseMetaDataSQLExceptionpublic boolean supportsPositionedDelete()
throws SQLException
supportsPositionedDelete in interface DatabaseMetaDataSQLExceptionpublic boolean supportsPositionedUpdate()
throws SQLException
supportsPositionedUpdate in interface DatabaseMetaDataSQLExceptionpublic boolean supportsResultSetConcurrency(int type,
int concurrency)
throws SQLException
supportsResultSetConcurrency in interface DatabaseMetaDataSQLExceptionpublic boolean supportsResultSetHoldability(int holdability)
throws SQLException
supportsResultSetHoldability in interface DatabaseMetaDataSQLExceptionpublic boolean supportsResultSetType(int type)
throws SQLException
Does the database support the given result set type?
supportsResultSetType in interface DatabaseMetaDatatype - defined in java.sql.ResultSettrue if so; false otherwiseSQLException - should never occurConnectionpublic boolean supportsSavepoints()
throws SQLException
supportsSavepoints in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSchemasInDataManipulation()
throws SQLException
supportsSchemasInDataManipulation in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSchemasInIndexDefinitions()
throws SQLException
supportsSchemasInIndexDefinitions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSchemasInPrivilegeDefinitions()
throws SQLException
supportsSchemasInPrivilegeDefinitions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSchemasInProcedureCalls()
throws SQLException
supportsSchemasInProcedureCalls in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSchemasInTableDefinitions()
throws SQLException
supportsSchemasInTableDefinitions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSelectForUpdate()
throws SQLException
supportsSelectForUpdate in interface DatabaseMetaDataSQLExceptionpublic boolean supportsStatementPooling()
throws SQLException
supportsStatementPooling in interface DatabaseMetaDataSQLExceptionpublic boolean supportsStoredProcedures()
throws SQLException
supportsStoredProcedures in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSubqueriesInComparisons()
throws SQLException
supportsSubqueriesInComparisons in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSubqueriesInExists()
throws SQLException
supportsSubqueriesInExists in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSubqueriesInIns()
throws SQLException
supportsSubqueriesInIns in interface DatabaseMetaDataSQLExceptionpublic boolean supportsSubqueriesInQuantifieds()
throws SQLException
supportsSubqueriesInQuantifieds in interface DatabaseMetaDataSQLExceptionpublic boolean supportsTableCorrelationNames()
throws SQLException
supportsTableCorrelationNames in interface DatabaseMetaDataSQLExceptionpublic boolean supportsTransactionIsolationLevel(int level)
throws SQLException
supportsTransactionIsolationLevel in interface DatabaseMetaDataSQLExceptionpublic boolean supportsTransactions()
throws SQLException
supportsTransactions in interface DatabaseMetaDataSQLExceptionpublic boolean supportsUnion()
throws SQLException
supportsUnion in interface DatabaseMetaDataSQLExceptionpublic boolean supportsUnionAll()
throws SQLException
supportsUnionAll in interface DatabaseMetaDataSQLExceptionpublic boolean updatesAreDetected(int type)
throws SQLException
updatesAreDetected in interface DatabaseMetaDataSQLExceptionpublic boolean usesLocalFilePerTable()
throws SQLException
usesLocalFilePerTable in interface DatabaseMetaDataSQLExceptionpublic boolean usesLocalFiles()
throws SQLException
usesLocalFiles in interface DatabaseMetaDataSQLExceptionpublic boolean autoCommitFailureClosesAllResultSets()
throws SQLException
autoCommitFailureClosesAllResultSets in interface DatabaseMetaDataSQLExceptionpublic int getResultSetHoldability()
throws SQLException
getResultSetHoldability in interface DatabaseMetaDataSQLExceptionpublic Connection getConnection() throws SQLException
getConnection in interface DatabaseMetaDataSQLExceptionpublic boolean supportsStoredFunctionsUsingCallSyntax()
throws SQLException
supportsStoredFunctionsUsingCallSyntax in interface DatabaseMetaDataSQLExceptionpublic ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
getAttributes in interface DatabaseMetaDataSQLExceptionpublic ResultSet getClientInfoProperties() throws SQLException
getClientInfoProperties in interface DatabaseMetaDataSQLExceptionpublic ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException
getFunctionColumns in interface DatabaseMetaDataSQLExceptionpublic ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException
getFunctions in interface DatabaseMetaDataSQLExceptionpublic RowIdLifetime getRowIdLifetime() throws SQLException
getRowIdLifetime in interface DatabaseMetaDataSQLExceptionpublic ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException
getSchemas in interface DatabaseMetaDataSQLExceptionpublic boolean generatedKeyAlwaysReturned()
throws SQLException
generatedKeyAlwaysReturned in interface DatabaseMetaDataSQLExceptionpublic ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
getPseudoColumns in interface DatabaseMetaDataSQLExceptionCopyright © 2020. All rights reserved.