|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.as400.access.AS400JDBCDatabaseMetaData
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 server:
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.
Fields inherited from interface java.sql.DatabaseMetaData |
bestRowNotPseudo,
bestRowPseudo,
bestRowSession,
bestRowTemporary,
bestRowTransaction,
bestRowUnknown,
columnNoNulls,
columnNullable,
columnNullableUnknown,
importedKeyCascade,
importedKeyInitiallyDeferred,
importedKeyInitiallyImmediate,
importedKeyNoAction,
importedKeyNotDeferrable,
importedKeyRestrict,
importedKeySetDefault,
importedKeySetNull,
procedureColumnIn,
procedureColumnInOut,
procedureColumnOut,
procedureColumnResult,
procedureColumnReturn,
procedureColumnUnknown,
procedureNoNulls,
procedureNoResult,
procedureNullable,
procedureNullableUnknown,
procedureResultUnknown,
procedureReturnsResult,
tableIndexClustered,
tableIndexHashed,
tableIndexOther,
tableIndexStatistic,
typeNoNulls,
typeNullable,
typeNullableUnknown,
typePredBasic,
typePredChar,
typePredNone,
typeSearchable,
versionColumnNotPseudo,
versionColumnPseudo,
versionColumnUnknown |
Method Summary | |
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. |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
Returns a description of a table's optimal set of columns that uniquely identifies a row. |
java.sql.ResultSet |
getCatalogs()
Returns the catalog name available in this database. |
java.lang.String |
getCatalogSeparator()
Returns the naming convention used when referring to tables. |
java.lang.String |
getCatalogTerm()
Returns the DB2 for OS/400 SQL term for "catalog". |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnPattern)
Returns a description of the access rights for a table's columns. |
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern,
java.lang.String columnPattern)
Returns a description of the table's columns available in a catalog. |
java.sql.Connection |
getConnection()
Returns the connection for this metadata. |
java.sql.ResultSet |
getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.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. |
java.lang.String |
getDatabaseProductName()
Returns the name of this database product. |
java.lang.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. |
java.lang.String |
getDriverName()
Returns the name of this JDBC driver. |
java.lang.String |
getDriverVersion()
Returns the version of this JDBC driver. |
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Returns a description of the foreign key columns that reference a table's primary key columns. |
java.lang.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 _). |
java.lang.String |
getIdentifierQuoteString()
Returns the string used to quote SQL identifiers. |
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Returns a description of the primary key columns that are referenced by a table's foreign key columns. |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
Returns a description of a table's indexes and statistics. |
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. |
java.lang.String |
getNumericFunctions()
Returns the list of supported math functions. |
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Returns a description of the primary key columns. |
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedurePattern,
java.lang.String columnPattern)
Returns a description of a catalog's stored procedure parameters and result columns. |
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedurePattern)
Returns the description of the stored procedures available in a catalog. |
java.lang.String |
getProcedureTerm()
Returns the DB2 for OS/400 SQL term for "procedure". |
java.sql.ResultSet |
getSchemas()
Returns the schema names available in this database. |
java.lang.String |
getSchemaTerm()
Returns the DB2 for OS/400 SQL term for "schema". |
java.lang.String |
getSearchStringEscape()
Returns the string used to escape wildcard characters. |
java.lang.String |
getSQLKeywords()
Returns the list of all of the database's SQL keywords that are not also SQL92 keywords. |
java.lang.String |
getStringFunctions()
Returns the list of supported string functions. |
java.lang.String |
getSystemFunctions()
Returns the list of supported system functions. |
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern)
Returns the description of the access rights for each table available in a catalog. |
java.sql.ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern,
java.lang.String[] tableTypes)
Returns the description of the tables available in a catalog. |
java.sql.ResultSet |
getTableTypes()
Returns the table types available in this database. |
java.lang.String |
getTimeDateFunctions()
Returns the list of supported time and date functions. |
java.sql.ResultSet |
getTypeInfo()
Returns a description of all of the standard SQL types supported by this database. |
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
Returns the description of the user-defined types available in a catalog. |
java.lang.String |
getURL()
Returns the URL for this database. |
java.lang.String |
getUserName()
Returns the current user name as known to the database. |
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.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 |
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 |
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 |
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 |
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 |
supportsResultSetType(int resultSetType)
Indicates if the specified result set type is 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 |
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. |
java.lang.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 |
Method Detail |
public boolean allProceduresAreCallable() throws java.sql.SQLException
public boolean allTablesAreSelectable() throws java.sql.SQLException
public boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLException
public boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLException
public boolean deletesAreDetected(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLException
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified and a default library 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.public java.sql.ResultSet getCatalogs() throws java.sql.SQLException
public java.lang.String getCatalogSeparator() throws java.sql.SQLException
public java.lang.String getCatalogTerm() throws java.sql.SQLException
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnPattern) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified and a default library 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 server and the server
default of *all is used. If empty string
is specified, an empty result set is returned.public java.sql.ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern, java.lang.String columnPattern) throws java.sql.SQLException
catalog
- 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 server and the server
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 server and the server
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 server and the server
default of *ALL is used. If empty string
is specified, an empty result set is returned.public java.sql.Connection getConnection() throws java.sql.SQLException
public java.sql.ResultSet getCrossReference(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable) throws java.sql.SQLException
primaryCatalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified,a default library 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default library 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.public java.lang.String getDatabaseProductName() throws java.sql.SQLException
public java.lang.String getDatabaseProductVersion() throws java.sql.SQLException
public int getDefaultTransactionIsolation() throws java.sql.SQLException
public int getDriverMajorVersion()
public int getDriverMinorVersion()
public java.lang.String getDriverName() throws java.sql.SQLException
public java.lang.String getDriverVersion() throws java.sql.SQLException
public java.sql.ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default library 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.public java.lang.String getExtraNameCharacters() throws java.sql.SQLException
public java.lang.String getIdentifierQuoteString() throws java.sql.SQLException
public java.sql.ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default library 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.public java.sql.ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default library 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.public int getMaxBinaryLiteralLength() throws java.sql.SQLException
public int getMaxCatalogNameLength() throws java.sql.SQLException
public int getMaxCharLiteralLength() throws java.sql.SQLException
public int getMaxColumnNameLength() throws java.sql.SQLException
public int getMaxColumnsInGroupBy() throws java.sql.SQLException
public int getMaxColumnsInIndex() throws java.sql.SQLException
public int getMaxColumnsInOrderBy() throws java.sql.SQLException
public int getMaxColumnsInSelect() throws java.sql.SQLException
public int getMaxColumnsInTable() throws java.sql.SQLException
public int getMaxConnections() throws java.sql.SQLException
public int getMaxCursorNameLength() throws java.sql.SQLException
public int getMaxIndexLength() throws java.sql.SQLException
public int getMaxProcedureNameLength() throws java.sql.SQLException
public int getMaxRowSize() throws java.sql.SQLException
public int getMaxSchemaNameLength() throws java.sql.SQLException
public int getMaxStatementLength() throws java.sql.SQLException
public int getMaxStatements() throws java.sql.SQLException
public int getMaxTableNameLength() throws java.sql.SQLException
public int getMaxTablesInSelect() throws java.sql.SQLException
public int getMaxUserNameLength() throws java.sql.SQLException
public java.lang.String getNumericFunctions() throws java.sql.SQLException
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default library 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.public java.sql.ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedurePattern, java.lang.String columnPattern) throws java.sql.SQLException
catalog
- 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.public java.sql.ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedurePattern) throws java.sql.SQLException
catalog
- 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.public java.lang.String getProcedureTerm() throws java.sql.SQLException
public java.sql.ResultSet getSchemas() throws java.sql.SQLException
public java.lang.String getSchemaTerm() throws java.sql.SQLException
public java.lang.String getSearchStringEscape() throws java.sql.SQLException
public java.lang.String getSQLKeywords() throws java.sql.SQLException
public java.lang.String getStringFunctions() throws java.sql.SQLException
public java.lang.String getSystemFunctions() throws java.sql.SQLException
public java.sql.ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern) throws java.sql.SQLException
catalog
- 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 server and the
server 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 server and the server
default of *ALL is used. If empty string
is specified, an empty result set is returned.public java.sql.ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern, java.lang.String[] tableTypes) throws java.sql.SQLException
catalog
- 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 server and the server
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 server and the server
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, and SYSTEM TABLE.public java.sql.ResultSet getTableTypes() throws java.sql.SQLException
public java.lang.String getTimeDateFunctions() throws java.sql.SQLException
public java.sql.ResultSet getTypeInfo() throws java.sql.SQLException
public java.sql.ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types) throws java.sql.SQLException
catalog
- 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 server and the server
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 server and the server
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.public java.lang.String getURL() throws java.sql.SQLException
public java.lang.String getUserName() throws java.sql.SQLException
public java.sql.ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
catalog
- 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 library specified in the URL is used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file is used.
If null is specified, a default library 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.public boolean insertsAreDetected(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean isCatalogAtStart() throws java.sql.SQLException
public boolean isReadOnly() throws java.sql.SQLException
public boolean nullPlusNonNullIsNull() throws java.sql.SQLException
public boolean nullsAreSortedAtEnd() throws java.sql.SQLException
public boolean nullsAreSortedAtStart() throws java.sql.SQLException
public boolean nullsAreSortedHigh() throws java.sql.SQLException
public boolean nullsAreSortedLow() throws java.sql.SQLException
public boolean othersDeletesAreVisible(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean othersInsertsAreVisible(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean othersUpdatesAreVisible(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean ownDeletesAreVisible(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean ownInsertsAreVisible(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean ownUpdatesAreVisible(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean storesLowerCaseIdentifiers() throws java.sql.SQLException
public boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLException
public boolean storesMixedCaseIdentifiers() throws java.sql.SQLException
public boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLException
public boolean storesUpperCaseIdentifiers() throws java.sql.SQLException
public boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLException
public boolean supportsAlterTableWithAddColumn() throws java.sql.SQLException
public boolean supportsAlterTableWithDropColumn() throws java.sql.SQLException
public boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLException
public boolean supportsANSI92FullSQL() throws java.sql.SQLException
public boolean supportsANSI92IntermediateSQL() throws java.sql.SQLException
public boolean supportsBatchUpdates() throws java.sql.SQLException
public boolean supportsCatalogsInDataManipulation() throws java.sql.SQLException
public boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLException
public boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLException
public boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLException
public boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLException
public boolean supportsColumnAliasing() throws java.sql.SQLException
public boolean supportsConvert() throws java.sql.SQLException
public boolean supportsConvert(int fromType, int toType) throws java.sql.SQLException
fromType
- The SQL type code defined in java.sql.Types.toType
- The SQL type code defined in java.sql.Types.public boolean supportsCoreSQLGrammar() throws java.sql.SQLException
public boolean supportsCorrelatedSubqueries() throws java.sql.SQLException
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLException
public boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLException
public boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLException
public boolean supportsExpressionsInOrderBy() throws java.sql.SQLException
public boolean supportsExtendedSQLGrammar() throws java.sql.SQLException
public boolean supportsFullOuterJoins() throws java.sql.SQLException
public boolean supportsGroupBy() throws java.sql.SQLException
public boolean supportsGroupByBeyondSelect() throws java.sql.SQLException
public boolean supportsGroupByUnrelated() throws java.sql.SQLException
public boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLException
public boolean supportsLikeEscapeClause() throws java.sql.SQLException
public boolean supportsLimitedOuterJoins() throws java.sql.SQLException
public boolean supportsMinimumSQLGrammar() throws java.sql.SQLException
public boolean supportsMixedCaseIdentifiers() throws java.sql.SQLException
public boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLException
public boolean supportsMultipleResultSets() throws java.sql.SQLException
public boolean supportsMultipleTransactions() throws java.sql.SQLException
public boolean supportsNonNullableColumns() throws java.sql.SQLException
public boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLException
public boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLException
public boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLException
public boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLException
public boolean supportsOrderByUnrelated() throws java.sql.SQLException
public boolean supportsOuterJoins() throws java.sql.SQLException
public boolean supportsPositionedDelete() throws java.sql.SQLException
public boolean supportsPositionedUpdate() throws java.sql.SQLException
public boolean supportsResultSetConcurrency(int resultSetType, int resultSetConcurrency) throws java.sql.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 | No | Yes |
resultSetType
- The result set type. Valid values are:
resultSetConcurrency
- The result set concurrency. Valid values are:
public boolean supportsResultSetType(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean supportsSchemasInDataManipulation() throws java.sql.SQLException
public boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLException
public boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLException
public boolean supportsSchemasInProcedureCalls() throws java.sql.SQLException
public boolean supportsSchemasInTableDefinitions() throws java.sql.SQLException
public boolean supportsSelectForUpdate() throws java.sql.SQLException
public boolean supportsStoredProcedures() throws java.sql.SQLException
public boolean supportsSubqueriesInComparisons() throws java.sql.SQLException
public boolean supportsSubqueriesInExists() throws java.sql.SQLException
public boolean supportsSubqueriesInIns() throws java.sql.SQLException
public boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLException
public boolean supportsTableCorrelationNames() throws java.sql.SQLException
public boolean supportsTransactionIsolationLevel(int transactionIsolationLevel) throws java.sql.SQLException
transactionIsolationLevel
- One of the Connection.TRANSACTION_*
values.public boolean supportsTransactions() throws java.sql.SQLException
public boolean supportsUnion() throws java.sql.SQLException
public boolean supportsUnionAll() throws java.sql.SQLException
public java.lang.String toString()
public boolean updatesAreDetected(int resultSetType) throws java.sql.SQLException
resultSetType
- The result set type. Value values are:
public boolean usesLocalFilePerTable() throws java.sql.SQLException
public boolean usesLocalFiles() throws java.sql.SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |