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.


Method Index

 o allProceduresAreCallable()
Indicates if all of the procedures returned by getProcedures() can be called by the current user.
 o allTablesAreSelectable()
Indicates if all of the tables returned by getTables() can be SELECTed by the current user.
 o dataDefinitionCausesTransactionCommit()
Indicates if a data definition statement within a transaction can force the transaction to commit.
 o dataDefinitionIgnoredInTransactions()
Indicates if a data definition statement within a transaction is ignored.
 o deletesAreDetected(int)
Indicates if visible deletes to a result set of the specified type can be detected by calling ResultSet.rowDeleted().
 o doesMaxRowSizeIncludeBlobs()
Indicates if getMaxRowSize() includes blobs when computing the maximum length of a single row.
 o getBestRowIdentifier(String, String, String, int, boolean)
Returns a description of a table's optimal set of columns that uniquely identifies a row.
 o getCatalogs()
Returns the catalog name available in this database.
 o getCatalogSeparator()
Returns the naming convention used when referring to tables.
 o getCatalogTerm()
Returns the DB2 for OS/400 SQL term for "catalog".
 o getColumnPrivileges(String, String, String, String)
Returns a description of the access rights for a table's columns.
 o getColumns(String, String, String, String)
Returns a description of the table's columns available in a catalog.
 o getConnection()
Returns the connection for this metadata.
 o 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.
 o getDatabaseProductName()
Returns the name of this database product.
 o getDatabaseProductVersion()
Returns the version of this database product.
 o getDefaultTransactionIsolation()
Returns the default transaction isolation level.
 o getDriverMajorVersion()
Returns the major version number for this JDBC driver.
 o getDriverMinorVersion()
Returns the minor version number for this JDBC driver.
 o getDriverName()
Returns the name of this JDBC driver.
 o getDriverVersion()
Returns the version of this JDBC driver.
 o getExportedKeys(String, String, String)
Returns a description of the foreign key columns that reference a table's primary key columns.
 o getExtraNameCharacters()
Returns all of the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9, and _).
 o getIdentifierQuoteString()
Returns the string used to quote SQL identifiers.
 o getImportedKeys(String, String, String)
Returns a description of the primary key columns that are referenced by a table's foreign key columns.
 o getIndexInfo(String, String, String, boolean, boolean)
Returns a description of a table's indexes and statistics.
 o getMaxBinaryLiteralLength()
Returns the maximum length for an inline binary literal.
 o getMaxCatalogNameLength()
Returns the maximum length for a catalog name.
 o getMaxCharLiteralLength()
Returns the maximum length for a character literal.
 o getMaxColumnNameLength()
Returns the maximum length for a column name.
 o getMaxColumnsInGroupBy()
Returns the maximum number of columns in a GROUP BY clause.
 o getMaxColumnsInIndex()
Returns the maximum number of columns allowed in an index.
 o getMaxColumnsInOrderBy()
Returns the maximum number of columns in an ORDER BY clause.
 o getMaxColumnsInSelect()
Returns the maximum number of columns in a SELECT list.
 o getMaxColumnsInTable()
Returns the maximum number of columns in a table.
 o getMaxConnections()
Returns the number of active connections you can have at a time to this database.
 o getMaxCursorNameLength()
Returns the maximum cursor name length.
 o getMaxIndexLength()
Returns the maximum length of an index.
 o getMaxProcedureNameLength()
Returns the maximum length of a procedure name.
 o getMaxRowSize()
Returns the maximum length of a single row.
 o getMaxSchemaNameLength()
Returns the maximum length allowed for a schema name.
 o getMaxStatementLength()
Returns the maximum length of an SQL statement.
 o getMaxStatements()
Returns the number of active statements you can have open at one time.
 o getMaxTableNameLength()
Returns the maximum length of a table name.
 o getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT.
 o getMaxUserNameLength()
Returns the maximum length of a user name.
 o getNumericFunctions()
Returns the list of supported math functions.
 o getPrimaryKeys(String, String, String)
Returns a description of the primary key columns.
 o getProcedureColumns(String, String, String, String)
Returns a description of a catalog's stored procedure parameters and result columns.
 o getProcedures(String, String, String)
Returns the description of the stored procedures available in a catalog.
 o getProcedureTerm()
Returns the DB2 for OS/400 SQL term for "procedure".
 o getSchemas()
Returns the schema names available in this database.
 o getSchemaTerm()
Returns the DB2 for OS/400 SQL term for "schema".
 o getSearchStringEscape()
Returns the string used to escape wildcard characters.
 o getSQLKeywords()
Returns the list of all of the database's SQL keywords that are not also SQL92 keywords.
 o getStringFunctions()
Returns the list of supported string functions.
 o getSystemFunctions()
Returns the list of supported system functions.
 o getTablePrivileges(String, String, String)
