|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectcom.ibm.as400.access.AS400JDBCDatabaseMetaData
public class AS400JDBCDatabaseMetaData extends Object implements DatabaseMetaData
The AS400JDBCDatabaseMetaData class provides information about the database as a whole.
Some of the methods in this class take arguments that are pattern strings. Such arguments are suffixed with "Pattern". Within a pattern string, "%" means match any substring of zero or more characters, and "_" means match exactly one character. Only entries matching the pattern string are returned.
For example, if the schemaPattern argument for getTables() is "H%WO_LD", then the following schemas might match the pattern, provided they exist on the system:
HELLOWORLD HIWORLD HWORLD HELLOWOULD HIWOULD
Many of the methods here return lists of information in result sets. You can use the normal ResultSet methods to retrieve data from these result sets. The format of the result sets are described in the JDBC interface specification.
Schema and table names that are passed as input to methods in this class are implicitly uppercased unless enclosed in double-quotes.
| Modifier and Type | Field and Description |
|---|---|
static int |
sqlStateSQL99
|
static int |
sqlStateXOpen
|
| Modifier and Type | Method and Description |
|---|---|
boolean |
allProceduresAreCallable()
Indicates if all of the procedures returned by getProcedures() can be called by the current user. |
boolean |
allTablesAreSelectable()
Indicates if all of the tables returned by getTables() can be SELECTed by the current user. |
boolean |
dataDefinitionCausesTransactionCommit()
Indicates if a data definition statement within a transaction can force the transaction to commit. |
boolean |
dataDefinitionIgnoredInTransactions()
Indicates if a data definition statement within a transaction is ignored. |
boolean |
deletesAreDetected(int resultSetType)
Indicates if visible deletes to a result set of the specified type can be detected by calling ResultSet.rowDeleted(). |
boolean |
doesMaxRowSizeIncludeBlobs()
Indicates if getMaxRowSize() includes blobs when computing the maximum length of a single row. |
ResultSet |
getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
Returns a ResultSet containing a description of type attributes available in a specified catalog. |
ResultSet |
getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
Returns a description of a table's optimal set of columns that uniquely identifies a row. |
ResultSet |
getCatalogs()
Returns the catalog name available in this database. |
String |
getCatalogSeparator()
Returns the naming convention used when referring to tables. |
String |
getCatalogTerm()
Returns the DB2 for IBM i SQL term for "catalog". |
ResultSet |
getClientInfoProperties()
Retrieves a list of the client info properties that the driver supports. |
ResultSet |
getColumnPrivileges(String catalog,
String schema,
String table,
String columnPattern)
Returns a description of the access rights for a table's columns. |
ResultSet |
getColumns(String catalog,
String schemaPattern,
String tablePattern,
String columnPattern)
Returns a description of the table's columns available in a catalog. |
Connection |
getConnection()
Returns the connection for this metadata. |
ResultSet |
getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Returns a description of the foreign key columns in the foreign key table that references the primary key columns of the primary key table. |
int |
getDatabaseMajorVersion()
Returns the major version number of the database. |
int |
getDatabaseMinorVersion()
Returns the minor version number of the database. |
String |
getDatabaseProductName()
Returns the name of this database product. |
String |
getDatabaseProductVersion()
Returns the version of this database product. |
int |
getDefaultTransactionIsolation()
Returns the default transaction isolation level. |
int |
getDriverMajorVersion()
Returns the major version number for this JDBC driver. |
int |
getDriverMinorVersion()
Returns the minor version number for this JDBC driver. |
String |
getDriverName()
Returns the name of this JDBC driver. |
String |
getDriverVersion()
Returns the version of this JDBC driver. |
ResultSet |
getExportedKeys(String catalog,
String schema,
String table)
Returns a description of the foreign key columns that reference a table's primary key columns. |
String |
getExtraNameCharacters()
Returns all of the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9, and _). |
ResultSet |
getFunctionColumns(String catalog,
String schemaPattern,
String functionNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's system or user function parameters and return type. |
ResultSet |
getFunctions(String catalog,
String schemaPattern,
String functionNamePattern)
Retrieves a description of the user functions available in the given catalog. |
String |
getIdentifierQuoteString()
Returns the string used to quote SQL identifiers. |
ResultSet |
getImportedKeys(String catalog,
String schema,
String table)
Returns a description of the primary key columns that are referenced by a table's foreign key columns. |
ResultSet |
getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
Returns a description of a table's indexes and statistics. |
int |
getJDBCMajorVersion()
Returns the JDBC major version number. |
int |
getJDBCMinorVersion()
Returns the JDBC minor version number. |
int |
getMaxBinaryLiteralLength()
Returns the maximum length for an inline binary literal. |
int |
getMaxCatalogNameLength()
Returns the maximum length for a catalog name. |
int |
getMaxCharLiteralLength()
Returns the maximum length for a character literal. |
int |
getMaxColumnNameLength()
Returns the maximum length for a column name. |
int |
getMaxColumnsInGroupBy()
Returns the maximum number of columns in a GROUP BY clause. |
int |
getMaxColumnsInIndex()
Returns the maximum number of columns allowed in an index. |
int |
getMaxColumnsInOrderBy()
Returns the maximum number of columns in an ORDER BY clause. |
int |
getMaxColumnsInSelect()
Returns the maximum number of columns in a SELECT list. |
int |
getMaxColumnsInTable()
Returns the maximum number of columns in a table. |
int |
getMaxConnections()
Returns the number of active connections you can have at a time to this database. |
int |
getMaxCursorNameLength()
Returns the maximum cursor name length. |
int |
getMaxIndexLength()
Returns the maximum length of an index. |
int |
getMaxProcedureNameLength()
Returns the maximum length of a procedure name. |
int |
getMaxRowSize()
Returns the maximum length of a single row. |
int |
getMaxSchemaNameLength()
Returns the maximum length allowed for a schema name. |
int |
getMaxStatementLength()
Returns the maximum length of an SQL statement. |
int |
getMaxStatements()
Returns the number of active statements you can have open at one time. |
int |
getMaxTableNameLength()
Returns the maximum length of a table name. |
int |
getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT. |
int |
getMaxUserNameLength()
Returns the maximum length of a user name. |
String |
getNumericFunctions()
Returns the list of supported math functions. |
ResultSet |
getPrimaryKeys(String catalog,
String schema,
String table)
Returns a description of the primary key columns. |
ResultSet |
getProcedureColumns(String catalog,
String schemaPattern,
String procedurePattern,
String columnPattern)
Returns a description of a catalog's stored procedure parameters and result columns. |
ResultSet |
getProcedures(String catalog,
String schemaPattern,
String procedurePattern)
Returns the description of the stored procedures available in a catalog. |
String |
getProcedureTerm()
Returns the DB2 for IBM i SQL term for "procedure". |
int |
getResultSetHoldability()
Retrieves the default holdability of this ResultSet object. |
ResultSet |
getSchemas()
Returns the schema names available in this database. |
ResultSet |
getSchemas(String catalog,
String schemaPattern)
Retrieves the schema names available in this database. |
String |
getSchemaTerm()
Returns the DB2 for IBM i SQL term for "schema". |
String |
getSearchStringEscape()
Returns the string used to escape wildcard characters. |
String |
getSQLKeywords()
Returns the list of all of the database's SQL keywords that are not also SQL92 keywords. |
int |
getSQLStateType()
Indicates whether the SQLSTATEs returned by SQLException.getSQLState is X/Open SQL CLI or SQL99. |
String |
getStringFunctions()
Returns the list of supported string functions. |
ResultSet |
getSuperTables(String catalog,
String schemaPattern,
String typeNamePattern)
Returns a ResultSet containing descriptions of the table hierarchies in a schema. |
ResultSet |
getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
Returns a ResultSet containing descriptions of user-defined type hierarchies in a schema. |
String |
getSystemFunctions()
Returns the list of supported system functions. |
ResultSet |
getTablePrivileges(String catalog,
String schemaPattern,
String tablePattern)
Returns the description of the access rights for each table available in a catalog. |
ResultSet |
getTables(String catalog,
String schemaPattern,
String tablePattern,
String[] tableTypes)
Returns the description of the tables available in a catalog. |
ResultSet |
getTableTypes()
Returns the table types available in this database. |
String |
getTimeDateFunctions()
Returns the list of supported time and date functions. |
ResultSet |
getTypeInfo()
Returns a description of all of the standard SQL types supported by this database. |
ResultSet |
getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
Returns the description of the user-defined types available in a catalog. |
String |
getURL()
Returns the URL for this database. |
String |
getUserName()
Returns the current user name as known to the database. |
ResultSet |
getVersionColumns(String catalog,
String schema,
String table)
Returns a description of a table's columns that are automatically updated when any value in a row is updated. |
boolean |
insertsAreDetected(int resultSetType)
Indicates if visible inserts to a result set of the specified type can be detected by calling ResultSet.rowInserted(). |
boolean |
isCatalogAtStart()
Indicates if a catalog appears at the start or the end of a qualified name. |
boolean |
isReadOnly()
Indicates if the database is in read-only mode. |
boolean |
locatorsUpdateCopy()
Indicates if updateable LOB methods update a copy of the LOB or if updates are made directly to the LOB. |
boolean |
nullPlusNonNullIsNull()
Indicates if concatenations between null and non-null values are null. |
boolean |
nullsAreSortedAtEnd()
Indicates if null values are sorted at the end regardless of sort order. |
boolean |
nullsAreSortedAtStart()
Indicates if null values are sorted at the start regardless of sort order. |
boolean |
nullsAreSortedHigh()
Indicates if null values are sorted high. |
boolean |
nullsAreSortedLow()
Indicates if null values are sorted low. |
boolean |
othersDeletesAreVisible(int resultSetType)
Indicates if deletes made by others are visible. |
boolean |
othersInsertsAreVisible(int resultSetType)
Indicates if inserts made by others are visible. |
boolean |
othersUpdatesAreVisible(int resultSetType)
Indicates if updates made by others are visible. |
boolean |
ownDeletesAreVisible(int resultSetType)
Indicates if a result set's own deletes are visible. |
boolean |
ownInsertsAreVisible(int resultSetType)
Indicates if a result set's own inserts are visible. |
boolean |
ownUpdatesAreVisible(int resultSetType)
Indicates if a result set's own updates are visible. |
boolean |
storesLowerCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in lowercase. |
boolean |
storesLowerCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in lowercase. |
boolean |
storesMixedCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in mixed case. |
boolean |
storesMixedCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in mixed case. |
boolean |
storesUpperCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in uppercase. |
boolean |
storesUpperCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in uppercase. |
boolean |
supportsAlterTableWithAddColumn()
Indicates if ALTER TABLE with ADD COLUMN is supported. |
boolean |
supportsAlterTableWithDropColumn()
Indicates if ALTER TABLE with DROP COLUMN is supported. |
boolean |
supportsANSI92EntryLevelSQL()
Indicates if the ANSI92 entry-level SQL grammar is supported. |
boolean |
supportsANSI92FullSQL()
Indicates if the ANSI92, full SQL grammar is supported. |
boolean |
supportsANSI92IntermediateSQL()
Indicates if the ANSI92 intermediate-level SQL grammar is supported. |
boolean |
supportsBatchUpdates()
Indicates if the batch updates are supported. |
boolean |
supportsCatalogsInDataManipulation()
Indicates if a catalog name can be used in a data manipulation statement. |
boolean |
supportsCatalogsInIndexDefinitions()
Indicates if a catalog name can be used in an index definition statement. |
boolean |
supportsCatalogsInPrivilegeDefinitions()
Indicates if a catalog name can be used in a privilege definition statement. |
boolean |
supportsCatalogsInProcedureCalls()
Indicates if a catalog name can be used in a procedure call statement. |
boolean |
supportsCatalogsInTableDefinitions()
Indicates if a catalog name can be used in a table definition statement. |
boolean |
supportsColumnAliasing()
Indicates if column aliasing is supported. |
boolean |
supportsConvert()
Indicates if the CONVERT function between SQL types is supported. |
boolean |
supportsConvert(int fromType,
int toType)
Indicates if CONVERT between the given SQL types is supported. |
boolean |
supportsCoreSQLGrammar()
Indicates if the ODBC Core SQL grammar is supported. |
boolean |
supportsCorrelatedSubqueries()
Indicates if the correlated subqueries are supported. |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Indicates if both data definition and data manipulation statements are supported within a transaction. |
boolean |
supportsDataManipulationTransactionsOnly()
Indicates if data manipulation statements are supported within a transaction. |
boolean |
supportsDifferentTableCorrelationNames()
Indicates if table correlation names are supported, and if so, are they restricted to be different from the names of the tables. |
boolean |
supportsExpressionsInOrderBy()
Indicates if expressions in ORDER BY lists are supported. |
boolean |
supportsExtendedSQLGrammar()
Indicates if the ODBC Extended SQL grammar is supported. |
boolean |
supportsFullOuterJoins()
Indicates if full nested outer joins are supported. |
boolean |
supportsGetGeneratedKeys()
Indicates if, after a statement is executed, auto-generated keys can be retrieved using the method Statement.getGeneratedKeys(). |
boolean |
supportsGroupBy()
Indicates if some form of the GROUP BY clause is supported. |
boolean |
supportsGroupByBeyondSelect()
Indicates if a GROUP BY clause can add columns not in the SELECT provided it specifies all of the columns in the SELECT. |
boolean |
supportsGroupByUnrelated()
Indicates if a GROUP BY clause can use columns not in the SELECT. |
boolean |
supportsIntegrityEnhancementFacility()
Indicates if the SQL Integrity Enhancement Facility is supported. |
boolean |
supportsLikeEscapeClause()
Indicates if the escape character in LIKE clauses is supported. |
boolean |
supportsLimitedOuterJoins()
Indicates if there is limited support for outer joins. |
boolean |
supportsMinimumSQLGrammar()
Indicates if the ODBC Minimum SQL grammar is supported. |
boolean |
supportsMixedCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case sensitive and stores them in mixed case. |
boolean |
supportsMixedCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
boolean |
supportsMultipleOpenResults()
Indicates if multiple result sets can be returned from a CallableStatement simultaneously. |
boolean |
supportsMultipleResultSets()
Indicates if multiple result sets from a single execute are supported. |
boolean |
supportsMultipleTransactions()
Indicates if multiple transactions can be open at once (on different connections). |
boolean |
supportsNamedParameters()
Indicates if using parameter names to specify parameters on callable statements are supported. |
boolean |
supportsNonNullableColumns()
Indicates if columns can be defined as non-nullable. |
boolean |
supportsOpenCursorsAcrossCommit()
Indicates if cursors can remain open across commits. |
boolean |
supportsOpenCursorsAcrossRollback()
Indicates if cursors can remain open across rollback. |
boolean |
supportsOpenStatementsAcrossCommit()
Indicates if statements can remain open across commits. |
boolean |
supportsOpenStatementsAcrossRollback()
Indicates if statements can remain open across rollback. |
boolean |
supportsOrderByUnrelated()
Indicates if an ORDER BY clause can use columns not in the SELECT. |
boolean |
supportsOuterJoins()
Indicates if some form of outer join is supported. |
boolean |
supportsPositionedDelete()
Indicates if positioned DELETE is supported. |
boolean |
supportsPositionedUpdate()
Indicates if positioned UPDATE is supported. |
boolean |
supportsResultSetConcurrency(int resultSetType,
int resultSetConcurrency)
Indicates if the specified result set concurrency is supported for the specified result set type. |
boolean |
supportsResultSetHoldability(int resultSetHoldability)
Indicates if a type of result set holdability is supported. |
boolean |
supportsResultSetType(int resultSetType)
Indicates if the specified result set type is supported. |
boolean |
supportsSavepoints()
Indicates if savepoints are supported. |
boolean |
supportsSchemasInDataManipulation()
Indicates if a schema name can be used in a data manipulation statement. |
boolean |
supportsSchemasInIndexDefinitions()
Indicates if a schema name can be used in an index definition statement. |
boolean |
supportsSchemasInPrivilegeDefinitions()
Indicates if a schema name be can used in a privilege definition statement. |
boolean |
supportsSchemasInProcedureCalls()
Indicates if a schema name be can used in a procedure call statement. |
boolean |
supportsSchemasInTableDefinitions()
Indicates if a schema name can be used in a table definition statement. |
boolean |
supportsSelectForUpdate()
Indicates if SELECT for UPDATE is supported. |
boolean |
supportsStatementPooling()
Indicates if statement pooling is supported. |
boolean |
supportsStoredProcedures()
Indicates if stored procedure calls using the stored procedure escape syntax are supported. |
boolean |
supportsSubqueriesInComparisons()
Indicates if subqueries in comparisons are supported. |
boolean |
supportsSubqueriesInExists()
Indicates if subqueries in EXISTS expressions are supported. |
boolean |
supportsSubqueriesInIns()
Indicates if subqueries in IN expressions are supported. |
boolean |
supportsSubqueriesInQuantifieds()
Indicates if subqueries in quantified expressions are supported. |
boolean |
supportsTableCorrelationNames()
Indicates if table correlation names are supported. |
boolean |
supportsTransactionIsolationLevel(int transactionIsolationLevel)
Indicates if the database supports the given transaction isolation level. |
boolean |
supportsTransactions()
Indicates if transactions are supported. |
boolean |
supportsUnion()
Indicates if SQL UNION is supported. |
boolean |
supportsUnionAll()
Indicates if SQL UNION ALL is supported. |
String |
toString()
Returns the name of the catalog. |
boolean |
updatesAreDetected(int resultSetType)
Indicates if visible updates to a result set of the specified type can be detected by calling ResultSet.rowUpdated(). |
boolean |
usesLocalFilePerTable()
Indicates if the database uses a file for each table. |
boolean |
usesLocalFiles()
Indicates if the database stores tables in a local file. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Methods inherited from interface java.sql.DatabaseMetaData |
|---|
autoCommitFailureClosesAllResultSets, getRowIdLifetime, supportsStoredFunctionsUsingCallSyntax |
| Methods inherited from interface java.sql.Wrapper |
|---|
isWrapperFor, unwrap |
| Field Detail |
|---|
public static final int sqlStateXOpen
public static final int sqlStateSQL99
| Method Detail |
|---|
public boolean allProceduresAreCallable()
throws SQLException
allProceduresAreCallable in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean allTablesAreSelectable()
throws SQLException
allTablesAreSelectable in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean dataDefinitionCausesTransactionCommit()
throws SQLException
dataDefinitionCausesTransactionCommit in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean dataDefinitionIgnoredInTransactions()
throws SQLException
dataDefinitionIgnoredInTransactions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean deletesAreDetected(int resultSetType)
throws SQLException
deletesAreDetected in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean doesMaxRowSizeIncludeBlobs()
throws SQLException
doesMaxRowSizeIncludeBlobs in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
throws SQLException
getAttributes in interface DatabaseMetaDatacatalog - The catalog name.schemaPattern - The schema name pattern.typeNamePattern - The type name pattern.attributeNamePattern - The attribute name pattern.SQLException - This exception is never thrown.
public ResultSet getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
throws SQLException
getBestRowIdentifier in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified and a default SQL schema was
not specified in the URL and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.scope - The scope of interest. Valid values are:
bestRowTemporary and bestRowTransaction.
bestRowSession is not allowed because
it cannot be guaranteed that
the row will remain valid for the session.
If bestRowSession is specified, an empty result
set is returned.
If bestRowTransaction is specified,
autocommit is false, and transaction is set to repeatable read,
then results is returned; otherwise, an empty result set
is returned.nullable - The value indicating if columns that are nullable should be included.SQLException - If the connection is not open
or an error occurs.
public ResultSet getCatalogs()
throws SQLException
getCatalogs in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public String getCatalogSeparator()
throws SQLException
getCatalogSeparator in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getCatalogTerm()
throws SQLException
getCatalogTerm in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getColumnPrivileges(String catalog,
String schema,
String table,
String columnPattern)
throws SQLException
getColumnPrivileges in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified and a default SQL schema was
not specified in the URL and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.columnPattern - The column name pattern. If null is specified,
no value is sent to the system and the system
default of *all is used. If empty string
is specified, an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public ResultSet getColumns(String catalog,
String schemaPattern,
String tablePattern,
String columnPattern)
throws SQLException
getColumns in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schemaPattern - The schema name pattern. If null is specified,
no value is sent to the system and the system
default of *USRLIBL is used. If empty string
is specified, an empty result set is returned.tablePattern - The table name pattern. If null is specified,
no value is sent to the system and the system
default of *ALL is used. If empty string
is specified, an empty result set is returned.columnPattern - The column name pattern. If null is specified,
no value is sent to the system and the system
default of *ALL is used. If empty string
is specified, an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public Connection getConnection()
throws SQLException
getConnection in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
throws SQLException
getCrossReference in interface DatabaseMetaDataprimaryCatalog - The catalog name. If null is specified,
this parameter is ignored. If
empty string is specified, an empty
result set is returned.primarySchema - The name of the schema where the primary table
is located.
If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified,a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result
set is returned.primaryTable - The primary table name. If null or empty string
is specified, an empty result set is returned.foreignCatalog - The catalog name. If null is specified,
this parameter is ignored. If
empty string is specified, an empty
result set is returned.foreignSchema - The name of the schema where the primary table
is located. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified,
an empty result set is returned.foreignTable - The foreign table name. If null or empty string
is specified, an empty result set is returned.SQLException - If the connection is not open
or an error occurs.public int getDatabaseMajorVersion()
getDatabaseMajorVersion in interface DatabaseMetaDatapublic int getDatabaseMinorVersion()
getDatabaseMinorVersion in interface DatabaseMetaData
public String getDatabaseProductName()
throws SQLException
getDatabaseProductName in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getDatabaseProductVersion()
throws SQLException
getDatabaseProductVersion in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public int getDefaultTransactionIsolation()
throws SQLException
getDefaultTransactionIsolation in interface DatabaseMetaDataSQLException - This exception is never thrown.public int getDriverMajorVersion()
getDriverMajorVersion in interface DatabaseMetaDatapublic int getDriverMinorVersion()
getDriverMinorVersion in interface DatabaseMetaData
public String getDriverName()
throws SQLException
getDriverName in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getDriverVersion()
throws SQLException
getDriverVersion in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getExportedKeys(String catalog,
String schema,
String table)
throws SQLException
getExportedKeys in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public String getExtraNameCharacters()
throws SQLException
getExtraNameCharacters in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getIdentifierQuoteString()
throws SQLException
getIdentifierQuoteString in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getImportedKeys(String catalog,
String schema,
String table)
throws SQLException
getImportedKeys in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public ResultSet getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
throws SQLException
getIndexInfo in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.unique - The value indicating if unique indexes should be returned.
If true, only indexes for unique values is returned.
If false, all indexes is returned.approximate - The value indicating if the result is allowed to reflect
approximate or out-of-date values. This value is ignored.SQLException - If the connection is not open
or an error occurs.
public int getJDBCMajorVersion()
throws SQLException
getJDBCMajorVersion in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getJDBCMinorVersion()
throws SQLException
getJDBCMinorVersion in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxBinaryLiteralLength()
throws SQLException
getMaxBinaryLiteralLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxCatalogNameLength()
throws SQLException
getMaxCatalogNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxCharLiteralLength()
throws SQLException
getMaxCharLiteralLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxColumnNameLength()
throws SQLException
getMaxColumnNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxColumnsInGroupBy()
throws SQLException
getMaxColumnsInGroupBy in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxColumnsInIndex()
throws SQLException
getMaxColumnsInIndex in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxColumnsInOrderBy()
throws SQLException
getMaxColumnsInOrderBy in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxColumnsInSelect()
throws SQLException
getMaxColumnsInSelect in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxColumnsInTable()
throws SQLException
getMaxColumnsInTable in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxConnections()
throws SQLException
getMaxConnections in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxCursorNameLength()
throws SQLException
getMaxCursorNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxIndexLength()
throws SQLException
getMaxIndexLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxProcedureNameLength()
throws SQLException
getMaxProcedureNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxRowSize()
throws SQLException
getMaxRowSize in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxSchemaNameLength()
throws SQLException
getMaxSchemaNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxStatementLength()
throws SQLException
getMaxStatementLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxStatements()
throws SQLException
getMaxStatements in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxTableNameLength()
throws SQLException
getMaxTableNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxTablesInSelect()
throws SQLException
getMaxTablesInSelect in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getMaxUserNameLength()
throws SQLException
getMaxUserNameLength in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getNumericFunctions()
throws SQLException
getNumericFunctions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getPrimaryKeys(String catalog,
String schema,
String table)
throws SQLException
getPrimaryKeys in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public ResultSet getProcedureColumns(String catalog,
String schemaPattern,
String procedurePattern,
String columnPattern)
throws SQLException
getProcedureColumns in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schemaPattern - The schema name pattern. If null is specified,
it will not be included in the selection
criteria. If empty string
is specified, an empty result set is returned.procedurePattern - The procedure name pattern. If null is specified,
it will not be included in the selection criteria.
If empty string
is specified, an empty result set is returned.columnPattern - The column name pattern. If null is specified,
it will not be included in the selection criteria.
If empty string
is specified, an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public ResultSet getProcedures(String catalog,
String schemaPattern,
String procedurePattern)
throws SQLException
getProcedures in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schemaPattern - The schema name pattern. If null is specified,
it will not be included in the selection
criteria. If empty string
is specified, an empty result set is returned.procedurePattern - The procedure name pattern. If null is specified,
it will not be included in the selection
criteria. If empty string
is specified, an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public String getProcedureTerm()
throws SQLException
getProcedureTerm in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getResultSetHoldability()
throws SQLException
getResultSetHoldability in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getSchemas()
throws SQLException
getSchemas in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public String getSchemaTerm()
throws SQLException
getSchemaTerm in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getSearchStringEscape()
throws SQLException
getSearchStringEscape in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getSQLKeywords()
throws SQLException
getSQLKeywords in interface DatabaseMetaDataSQLException - This exception is never thrown.
public int getSQLStateType()
throws SQLException
getSQLStateType in interface DatabaseMetaDataSQLException - This exception is never thrown.
public String getStringFunctions()
throws SQLException
getStringFunctions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getSuperTables(String catalog,
String schemaPattern,
String typeNamePattern)
throws SQLException
getSuperTables in interface DatabaseMetaDatacatalog - The catalog name.schemaPattern - The schema name pattern.typeNamePattern - The type name pattern.SQLException - This exception is never thrown.
public ResultSet getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
throws SQLException
getSuperTypes in interface DatabaseMetaDatacatalog - The catalog name.schemaPattern - The schema name pattern.typeNamePattern - The type name pattern.SQLException - This exception is never thrown.
public String getSystemFunctions()
throws SQLException
getSystemFunctions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getTablePrivileges(String catalog,
String schemaPattern,
String tablePattern)
throws SQLException
getTablePrivileges in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schemaPattern - The schema name pattern. If null is specified,
no value is sent to the system and the
system default of *USRLIBL is used.
If empty string is specified, an empty
result set is returned.tablePattern - The table name. If null is specified,
no value is sent to the system and the system
default of *ALL is used. If empty string
is specified, an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public ResultSet getTables(String catalog,
String schemaPattern,
String tablePattern,
String[] tableTypes)
throws SQLException
getTables in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schemaPattern - The schema name pattern. If null is specified,
no value is sent to the system and the system
default of *USRLIBL is used. If empty string
is specified, an empty result set is returned.tablePattern - The table name pattern. If null is specified,
no value is sent to the system and the system
default of *ALL is used. If empty string
is specified, an empty result set is returned.tableTypes - The list of table types to include, or null to
include all table types. Valid types are:
TABLE, VIEW, SYSTEM TABLE, MATERIALIZED QUERY TABLE, and ALIAS.SQLException - If the connection is not open
or an error occurs.
public ResultSet getTableTypes()
throws SQLException
getTableTypes in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public String getTimeDateFunctions()
throws SQLException
getTimeDateFunctions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getTypeInfo()
throws SQLException
getTypeInfo in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
throws SQLException
getUDTs in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schemaPattern - The schema name pattern. If null is specified,
no value is sent to the system and the system
default of *USRLIBL is used. If empty string
is specified, an empty result set is returned.typeNamePattern - The type name pattern. If null is specified,
no value is sent to the system and the system
default of *ALL is used. If empty string
is specified, an empty result set is returned.types - The list of user-defined types to include, or null to
include all user-defined types. Valid types are:
JAVA_OBJECT, STRUCT, and DISTINCT.SQLException - If the connection is not open
or an error occurs.
public String getURL()
throws SQLException
getURL in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public String getUserName()
throws SQLException
getUserName in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public ResultSet getVersionColumns(String catalog,
String schema,
String table)
throws SQLException
getVersionColumns in interface DatabaseMetaDatacatalog - The catalog name. If null is specified, this parameter
is ignored. If empty string is specified,
an empty result set is returned.schema - The schema name. If null is specified, the
default SQL schema specified in the URL is used.
If null is specified and a default SQL schema was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default SQL schema was
not specified in the URL, and a library was not
specified in the libraries properties file,
QGPL is used.
If empty string is specified, an empty result set will
be returned.table - The table name. If null or empty string is specified,
an empty result set is returned.SQLException - If the connection is not open
or an error occurs.
public boolean insertsAreDetected(int resultSetType)
throws SQLException
insertsAreDetected in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean isCatalogAtStart()
throws SQLException
isCatalogAtStart in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean isReadOnly()
throws SQLException
isReadOnly in interface DatabaseMetaDataSQLException - If the connection is not open
or an error occurs.
public boolean locatorsUpdateCopy()
throws SQLException
locatorsUpdateCopy in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean nullPlusNonNullIsNull()
throws SQLException
nullPlusNonNullIsNull in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean nullsAreSortedAtEnd()
throws SQLException
nullsAreSortedAtEnd in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean nullsAreSortedAtStart()
throws SQLException
nullsAreSortedAtStart in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean nullsAreSortedHigh()
throws SQLException
nullsAreSortedHigh in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean nullsAreSortedLow()
throws SQLException
nullsAreSortedLow in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean othersDeletesAreVisible(int resultSetType)
throws SQLException
othersDeletesAreVisible in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean othersInsertsAreVisible(int resultSetType)
throws SQLException
othersInsertsAreVisible in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean othersUpdatesAreVisible(int resultSetType)
throws SQLException
othersUpdatesAreVisible in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean ownDeletesAreVisible(int resultSetType)
throws SQLException
ownDeletesAreVisible in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean ownInsertsAreVisible(int resultSetType)
throws SQLException
ownInsertsAreVisible in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean ownUpdatesAreVisible(int resultSetType)
throws SQLException
ownUpdatesAreVisible in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean storesLowerCaseIdentifiers()
throws SQLException
storesLowerCaseIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean storesLowerCaseQuotedIdentifiers()
throws SQLException
storesLowerCaseQuotedIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean storesMixedCaseIdentifiers()
throws SQLException
storesMixedCaseIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean storesMixedCaseQuotedIdentifiers()
throws SQLException
storesMixedCaseQuotedIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean storesUpperCaseIdentifiers()
throws SQLException
storesUpperCaseIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean storesUpperCaseQuotedIdentifiers()
throws SQLException
storesUpperCaseQuotedIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsAlterTableWithAddColumn()
throws SQLException
supportsAlterTableWithAddColumn in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsAlterTableWithDropColumn()
throws SQLException
supportsAlterTableWithDropColumn in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsANSI92EntryLevelSQL()
throws SQLException
supportsANSI92EntryLevelSQL in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsANSI92FullSQL()
throws SQLException
supportsANSI92FullSQL in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsANSI92IntermediateSQL()
throws SQLException
supportsANSI92IntermediateSQL in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsBatchUpdates()
throws SQLException
supportsBatchUpdates in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsCatalogsInDataManipulation()
throws SQLException
supportsCatalogsInDataManipulation in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsCatalogsInIndexDefinitions()
throws SQLException
supportsCatalogsInIndexDefinitions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsCatalogsInPrivilegeDefinitions()
throws SQLException
supportsCatalogsInPrivilegeDefinitions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsCatalogsInProcedureCalls()
throws SQLException
supportsCatalogsInProcedureCalls in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsCatalogsInTableDefinitions()
throws SQLException
supportsCatalogsInTableDefinitions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsColumnAliasing()
throws SQLException
supportsColumnAliasing in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsConvert()
throws SQLException
supportsConvert in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsConvert(int fromType,
int toType)
throws SQLException
supportsConvert in interface DatabaseMetaDatafromType - The SQL type code defined in java.sql.Types.toType - The SQL type code defined in java.sql.Types.SQLException - This exception is never thrown.
public boolean supportsCoreSQLGrammar()
throws SQLException
supportsCoreSQLGrammar in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsCorrelatedSubqueries()
throws SQLException
supportsCorrelatedSubqueries in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsDataDefinitionAndDataManipulationTransactions()
throws SQLException
supportsDataDefinitionAndDataManipulationTransactions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsDataManipulationTransactionsOnly()
throws SQLException
supportsDataManipulationTransactionsOnly in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsDifferentTableCorrelationNames()
throws SQLException
supportsDifferentTableCorrelationNames in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsExpressionsInOrderBy()
throws SQLException
supportsExpressionsInOrderBy in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsExtendedSQLGrammar()
throws SQLException
supportsExtendedSQLGrammar in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsFullOuterJoins()
throws SQLException
supportsFullOuterJoins in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsGetGeneratedKeys()
throws SQLException
supportsGetGeneratedKeys in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsGroupBy()
throws SQLException
supportsGroupBy in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsGroupByBeyondSelect()
throws SQLException
supportsGroupByBeyondSelect in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsGroupByUnrelated()
throws SQLException
supportsGroupByUnrelated in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsIntegrityEnhancementFacility()
throws SQLException
supportsIntegrityEnhancementFacility in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsLikeEscapeClause()
throws SQLException
supportsLikeEscapeClause in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsLimitedOuterJoins()
throws SQLException
supportsLimitedOuterJoins in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsMinimumSQLGrammar()
throws SQLException
supportsMinimumSQLGrammar in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsMixedCaseIdentifiers()
throws SQLException
supportsMixedCaseIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsMixedCaseQuotedIdentifiers()
throws SQLException
supportsMixedCaseQuotedIdentifiers in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsMultipleOpenResults()
throws SQLException
supportsMultipleOpenResults in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsMultipleResultSets()
throws SQLException
supportsMultipleResultSets in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsMultipleTransactions()
throws SQLException
supportsMultipleTransactions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsNamedParameters()
throws SQLException
supportsNamedParameters in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsNonNullableColumns()
throws SQLException
supportsNonNullableColumns in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsOpenCursorsAcrossCommit()
throws SQLException
supportsOpenCursorsAcrossCommit in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsOpenCursorsAcrossRollback()
throws SQLException
supportsOpenCursorsAcrossRollback in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsOpenStatementsAcrossCommit()
throws SQLException
supportsOpenStatementsAcrossCommit in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsOpenStatementsAcrossRollback()
throws SQLException
supportsOpenStatementsAcrossRollback in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsOrderByUnrelated()
throws SQLException
supportsOrderByUnrelated in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsOuterJoins()
throws SQLException
supportsOuterJoins in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsPositionedDelete()
throws SQLException
supportsPositionedDelete in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsPositionedUpdate()
throws SQLException
supportsPositionedUpdate in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsResultSetConcurrency(int resultSetType,
int resultSetConcurrency)
throws SQLException
This chart describes the combinations of result set concurrency
and type that this driver supports:
| CONCUR_READ_ONLY | CONCUR_UPDATABLE | |
|---|---|---|
| TYPE_FORWARD_ONLY | Yes | Yes |
| TYPE_SCROLL_INSENSITIVE | Yes | No |
| TYPE_SCROLL_SENSITIVE | Yes | Yes |
supportsResultSetConcurrency in interface DatabaseMetaDataresultSetType - The result set type. Valid values are:
resultSetConcurrency - The result set concurrency. Valid values are:
SQLException - If the result set type or result set
concurrency is not valid.
public boolean supportsResultSetHoldability(int resultSetHoldability)
throws SQLException
supportsResultSetHoldability in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSavepoints()
throws SQLException
supportsSavepoints in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsResultSetType(int resultSetType)
throws SQLException
supportsResultSetType in interface DatabaseMetaDataresultSetType - The result set type. Valid values are:
SQLException - If the result set type is not valid.
public boolean supportsSchemasInDataManipulation()
throws SQLException
supportsSchemasInDataManipulation in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSchemasInIndexDefinitions()
throws SQLException
supportsSchemasInIndexDefinitions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSchemasInPrivilegeDefinitions()
throws SQLException
supportsSchemasInPrivilegeDefinitions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSchemasInProcedureCalls()
throws SQLException
supportsSchemasInProcedureCalls in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSchemasInTableDefinitions()
throws SQLException
supportsSchemasInTableDefinitions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSelectForUpdate()
throws SQLException
supportsSelectForUpdate in interface DatabaseMetaDataSQLException - This exception is never thrown.public boolean supportsStatementPooling()
supportsStatementPooling in interface DatabaseMetaData
public boolean supportsStoredProcedures()
throws SQLException
supportsStoredProcedures in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSubqueriesInComparisons()
throws SQLException
supportsSubqueriesInComparisons in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSubqueriesInExists()
throws SQLException
supportsSubqueriesInExists in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSubqueriesInIns()
throws SQLException
supportsSubqueriesInIns in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsSubqueriesInQuantifieds()
throws SQLException
supportsSubqueriesInQuantifieds in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsTableCorrelationNames()
throws SQLException
supportsTableCorrelationNames in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsTransactionIsolationLevel(int transactionIsolationLevel)
throws SQLException
supportsTransactionIsolationLevel in interface DatabaseMetaDatatransactionIsolationLevel - One of the Connection.TRANSACTION_*
values.SQLException - If the transaction isolation level is not valid.
public boolean supportsTransactions()
throws SQLException
supportsTransactions in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsUnion()
throws SQLException
supportsUnion in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean supportsUnionAll()
throws SQLException
supportsUnionAll in interface DatabaseMetaDataSQLException - This exception is never thrown.public String toString()
toString in class Object
public boolean updatesAreDetected(int resultSetType)
throws SQLException
updatesAreDetected in interface DatabaseMetaDataresultSetType - The result set type. Value values are:
SQLException - If the result set type is not valid.
public boolean usesLocalFilePerTable()
throws SQLException
usesLocalFilePerTable in interface DatabaseMetaDataSQLException - This exception is never thrown.
public boolean usesLocalFiles()
throws SQLException
usesLocalFiles in interface DatabaseMetaDataSQLException - This exception is never thrown.
public ResultSet getClientInfoProperties()
throws SQLException
The ResultSet is sorted by the NAME column in ascending order
getClientInfoProperties in interface DatabaseMetaDataResultSet object; each row is a supported client info
property
SQLException - if a database access error occurs
public ResultSet getSchemas(String catalog,
String schemaPattern)
throws SQLException
The schema column is:
null)
getSchemas in interface DatabaseMetaDatacatalog - a catalog name; must match the catalog name as it is stored
in the database;"" retrieves those without a catalog; null means catalog
name should not be used to narrow down the search.schemaPattern - a schema name; must match the schema name as it is
stored in the database; null means
schema name should not be used to narrow down the search.ResultSet object in which each row is a
schema decriptionSQLException - if a database access error occursgetSearchStringEscape()
public ResultSet getFunctions(String catalog,
String schemaPattern,
String functionNamePattern)
throws SQLException
Only system and user function descriptions matching the schema and
function name criteria are returned. They are ordered by
FUNCTION_CAT, FUNCTION_SCHEM,
FUNCTION_NAME and
SPECIFIC_ NAME.
Each function description has the the following columns:
null)
null)
FUNCTION_NAME
for example with overload functions
A user may not have permissions to execute any of the functions that are
returned by getFunctions
getFunctions in interface DatabaseMetaDatacatalog - a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
null means that the catalog name should not be used to narrow
the searchschemaPattern - a schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
null means that the schema name should not be used to narrow
the searchfunctionNamePattern - a function name pattern; must match the
function name as it is stored in the databaseResultSet - each row is a function descriptionSQLException - if a database access error occursgetSearchStringEscape()
public ResultSet getFunctionColumns(String catalog,
String schemaPattern,
String functionNamePattern,
String columnNamePattern)
throws SQLException
Only descriptions matching the schema, function and
parameter name criteria are returned. They are ordered by
FUNCTION_CAT, FUNCTION_SCHEM,
FUNCTION_NAME and
SPECIFIC_ NAME. Within this, the return value,
if any, is first. Next are the parameter descriptions in call
order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description, column description or
return type description with the following fields:
null)
null)
ResultSet
FUNCTION_NAME
for example with overload functions
The PRECISION column represents the specified column size for the given parameter or column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getFunctionColumns in interface DatabaseMetaDatacatalog - a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
null means that the catalog name should not be used to narrow
the searchschemaPattern - a schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
null means that the schema name should not be used to narrow
the searchfunctionNamePattern - a procedure name pattern; must match the
function name as it is stored in the databasecolumnNamePattern - a parameter name pattern; must match the
parameter or column name as it is stored in the databaseResultSet - each row describes a
user function parameter, column or return typeSQLException - if a database access error occursgetSearchStringEscape()
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||