public class DatabaseMetaDataImpl extends WrapperImpl implements DatabaseMetaData
Modifier and Type | Field and Description |
---|---|
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()
Checks whether the current user has the required security rights to call
all the procedures returned by the method getProcedures.
|
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)
Indicates whether or not a visible row delete can be detected by
calling ResultSet.rowDeleted().
|
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)
Gets a description of a table's optimal set of columns that uniquely identifies a row.
|
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)
Gets a description of the access rights for a column of the given name.
|
ResultSet |
getColumns(String catalog,
String schema,
String tableNamePattern,
String columnNamePattern)
Get's the metadata information about the columns whose names match the given
columnNamePattern.
|
Connection |
getConnection() |
ResultSet |
getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Gets the description of the foreign key columns in the table 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)
Gets the description of the columns in a table that are automatically updated
when any value in a row is updated.
|
boolean |
insertsAreDetected(int type)
Indicates whether or not a visible row insert can be detected
by calling ResultSet.rowInserted().
|
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 vaule and a non-NULL value results
in a NULL value.
|
boolean |
nullsAreSortedAtEnd()
Checks whether NULL vaules are sorted at the end regardless of sort order.
|
boolean |
nullsAreSortedAtStart()
Checks whether NULL vaules are sorted at the start regardless of sort order.
|
boolean |
nullsAreSortedHigh()
Checks whether NULL vaules are sorted high.
|
boolean |
nullsAreSortedLow()
Checks whether NULL vaules are sorted low.
|
boolean |
othersDeletesAreVisible(int type)
Indicates whether deletes made by others are visible.
|
boolean |
othersInsertsAreVisible(int type)
Indicates whether inserts made by others are visible.
|
boolean |
othersUpdatesAreVisible(int type)
Indicates whether updates made by others are visible.
|
boolean |
ownDeletesAreVisible(int type)
Indicates whether a result set's own deletes are visible.
|
boolean |
ownInsertsAreVisible(int type)
Indicates whether a result set's own inserts are visible.
|
boolean |
ownUpdatesAreVisible(int type)
Indicates whether a result set's own updates are visible.
|
boolean |
storesLowerCaseIdentifiers() |
boolean |
storesLowerCaseQuotedIdentifiers() |
boolean |
storesMixedCaseIdentifiers() |
boolean |
storesMixedCaseQuotedIdentifiers() |
boolean |
storesUpperCaseIdentifiers() |
boolean |
storesUpperCaseQuotedIdentifiers() |
boolean |
supportsAlterTableWithAddColumn() |
boolean |
supportsAlterTableWithDropColumn() |
boolean |
supportsANSI92EntryLevelSQL() |
boolean |
supportsANSI92FullSQL() |
boolean |
supportsANSI92IntermediateSQL() |
boolean |
supportsBatchUpdates()
Indicates whether the driver supports batch updates.
|
boolean |
supportsCatalogsInDataManipulation() |
boolean |
supportsCatalogsInIndexDefinitions() |
boolean |
supportsCatalogsInPrivilegeDefinitions() |
boolean |
supportsCatalogsInProcedureCalls() |
boolean |
supportsCatalogsInTableDefinitions() |
boolean |
supportsColumnAliasing() |
boolean |
supportsConvert() |
boolean |
supportsConvert(int fromType,
int toType) |
boolean |
supportsCoreSQLGrammar() |
boolean |
supportsCorrelatedSubqueries() |
boolean |
supportsDataDefinitionAndDataManipulationTransactions() |
boolean |
supportsDataManipulationTransactionsOnly() |
boolean |
supportsDifferentTableCorrelationNames() |
boolean |
supportsExpressionsInOrderBy() |
boolean |
supportsExtendedSQLGrammar() |
boolean |
supportsFullOuterJoins() |
boolean |
supportsGetGeneratedKeys() |
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)
Retrieves whether database supports the given result set 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 boolean allProceduresAreCallable() throws SQLException
Checks whether the current user has the required security rights to call all the procedures returned by the method getProcedures.
allProceduresAreCallable
in interface DatabaseMetaData
SQLException.
- Should never occur.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
public boolean deletesAreDetected(int type) throws SQLException
Indicates whether or not a visible row delete can be detected by calling ResultSet.rowDeleted(). If deletesAreDetected() returns false, then deleted rows are removed from the result set.
deletesAreDetected
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXSQLException,
- should never occurSQLException
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
doesMaxRowSizeIncludeBlobs
in interface DatabaseMetaData
true
if so; false
otherwiseSQLException,
- should never occurSQLException
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
Gets a description of a table's optimal set of columns that uniquely identifies a row.
getBestRowIdentifier
in interface DatabaseMetaData
name
- of the catalog from which metadata needscatalog
- name in which the table is present.schema
- name in which this table is present.table
- name whose best row identifier info is sought.int
- indicating the scope of the result.boolean
- indicating whether the nullable columns can be included.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.SQLException
public String getCatalogTerm() throws SQLException
getCatalogTerm
in interface DatabaseMetaData
SQLException
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnName) throws SQLException
Gets a description of the access rights for a column of the given name. Catalog name should match the virtualdatabasename used to obtain this driver connection.
getColumnPrivileges
in interface DatabaseMetaData
name
- of the catalog to which columns belong.name
- of the schema to which columns belong.name
- of the table to which columns belong.name
- pattern to be matched by column names.SQLException
- if there is an error obtaining server resultspublic ResultSet getColumns(String catalog, String schema, String tableNamePattern, String columnNamePattern) throws SQLException
Get's the metadata information about the columns whose names match the given columnNamePattern. Catalog names should match the virtualdatabasename used to obtain this driver connection.
The ResultSet returned by this method contains the following additional columns that are not specified in the JDBC specification.
getColumns
in interface DatabaseMetaData
catalog
- name to which the columns belong.schema
- name to which the columns belong.pattern
- name to be matched by table name.pattern
- name to be matched by column name.SQLException
- if there is an error obtaining server results.public ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException
Gets the description of the foreign key columns in the table foreignTable. These foreign key columns reference primary key columns of primaryTable. Catalog names(primary and foreign) should match the virtualdatabasename used to obtain this driver connection.
getCrossReference
in interface DatabaseMetaData
name
- of the catalog containing primary keys.name
- of the schema containing primary keys.name
- of the table containing primary keys.name
- of the catalog containing foreign keys.name
- of the schema containing foreign keys.name
- of the table containing foreign keys.SQLException
- if there is an error obtaining server resultspublic 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.SQLException
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.SQLException
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 occurSQLException
public 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 occurSQLException
public 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 occurSQLException
public int getMaxCatalogNameLength() throws SQLException
Gets the maximum number of characters allowed in a catalog name
getMaxCatalogNameLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxCharLiteralLength() throws SQLException
Gets the maximum number of characters allowed in a character literal
getMaxCharLiteralLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxColumnNameLength() throws SQLException
Gets the maximum number of characters allowed in a column name
getMaxColumnNameLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxColumnsInGroupBy() throws SQLException
Gets the maximum number of columns allowed in a GROUP BY clause
getMaxColumnsInGroupBy
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxColumnsInIndex() throws SQLException
Gets the maximum number of columns allowed in an index
getMaxColumnsInIndex
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxColumnsInOrderBy() throws SQLException
Gets the maximum number of columns allowed in a ORDER BY clause
getMaxColumnsInOrderBy
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxColumnsInSelect() throws SQLException
Gets the maximum number of columns allowed in a SELECT clause
getMaxColumnsInSelect
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public 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 occurSQLException
public int getMaxRowSize() throws SQLException
Gets the maximum number of bytes allowed in a single row
getMaxRowSize
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxSchemaNameLength() throws SQLException
Gets the maximum number of characters allowed in a schema name
getMaxSchemaNameLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxStatementLength() throws SQLException
Gets the maximum number of characters allowed in an SQL statement
getMaxStatementLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public 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 occurSQLException
public int getMaxTableNameLength() throws SQLException
Gets the maximum number of characters allowed in a table name
getMaxTableNameLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxTablesInSelect() throws SQLException
Gets the maximum number of tables allowed in a SELECT clause
getMaxTablesInSelect
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public int getMaxUserNameLength() throws SQLException
Gets the maximum number of characters allowed in a user name
getMaxUserNameLength
in interface DatabaseMetaData
SQLException,
- should never occurSQLException
public 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 occurSQLException
public 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
Gets the description of the columns in a table that are automatically updated when any value in a row is updated. The column descriptions are not ordered.
getVersionColumns
in interface DatabaseMetaData
name
- of the catalog in which the table is present.name
- of the schema in which the table is present.name
- of the table which has the version columns.SQLException,
- should never occurSQLException
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.SQLException
public boolean insertsAreDetected(int type) throws SQLException
Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
insertsAreDetected
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXSQLException,
- should never occurSQLException
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.SQLException
public boolean nullPlusNonNullIsNull() throws SQLException
Checks whether the concatenation of a NULL vaule and a non-NULL value results in a NULL value.
nullPlusNonNullIsNull
in interface DatabaseMetaData
SQLException,
- should never occur.SQLException
public boolean nullsAreSortedAtEnd() throws SQLException
Checks whether NULL vaules are sorted at the end regardless of sort order.
nullsAreSortedAtEnd
in interface DatabaseMetaData
SQLException,
- should never occur.SQLException
public boolean nullsAreSortedAtStart() throws SQLException
Checks whether NULL vaules are sorted at the start regardless of sort order.
nullsAreSortedAtStart
in interface DatabaseMetaData
SQLException,
- should never occur.SQLException
public boolean nullsAreSortedHigh() throws SQLException
Checks whether NULL vaules are sorted high.
nullsAreSortedHigh
in interface DatabaseMetaData
SQLException,
- should never occur.SQLException
public boolean nullsAreSortedLow() throws SQLException
Checks whether NULL vaules are sorted low.
nullsAreSortedLow
in interface DatabaseMetaData
SQLException,
- should never occur.SQLException
public boolean ownUpdatesAreVisible(int type) throws SQLException
Indicates whether a result set's own updates are visible.
ownUpdatesAreVisible
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if updates are visible for the result set type;
false
otherwiseSQLException,
- should never occurSQLException
public boolean ownDeletesAreVisible(int type) throws SQLException
Indicates whether a result set's own deletes are visible.
ownDeletesAreVisible
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if deletes are visible for the result set type;
false
otherwiseSQLException,
- should never occurSQLException
public boolean ownInsertsAreVisible(int type) throws SQLException
Indicates whether a result set's own inserts are visible.
ownInsertsAreVisible
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if inserts are visible for the result set type;
false
otherwiseSQLException,
- should never occurSQLException
public boolean othersUpdatesAreVisible(int type) throws SQLException
Indicates whether updates made by others are visible.
othersUpdatesAreVisible
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if updates made by others
are visible for the result set type;
false
otherwiseSQLException,
- should never occurSQLException
public boolean othersDeletesAreVisible(int type) throws SQLException
Indicates whether deletes made by others are visible.
othersDeletesAreVisible
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if deletes made by others
are visible for the result set type;
false
otherwiseSQLException,
- should never occurSQLException
public boolean othersInsertsAreVisible(int type) throws SQLException
Indicates whether inserts made by others are visible.
othersInsertsAreVisible
in interface DatabaseMetaData
result
- set type, i.e. ResultSet.TYPE_XXXtrue
if inserts made by others are visible for the result set type;
false
otherwiseSQLException,
- should never occurSQLException
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 occurSQLException
public 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
intValue
- holdabilitySQLException,
- should never occurSQLException
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 occurSQLException
Connection
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 © 2016 JBoss by Red Hat. All rights reserved.