public class DatabaseMetaDataImpl extends WrapperImpl implements DatabaseMetaData
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()
Retrieves whether auto-generated keys can be retrieved after a
statement has been executed.
|
boolean |
supportsGroupBy() |
boolean |
supportsGroupByBeyondSelect() |
boolean |
supportsGroupByUnrelated() |
boolean |
supportsIntegrityEnhancementFacility() |
boolean |
supportsLikeEscapeClause() |
boolean |
supportsLimitedOuterJoins() |
boolean |
supportsMinimumSQLGrammar() |
boolean |
supportsMixedCaseIdentifiers() |
boolean |
supportsMixedCaseQuotedIdentifiers() |
boolean |
supportsMultipleOpenResults() |
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, unwrapclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitisWrapperFor, unwrappublic 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 DatabaseMetaDataSQLException. - Should never occur.SQLExceptionpublic 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 DatabaseMetaDataSQLExceptionpublic 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 DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXSQLException, - should never occurSQLExceptionpublic boolean doesMaxRowSizeIncludeBlobs()
throws SQLException
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
doesMaxRowSizeIncludeBlobs in interface DatabaseMetaDatatrue if so; false otherwiseSQLException, - should never occurSQLExceptionpublic 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 DatabaseMetaDataname - 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.SQLExceptionpublic 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.SQLExceptionpublic String getCatalogTerm() throws SQLException
getCatalogTerm in interface DatabaseMetaDataSQLExceptionpublic 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 DatabaseMetaDataname - 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 DatabaseMetaDatacatalog - 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 DatabaseMetaDataname - 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 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.SQLExceptionpublic 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.SQLExceptionpublic 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 occurSQLExceptionpublic 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 occurSQLExceptionpublic 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 occurSQLExceptionpublic int getMaxCatalogNameLength()
throws SQLException
Gets the maximum number of characters allowed in a catalog name
getMaxCatalogNameLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxCharLiteralLength()
throws SQLException
Gets the maximum number of characters allowed in a character literal
getMaxCharLiteralLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxColumnNameLength()
throws SQLException
Gets the maximum number of characters allowed in a column name
getMaxColumnNameLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxColumnsInGroupBy()
throws SQLException
Gets the maximum number of columns allowed in a GROUP BY clause
getMaxColumnsInGroupBy in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxColumnsInIndex()
throws SQLException
Gets the maximum number of columns allowed in an index
getMaxColumnsInIndex in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxColumnsInOrderBy()
throws SQLException
Gets the maximum number of columns allowed in a ORDER BY clause
getMaxColumnsInOrderBy in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxColumnsInSelect()
throws SQLException
Gets the maximum number of columns allowed in a SELECT clause
getMaxColumnsInSelect in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic 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 occurSQLExceptionpublic int getMaxRowSize()
throws SQLException
Gets the maximum number of bytes allowed in a single row
getMaxRowSize in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxSchemaNameLength()
throws SQLException
Gets the maximum number of characters allowed in a schema name
getMaxSchemaNameLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxStatementLength()
throws SQLException
Gets the maximum number of characters allowed in an SQL statement
getMaxStatementLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic 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 occurSQLExceptionpublic int getMaxTableNameLength()
throws SQLException
Gets the maximum number of characters allowed in a table name
getMaxTableNameLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxTablesInSelect()
throws SQLException
Gets the maximum number of tables allowed in a SELECT clause
getMaxTablesInSelect in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic int getMaxUserNameLength()
throws SQLException
Gets the maximum number of characters allowed in a user name
getMaxUserNameLength in interface DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic 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 occurSQLExceptionpublic 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
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 DatabaseMetaDataname - 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 occurSQLExceptionpublic 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.SQLExceptionpublic boolean insertsAreDetected(int type)
throws SQLException
Indicates whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
insertsAreDetected in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXSQLException, - should never occurSQLExceptionpublic 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.SQLExceptionpublic 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 DatabaseMetaDataSQLException, - should never occur.SQLExceptionpublic boolean nullsAreSortedAtEnd()
throws SQLException
Checks whether NULL vaules are sorted at the end regardless of sort order.
nullsAreSortedAtEnd in interface DatabaseMetaDataSQLException, - should never occur.SQLExceptionpublic boolean nullsAreSortedAtStart()
throws SQLException
Checks whether NULL vaules are sorted at the start regardless of sort order.
nullsAreSortedAtStart in interface DatabaseMetaDataSQLException, - should never occur.SQLExceptionpublic boolean nullsAreSortedHigh()
throws SQLException
Checks whether NULL vaules are sorted high.
nullsAreSortedHigh in interface DatabaseMetaDataSQLException, - should never occur.SQLExceptionpublic boolean nullsAreSortedLow()
throws SQLException
Checks whether NULL vaules are sorted low.
nullsAreSortedLow in interface DatabaseMetaDataSQLException, - should never occur.SQLExceptionpublic boolean ownUpdatesAreVisible(int type)
throws SQLException
Indicates whether a result set's own updates are visible.
ownUpdatesAreVisible in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXtrue if updates are visible for the result set type;
false otherwiseSQLException, - should never occurSQLExceptionpublic boolean ownDeletesAreVisible(int type)
throws SQLException
Indicates whether a result set's own deletes are visible.
ownDeletesAreVisible in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXtrue if deletes are visible for the result set type;
false otherwiseSQLException, - should never occurSQLExceptionpublic boolean ownInsertsAreVisible(int type)
throws SQLException
Indicates whether a result set's own inserts are visible.
ownInsertsAreVisible in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXtrue if inserts are visible for the result set type;
false otherwiseSQLException, - should never occurSQLExceptionpublic boolean othersUpdatesAreVisible(int type)
throws SQLException
Indicates whether updates made by others are visible.
othersUpdatesAreVisible in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXtrue if updates made by others
are visible for the result set type;
false otherwiseSQLException, - should never occurSQLExceptionpublic boolean othersDeletesAreVisible(int type)
throws SQLException
Indicates whether deletes made by others are visible.
othersDeletesAreVisible in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXtrue if deletes made by others
are visible for the result set type;
false otherwiseSQLException, - should never occurSQLExceptionpublic boolean othersInsertsAreVisible(int type)
throws SQLException
Indicates whether inserts made by others are visible.
othersInsertsAreVisible in interface DatabaseMetaDataresult - set type, i.e. ResultSet.TYPE_XXXtrue
if inserts made by others are visible for the result set type;
false otherwiseSQLException, - should never occurSQLExceptionpublic 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 occurSQLExceptionpublic 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 DatabaseMetaDataSQLException, - should never occurSQLExceptionpublic 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 DatabaseMetaDataintValue - holdabilitySQLException, - should never occurSQLExceptionpublic 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 occurSQLExceptionConnectionpublic 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 © 2012 JBoss by Red Hat. All Rights Reserved.