Returns the description of the access rights for each table available in a catalog.
 o getTables(String, String, String, String[])
Returns the description of the tables available in a catalog.
 o getTableTypes()
Returns the table types available in this database.
 o getTimeDateFunctions()
Returns the list of supported time and date functions.
 o getTypeInfo()
Returns a description of all of the standard SQL types supported by this database.
 o getUDTs(String, String, String, int[])
Returns the description of the user-defined types available in a catalog.
 o getURL()
Returns the URL for this database.
 o getUserName()
Returns the current user name as known to the database.
 o getVersionColumns(String, String, String)
Returns a description of a table's columns that are automatically updated when any value in a row is updated.
 o insertsAreDetected(int)
Indicates if visible inserts to a result set of the specified type can be detected by calling ResultSet.rowInserted().
 o isCatalogAtStart()
Indicates if a catalog appears at the start or the end of a qualified name.
 o isReadOnly()
Indicates if the database is in read-only mode.
 o nullPlusNonNullIsNull()
Indicates if concatenations between null and non-null values are null.
 o nullsAreSortedAtEnd()
Indicates if null values are sorted at the end regardless of sort order.
 o nullsAreSortedAtStart()
Indicates if null values are sorted at the start regardless of sort order.
 o nullsAreSortedHigh()
Indicates if null values are sorted high.
 o nullsAreSortedLow()
Indicates if null values are sorted low.
 o othersDeletesAreVisible(int)
Indicates if deletes made by others are visible.
 o othersInsertsAreVisible(int)
Indicates if inserts made by others are visible.
 o othersUpdatesAreVisible(int)
Indicates if updates made by others are visible.
 o ownDeletesAreVisible(int)
Indicates if a result set's own deletes are visible.
 o ownInsertsAreVisible(int)
Indicates if a result set's own inserts are visible.
 o ownUpdatesAreVisible(int)
Indicates if a result set's own updates are visible.
 o storesLowerCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in lowercase.
 o storesLowerCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in lowercase.
 o storesMixedCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in mixed case.
 o storesMixedCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in mixed case.
 o storesUpperCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in uppercase.
 o storesUpperCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in uppercase.
 o supportsAlterTableWithAddColumn()
Indicates if ALTER TABLE with ADD COLUMN is supported.
 o supportsAlterTableWithDropColumn()
Indicates if ALTER TABLE with DROP COLUMN is supported.
 o supportsANSI92EntryLevelSQL()
Indicates if the ANSI92 entry-level SQL grammar is supported.
 o supportsANSI92FullSQL()
Indicates if the ANSI92, full SQL grammar is supported.
 o supportsANSI92IntermediateSQL()
Indicates if the ANSI92 intermediate-level SQL grammar is supported.
 o supportsBatchUpdates()
Indicates if the batch updates are supported.
 o supportsCatalogsInDataManipulation()
Indicates if a catalog name can be used in a data manipulation statement.
 o supportsCatalogsInIndexDefinitions()
Indicates if a catalog name can be used in an index definition statement.
 o supportsCatalogsInPrivilegeDefinitions()
Indicates if a catalog name can be used in a privilege definition statement.
 o supportsCatalogsInProcedureCalls()
Indicates if a catalog name can be used in a procedure call statement.
 o supportsCatalogsInTableDefinitions()
Indicates if a catalog name can be used in a table definition statement.
 o supportsColumnAliasing()
Indicates if column aliasing is supported.
 o supportsConvert()
Indicates if the CONVERT function between SQL types is supported.
 o supportsConvert(int, int)
Indicates if CONVERT between the given SQL types is supported.
 o supportsCoreSQLGrammar()
Indicates if the ODBC Core SQL grammar is supported.
 o supportsCorrelatedSubqueries()
Indicates if the correlated subqueries are supported.
 o supportsDataDefinitionAndDataManipulationTransactions()
Indicates if both data definition and data manipulation statements are supported within a transaction.
 o supportsDataManipulationTransactionsOnly()
Indicates if data manipulation statements are supported within a transaction.
 o supportsDifferentTableCorrelationNames()
Indicates if table correlation names are supported, and if so, are they restricted to be different from the names of the tables.
 o supportsExpressionsInOrderBy()
Indicates if expressions in ORDER BY lists are supported.
 o supportsExtendedSQLGrammar()
Indicates if the ODBC Extended SQL grammar is supported.
 o supportsFullOuterJoins()
Indicates if full nested outer joins are supported.
 o supportsGroupBy()
Indicates if some form of the GROUP BY clause is supported.
 o supportsGroupByBeyondSelect()
Indicates if a GROUP BY clause can add columns not in the SELECT provided it specifies all of the columns in the SELECT.
 o supportsGroupByUnrelated()
Indicates if a GROUP BY clause can use columns not in the SELECT.
 o supportsIntegrityEnhancementFacility()
Indicates if the SQL Integrity Enhancement Facility is supported.
 o supportsLikeEscapeClause()
Indicates if the escape character in LIKE clauses is supported.
 o supportsLimitedOuterJoins()
Indicates if there is limited support for outer joins.
 o supportsMinimumSQLGrammar()
Indicates if the ODBC Minimum SQL grammar is supported.
 o supportsMixedCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case sensitive and stores them in mixed case.
 o supportsMixedCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
 o supportsMultipleResultSets()
Indicates if multiple result sets from a single execute are supported.
 o supportsMultipleTransactions()
Indicates if multiple transactions can be open at once (on different connections).
 o supportsNonNullableColumns()
Indicates if columns can be defined as non-nullable.
 o supportsOpenCursorsAcrossCommit()
Indicates if cursors can remain open across commits.
 o supportsOpenCursorsAcrossRollback()
Indicates if cursors can remain open across rollback.
 o supportsOpenStatementsAcrossCommit()
Indicates if statements can remain open across commits.
 o supportsOpenStatementsAcrossRollback()
Indicates if statements can remain open across rollback.
 o supportsOrderByUnrelated()
Indicates if an ORDER BY clause can use columns not in the SELECT.
 o supportsOuterJoins()
Indicates if some form of outer join is supported.
 o supportsPositionedDelete()
Indicates if positioned DELETE is supported.
 o supportsPositionedUpdate()
Indicates if positioned UPDATE is supported.
 o supportsResultSetConcurrency(int, int)
Indicates if the specified result set concurrency is supported for the specified result set type.
 o supportsResultSetType(int)
Indicates if the specified result set type is supported.
 o supportsSchemasInDataManipulation()
Indicates if a schema name can be used in a data manipulation statement.
 o supportsSchemasInIndexDefinitions()
Indicates if a schema name can be used in an index definition statement.
 o supportsSchemasInPrivilegeDefinitions()
Indicates if a schema name be can used in a privilege definition statement.
 o supportsSchemasInProcedureCalls()
Indicates if a schema name be can used in a procedure call statement.
 o supportsSchemasInTableDefinitions()
Indicates if a schema name can be used in a table definition statement.
 o supportsSelectForUpdate()
Indicates if SELECT for UPDATE is supported.
 o supportsStoredProcedures()
Indicates if stored procedure calls using the stored procedure escape syntax are supported.
 o supportsSubqueriesInComparisons()
Indicates if subqueries in comparisons are supported.
 o supportsSubqueriesInExists()
Indicates if subqueries in EXISTS expressions are supported.
 o supportsSubqueriesInIns()
Indicates if subqueries in IN expressions are supported.
 o supportsSubqueriesInQuantifieds()
Indicates if subqueries in quantified expressions are supported.
 o supportsTableCorrelationNames()
Indicates if table correlation names are supported.
 o supportsTransactionIsolationLevel(int)
Indicates if the database supports the given transaction isolation level.
 o supportsTransactions()
Indicates if transactions are supported.
 o supportsUnion()
Indicates if SQL UNION is supported.
 o supportsUnionAll()
Indicates if SQL UNION ALL is supported.
 o toString()
Returns the name of the catalog.
 o updatesAreDetected(int)
Indicates if visible updates to a result set of the specified type can be detected by calling ResultSet.rowUpdated().
 o usesLocalFilePerTable()
Indicates if the database uses a file for each table.
 o usesLocalFiles()
Indicates if the database stores tables in a local file.

Methods

 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o getDriverMajorVersion
 public int getDriverMajorVersion()
Returns the major version number for this JDBC driver.

Returns:
The major version number.
 o getDriverMinorVersion
 public int getDriverMinorVersion()
Returns the minor version number for this JDBC driver.

Returns:
The minor version number.
 o getDriverName
 public String getDriverName() throws SQLException
Returns the name of this JDBC driver.

Returns:
The driver name.
Throws: SQLException
This exception is never thrown.
 o getDriverVersion
 public String getDriverVersion() throws SQLException
Returns the version of this JDBC driver.

Returns:
The driver version.
Throws: SQLException
This exception is never thrown.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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_ONLYCONCUR_UPDATABLE
TYPE_FORWARD_ONLYYesYes
TYPE_SCROLL_INSENSITIVEYesNo
TYPE_SCROLL_SENSITIVENoYes

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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o supportsTransactions
 public boolean supportsTransactions() throws SQLException
Indicates if transactions are supported.

Returns:
Always true. Transactions are supported.
Throws: SQLException
This exception is never thrown.
 o 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.
 o 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.
 o toString
 public String toString()
Returns the name of the catalog.

Returns:
The name of the catalog.
Overrides:
toString in class Object
 o 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.
 o 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.
 o 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