All Packages Class Hierarchy This Package Previous Next Index
Class com.ibm.as400.access.AS400JDBCDatabaseMetaData
java.lang.Object
|
+----com.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 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.
-
allProceduresAreCallable()
- Indicates if all of the procedures returned by getProcedures() can be
called by the current user.
-
allTablesAreSelectable()
- Indicates if all of the tables returned by getTables() can be
SELECTed by the current user.
-
dataDefinitionCausesTransactionCommit()
- Indicates if a data definition statement within a transaction
can force the transaction to commit.
-
dataDefinitionIgnoredInTransactions()
- Indicates if a data definition statement within a transaction is
ignored.
-
deletesAreDetected(int)
- Indicates if visible deletes to a result set of the specified type
can be detected by calling ResultSet.rowDeleted().
-
doesMaxRowSizeIncludeBlobs()
- Indicates if getMaxRowSize() includes blobs when computing the
maximum length of a single row.
-
getBestRowIdentifier(String, String, String, int, boolean)
- Returns a description of a table's optimal set of columns
that uniquely identifies a row.
-
getCatalogs()
- Returns the catalog name available in this database.
-
getCatalogSeparator()
- Returns the naming convention used when referring to tables.
-
getCatalogTerm()
- Returns the DB2 for OS/400 SQL term for "catalog".
-
getColumnPrivileges(String, String, String, String)
- Returns a description of the access rights for a table's columns.
-
getColumns(String, String, String, String)
- Returns a description of the table's columns available in a
catalog.
-
getConnection()
- Returns the connection for this metadata.
-
getCrossReference(String, String, String, String, String, String)
- Returns a description of the foreign key columns in the
foreign key table that references the primary key columns
of the primary key table.
-
getDatabaseProductName()
- Returns the name of this database product.
-
getDatabaseProductVersion()
- Returns the version of this database product.
-
getDefaultTransactionIsolation()
- Returns the default transaction isolation level.
-
getDriverMajorVersion()
- Returns the major version number for this JDBC driver.
-
getDriverMinorVersion()
- Returns the minor version number for this JDBC driver.
-
getDriverName()
- Returns the name of this JDBC driver.
-
getDriverVersion()
- Returns the version of this JDBC driver.
-
getExportedKeys(String, String, String)
- Returns a description of the foreign key columns that
reference a table's primary key columns.
-
getExtraNameCharacters()
- Returns all of the "extra" characters that can be used in
unquoted identifier names (those beyond a-z, A-Z, 0-9,
and _).
-
getIdentifierQuoteString()
- Returns the string used to quote SQL identifiers.
-
getImportedKeys(String, String, String)
- Returns a description of the primary key columns that are
referenced by a table's foreign key columns.
-
getIndexInfo(String, String, String, boolean, boolean)
- Returns a description of a table's indexes and statistics.
-
getMaxBinaryLiteralLength()
- Returns the maximum length for an inline binary literal.
-
getMaxCatalogNameLength()
- Returns the maximum length for a catalog name.
-
getMaxCharLiteralLength()
- Returns the maximum length for a character literal.
-
getMaxColumnNameLength()
- Returns the maximum length for a column name.
-
getMaxColumnsInGroupBy()
- Returns the maximum number of columns in a GROUP BY clause.
-
getMaxColumnsInIndex()
- Returns the maximum number of columns allowed in an index.
-
getMaxColumnsInOrderBy()
- Returns the maximum number of columns in an ORDER BY clause.
-
getMaxColumnsInSelect()
- Returns the maximum number of columns in a SELECT list.
-
getMaxColumnsInTable()
- Returns the maximum number of columns in a table.
-
getMaxConnections()
- Returns the number of active connections you can have at a time
to this database.
-
getMaxCursorNameLength()
- Returns the maximum cursor name length.
-
getMaxIndexLength()
- Returns the maximum length of an index.
-
getMaxProcedureNameLength()
- Returns the maximum length of a procedure name.
-
getMaxRowSize()
- Returns the maximum length of a single row.
-
getMaxSchemaNameLength()
- Returns the maximum length allowed for a schema name.
-
getMaxStatementLength()
- Returns the maximum length of an SQL statement.
-
getMaxStatements()
- Returns the number of active statements you can have open at one
time.
-
getMaxTableNameLength()
- Returns the maximum length of a table name.
-
getMaxTablesInSelect()
- Returns the maximum number of tables in a SELECT.
-
getMaxUserNameLength()
- Returns the maximum length of a user name.
-
getNumericFunctions()
- Returns the list of supported math functions.
-
getPrimaryKeys(String, String, String)
- Returns a description of the primary key columns.
-
getProcedureColumns(String, String, String, String)
- Returns a description of a catalog's stored procedure
parameters and result columns.
-
getProcedures(String, String, String)
- Returns the description of the stored procedures available
in a catalog.
-
getProcedureTerm()
- Returns the DB2 for OS/400 SQL term for "procedure".
-
getSchemas()
- Returns the schema names available in this database.
-
getSchemaTerm()
- Returns the DB2 for OS/400 SQL term for "schema".
-
getSearchStringEscape()
- Returns the string used to escape wildcard characters.
-
getSQLKeywords()
- Returns the list of all of the database's SQL keywords
that are not also SQL92 keywords.
-
getStringFunctions()
- Returns the list of supported string functions.
-
getSystemFunctions()
- Returns the list of supported system functions.
-
getTablePrivileges(String, String, String)
- Returns the description of the access rights for each table
available in a catalog.
-
getTables(String, String, String, String[])
- Returns the description of the tables available in a catalog.
-
getTableTypes()
- Returns the table types available in this database.
-
getTimeDateFunctions()
- Returns the list of supported time and date functions.
-
getTypeInfo()
- Returns a description of all of the standard SQL types
supported by this database.
-
getUDTs(String, String, String, int[])
- Returns the description of the user-defined types
available in a catalog.
-
getURL()
- Returns the URL for this database.
-
getUserName()
- Returns the current user name as known to the database.
-
getVersionColumns(String, String, String)
- Returns a description of a table's columns that are automatically
updated when any value in a row is updated.
-
insertsAreDetected(int)
- Indicates if visible inserts to a result set of the specified type
can be detected by calling ResultSet.rowInserted().
-
isCatalogAtStart()
- Indicates if a catalog appears at the start or the end of
a qualified name.
-
isReadOnly()
- Indicates if the database is in read-only mode.
-
nullPlusNonNullIsNull()
- Indicates if concatenations between null and non-null values
are null.
-
nullsAreSortedAtEnd()
- Indicates if null values are sorted at the end regardless of sort
order.
-
nullsAreSortedAtStart()
- Indicates if null values are sorted at the start regardless of sort
order.
-
nullsAreSortedHigh()
- Indicates if null values are sorted high.
-
nullsAreSortedLow()
- Indicates if null values are sorted low.
-
othersDeletesAreVisible(int)
- Indicates if deletes made by others are visible.
-
othersInsertsAreVisible(int)
- Indicates if inserts made by others are visible.
-
othersUpdatesAreVisible(int)
- Indicates if updates made by others are visible.
-
ownDeletesAreVisible(int)
- Indicates if a result set's own deletes are visible.
-
ownInsertsAreVisible(int)
- Indicates if a result set's own inserts are visible.
-
ownUpdatesAreVisible(int)
- Indicates if a result set's own updates are visible.
-
storesLowerCaseIdentifiers()
- Indicates if the database treats mixed case, unquoted SQL identifiers
as case insensitive and stores them in lowercase.
-
storesLowerCaseQuotedIdentifiers()
- Indicates if the database treats mixed case, quoted SQL identifiers
as case insensitive and stores them in lowercase.
-
storesMixedCaseIdentifiers()
- Indicates if the database treats mixed case, unquoted SQL identifiers
as case insensitive and stores them in mixed case.
-
storesMixedCaseQuotedIdentifiers()
- Indicates if the database treats mixed case, quoted SQL identifiers
as case insensitive and stores them in mixed case.
-
storesUpperCaseIdentifiers()
- Indicates if the database treats mixed case, unquoted SQL identifiers
as case insensitive and stores them in uppercase.
-
storesUpperCaseQuotedIdentifiers()
- Indicates if the database treats mixed case, quoted SQL identifiers
as case insensitive and stores them in uppercase.
-
supportsAlterTableWithAddColumn()
- Indicates if ALTER TABLE with ADD COLUMN is supported.
-
supportsAlterTableWithDropColumn()
- Indicates if ALTER TABLE with DROP COLUMN is supported.
-
supportsANSI92EntryLevelSQL()
- Indicates if the ANSI92 entry-level SQL grammar is supported.
-
supportsANSI92FullSQL()
- Indicates if the ANSI92, full SQL grammar is supported.
-
supportsANSI92IntermediateSQL()
- Indicates if the ANSI92 intermediate-level SQL grammar is supported.
-
supportsBatchUpdates()
- Indicates if the batch updates are supported.
-
supportsCatalogsInDataManipulation()
- Indicates if a catalog name can be used in a data manipulation
statement.
-
supportsCatalogsInIndexDefinitions()
- Indicates if a catalog name can be used in an index definition
statement.
-
supportsCatalogsInPrivilegeDefinitions()
- Indicates if a catalog name can be used in a privilege definition
statement.
-
supportsCatalogsInProcedureCalls()
- Indicates if a catalog name can be used in a procedure call
statement.
-
supportsCatalogsInTableDefinitions()
- Indicates if a catalog name can be used in a table definition
statement.
-
supportsColumnAliasing()
- Indicates if column aliasing is supported.
-
supportsConvert()
- Indicates if the CONVERT function between SQL types is supported.
-
supportsConvert(int, int)
- Indicates if CONVERT between the given SQL types is supported.
-
supportsCoreSQLGrammar()
- Indicates if the ODBC Core SQL grammar is supported.
-
supportsCorrelatedSubqueries()
- Indicates if the correlated subqueries are supported.
-
supportsDataDefinitionAndDataManipulationTransactions()
- Indicates if both data definition and data manipulation statements
are supported within a transaction.
-
supportsDataManipulationTransactionsOnly()
- Indicates if data manipulation statements are supported within a transaction.
-
supportsDifferentTableCorrelationNames()
- Indicates if table correlation names are supported, and if so, are they
restricted to be different from the names of the tables.
-
supportsExpressionsInOrderBy()
- Indicates if expressions in ORDER BY lists are supported.
-
supportsExtendedSQLGrammar()
- Indicates if the ODBC Extended SQL grammar is supported.
-
supportsFullOuterJoins()
- Indicates if full nested outer joins are supported.
-
supportsGroupBy()
- Indicates if some form of the GROUP BY clause is supported.
-
supportsGroupByBeyondSelect()
- Indicates if a GROUP BY clause can add columns not in the SELECT
provided it specifies all of the columns in the SELECT.
-
supportsGroupByUnrelated()
- Indicates if a GROUP BY clause can use columns not in the SELECT.
-
supportsIntegrityEnhancementFacility()
- Indicates if the SQL Integrity Enhancement Facility is supported.
-
supportsLikeEscapeClause()
- Indicates if the escape character in LIKE clauses is supported.
-
supportsLimitedOuterJoins()
- Indicates if there is limited support for outer joins.
-
supportsMinimumSQLGrammar()
- Indicates if the ODBC Minimum SQL grammar is supported.
-
supportsMixedCaseIdentifiers()
- Indicates if the database treats mixed case, unquoted SQL
identifiers as case sensitive and stores
them in mixed case.
-
supportsMixedCaseQuotedIdentifiers()
- Indicates if the database treats mixed case, quoted SQL
identifiers as case sensitive and as a result stores
them in mixed case.
-
supportsMultipleResultSets()
- Indicates if multiple result sets from a single execute are
supported.
-
supportsMultipleTransactions()
- Indicates if multiple transactions can be open at once (on
different connections).
-
supportsNonNullableColumns()
- Indicates if columns can be defined as non-nullable.
-
supportsOpenCursorsAcrossCommit()
- Indicates if cursors can remain open across commits.
-
supportsOpenCursorsAcrossRollback()
- Indicates if cursors can remain open across rollback.
-
supportsOpenStatementsAcrossCommit()
- Indicates if statements can remain open across commits.
-
supportsOpenStatementsAcrossRollback()
- Indicates if statements can remain open across rollback.
-
supportsOrderByUnrelated()
- Indicates if an ORDER BY clause can use columns not in the SELECT.
-
supportsOuterJoins()
- Indicates if some form of outer join is supported.
-
supportsPositionedDelete()
- Indicates if positioned DELETE is supported.
-
supportsPositionedUpdate()
- Indicates if positioned UPDATE is supported.
-
supportsResultSetConcurrency(int, int)
- Indicates if the specified result set concurrency is supported
for the specified result set type.
-
supportsResultSetType(int)
- Indicates if the specified result set type is supported.
-
supportsSchemasInDataManipulation()
- Indicates if a schema name can be used in a data manipulation
statement.
-
supportsSchemasInIndexDefinitions()
- Indicates if a schema name can be used in an index definition
statement.
-
supportsSchemasInPrivilegeDefinitions()
- Indicates if a schema name be can used in a privilege definition
statement.
-
supportsSchemasInProcedureCalls()
- Indicates if a schema name be can used in a procedure call
statement.
-
supportsSchemasInTableDefinitions()
- Indicates if a schema name can be used in a table definition
statement.
-
supportsSelectForUpdate()
- Indicates if SELECT for UPDATE is supported.
-
supportsStoredProcedures()
- Indicates if stored procedure calls using the stored procedure
escape syntax are supported.
-
supportsSubqueriesInComparisons()
- Indicates if subqueries in comparisons are supported.
-
supportsSubqueriesInExists()
- Indicates if subqueries in EXISTS expressions are supported.
-
supportsSubqueriesInIns()
- Indicates if subqueries in IN expressions are supported.
-
supportsSubqueriesInQuantifieds()
- Indicates if subqueries in quantified expressions are supported.
-
supportsTableCorrelationNames()
- Indicates if table correlation names are supported.
-
supportsTransactionIsolationLevel(int)
- Indicates if the database supports the given transaction
isolation level.
-
supportsTransactions()
- Indicates if transactions are supported.
-
supportsUnion()
- Indicates if SQL UNION is supported.
-
supportsUnionAll()
- Indicates if SQL UNION ALL is supported.
-
toString()
- Returns the name of the catalog.
-
updatesAreDetected(int)
- Indicates if visible updates to a result set of the specified type
can be detected by calling ResultSet.rowUpdated().
-
usesLocalFilePerTable()
- Indicates if the database uses a file for each table.
-
usesLocalFiles()
- Indicates if the database stores tables in a local file.
allProceduresAreCallable
public boolean allProceduresAreCallable() throws SQLException
- Indicates if all of the procedures returned by getProcedures() can be
called by the current user.
- Returns:
- Always false. This driver cannot determine if all of the procedures
can be called by the current user.
- Throws: SQLException
- This exception is never thrown.
allTablesAreSelectable
public boolean allTablesAreSelectable() throws SQLException
- Indicates if all of the tables returned by getTables() can be
SELECTed by the current user.
- Returns:
- Always false. This driver cannot determine if all of the tables
returned by getTables() can be selected by the current user.
- Throws: SQLException
- This exception is never thrown.
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit() throws SQLException
- Indicates if a data definition statement within a transaction
can force the transaction to commit.
- Returns:
- Always false. A data definition statement within a transaction
does not force the transaction to commit.
- Throws: SQLException
- This exception is never thrown.
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions() throws SQLException
- Indicates if a data definition statement within a transaction is
ignored.
- Returns:
- Always false. A data definition statement within a
transaction is not ignored.
- Throws: SQLException
- This exception is never thrown.
deletesAreDetected
public boolean deletesAreDetected(int resultSetType) throws SQLException
- Indicates if visible deletes to a result set of the specified type
can be detected by calling ResultSet.rowDeleted(). If visible
deletes cannot be detected, then rows are removed from the
result set as they are deleted.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- Always false. Deletes can not be detected
by calling ResultSet.rowDeleted().
- Throws: SQLException
- If the result set type is not valid.
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
- Indicates if getMaxRowSize() includes blobs when computing the
maximum length of a single row.
- Returns:
- Always true. getMaxRowSize() does include blobs when
computing the maximum length of a single row.
- Throws: SQLException
- This exception is never thrown.
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable) throws SQLException
- Returns a description of a table's optimal set of columns
that uniquely identifies a row.
- Parameters:
- 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.
- Returns:
- The ResultSet containing a table's optimal
set of columns that uniquely identify a row.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getCatalogs
public ResultSet getCatalogs() throws SQLException
- Returns the catalog name available in this database. This
will return a ResultSet with a single row, whose value is
the server name.
- Returns:
- The ResultSet containing the server name.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getCatalogSeparator
public String getCatalogSeparator() throws SQLException
- Returns the naming convention used when referring to tables.
This depends on the naming convention specified in the connection
properties.
- Returns:
- If using SQL naming convention, "." is returned. If
using AS/400 system naming convention, "/" is returned.
- Throws: SQLException
- This exception is never thrown.
getCatalogTerm
public String getCatalogTerm() throws SQLException
- Returns the DB2 for OS/400 SQL term for "catalog".
- Returns:
- The term "System".
- Throws: SQLException
- This exception is never thrown.
getColumnPrivileges
public ResultSet getColumnPrivileges(String catalog,
String schema,
String table,
String columnPattern) throws SQLException
- Returns a description of the access rights for a table's columns.
- Parameters:
- 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.
- Returns:
- The ResultSet containing access rights for a
table's columns.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getColumns
public ResultSet getColumns(String catalog,
String schemaPattern,
String tablePattern,
String columnPattern) throws SQLException
- Returns a description of the table's columns available in a
catalog.
The following column in the description is not currently
supported:
- Parameters:
- 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.
- Returns:
- The ResultSet containing the table's columns available
in a catalog.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getConnection
public Connection getConnection() throws SQLException
- Returns the connection for this metadata.
- Returns:
- The connection for this metadata.
- Throws: SQLException
- This exception is never thrown.
getCrossReference
public ResultSet getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable) throws SQLException
- Returns a description of the foreign key columns in the
foreign key table that references the primary key columns
of the primary key table. This is a description of how
the primary table imports the foreign table's key.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
foreign key columns in the foreign key table that
references the primary key columns of the primary
key table.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getDatabaseProductName
public String getDatabaseProductName() throws SQLException
- Returns the name of this database product.
- Returns:
- The database product name.
- Throws: SQLException
- This exception is never thrown.
getDatabaseProductVersion
public String getDatabaseProductVersion() throws SQLException
- Returns the version of this database product.
- Returns:
- The product version.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() throws SQLException
- Returns the default transaction isolation level.
- Returns:
- The default transaction isolation level.
- Throws: SQLException
- This exception is never thrown.
getDriverMajorVersion
public int getDriverMajorVersion()
- Returns the major version number for this JDBC driver.
- Returns:
- The major version number.
getDriverMinorVersion
public int getDriverMinorVersion()
- Returns the minor version number for this JDBC driver.
- Returns:
- The minor version number.
getDriverName
public String getDriverName() throws SQLException
- Returns the name of this JDBC driver.
- Returns:
- The driver name.
- Throws: SQLException
- This exception is never thrown.
getDriverVersion
public String getDriverVersion() throws SQLException
- Returns the version of this JDBC driver.
- Returns:
- The driver version.
- Throws: SQLException
- This exception is never thrown.
getExportedKeys
public ResultSet getExportedKeys(String catalog,
String schema,
String table) throws SQLException
- Returns a description of the foreign key columns that
reference a table's primary key columns. This is the
foreign keys exported by a table.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
foreign key columns that reference a table's
primary key columns.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getExtraNameCharacters
public String getExtraNameCharacters() throws SQLException
- Returns all of the "extra" characters that can be used in
unquoted identifier names (those beyond a-z, A-Z, 0-9,
and _).
- Returns:
- The String containing the "extra" characters.
- Throws: SQLException
- This exception is never thrown.
getIdentifierQuoteString
public String getIdentifierQuoteString() throws SQLException
- Returns the string used to quote SQL identifiers.
- Returns:
- The quote string.
- Throws: SQLException
- This exception is never thrown.
getImportedKeys
public ResultSet getImportedKeys(String catalog,
String schema,
String table) throws SQLException
- Returns a description of the primary key columns that are
referenced by a table's foreign key columns. This is the
primary keys imported by a table.
- Parameters:
- 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.
- Returns:
- The ResultSets containing the description of the primary
key columns that are referenced by a table's foreign
key columns.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getIndexInfo
public ResultSet getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate) throws SQLException
- Returns a description of a table's indexes and statistics.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of a table's indexes
and statistics.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength() throws SQLException
- Returns the maximum length for an inline binary literal.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxCatalogNameLength
public int getMaxCatalogNameLength() throws SQLException
- Returns the maximum length for a catalog name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxCharLiteralLength
public int getMaxCharLiteralLength() throws SQLException
- Returns the maximum length for a character literal.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxColumnNameLength
public int getMaxColumnNameLength() throws SQLException
- Returns the maximum length for a column name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy() throws SQLException
- Returns the maximum number of columns in a GROUP BY clause.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- This exception is never thrown.
getMaxColumnsInIndex
public int getMaxColumnsInIndex() throws SQLException
- Returns the maximum number of columns allowed in an index.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- This exception is never thrown.
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy() throws SQLException
- Returns the maximum number of columns in an ORDER BY clause.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- This exception is never thrown.
getMaxColumnsInSelect
public int getMaxColumnsInSelect() throws SQLException
- Returns the maximum number of columns in a SELECT list.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- This exception is never thrown.
getMaxColumnsInTable
public int getMaxColumnsInTable() throws SQLException
- Returns the maximum number of columns in a table.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- This exception is never thrown.
getMaxConnections
public int getMaxConnections() throws SQLException
- Returns the number of active connections you can have at a time
to this database.
- Returns:
- The maximum number of connections or 0
if no limit.
- Throws: SQLException
- This exception is never thrown.
getMaxCursorNameLength
public int getMaxCursorNameLength() throws SQLException
- Returns the maximum cursor name length.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxIndexLength
public int getMaxIndexLength() throws SQLException
- Returns the maximum length of an index.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxProcedureNameLength
public int getMaxProcedureNameLength() throws SQLException
- Returns the maximum length of a procedure name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxRowSize
public int getMaxRowSize() throws SQLException
- Returns the maximum length of a single row.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxSchemaNameLength
public int getMaxSchemaNameLength() throws SQLException
- Returns the maximum length allowed for a schema name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxStatementLength
public int getMaxStatementLength() throws SQLException
- Returns the maximum length of an SQL statement.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxStatements
public int getMaxStatements() throws SQLException
- Returns the number of active statements you can have open at one
time.
- Returns:
- The maximum number of statements or 0
if no limit.
- Throws: SQLException
- This exception is never thrown.
getMaxTableNameLength
public int getMaxTableNameLength() throws SQLException
- Returns the maximum length of a table name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getMaxTablesInSelect
public int getMaxTablesInSelect() throws SQLException
- Returns the maximum number of tables in a SELECT.
- Returns:
- The maximum number of tables.
- Throws: SQLException
- This exception is never thrown.
getMaxUserNameLength
public int getMaxUserNameLength() throws SQLException
- Returns the maximum length of a user name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- This exception is never thrown.
getNumericFunctions
public String getNumericFunctions() throws SQLException
- Returns the list of supported math functions.
- Returns:
- The list of supported math functions, separated by commas.
- Throws: SQLException
- This exception is never thrown.
getPrimaryKeys
public ResultSet getPrimaryKeys(String catalog,
String schema,
String table) throws SQLException
- Returns a description of the primary key columns.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the primary
key columns.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getProcedureColumns
public ResultSet getProcedureColumns(String catalog,
String schemaPattern,
String procedurePattern,
String columnPattern) throws SQLException
- Returns a description of a catalog's stored procedure
parameters and result columns.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
catalog's stored procedure parameters and result
columns.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getProcedures
public ResultSet getProcedures(String catalog,
String schemaPattern,
String procedurePattern) throws SQLException
- Returns the description of the stored procedures available
in a catalog.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
stored procedures available in the catalog.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getProcedureTerm
public String getProcedureTerm() throws SQLException
- Returns the DB2 for OS/400 SQL term for "procedure".
- Returns:
- The term for "procedure".
- Throws: SQLException
- This exception is never thrown.
getSchemas
public ResultSet getSchemas() throws SQLException
- Returns the schema names available in this database.
This will return a ResultSet with a list of all the
libraries.
- Returns:
- The ResultSet containing the list of all the libraries.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getSchemaTerm
public String getSchemaTerm() throws SQLException
- Returns the DB2 for OS/400 SQL term for "schema".
- Returns:
- The term for schema.
- Throws: SQLException
- This exception is never thrown.
getSearchStringEscape
public String getSearchStringEscape() throws SQLException
- Returns the string used to escape wildcard characters.
This is the string that can be used to escape '_' or '%'
in string patterns.
- Returns:
- The escape string.
- Throws: SQLException
- This exception is never thrown.
getSQLKeywords
public String getSQLKeywords() throws SQLException
- Returns the list of all of the database's SQL keywords
that are not also SQL92 keywords.
- Returns:
- The list of SQL keywords, separated by commas.
- Throws: SQLException
- This exception is never thrown.
getStringFunctions
public String getStringFunctions() throws SQLException
- Returns the list of supported string functions.
- Returns:
- The list of supported string functions, separated by commas.
- Throws: SQLException
- This exception is never thrown.
getSystemFunctions
public String getSystemFunctions() throws SQLException
- Returns the list of supported system functions.
- Returns:
- The list of supported system functions, separated by commas.
- Throws: SQLException
- This exception is never thrown.
getTablePrivileges
public ResultSet getTablePrivileges(String catalog,
String schemaPattern,
String tablePattern) throws SQLException
- Returns the description of the access rights for each table
available in a catalog. Note that a table privilege applies
to one or more columns in a table.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
access rights for each table available in the
catalog.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getTables
public ResultSet getTables(String catalog,
String schemaPattern,
String tablePattern,
String tableTypes[]) throws SQLException
- Returns the description of the tables available in a catalog.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
tables available in the catalog.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getTableTypes
public ResultSet getTableTypes() throws SQLException
- Returns the table types available in this database.
- Returns:
- The ResultSet containing the table types available in
this database.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getTimeDateFunctions
public String getTimeDateFunctions() throws SQLException
- Returns the list of supported time and date functions.
- Returns:
- The list of supported time and data functions,
separated by commas.
- Throws: SQLException
- This exception is never thrown.
getTypeInfo
public ResultSet getTypeInfo() throws SQLException
- Returns a description of all of the standard SQL types
supported by this database.
- Returns:
- The ResultSet containing the description of all
the standard SQL types supported by this
database.
- Throws: SQLException
- This exception is never thrown.
getUDTs
public ResultSet getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int types[]) throws SQLException
- Returns the description of the user-defined types
available in a catalog.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
user-defined available in the catalog.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getURL
public String getURL() throws SQLException
- Returns the URL for this database.
- Returns:
- The URL for this database.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getUserName
public String getUserName() throws SQLException
- Returns the current user name as known to the database.
- Returns:
- The current user name as known to the database.
- Throws: SQLException
- If the connection is not open
or an error occurs.
getVersionColumns
public ResultSet getVersionColumns(String catalog,
String schema,
String table) throws SQLException
- Returns a description of a table's columns that are automatically
updated when any value in a row is updated.
- Parameters:
- 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.
- Returns:
- The ResultSet containing the description of the
table's columns that are automatically updated
when any value in a row is updated.
- Throws: SQLException
- If the connection is not open
or an error occurs.
insertsAreDetected
public boolean insertsAreDetected(int resultSetType) throws SQLException
- Indicates if visible inserts to a result set of the specified type
can be detected by calling ResultSet.rowInserted().
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- Always false. Inserts can not be detected
by calling ResultSet.rowInserted().
- Throws: SQLException
- If the result set type is not valid.
isCatalogAtStart
public boolean isCatalogAtStart() throws SQLException
- Indicates if a catalog appears at the start or the end of
a qualified name.
- Returns:
- Always true. A catalog appears at the start of a
qualified name.
- Throws: SQLException
- This exception is never thrown.
isReadOnly
public boolean isReadOnly() throws SQLException
- Indicates if the database is in read-only mode.
- Returns:
- true if in read-only mode; false otherwise.
- Throws: SQLException
- If the connection is not open
or an error occurs.
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull() throws SQLException
- Indicates if concatenations between null and non-null values
are null.
- Returns:
- Always true. Concatenations between null and non-null
values are null.
- Throws: SQLException
- This exception is never thrown.
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd() throws SQLException
- Indicates if null values are sorted at the end regardless of sort
order.
- Returns:
- Always false. Null values are not sorted at the end
regardless of sort order.
- Throws: SQLException
- This exception is never thrown.
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart() throws SQLException
- Indicates if null values are sorted at the start regardless of sort
order.
- Returns:
- Always false. Null values are not sorted at the start
regardless of sort order.
- Throws: SQLException
- This exception is never thrown.
nullsAreSortedHigh
public boolean nullsAreSortedHigh() throws SQLException
- Indicates if null values are sorted high.
- Returns:
- Always true. Null values are sorted high.
- Throws: SQLException
- This exception is never thrown.
nullsAreSortedLow
public boolean nullsAreSortedLow() throws SQLException
- Indicates if null values are sorted low.
- Returns:
- Always false. Null values are not sorted low.
- Throws: SQLException
- This exception is never thrown.
othersDeletesAreVisible
public boolean othersDeletesAreVisible(int resultSetType) throws SQLException
- Indicates if deletes made by others are visible.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- true if deletes made by others
are visible; false otherwise.
- Throws: SQLException
- If the result set type is not valid.
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int resultSetType) throws SQLException
- Indicates if inserts made by others are visible.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- true if inserts made by others
are visible; false otherwise.
- Throws: SQLException
- If the result set type is not valid.
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int resultSetType) throws SQLException
- Indicates if updates made by others are visible.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- true if updates made by others
are visible; false otherwise.
- Throws: SQLException
- If the result set type is not valid.
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int resultSetType) throws SQLException
- Indicates if a result set's own deletes are visible.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- true if the result set's own deletes
are visible; false otherwise.
- Throws: SQLException
- If the result set type is not valid.
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int resultSetType) throws SQLException
- Indicates if a result set's own inserts are visible.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- true if the result set's own inserts
are visible; false otherwise.
- Throws: SQLException
- If the result set type is not valid.
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int resultSetType) throws SQLException
- Indicates if a result set's own updates are visible.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- true if the result set's own updates
are visible; false otherwise.
- Throws: SQLException
- If the result set type is not valid.
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers() throws SQLException
- Indicates if the database treats mixed case, unquoted SQL identifiers
as case insensitive and stores them in lowercase.
- Returns:
- Always false. The database does not treat mixed case,
unquoted SQL identifiers as case insensitive and store
them in lowercase.
- Throws: SQLException
- This exception is never thrown.
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
- Indicates if the database treats mixed case, quoted SQL identifiers
as case insensitive and stores them in lowercase.
- Returns:
- Always false. The database does not treat mixed case, quoted
SQL identifiers as case insensitive and store them in
lowercase.
- Throws: SQLException
- This exception is never thrown.
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers() throws SQLException
- Indicates if the database treats mixed case, unquoted SQL identifiers
as case insensitive and stores them in mixed case.
- Returns:
- Always false. The database does not treat mixed case, unquoted
SQL identifiers as case insensitive and store them in
mixed case.
- Throws: SQLException
- This exception is never thrown.
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
- Indicates if the database treats mixed case, quoted SQL identifiers
as case insensitive and stores them in mixed case.
- Returns:
- Always true. The database does treat mixed case, quoted
SQL identifiers as case insensitive and store them in
mixed case.
- Throws: SQLException
- This exception is never thrown.
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers() throws SQLException
- Indicates if the database treats mixed case, unquoted SQL identifiers
as case insensitive and stores them in uppercase.
- Returns:
- Always true. The database does treat mixed case, unquoted
SQL identifiers as case insensitive and store them
in uppercase.
- Throws: SQLException
- This exception is never thrown.
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
- Indicates if the database treats mixed case, quoted SQL identifiers
as case insensitive and stores them in uppercase.
- Returns:
- Always false. The database does not treat mixed case, quoted
SQL identifiers as case insensitive and store them
in uppercase.
- Throws: SQLException
- This exception is never thrown.
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn() throws SQLException
- Indicates if ALTER TABLE with ADD COLUMN is supported.
- Returns:
- Always true. ALTER TABLE with ADD COLUMN is supported.
- Throws: SQLException
- This exception is never thrown.
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn() throws SQLException
- Indicates if ALTER TABLE with DROP COLUMN is supported.
- Returns:
- Always true. ALTER TABLE with DROP COLUMN is not supported.
- Throws: SQLException
- This exception is never thrown.
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL() throws SQLException
- Indicates if the ANSI92 entry-level SQL grammar is supported.
- Returns:
- Always true. The ANSI92 entry-level SQL grammar is supported.
- Throws: SQLException
- This exception is never thrown.
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL() throws SQLException
- Indicates if the ANSI92, full SQL grammar is supported.
- Returns:
- Always false. ANSI92, full SQL grammar is not supported.
- Throws: SQLException
- This exception is never thrown.
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL() throws SQLException
- Indicates if the ANSI92 intermediate-level SQL grammar is supported.
- Returns:
- Always false. ANSI92 intermediate-level SQL grammar is not supported.
- Throws: SQLException
- This exception is never thrown.
supportsBatchUpdates
public boolean supportsBatchUpdates() throws SQLException
- Indicates if the batch updates are supported.
- Returns:
- Always true. Batch updates are supported.
- Throws: SQLException
- This exception is never thrown.
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation() throws SQLException
- Indicates if a catalog name can be used in a data manipulation
statement.
- Returns:
- Always false. A catalog name can not be used in a data manipulation
statement.
- Throws: SQLException
- This exception is never thrown.
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions() throws SQLException
- Indicates if a catalog name can be used in an index definition
statement.
- Returns:
- Always false. A catalog name can not be used in an index definition
statement.
- Throws: SQLException
- This exception is never thrown.
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
- Indicates if a catalog name can be used in a privilege definition
statement.
- Returns:
- Always false. A catalog name can not be used in a privilege definition
statement.
- Throws: SQLException
- This exception is never thrown.
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls() throws SQLException
- Indicates if a catalog name can be used in a procedure call
statement.
- Returns:
- Always false. A catalog name can not be used in a procedure call
statement.
- Throws: SQLException
- This exception is never thrown.
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions() throws SQLException
- Indicates if a catalog name can be used in a table definition
statement.
- Returns:
- Always false. A catalog name can not be used in a table definition
statement.
- Throws: SQLException
- This exception is never thrown.
supportsColumnAliasing
public boolean supportsColumnAliasing() throws SQLException
- Indicates if column aliasing is supported. Column aliasing means
that the SQL AS clause can be used to provide names for
computed columns or to provide alias names for column
as required.
- Returns:
- Always true. Column aliasing is supported.
- Throws: SQLException
- This exception is never thrown.
supportsConvert
public boolean supportsConvert() throws SQLException
- Indicates if the CONVERT function between SQL types is supported.
- Returns:
- true if the CONVERT function between SQL types is supported;
false otherwise.
- Throws: SQLException
- This exception is never thrown.
supportsConvert
public boolean supportsConvert(int fromType,
int toType) throws SQLException
- Indicates if CONVERT between the given SQL types is supported.
- Parameters:
- fromType - The SQL type code defined in java.sql.Types.
- toType - The SQL type code defined in java.sql.Types.
- Returns:
- true if CONVERT between the given SQL types is supported;
false otherwise.
- Throws: SQLException
- This exception is never thrown.
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar() throws SQLException
- Indicates if the ODBC Core SQL grammar is supported.
- Returns:
- Always true. The ODBC Core SQL grammar is supported.
- Throws: SQLException
- This exception is never thrown.
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries() throws SQLException
- Indicates if the correlated subqueries are supported.
- Returns:
- Always true. Correlated subqueries are supported.
- Throws: SQLException
- This exception is never thrown.
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
- Indicates if both data definition and data manipulation statements
are supported within a transaction.
- Returns:
- Always true. Data definition and data manipulation statements
are both supported within a transaction.
- Throws: SQLException
- This exception is never thrown.
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly() throws SQLException
- Indicates if data manipulation statements are supported within a transaction.
- Returns:
- Always false. Data manipulation statements are not supported within
a transaction.
- Throws: SQLException
- This exception is never thrown.
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames() throws SQLException
- Indicates if table correlation names are supported, and if so, are they
restricted to be different from the names of the tables.
- Returns:
- Always false. Table correlation names are not restricted
to be different from the names of the tables.
- Throws: SQLException
- This exception is never thrown.
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy() throws SQLException
- Indicates if expressions in ORDER BY lists are supported.
- Returns:
- Always false. Expression in ORDER BY lists are not supported.
- Throws: SQLException
- This exception is never thrown.
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar() throws SQLException
- Indicates if the ODBC Extended SQL grammar is supported.
- Returns:
- Always false. The ODBC Extended SQL grammar is not supported.
- Throws: SQLException
- This exception is never thrown.
supportsFullOuterJoins
public boolean supportsFullOuterJoins() throws SQLException
- Indicates if full nested outer joins are supported.
- Returns:
- Always false. Full nested outer joins are not supported.
- Throws: SQLException
- This exception is never thrown.
supportsGroupBy
public boolean supportsGroupBy() throws SQLException
- Indicates if some form of the GROUP BY clause is supported.
- Returns:
- Always true. Some form of GROUP BY clause is supported.
- Throws: SQLException
- This exception is never thrown.
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect() throws SQLException
- Indicates if a GROUP BY clause can add columns not in the SELECT
provided it specifies all of the columns in the SELECT.
- Returns:
- Always true. A GROUP BY clause can add columns not in the SELECT
provided it specifies all of the columns in the SELECT.
- Throws: SQLException
- This exception is never thrown.
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated() throws SQLException
- Indicates if a GROUP BY clause can use columns not in the SELECT.
- Returns:
- Always true. A GROUP BY clause can use columns not in the SELECT.
- Throws: SQLException
- This exception is never thrown.
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility() throws SQLException
- Indicates if the SQL Integrity Enhancement Facility is supported.
- Returns:
- Always false. The SQL Integrity Enhancement Facility is not
supported.
- Throws: SQLException
- This exception is never thrown.
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause() throws SQLException
- Indicates if the escape character in LIKE clauses is supported.
- Returns:
- Always true. The escape character in LIKE clauses is supported.
- Throws: SQLException
- This exception is never thrown.
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins() throws SQLException
- Indicates if there is limited support for outer joins.
- Returns:
- Always true. There is limited support for outer joins.
- Throws: SQLException
- This exception is never thrown.
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar() throws SQLException
- Indicates if the ODBC Minimum SQL grammar is supported.
- Returns:
- Always true. The ODBC Minimum SQL grammar is supported.
- Throws: SQLException
- This exception is never thrown.
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers() throws SQLException
- Indicates if the database treats mixed case, unquoted SQL
identifiers as case sensitive and stores
them in mixed case.
- Returns:
- Always false. The database does not treat mixed case,
unquoted SQL identifiers as case sensitive and as
a result store them in mixed case.
- Throws: SQLException
- This exception is never thrown.
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
- Indicates if the database treats mixed case, quoted SQL
identifiers as case sensitive and as a result stores
them in mixed case.
- Returns:
- Always true. The database does treat mixed case, quoted SQL
identifiers as case sensitive and stores
them in mixed case.
- Throws: SQLException
- This exception is never thrown.
supportsMultipleResultSets
public boolean supportsMultipleResultSets() throws SQLException
- Indicates if multiple result sets from a single execute are
supported.
- Returns:
- Always true. Multiple result sets from a single execute
are supported.
- Throws: SQLException
- This exception is never thrown.
supportsMultipleTransactions
public boolean supportsMultipleTransactions() throws SQLException
- Indicates if multiple transactions can be open at once (on
different connections).
- Returns:
- Always true. Multiple transactions can be open at
once on different connections.
- Throws: SQLException
- This exception is never thrown.
supportsNonNullableColumns
public boolean supportsNonNullableColumns() throws SQLException
- Indicates if columns can be defined as non-nullable.
- Returns:
- Always true. Columns can be defined as non-nullable.
- Throws: SQLException
- This exception is never thrown.
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit() throws SQLException
- Indicates if cursors can remain open across commits.
- Returns:
- Always true. Cursors can remain open across commits.
- Throws: SQLException
- This exception is never thrown.
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback() throws SQLException
- Indicates if cursors can remain open across rollback.
- Returns:
- Always true. Cursors can remain open across rollback.
- Throws: SQLException
- This exception is never thrown.
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit() throws SQLException
- Indicates if statements can remain open across commits.
- Returns:
- Always true. Statements can remain open across commits.
- Throws: SQLException
- This exception is never thrown.
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback() throws SQLException
- Indicates if statements can remain open across rollback.
- Returns:
- Always true. Statements can remain open across rollback.
- Throws: SQLException
- This exception is never thrown.
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated() throws SQLException
- Indicates if an ORDER BY clause can use columns not in the SELECT.
- Returns:
- Always false. ORDER BY cannot use columns not in the SELECT.
- Throws: SQLException
- This exception is never thrown.
supportsOuterJoins
public boolean supportsOuterJoins() throws SQLException
- Indicates if some form of outer join is supported.
- Returns:
- Always true. Some form of outer join is supported.
- Throws: SQLException
- This exception is never thrown.
supportsPositionedDelete
public boolean supportsPositionedDelete() throws SQLException
- Indicates if positioned DELETE is supported.
- Returns:
- Always true. Positioned DELETE is supported.
- Throws: SQLException
- This exception is never thrown.
supportsPositionedUpdate
public boolean supportsPositionedUpdate() throws SQLException
- Indicates if positioned UPDATE is supported.
- Returns:
- Always true. Positioned UPDATE is supported.
- Throws: SQLException
- This exception is never thrown.
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int resultSetType,
int resultSetConcurrency) throws SQLException
- Indicates if the specified result set concurrency is supported
for the specified result set type.
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 |
- Parameters:
- resultSetType - The result set type. Valid values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- resultSetConcurrency - The result set concurrency. Valid values are:
- ResultSet.CONCUR_READ_ONLY
- ResultSet.CONCUR_UPDATABLE
- Returns:
- true if the specified result set
concurrency is supported for the specified
result set type; false otherwise.
- Throws: SQLException
- If the result set type or result set
concurrency is not valid.
supportsResultSetType
public boolean supportsResultSetType(int resultSetType) throws SQLException
- Indicates if the specified result set type is supported.
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- Always true. All result set types
are supported.
- Throws: SQLException
- If the result set type is not valid.
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation() throws SQLException
- Indicates if a schema name can be used in a data manipulation
statement.
- Returns:
- Always true. A schema name can be used in a data
manipulation statement.
- Throws: SQLException
- This exception is never thrown.
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions() throws SQLException
- Indicates if a schema name can be used in an index definition
statement.
- Returns:
- Always true. A schema name can be used in an index definition
statement.
- Throws: SQLException
- This exception is never thrown.
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
- Indicates if a schema name be can used in a privilege definition
statement.
- Returns:
- Always true. A schema name can be used in a privilege definition
statement.
- Throws: SQLException
- This exception is never thrown.
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls() throws SQLException
- Indicates if a schema name be can used in a procedure call
statement.
- Returns:
- Always true. A schema name can be used in a procedure call
statement.
- Throws: SQLException
- This exception is never thrown.
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions() throws SQLException
- Indicates if a schema name can be used in a table definition
statement.
- Returns:
- Always true. A schema name can be used in a table definition
statement.
- Throws: SQLException
- This exception is never thrown.
supportsSelectForUpdate
public boolean supportsSelectForUpdate() throws SQLException
- Indicates if SELECT for UPDATE is supported.
- Returns:
- Always true. SELECT for UPDATE is supported.
- Throws: SQLException
- This exception is never thrown.
supportsStoredProcedures
public boolean supportsStoredProcedures() throws SQLException
- Indicates if stored procedure calls using the stored procedure
escape syntax are supported.
- Returns:
- Always true. Stored procedure calls using the stored
procedure escape syntax are supported.
- Throws: SQLException
- This exception is never thrown.
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() throws SQLException
- Indicates if subqueries in comparisons are supported.
- Returns:
- Always true. Subqueries in comparisons are supported.
- Throws: SQLException
- This exception is never thrown.
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists() throws SQLException
- Indicates if subqueries in EXISTS expressions are supported.
- Returns:
- Always true. Subqueries in EXISTS expressions are supported.
- Throws: SQLException
- This exception is never thrown.
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns() throws SQLException
- Indicates if subqueries in IN expressions are supported.
- Returns:
- Always true. Subqueries in IN expressions are supported.
- Throws: SQLException
- This exception is never thrown.
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds() throws SQLException
- Indicates if subqueries in quantified expressions are supported.
- Returns:
- Always true. Subqueries in quantified expressions are
supported.
- Throws: SQLException
- This exception is never thrown.
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() throws SQLException
- Indicates if table correlation names are supported.
- Returns:
- Always true. Table correlation names are supported.
- Throws: SQLException
- This exception is never thrown.
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int transactionIsolationLevel) throws SQLException
- Indicates if the database supports the given transaction
isolation level.
- Parameters:
- transactionIsolationLevel - One of the Connection.TRANSACTION_*
values.
- Returns:
- Always true. All transaction isolation
levels are supported.
- Throws: SQLException
- If the transaction isolation level is not valid.
supportsTransactions
public boolean supportsTransactions() throws SQLException
- Indicates if transactions are supported.
- Returns:
- Always true. Transactions are supported.
- Throws: SQLException
- This exception is never thrown.
supportsUnion
public boolean supportsUnion() throws SQLException
- Indicates if SQL UNION is supported.
- Returns:
- Always true. SQL UNION is supported.
- Throws: SQLException
- This exception is never thrown.
supportsUnionAll
public boolean supportsUnionAll() throws SQLException
- Indicates if SQL UNION ALL is supported.
- Returns:
- Always true. SQL UNION ALL is supported.
- Throws: SQLException
- This exception is never thrown.
toString
public String toString()
- Returns the name of the catalog.
- Returns:
- The name of the catalog.
- Overrides:
- toString in class Object
updatesAreDetected
public boolean updatesAreDetected(int resultSetType) throws SQLException
- Indicates if visible updates to a result set of the specified type
can be detected by calling ResultSet.rowUpdated().
- Parameters:
- resultSetType - The result set type. Value values are:
- ResultSet.TYPE_FORWARD_ONLY
- ResultSet.TYPE_SCROLL_INSENSITIVE
- ResultSet.TYPE_SCROLL_SENSITIVE
- Returns:
- Always false. Updates can not be detected
by calling ResultSet.rowUpdated().
- Throws: SQLException
- If the result set type is not valid.
usesLocalFilePerTable
public boolean usesLocalFilePerTable() throws SQLException
- Indicates if the database uses a file for each table.
- Returns:
- Always false. The database does not use a file for each
table.
- Throws: SQLException
- This exception is never thrown.
usesLocalFiles
public boolean usesLocalFiles() throws SQLException
- Indicates if the database stores tables in a local file.
- Returns:
- Always false. The database does not store tables in a local
file.
- Throws: SQLException
- This exception is never thrown.
All Packages Class Hierarchy This Package Previous Next Index