|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
public interface DatabaseMetaData
| Field Summary | |
|---|---|
static short |
attributeNoNulls
A NULL value is not allowed for this attribute. |
static short |
attributeNullable
A NULL value is allowed for this attribute. |
static short |
attributeNullableUnknown
It is unknown whether or not NULL values are allowed for this attribute. |
static int |
bestRowNotPseudo
The best row identifier is not a pseudo-column. |
static int |
bestRowPseudo
The best row identifier is a pseudo-column. |
static int |
bestRowSession
The best row identifier is valid to the end of the session. |
static int |
bestRowTemporary
The best row's scope is only guaranteed to be valid so long as the row is actually being used. |
static int |
bestRowTransaction
The best row identifier is valid to the end of the transaction. |
static int |
bestRowUnknown
The best row may or may not be a pseudo-column. |
static int |
columnNoNulls
The column does not allow NULL |
static int |
columnNullable
The column does allow NULL |
static int |
columnNullableUnknown
It is unknown whether or not the column allows NULL |
static int |
importedKeyCascade
Foreign key changes are cascaded in updates or deletes. |
static int |
importedKeyInitiallyDeferred
Wish I knew what this meant. |
static int |
importedKeyInitiallyImmediate
Wish I knew what this meant. |
static int |
importedKeyNoAction
If the primary key is a foreign key, it cannot be udpated or deleted. |
static int |
importedKeyNotDeferrable
Wish I knew what this meant. |
static int |
importedKeyRestrict
Column may not be updated or deleted in use as a foreign key. |
static int |
importedKeySetDefault
If the primary key is updated or deleted, the foreign key is set to a default value. |
static int |
importedKeySetNull
When primary key is updated or deleted, the foreign key is set to NULL. |
static int |
procedureColumnIn
The column type is input. |
static int |
procedureColumnInOut
The column type is input/output. |
static int |
procedureColumnOut
The column type is output |
static int |
procedureColumnResult
The column is used for storing results |
static int |
procedureColumnReturn
The column is used for return values. |
static int |
procedureColumnUnknown
The column type is unknown. |
static int |
procedureNoNulls
NULL values are not allowed. |
static int |
procedureNoResult
The procedure does not return a result. |
static int |
procedureNullable
NULL values are allowed. |
static int |
procedureNullableUnknown
It is unknown whether or not NULL values are allowed. |
static int |
procedureResultUnknown
It is unknown whether or not the procedure returns a result. |
static int |
procedureReturnsResult
The procedure returns a result. |
static int |
sqlStateSQL99
|
static int |
sqlStateXOpen
|
static short |
tableIndexClustered
This table index is clustered. |
static short |
tableIndexHashed
This table index is hashed. |
static short |
tableIndexOther
This table index is of another type. |
static short |
tableIndexStatistic
This column contains table statistics. |
static int |
typeNoNulls
A NULL value is not allowed for this data type. |
static int |
typeNullable
A NULL value is allowed for this data type. |
static int |
typeNullableUnknown
It is unknown whether or not NULL values are allowed for this data type. |
static int |
typePredBasic
All WHERE clauses except "WHERE..LIKE" style are allowed on this data type. |
static int |
typePredChar
Only "WHERE..LIKE" style WHERE clauses are allowed on this data type. |
static int |
typePredNone
Where clauses are not supported for this type. |
static int |
typeSearchable
Any type of WHERE clause is allowed for this data type. |
static int |
versionColumnNotPseudo
The version column is not a pseudo-column |
static int |
versionColumnPseudo
The version column is a pseudo-column |
static int |
versionColumnUnknown
It is unknown whether or not the version column is a pseudo-column. |
| Method Summary | |
|---|---|
boolean |
allProceduresAreCallable()
This method tests whether or not all the procedures returned by the getProcedures method can be called by this user. |
boolean |
allTablesAreSelectable()
This method tests whether or not all the table returned by the getTables method can be selected by this user. |
boolean |
dataDefinitionCausesTransactionCommit()
This method tests whether or not a DDL statement will cause the current transaction to be automatically committed. |
boolean |
dataDefinitionIgnoredInTransactions()
This method tests whether or not DDL statements are ignored in transactions. |
boolean |
deletesAreDetected(int type)
This method tests whether or not the specified result set type can detect a visible delete by calling the rowUpdated method. |
boolean |
doesMaxRowSizeIncludeBlobs()
This method tests whether or not the maximum row size includes BLOB's |
ResultSet |
getAttributes(String catalog,
String schemaPattern,
String typePattern,
String attributePattern)
|
ResultSet |
getBestRowIdentifier(String catalog,
String schema,
String tableName,
int scope,
boolean nullable)
This method returns the best set of columns for uniquely identifying a row. |
ResultSet |
getCatalogs()
This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the
name of the catalog. |
String |
getCatalogSeparator()
This method returns the separator between the catalog name and the table name. |
String |
getCatalogTerm()
This method returns the vendor's term for "catalog". |
ResultSet |
getColumnPrivileges(String catalog,
String schema,
String tableName,
String columnPattern)
This method returns the access rights that have been granted to the requested columns. |
ResultSet |
getColumns(String catalog,
String schemaPattern,
String tablePattern,
String columnPattern)
This method returns a list of the tables columns for the requested tables. |
Connection |
getConnection()
This method returns the Connection object that was used
to generate the metadata in this object. |
ResultSet |
getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTableName,
String foreignCatalog,
String foreignSchema,
String foreignTableName)
This method returns a description of how one table imports another table's primary key as a foreign key. |
int |
getDatabaseMajorVersion()
This method returns the major version number of the database. |
int |
getDatabaseMinorVersion()
This method returns the minor version number of the database. |
String |
getDatabaseProductName()
This method returns the name of the database product. |
String |
getDatabaseProductVersion()
This method returns the version of the database product. |
int |
getDefaultTransactionIsolation()
This method returns the default transaction isolation level of the database. |
int |
getDriverMajorVersion()
This method returns the major version number of the JDBC driver. |
int |
getDriverMinorVersion()
This method returns the minor version number of the JDBC driver. |
String |
getDriverName()
This method returns the name of the JDBC driver. |
String |
getDriverVersion()
This method returns the version of the JDBC driver. |
ResultSet |
getExportedKeys(String catalog,
String schema,
String tableName)
This method returns a list of the table's which use this table's primary key as a foreign key. |
String |
getExtraNameCharacters()
This methods returns non-standard characters that can appear in unquoted identifiers. |
String |
getIdentifierQuoteString()
This metohd returns the quote string for SQL identifiers. |
ResultSet |
getImportedKeys(String catalog,
String schema,
String tableName)
This method returns a list of the table's foreign keys. |
ResultSet |
getIndexInfo(String catalog,
String schema,
String tableName,
boolean unique,
boolean approximate)
This method returns information about a tables indices and statistics. |
int |
getJDBCMajorVersion()
This method returns the major version number of the JDBC driver. |
int |
getJDBCMinorVersion()
This method returns the minor version number of the JDBC driver. |
int |
getMaxBinaryLiteralLength()
This method returns the number of hex characters allowed in an inline binary literal. |
int |
getMaxCatalogNameLength()
This method returns the maximum length of a catalog name. |
int |
getMaxCharLiteralLength()
This method returns the maximum length of a character literal. |
int |
getMaxColumnNameLength()
This method returns the maximum length of a column name. |
int |
getMaxColumnsInGroupBy()
This method returns the maximum number of columns in a GROUP BY statement. |
int |
getMaxColumnsInIndex()
This method returns the maximum number of columns in an index. |
int |
getMaxColumnsInOrderBy()
This method returns the maximum number of columns in an ORDER BY statement. |
int |
getMaxColumnsInSelect()
This method returns the maximum number of columns in a SELECT statement. |
int |
getMaxColumnsInTable()
This method returns the maximum number of columns in a table. |
int |
getMaxConnections()
This method returns the maximum number of connections this client can have to the database. |
int |
getMaxCursorNameLength()
This method returns the maximum length of a cursor name. |
int |
getMaxIndexLength()
This method returns the maximum length of an index. |
int |
getMaxProcedureNameLength()
This method returns the maximum length of a procedure name. |
int |
getMaxRowSize()
This method returns the maximum size of a row in bytes. |
int |
getMaxSchemaNameLength()
This method returns the maximum length of a schema name. |
int |
getMaxStatementLength()
This method includes the maximum length of a SQL statement. |
int |
getMaxStatements()
This method returns the maximum number of statements that can be active at any time. |
int |
getMaxTableNameLength()
This method returns the maximum length of a table name. |
int |
getMaxTablesInSelect()
This method returns the maximum number of tables that may be referenced in a SELECT statement. |
int |
getMaxUserNameLength()
This method returns the maximum length of a user name. |
String |
getNumericFunctions()
This method returns a comma separated list of math functions. |
ResultSet |
getPrimaryKeys(String catalog,
String schema,
String tableName)
This method returns a list of a table's primary key columns. |
ResultSet |
getProcedureColumns(String catalog,
String schemaPattern,
String procedurePattern,
String columnPattern)
This method returns a list of the parameter and result columns for the requested stored procedures. |
ResultSet |
getProcedures(String catalog,
String schemaPattern,
String procedurePattern)
This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog. |
String |
getProcedureTerm()
This method returns the vendor's term for "procedure". |
int |
getResultSetHoldability()
This method returns the default holdability type of ResultSetS
retrieved from this database. |
ResultSet |
getSchemas()
This method returns the list of database schemas as a ResultSet, with one column - TABLE_SCHEM - that is the
name of the schema. |
String |
getSchemaTerm()
This method returns the vendor's term for "schema". |
String |
getSearchStringEscape()
This method returns the string used to escape wildcards in search strings. |
String |
getSQLKeywords()
This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92. |
int |
getSQLStateType()
|
String |
getStringFunctions()
This method returns a comma separated list of string functions. |
ResultSet |
getSuperTables(String catalog,
String schemaPattern,
String tablePattern)
|
ResultSet |
getSuperTypes(String catalog,
String schemaPattern,
String typePattern)
|
String |
getSystemFunctions()
This method returns a comma separated list of of system functions. |
ResultSet |
getTablePrivileges(String catalog,
String schemaPattern,
String tablePattern)
This method returns the access rights that have been granted to the requested tables. |
ResultSet |
getTables(String catalog,
String schemaPattern,
String tablePattern,
String[] types)
This method returns a list of the requested table as a ResultSet with the following columns:
TABLE_CAT - The catalog the table is in, which may be null. |
ResultSet |
getTableTypes()
This method returns the list of database table types as a ResultSet with one column - TABLE_TYPE - that is the
name of the table type. |
String |
getTimeDateFunctions()
This method returns comma separated list of time/date functions. |
ResultSet |
getTypeInfo()
This method returns a list of the SQL types supported by this database. |
ResultSet |
getUDTs(String catalog,
String schemaPattern,
String typePattern,
int[] types)
This method returns the list of user defined data types in use. |
String |
getURL()
This method returns the URL for this database. |
String |
getUserName()
This method returns the database username for this connection. |
ResultSet |
getVersionColumns(String catalog,
String schema,
String tableName)
This method returns the set of columns that are automatically updated when the row is update. |
boolean |
insertsAreDetected(int type)
This method tests whether or not the specified result set type can detect a visible insert by calling the rowUpdated method. |
boolean |
isCatalogAtStart()
This method tests whether a catalog name appears at the beginning of a fully qualified table name. |
boolean |
isReadOnly()
This method tests whether or not the database is in read only mode. |
boolean |
locatorsUpdateCopy()
|
boolean |
nullPlusNonNullIsNull()
This method tests whether the concatenation of a NULL and non-NULL value results in a NULL. |
boolean |
nullsAreSortedAtEnd()
This method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order. |
boolean |
nullsAreSortedAtStart()
This method tests whether or not NULL's sort as high values. |
boolean |
nullsAreSortedHigh()
This method tests whether or not NULL's sort as high values. |
boolean |
nullsAreSortedLow()
This method tests whether or not NULL's sort as low values. |
boolean |
othersDeletesAreVisible(int type)
This method tests whether or not the specified result set type sees deletes committed by others. |
boolean |
othersInsertsAreVisible(int type)
This method tests whether or not the specified result set type sees inserts committed by others. |
boolean |
othersUpdatesAreVisible(int type)
This method tests whether or not the specified result set type sees updates committed by others. |
boolean |
ownDeletesAreVisible(int type)
This method tests whether or not the specified result set type sees its own deletes. |
boolean |
ownInsertsAreVisible(int type)
This method tests whether or not the specified result set type sees its own inserts. |
boolean |
ownUpdatesAreVisible(int type)
This method tests whether or not the specified result set type sees its own updates. |
boolean |
storesLowerCaseIdentifiers()
This method tests whether or not the database treats mixed case identifiers as all lower case. |
boolean |
storesLowerCaseQuotedIdentifiers()
This method tests whether or not the database treats mixed case quoted identifiers as all lower case. |
boolean |
storesMixedCaseIdentifiers()
This method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive. |
boolean |
storesMixedCaseQuotedIdentifiers()
This method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive. |
boolean |
storesUpperCaseIdentifiers()
This method tests whether or not the database treats mixed case identifiers as all upper case. |
boolean |
storesUpperCaseQuotedIdentifiers()
This method tests whether or not the database treats mixed case quoted identifiers as all upper case. |
boolean |
supportsAlterTableWithAddColumn()
This method tests whether or not the database supports "ALTER TABLE ADD COLUMN" |
boolean |
supportsAlterTableWithDropColumn()
This method tests whether or not the database supports "ALTER TABLE DROP COLUMN" |
boolean |
supportsANSI92EntryLevelSQL()
This method tests whether or not the ANSI92 entry level SQL grammar is supported. |
boolean |
supportsANSI92FullSQL()
This method tests whether or not the ANSI92 full SQL grammar is supported. |
boolean |
supportsANSI92IntermediateSQL()
This method tests whether or not the ANSI92 intermediate SQL grammar is supported. |
boolean |
supportsBatchUpdates()
This method tests whether or not the database supports batch updates. |
boolean |
supportsCatalogsInDataManipulation()
This method tests whether a catalog name can appear in a data manipulation statement. |
boolean |
supportsCatalogsInIndexDefinitions()
This method tests whether a catalog name can appear in an index definition. |
boolean |
supportsCatalogsInPrivilegeDefinitions()
This method tests whether a catalog name can appear in privilege definitions. |
boolean |
supportsCatalogsInProcedureCalls()
This method tests whether a catalog name can appear in a procedure call |
boolean |
supportsCatalogsInTableDefinitions()
This method tests whether a catalog name can appear in a table definition. |
boolean |
supportsColumnAliasing()
This method tests whether or not column aliasing is supported. |
boolean |
supportsConvert()
Tests whether or not CONVERT is supported. |
boolean |
supportsConvert(int fromType,
int toType)
This method tests whether or not CONVERT can be performed between the specified types. |
boolean |
supportsCoreSQLGrammar()
This method tests whether or not the core grammer for ODBC is supported. |
boolean |
supportsCorrelatedSubqueries()
This method test whether or not correlated subqueries are allowed. |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
This method tests whether or not DDL and DML statements allowed within the same transaction. |
boolean |
supportsDataManipulationTransactionsOnly()
This method tests whether or not only DML statement are allowed inside a transaction. |
boolean |
supportsDifferentTableCorrelationNames()
This method tests whether correlation names must be different from the name of the table. |
boolean |
supportsExpressionsInOrderBy()
This method tests whether or not expressions are allowed in an ORDER BY lists. |
boolean |
supportsExtendedSQLGrammar()
This method tests whether or not the extended grammer for ODBC is supported. |
boolean |
supportsFullOuterJoins()
This method tests whether or not the database supports full outer joins. |
boolean |
supportsGetGeneratedKeys()
|
boolean |
supportsGroupBy()
This method tests whether or not GROUP BY is supported. |
boolean |
supportsGroupByBeyondSelect()
This method tests whether or not a GROUP BY can add columns not in the select if it includes all the columns in the select. |
boolean |
supportsGroupByUnrelated()
This method tests whether GROUP BY on a non-selected column is allowed. |
boolean |
supportsIntegrityEnhancementFacility()
This method tests whether or not the SQL integrity enhancement facility is supported. |
boolean |
supportsLikeEscapeClause()
This method tests whether or not the escape character is supported in LIKE expressions. |
boolean |
supportsLimitedOuterJoins()
This method tests whether or not the database supports limited outer joins. |
boolean |
supportsMinimumSQLGrammar()
This method tests whether or not the minimum grammer for ODBC is supported. |
boolean |
supportsMixedCaseIdentifiers()
This method tests whether or not the database supports identifiers with mixed case. |
boolean |
supportsMixedCaseQuotedIdentifiers()
This method tests whether or not the database supports quoted identifiers with mixed case. |
boolean |
supportsMultipleOpenResults()
This method tests whether the database supports returning multiple ResultSetS from a CallableStatement at once. |
boolean |
supportsMultipleResultSets()
This method tests whether multiple result sets for a single statement are supported. |
boolean |
supportsMultipleTransactions()
This method test whether or not multiple transactions may be open at once, as long as they are on different connections. |
boolean |
supportsNamedParameters()
This method tests whether the database supports named parameters. |
boolean |
supportsNonNullableColumns()
This method tests whether or not columns can be defined as NOT NULL. |
boolean |
supportsOpenCursorsAcrossCommit()
This method tests whether or not the database supports cursors remaining open across commits. |
boolean |
supportsOpenCursorsAcrossRollback()
This method tests whether or not the database supports cursors remaining open across rollbacks. |
boolean |
supportsOpenStatementsAcrossCommit()
This method tests whether or not the database supports statements remaining open across commits. |
boolean |
supportsOpenStatementsAcrossRollback()
This method tests whether or not the database supports statements remaining open across rollbacks. |
boolean |
supportsOrderByUnrelated()
This method tests whether or ORDER BY on a non-selected column is allowed. |
boolean |
supportsOuterJoins()
This method tests whether or not the database supports outer joins. |
boolean |
supportsPositionedDelete()
This method tests whether or not that database supports positioned deletes. |
boolean |
supportsPositionedUpdate()
This method tests whether or not that database supports positioned updates. |
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
This method tests whether the specified result set type and result set concurrency type are supported by the database. |
boolean |
supportsResultSetHoldability(int holdability)
This method tests if the database supports the specified holdability type. |
boolean |
supportsResultSetType(int type)
This method tests whether or not the datbase supports the specified result type. |
boolean |
supportsSavepoints()
This method tests whether the databse supports savepoints. |
boolean |
supportsSchemasInDataManipulation()
This method tests whether a catalog name can appear in a data manipulation statement. |
boolean |
supportsSchemasInIndexDefinitions()
This method tests whether a catalog name can appear in an index definition. |
boolean |
supportsSchemasInPrivilegeDefinitions()
This method tests whether a catalog name can appear in privilege definitions. |
boolean |
supportsSchemasInProcedureCalls()
This method tests whether a catalog name can appear in a procedure call |
boolean |
supportsSchemasInTableDefinitions()
This method tests whether a catalog name can appear in a table definition. |
boolean |
supportsSelectForUpdate()
This method tests whether or not SELECT FOR UPDATE is supported by the database. |
boolean |
supportsStatementPooling()
|
boolean |
supportsStoredProcedures()
This method tests whether or not stored procedures are supported on this database. |
boolean |
supportsSubqueriesInComparisons()
This method tests whether or not subqueries are allowed in comparisons. |
boolean |
supportsSubqueriesInExists()
This method tests whether or not subqueries are allowed in exists expressions. |
boolean |
supportsSubqueriesInIns()
This method tests whether subqueries are allowed in IN statements. |
boolean |
supportsSubqueriesInQuantifieds()
This method tests whether or not subqueries are allowed in quantified expressions. |
boolean |
supportsTableCorrelationNames()
This method tests whether or not table correlation names are supported. |
boolean |
supportsTransactionIsolationLevel(int level)
This method tests whether or not the database supports the specified transaction isolation level. |
boolean |
supportsTransactions()
This method tests whether or not the database supports transactions. |
boolean |
supportsUnion()
This method tests whether or not the UNION statement is supported. |
boolean |
supportsUnionAll()
This method tests whether or not the UNION ALL statement is supported. |
boolean |
updatesAreDetected(int type)
This method tests whether or not the specified result set type can detect a visible update by calling the rowUpdated method. |
boolean |
usesLocalFilePerTable()
This method tests whether or not the database uses a separate file for each table. |
boolean |
usesLocalFiles()
This method tests whether or not the database uses local files to store tables. |
| Field Detail |
|---|
static final int procedureResultUnknown
static final int procedureNoResult
static final int procedureReturnsResult
static final int procedureColumnUnknown
static final int procedureColumnIn
static final int procedureColumnInOut
static final int procedureColumnOut
static final int procedureColumnReturn
static final int procedureColumnResult
static final int procedureNoNulls
static final int procedureNullable
static final int procedureNullableUnknown
static final int columnNoNulls
static final int columnNullable
static final int columnNullableUnknown
static final int bestRowTemporary
static final int bestRowTransaction
static final int bestRowSession
static final int bestRowUnknown
static final int bestRowNotPseudo
static final int bestRowPseudo
static final int versionColumnUnknown
static final int versionColumnNotPseudo
static final int versionColumnPseudo
static final int importedKeyCascade
static final int importedKeyRestrict
static final int importedKeySetNull
static final int importedKeyNoAction
static final int importedKeySetDefault
static final int importedKeyInitiallyDeferred
static final int importedKeyInitiallyImmediate
static final int importedKeyNotDeferrable
static final int typeNoNulls
static final int typeNullable
static final int typeNullableUnknown
static final int typePredNone
static final int typePredChar
static final int typePredBasic
static final int typeSearchable
static final short tableIndexStatistic
static final short tableIndexClustered
static final short tableIndexHashed
static final short tableIndexOther
static final short attributeNoNulls
static final short attributeNullable
static final short attributeNullableUnknown
static final int sqlStateXOpen
static final int sqlStateSQL99
| Method Detail |
|---|
boolean allProceduresAreCallable()
throws SQLException
getProcedures method can be called by this user.
true if all the procedures can be called,
false otherwise.
SQLException - If an error occurs.
boolean allTablesAreSelectable()
throws SQLException
getTables method can be selected by this user.
true if all the procedures can be called,
false otherwise.
SQLException - If an error occurs.
String getURL()
throws SQLException
null if it
is not known.
SQLException - If an error occurs.
String getUserName()
throws SQLException
SQLException - If an error occurs.
boolean isReadOnly()
throws SQLException
true if the database is in read only mode,
false otherwise.
SQLException - If an error occurs.
boolean nullsAreSortedHigh()
throws SQLException
true if NULL's sort as high values, false
otherwise.
SQLException - If an error occurs.
boolean nullsAreSortedLow()
throws SQLException
true if NULL's sort as low values, false
otherwise.
SQLException - If an error occurs.
boolean nullsAreSortedAtStart()
throws SQLException
true if NULL's sort as high values, false
otherwise.
SQLException - If an error occurs.
boolean nullsAreSortedAtEnd()
throws SQLException
true if NULL's always sort to the end,
false otherwise.
SQLException - If an error occurs.
String getDatabaseProductName()
throws SQLException
SQLException - If an error occurs.
String getDatabaseProductVersion()
throws SQLException
SQLException - If an error occurs.
String getDriverName()
throws SQLException
SQLException - If an error occurs.
String getDriverVersion()
throws SQLException
SQLException - If an error occurs.int getDriverMajorVersion()
int getDriverMinorVersion()
boolean usesLocalFiles()
throws SQLException
true if the database uses local files,
false otherwise.
SQLException - If an error occurs.
boolean usesLocalFilePerTable()
throws SQLException
true if the database uses a separate file for each
table false otherwise.
SQLException - If an error occurs.
boolean supportsMixedCaseIdentifiers()
throws SQLException
true if the database supports mixed case identifiers,
false otherwise.
SQLException - If an error occurs.
boolean storesUpperCaseIdentifiers()
throws SQLException
true if the database treats all identifiers as
upper case, false otherwise.
SQLException - If an error occurs.
boolean storesLowerCaseIdentifiers()
throws SQLException
true if the database treats all identifiers as
lower case, false otherwise.
SQLException - If an error occurs.
boolean storesMixedCaseIdentifiers()
throws SQLException
true if the database stores mixed case identifiers,
false otherwise.
SQLException - If an error occurs.
boolean supportsMixedCaseQuotedIdentifiers()
throws SQLException
true if the database supports mixed case quoted
identifiers, false otherwise.
SQLException - If an error occurs.
boolean storesUpperCaseQuotedIdentifiers()
throws SQLException
true if the database treats all quoted identifiers
as upper case, false otherwise.
SQLException - If an error occurs.
boolean storesLowerCaseQuotedIdentifiers()
throws SQLException
true if the database treats all quoted identifiers
as lower case, false otherwise.
SQLException - If an error occurs.
boolean storesMixedCaseQuotedIdentifiers()
throws SQLException
true if the database stores mixed case quoted
identifiers, false otherwise.
SQLException - If an error occurs.
String getIdentifierQuoteString()
throws SQLException
SQLException - If an error occurs.
String getSQLKeywords()
throws SQLException
SQLException - If an error occurs.
String getNumericFunctions()
throws SQLException
SQLException - If an error occurs.
String getStringFunctions()
throws SQLException
SQLException - If an error occurs.
String getSystemFunctions()
throws SQLException
SQLException - If an error occurs.
String getTimeDateFunctions()
throws SQLException
SQLException - If an error occurs.
String getSearchStringEscape()
throws SQLException
SQLException - If an error occurs.
String getExtraNameCharacters()
throws SQLException
SQLException - If an error occurs.
boolean supportsAlterTableWithAddColumn()
throws SQLException
true if column add supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsAlterTableWithDropColumn()
throws SQLException
true if column drop supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsColumnAliasing()
throws SQLException
true if column aliasing is supported,
false otherwise.
SQLException - If an error occurs.
boolean nullPlusNonNullIsNull()
throws SQLException
true if concatenating NULL and a non-NULL value
returns a NULL, false otherwise.
SQLException - If an error occurs.
boolean supportsConvert()
throws SQLException
true if CONVERT is supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsConvert(int fromType,
int toType)
throws SQLException
Types.
fromType - The SQL type to convert from.toType - The SQL type to convert to.
true if the conversion can be performed,
false otherwise.
SQLExceptionTypes
boolean supportsTableCorrelationNames()
throws SQLException
true in a fully JDBC
compliant driver.
true if table correlation names are supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsDifferentTableCorrelationNames()
throws SQLException
true if the correlation name must be different from
the table name, false otherwise.
SQLException - If an error occurs.
boolean supportsExpressionsInOrderBy()
throws SQLException
true if expressions are allowed in ORDER BY
lists, false otherwise.
SQLException - If an error occurs.
boolean supportsOrderByUnrelated()
throws SQLException
true if a non-selected column can be used in an
ORDER BY, false otherwise.
SQLException - If an error occurs.
boolean supportsGroupBy()
throws SQLException
true if GROUP BY is supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsGroupByUnrelated()
throws SQLException
true if a non-selected column can be used in a
GROUP BY, false otherwise.
SQLException - If an error occurs.
boolean supportsGroupByBeyondSelect()
throws SQLException
true if GROUP BY an add columns provided it includes
all columns in the select, false otherwise.
SQLException - If an error occurs.
boolean supportsLikeEscapeClause()
throws SQLException
true.
true if escapes are supported in LIKE expressions,
false otherwise.
SQLException - If an error occurs.
boolean supportsMultipleResultSets()
throws SQLException
true if multiple result sets are supported for a
single statement, false otherwise.
SQLException - If an error occurs.
boolean supportsMultipleTransactions()
throws SQLException
true if multiple transactions on different
connections are supported, false otherwise.
SQLException - If an error occurs.
boolean supportsNonNullableColumns()
throws SQLException
true.
true if NOT NULL columns are supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsMinimumSQLGrammar()
throws SQLException
true.
true if the ODBC minimum grammar is supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsCoreSQLGrammar()
throws SQLException
true if the ODBC core grammar is supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsExtendedSQLGrammar()
throws SQLException
true if the ODBC extended grammar is supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsANSI92EntryLevelSQL()
throws SQLException
true.
true if the ANSI92 entry level SQL grammar is
supported, false otherwise.
SQLException - If an error occurs.
boolean supportsANSI92IntermediateSQL()
throws SQLException
true if the ANSI92 intermediate SQL grammar is
supported, false otherwise.
SQLException - If an error occurs.
boolean supportsANSI92FullSQL()
throws SQLException
true if the ANSI92 full SQL grammar is
supported, false otherwise.
SQLException - If an error occurs.
boolean supportsIntegrityEnhancementFacility()
throws SQLException
true if the integrity enhancement facility is
supported, false otherwise.
SQLException - If an error occurs.
boolean supportsOuterJoins()
throws SQLException
true if outer joins are supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsFullOuterJoins()
throws SQLException
true if full outer joins are supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsLimitedOuterJoins()
throws SQLException
true if limited outer joins are supported,
false otherwise.
SQLException - If an error occurs.
String getSchemaTerm()
throws SQLException
SQLException - if an error occurs.
String getProcedureTerm()
throws SQLException
SQLException - if an error occurs.
String getCatalogTerm()
throws SQLException
SQLException - if an error occurs.
boolean isCatalogAtStart()
throws SQLException
true if the catalog name appears at the beginning,
false if it appears at the end.
SQLException - If an error occurs.
String getCatalogSeparator()
throws SQLException
SQLException - If an error occurs.
boolean supportsSchemasInDataManipulation()
throws SQLException
true if a catalog name can appear in a data
manipulation statement, false otherwise.
SQLException - If an error occurs.
boolean supportsSchemasInProcedureCalls()
throws SQLException
true if a catalog name can appear in a procedure
call, false otherwise.
SQLException - If an error occurs.
boolean supportsSchemasInTableDefinitions()
throws SQLException
true if a catalog name can appear in a table
definition, false otherwise.
SQLException - If an error occurs.
boolean supportsSchemasInIndexDefinitions()
throws SQLException
true if a catalog name can appear in an index
definition, false otherwise.
SQLException - If an error occurs.
boolean supportsSchemasInPrivilegeDefinitions()
throws SQLException
true if a catalog name can appear in privilege
definition, false otherwise.
SQLException - If an error occurs.
boolean supportsCatalogsInDataManipulation()
throws SQLException
true if a catalog name can appear in a data
manipulation statement, false otherwise.
SQLException - If an error occurs.
boolean supportsCatalogsInProcedureCalls()
throws SQLException
true if a catalog name can appear in a procedure
call, false otherwise.
SQLException - If an error occurs.
boolean supportsCatalogsInTableDefinitions()
throws SQLException
true if a catalog name can appear in a table
definition, false otherwise.
SQLException - If an error occurs.
boolean supportsCatalogsInIndexDefinitions()
throws SQLException
true if a catalog name can appear in an index
definition, false otherwise.
SQLException - If an error occurs.
boolean supportsCatalogsInPrivilegeDefinitions()
throws SQLException
true if a catalog name can appear in privilege
definition, false otherwise.
SQLException - If an error occurs.
boolean supportsPositionedDelete()
throws SQLException
true if positioned deletes are supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsPositionedUpdate()
throws SQLException
true if positioned updates are supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsSelectForUpdate()
throws SQLException
true if SELECT FOR UPDATE is supported
false otherwise.
SQLException - If an error occurs.
boolean supportsStoredProcedures()
throws SQLException
true if stored procedures are supported,
false otherwise.
SQLException - If an error occurs.
boolean supportsSubqueriesInComparisons()
throws SQLException
true.
true if subqueries are allowed in comparisons,
false otherwise.
SQLException - If an error occurs.
boolean supportsSubqueriesInExists()
throws SQLException
true.
true if subqueries are allowed in exists
expressions, false otherwise.
SQLException - If an error occurs.
boolean supportsSubqueriesInIns()
throws SQLException
true.
true if the driver supports subqueries in IN
statements, false otherwise.
SQLException - If an error occurs.
boolean supportsSubqueriesInQuantifieds()
throws SQLException
true.
true if subqueries are allowed in quantified
expressions, false otherwise.
SQLException - If an error occurs.
boolean supportsCorrelatedSubqueries()
throws SQLException
true.
true if correlated subqueries are allowed,
false otherwise.
SQLException - If an error occurs.
boolean supportsUnion()
throws SQLException
true if UNION is supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsUnionAll()
throws SQLException
true if UNION ALL is supported, false
otherwise.
SQLException - If an error occurs.
boolean supportsOpenCursorsAcrossCommit()
throws SQLException
true if cursors can remain open across commits,
false otherwise.
SQLException - If an error occurs.
boolean supportsOpenCursorsAcrossRollback()
throws SQLException
true if cursors can remain open across rollbacks,
false otherwise.
SQLException - If an error occurs.
boolean supportsOpenStatementsAcrossCommit()
throws SQLException
true if statements can remain open across commits,
false otherwise.
SQLException - If an error occurs.
boolean supportsOpenStatementsAcrossRollback()
throws SQLException
true if statements can remain open across rollbacks,
false otherwise.
SQLException - If an error occurs.
int getMaxBinaryLiteralLength()
throws SQLException
SQLException - If an error occurs.
int getMaxCharLiteralLength()
throws SQLException
SQLException - If an error occurs.
int getMaxColumnNameLength()
throws SQLException
SQLException - If an error occurs.
int getMaxColumnsInGroupBy()
throws SQLException
SQLException - If an error occurs.
int getMaxColumnsInIndex()
throws SQLException
SQLException - If an error occurs.
int getMaxColumnsInOrderBy()
throws SQLException
SQLException - If an error occurs.
int getMaxColumnsInSelect()
throws SQLException
SQLException - If an error occurs.
int getMaxColumnsInTable()
throws SQLException
SQLException - If an error occurs.
int getMaxConnections()
throws SQLException
SQLException
int getMaxCursorNameLength()
throws SQLException
SQLException - If an error occurs.
int getMaxIndexLength()
throws SQLException
SQLException - If an error occurs.
int getMaxSchemaNameLength()
throws SQLException
SQLException - If an error occurs.
int getMaxProcedureNameLength()
throws SQLException
SQLException - If an error occurs.
int getMaxCatalogNameLength()
throws SQLException
SQLException - If an error occurs.
int getMaxRowSize()
throws SQLException
SQLException - If an error occurs.
boolean doesMaxRowSizeIncludeBlobs()
throws SQLException
true if the maximum row size includes BLOB's,
false otherwise.
SQLException - If an error occurs.
int getMaxStatementLength()
throws SQLException
SQLException - If an error occurs.
int getMaxStatements()
throws SQLException
SQLException - If an error occurs.
int getMaxTableNameLength()
throws SQLException
SQLException - If an error occurs.
int getMaxTablesInSelect()
throws SQLException
SQLException - If an error occurs.
int getMaxUserNameLength()
throws SQLException
SQLException - If an error occurs.
int getDefaultTransactionIsolation()
throws SQLException
SQLException - If an error occurs.Connection
boolean supportsTransactions()
throws SQLException
true if the database supports transactions,
false otherwise.
SQLException - If an error occurs.
boolean supportsTransactionIsolationLevel(int level)
throws SQLException
level - The transaction isolation level.
true if the specified transaction isolation level
is supported, false otherwise.
SQLException - If an error occurs.
boolean supportsDataDefinitionAndDataManipulationTransactions()
throws SQLException
true if DDL and DML statements are allowed in the
same transaction, false otherwise.
SQLException - If an error occurs.
boolean supportsDataManipulationTransactionsOnly()
throws SQLException
true if only DML statements are allowed in
transactions, false otherwise.
SQLException - If an error occurs.
boolean dataDefinitionCausesTransactionCommit()
throws SQLException
true if DDL causes an immediate transaction commit,
false otherwise.
SQLException - If an error occurs.
boolean dataDefinitionIgnoredInTransactions()
throws SQLException
true if DDL statements are ignored in transactions,
false otherwise.
SQLException - If an error occurs.
ResultSet getProcedures(String catalog,
String schemaPattern,
String procedurePattern)
throws SQLException
ResultSet with the following columns:
null.null.procedureResultUnknown, procedureNoResult, or
procedureReturnsResult).
catalog - The name of the catalog to return stored procedured from,
or "" to return procedures from all catalogs.schemaPattern - A schema pattern for the schemas to return stored
procedures from, or "" to return procedures from all schemas.procedurePattern - The pattern of procedure names to return.
SQLException - If an error occurs.
ResultSet getProcedureColumns(String catalog,
String schemaPattern,
String procedurePattern,
String columnPattern)
throws SQLException
ResultSet with the following columns:
null.null.procedureColumnUnknown,
procedureColumnIn, procedureColumnInOut,
procedureColumnOut, procedureColumnReturn,
or procedureColumnResult).Types.procedureNoNulls,
procedureNullable, or procedureNullableUnknown)
catalog - The name of the catalog to return stored procedured from,
or "" to return procedures from all catalogs.schemaPattern - A schema pattern for the schemas to return stored
procedures from, or "" to return procedures from all schemas.procedurePattern - The pattern of procedures names to return.columnPattern - The pattern of column names to return.
SQLException - If an error occurs.
ResultSet getTables(String catalog,
String schemaPattern,
String tablePattern,
String[] types)
throws SQLException
ResultSet with the following columns:
null.null.getTableTypes() method.
catalog - The name of the catalog to return tables from,
or "" to return tables from all catalogs.schemaPattern - A schema pattern for the schemas to return tables
from, or "" to return tables from all schemas.tablePattern - The pattern of table names to return.types - The list of table types to include; null returns all types.
SQLException - If an error occurs.
ResultSet getSchemas()
throws SQLException
ResultSet, with one column - TABLE_SCHEM - that is the
name of the schema.
ResultSet with all the requested schemas.
SQLException - If an error occurs.
ResultSet getCatalogs()
throws SQLException
ResultSet with one column - TABLE_CAT - that is the
name of the catalog.
ResultSet with all the requested catalogs.
SQLException - If an error occurs.
ResultSet getTableTypes()
throws SQLException
ResultSet with one column - TABLE_TYPE - that is the
name of the table type.
ResultSet with all the requested table types.
SQLException - If an error occurs.
ResultSet getColumns(String catalog,
String schemaPattern,
String tablePattern,
String columnPattern)
throws SQLException
ResultSet with the following columns:
null.null.Types.tableNoNulls,
tableNullable, or tableNullableUnknown)null.
catalog - The name of the catalog to return table from,
or "" to return tables from all catalogs.schemaPattern - A schema pattern for the schemas to return
tables from, or "" to return tables from all schemas.tablePattern - The pattern of table names to return.columnPattern - The pattern of column names to return.
SQLException - If an error occurs.
ResultSet getColumnPrivileges(String catalog,
String schema,
String tableName,
String columnPattern)
throws SQLException
ResultSet
with the following columns:
null.null.null if unknown.
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for.columnPattern - A pattern of column names to return information for.
ResultSet with all the requested privileges.
SQLException - If an error occurs.
ResultSet getTablePrivileges(String catalog,
String schemaPattern,
String tablePattern)
throws SQLException
ResultSet
with the following columns:
null.null.null if unknown.
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schemaPattern - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tablePattern - The table name pattern of tables to return
information for.
ResultSet with all the requested privileges.
SQLException - If an error occurs.
ResultSet getBestRowIdentifier(String catalog,
String schema,
String tableName,
int scope,
boolean nullable)
throws SQLException
ResultSet with
the following columns:
bestRowTemporary,
bestRowTransaction, or bestRowSession).Types.bestRowUnknown, bestRowNotPseudo, or
bestRowPseudo).
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for.scope - One of the best row id scope constants from this class.nullable - true to include columns that are nullable,
false otherwise.
ResultSet with the best row identifier.
SQLException - If an error occurs.
ResultSet getVersionColumns(String catalog,
String schema,
String tableName)
throws SQLException
ResultSet with the following columns:
Types.versionRowUnknown, versionRowNotPseudo, or
versionRowPseudo).
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for
ResultSet with the version columns.
SQLException - If an error occurs.
ResultSet getPrimaryKeys(String catalog,
String schema,
String tableName)
throws SQLException
ResultSet with the following columns.
null.null.null.
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for.
ResultSet with the primary key columns.
SQLException - If an error occurs.
ResultSet getImportedKeys(String catalog,
String schema,
String tableName)
throws SQLException
ResultSet with the following columns:
importedNoAction, importedKeyCascade,
importedKeySetNull, importedKeySetDefault, or
importedKeyRestrict).importedNoAction, importedKeyCascade,
importedKeySetNull, or importedKeySetDefault)importedKeyInitiallyDeferred,
importedKeyInitiallyImmediate, or
importedKeyNotDeferrable).
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for.
ResultSet with the foreign key columns.
SQLException - If an error occurs.
ResultSet getExportedKeys(String catalog,
String schema,
String tableName)
throws SQLException
ResultSet with the following columns:
importedNoAction, importedKeyCascade,
importedKeySetNull, importedKeySetDefault, or
importedKeyRestrict).importedNoAction, importedKeyCascade,
importedKeySetNull, or importedKeySetDefault)importedKeyInitiallyDeferred,
importedKeyInitiallyImmediate, or
importedKeyNotDeferrable).
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for.
ResultSet with the requested information
SQLException - If an error occurs.
ResultSet getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTableName,
String foreignCatalog,
String foreignSchema,
String foreignTableName)
throws SQLException
ResultSet with the following columns:
importedNoAction, importedKeyCascade,
importedKeySetNull, importedKeySetDefault, or
importedKeyRestrict).importedNoAction, importedKeyCascade,
importedKeySetNull, or importedKeySetDefault)importedKeyInitiallyDeferred,
importedKeyInitiallyImmediate, or
importedKeyNotDeferrable).
primaryCatalog - The catalog to retrieve information from, or the
empty string to return entities not associated with a catalog, or
null to return information from all catalogs, on the
exporting side.primarySchema - The schema to retrieve information from, or the empty
string to return entities not associated with a schema, on the
exporting side.primaryTableName - The table name to return information for, on the
exporting side.foreignCatalog - The catalog to retrieve information from, or the
empty string to return entities not associated with a catalog,
or null to return information from all catalogs, on
the importing side.foreignSchema - The schema to retrieve information from, or the
empty string to return entities not associated with a schema on
the importing side.foreignTableName - The table name to return information for on the
importing side.
ResultSet with the requested information
SQLException - If an error occurs.
ResultSet getTypeInfo()
throws SQLException
ResultSet
with the following columns:
Types for this
type.null.null.null.typeNoNulls, typeNullable, or
typeNullableUnknown).typePredNone, typePredChar,
typePredBasic, or typeSearchable).
ResultSet with the list of available data types.
SQLException - If an error occurs.
ResultSet getIndexInfo(String catalog,
String schema,
String tableName,
boolean unique,
boolean approximate)
throws SQLException
ResultSet with the following columns:
null.null.nulltableIndexStatistic,
tableIndexClustered, tableIndexHashed, or
tableIndexOther).tableIndexStatistic.null if a sort sequence is not
supported.tableIndexStatistic.tableIndexStatistic.null.
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or
null to return information from all catalogs.schema - The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName - The table name to return information for.unique - true to return only unique indexes,
false otherwise.approximate - true if data values can be approximations,
false otherwise.
ResultSet with the requested index information
SQLException - If an error occurs.
boolean supportsResultSetType(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type is supported,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean supportsResultSetConcurrency(int type,
int concurrency)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.concurrency - The desired concurrency type, which is one of the
constants defined in ResultSet.
true if the result set type is supported,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean ownUpdatesAreVisible(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type sees its own updates,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean ownDeletesAreVisible(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type sees its own deletes,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean ownInsertsAreVisible(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type sees its own inserts,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean othersUpdatesAreVisible(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type sees other updates,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean othersDeletesAreVisible(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type sees other deletes,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean othersInsertsAreVisible(int type)
throws SQLException
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type sees other inserts,
false otherwise.
SQLException - If an error occurs.ResultSet
boolean updatesAreDetected(int type)
throws SQLException
rowUpdated method.
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type can detect visible updates
using rowUpdated, false otherwise.
SQLException - If an error occurs.ResultSet
boolean deletesAreDetected(int type)
throws SQLException
rowUpdated method.
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type can detect visible deletes
using rowUpdated, false otherwise.
SQLException - If an error occurs.ResultSet
boolean insertsAreDetected(int type)
throws SQLException
rowUpdated method.
type - The desired result type, which is one of the constants
defined in ResultSet.
true if the result set type can detect visible inserts
using rowUpdated, false otherwise.
SQLException - If an error occurs.ResultSet
boolean supportsBatchUpdates()
throws SQLException
true if batch updates are supported,
false otherwise.
SQLException - If an error occurs.
ResultSet getUDTs(String catalog,
String schemaPattern,
String typePattern,
int[] types)
throws SQLException
ResultSet with the following columns:
null.null.Types for this type.
This will be one of JAVA_OBJECT, STRUCT, or
DISTINCT.
catalog - The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schemaPattern - The schema to retrieve information from, or the
empty string to return entities not associated with a schema.typePattern - The type name pattern to match.types - The type identifier patterns (from Types) to
match.
ResultSet with the requested type information
SQLException - If an error occurs.
Connection getConnection()
throws SQLException
Connection object that was used
to generate the metadata in this object.
SQLException - If an error occurs.
boolean supportsSavepoints()
throws SQLException
true if the database supports savepoints,
false if it does not.
SQLException - If an error occurs.Savepoint
boolean supportsNamedParameters()
throws SQLException
true if the database supports named parameters,
false if it does not.
SQLException - If an error occurs.
boolean supportsMultipleOpenResults()
throws SQLException
ResultSetS from a CallableStatement at once.
true if the database supports returnig multiple
results at once, false if it does not.
SQLException - If an error occurs.
boolean supportsGetGeneratedKeys()
throws SQLException
SQLException
ResultSet getSuperTypes(String catalog,
String schemaPattern,
String typePattern)
throws SQLException
SQLException
ResultSet getSuperTables(String catalog,
String schemaPattern,
String tablePattern)
throws SQLException
SQLException
ResultSet getAttributes(String catalog,
String schemaPattern,
String typePattern,
String attributePattern)
throws SQLException
SQLException
boolean supportsResultSetHoldability(int holdability)
throws SQLException
ResultSet class.
holdability - The holdability type to test.
true if the database supports the holdability type,
false if it does not.
SQLException - If an error occurs.ResultSet
int getResultSetHoldability()
throws SQLException
ResultSetS
retrieved from this database. The possible values are specified in the
ResultSet class.
SQLException - If an error occurs.
int getDatabaseMajorVersion()
throws SQLException
SQLException - If an error occurs.
int getDatabaseMinorVersion()
throws SQLException
SQLException - If an error occurs.
int getJDBCMajorVersion()
throws SQLException
SQLException - If an error occurs.
int getJDBCMinorVersion()
throws SQLException
SQLException - If an error occurs.
int getSQLStateType()
throws SQLException
SQLException
boolean locatorsUpdateCopy()
throws SQLException
SQLException
boolean supportsStatementPooling()
throws SQLException
SQLException
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||