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 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.
Many of the methods here return lists of information in
ResultSets. You can use the normal ResultSet methods to
retrieve data from these ResultSets. The format of the
ResultSets are described in the JDBC interface specification.
- See Also:
- AS400JDBCResultSet
-
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.
-
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.
-
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 a 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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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
- If an error occurs.
- See Also:
- getProcedures
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
- If an error occurs.
- See Also:
- getTables
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be 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 will be returned.
If bestRowTransaction is specified,
autocommit is false, and transaction is set to repeatable read,
then results will be returned; otherwise, an empty result set
will be 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 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 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, "." will be returned. If
using AS/400 system naming convention, "/" will be returned.
- Throws: SQLException
- If an error occurs.
- See Also:
- connect
getCatalogTerm
public String getCatalogTerm() throws SQLException
- Returns the DB2 for OS/400 SQL term for "catalog".
- Returns:
- The term "System".
- Throws: SQLException
- If an error occurs.
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be returned.
- columnPattern - The column name pattern. If null is specified,
no value will be sent to the server and the server
default of *all will be used. If empty string
is specified, an empty result set will be returned.
- Returns:
- The ResultSet containing access rights for a
table's columns.
- Throws: SQLException
- If 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.
- Parameters:
- catalog - The catalog name. If null is specified, this parameter
will be ignored. If empty string is specified,
an empty result set will be returned.
- schemaPattern - The schema name pattern. If null is specified,
no value will be sent to the server and the server
default of *USRLIBL will be used. If empty string
is specified, an empty result set will be returned.
- tablePattern - The table name pattern. If null is specified,
no value will be sent to the server and the server
default of *ALL will be used. If empty string
is specified, an empty result set will be returned.
- columnPattern - The column name pattern. If null is specified,
no value will be sent to the server and the server
default of *ALL will be used. If empty string
is specified, an empty result set will be returned.
- Returns:
- The ResultSet containing the table's columns available
in a catalog.
- Throws: SQLException
- If an error occurs.
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 will be ignored. If
empty string is specified, an empty
result set will be returned.
- primarySchema - The name of the schema where the primary table
is located.
If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be used.
If empty string is specified, an empty result
set will be returned.
- primaryTable - The primary table name. If null or empty string
is specified, an empty result set will be returned.
- foreignCatalog - The catalog name. If null is specified,
this parameter will be ignored. If
empty string is specified, an empty
result set will be returned.
- foreignSchema - The name of the schema where the primary table
is located. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be used.
If empty string is specified,
an empty result set will be returned.
- foreignTable - The foreign table name. If null or empty string
is specified, an empty result set will be 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 an error occurs.
- See Also:
- getImportedKeys, getExportedKeys
getDatabaseProductName
public String getDatabaseProductName() throws SQLException
- Returns the name of this database product.
- Returns:
- The database product name.
- Throws: SQLException
- If an error occurs.
- See Also:
- getDatabaseProductVersion
getDatabaseProductVersion
public String getDatabaseProductVersion() throws SQLException
- Returns the version of this database product.
- Returns:
- The product version.
- Throws: SQLException
- If an error occurs.
- See Also:
- getDatabaseProductName
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() throws SQLException
- Returns the default transaction isolation level.
- Returns:
- The default transaction isolation level.
- Throws: SQLException
- If an error occurs.
- See Also:
- supportsTransactionIsolationLevel
getDriverMajorVersion
public int getDriverMajorVersion()
- Returns the major version number for this JDBC driver.
- Returns:
- The major version number.
- See Also:
- getDriverMinorVersion, getDriverName, getDriverVersion, getMajorVersion
getDriverMinorVersion
public int getDriverMinorVersion()
- Returns the minor version number for this JDBC driver.
- Returns:
- The minor version number.
- See Also:
- getDriverMajorVersion, getDriverName, getDriverVersion, getMinorVersion
getDriverName
public String getDriverName() throws SQLException
- Returns the name of this JDBC driver.
- Returns:
- The driver name.
- Throws: SQLException
- If an error occurs.
- See Also:
- getDriverMinorVersion, getDriverMajorVersion, getDriverVersion
getDriverVersion
public String getDriverVersion() throws SQLException
- Returns the version of this JDBC driver.
- Returns:
- The driver version.
- Throws: SQLException
- If an error occurs.
- See Also:
- getDriverMinorVersion, getDriverMajorVersion, getDriverName
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be returned.
- Returns:
- The ResultSet containing the description of the
foreign key columns that reference a table's
primary key columns.
- Throws: SQLException
- If an error occurs.
- See Also:
- getImportedKeys, getCrossReference
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
- If an error occurs.
getIdentifierQuoteString
public String getIdentifierQuoteString() throws SQLException
- Returns the string used to quote SQL identifiers.
- Returns:
- The quote string.
- Throws: SQLException
- If an error occurs.
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be 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 an error occurs.
- See Also:
- getExportedKeys, getCrossReference
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be returned.
- unique - The value indicating if unique indexes should be returned.
If true, only indexes for unique values will be returned.
If false, all indexes will be returned.
- approximate - The value indicating if the result is allowed to reflect
approximate or out-of-date values. This value will be ignored.
- Returns:
- The ResultSet containing the description of a table's indexes
and statistics.
- Throws: SQLException
- If 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
- If an error occurs.
getMaxCatalogNameLength
public int getMaxCatalogNameLength() throws SQLException
- Returns the maximum length for a catalog name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxCharLiteralLength
public int getMaxCharLiteralLength() throws SQLException
- Returns the maximum length for a character literal.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxColumnNameLength
public int getMaxColumnNameLength() throws SQLException
- Returns the maximum length for a column name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
getMaxColumnsInIndex
public int getMaxColumnsInIndex() throws SQLException
- Returns the maximum number of columns allowed in an index.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
getMaxColumnsInSelect
public int getMaxColumnsInSelect() throws SQLException
- Returns the maximum number of columns in a SELECT list.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- If an error occurs.
getMaxColumnsInTable
public int getMaxColumnsInTable() throws SQLException
- Returns the maximum number of columns in a table.
- Returns:
- The maximum number of columns.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
getMaxCursorNameLength
public int getMaxCursorNameLength() throws SQLException
- Returns the maximum cursor name length.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxIndexLength
public int getMaxIndexLength() throws SQLException
- Returns the maximum length of an index.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxProcedureNameLength
public int getMaxProcedureNameLength() throws SQLException
- Returns the maximum length of a procedure name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxRowSize
public int getMaxRowSize() throws SQLException
- Returns the maximum length of a single row.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxSchemaNameLength
public int getMaxSchemaNameLength() throws SQLException
- Returns the maximum length allowed for a schema name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxStatementLength
public int getMaxStatementLength() throws SQLException
- Returns the maximum length of a SQL statement.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
getMaxTableNameLength
public int getMaxTableNameLength() throws SQLException
- Returns the maximum length of a table name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
getMaxTablesInSelect
public int getMaxTablesInSelect() throws SQLException
- Returns the maximum number of tables in a SELECT.
- Returns:
- The maximum number of tables.
- Throws: SQLException
- If an error occurs.
getMaxUserNameLength
public int getMaxUserNameLength() throws SQLException
- Returns the maximum length of a user name.
- Returns:
- The maximum length (in bytes).
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be returned.
- Returns:
- The ResultSet containing the description of the primary
key columns.
- Throws: SQLException
- If 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
will be ignored. If empty string is specified,
an empty result set will be 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 will be 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 will be 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 will be returned.
- Returns:
- The ResultSet containing the description of the
catalog's stored procedure parameters and result
columns.
- Throws: SQLException
- If 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
will be ignored. If empty string is specified,
an empty result set will be 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 will be 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 will be returned.
- Returns:
- The ResultSet containing the description of the
stored procedures available in the catalog.
- Throws: SQLException
- If 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
- If an error occurs.
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 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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schemaPattern - The schema name pattern. If null is specified,
no value will be sent to the server and the
server default of *USRLIBL will be used.
If empty string is specified, an empty
result set will be returned.
- tablePattern - The table name. If null is specified,
no value will be sent to the server and the server
default of *ALL will be used. If empty string
is specified, an empty result set will be returned.
- Returns:
- The ResultSet containing the description of the
access rights for each table available in the
catalog.
- Throws: SQLException
- If 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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schemaPattern - The schema name pattern. If null is specified,
no value will be sent to the server and the server
default of *USRLIBL will be used. If empty string
is specified, an empty result set will be returned.
- tablePattern - The table name pattern. If null is specified,
no value will be sent to the server and the server
default of *ALL will be used. If empty string
is specified, an empty result set will be 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 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 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
- If an error occurs.
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
- If an error occurs.
getURL
public String getURL() throws SQLException
- Returns the URL for this database.
- Returns:
- The URL for this database.
- Throws: SQLException
- If 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 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
will be ignored. If empty string is specified,
an empty result set will be returned.
- schema - The schema name. If null is specified, the
default library specified in the URL will be used.
If null is specified and a default library was not
specified in the URL, the first library specified
in the libraries properties file will be 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 will be 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 will be 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 an error occurs.
isCatalogAtStart
public boolean isCatalogAtStart() throws SQLException
- Indicates if a catalog appears at the start or the end of
a qualified name.
- Returns:
- Always true. Catalog appears at the start of a qualified name.
- Throws: SQLException
- If an error occurs.
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 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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
nullsAreSortedHigh
public boolean nullsAreSortedHigh() throws SQLException
- Indicates if null values are sorted high.
- Returns:
- Always true. Null values are sorted high.
- Throws: SQLException
- If an error occurs.
nullsAreSortedLow
public boolean nullsAreSortedLow() throws SQLException
- Indicates if null values are sorted low.
- Returns:
- Always false. Null values are not sorted low.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
- See Also:
- supportsAlterTableWithAddColumn
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
- See Also:
- Types
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
- If an error occurs.
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries() throws SQLException
- Indicates if the correlated subqueries are supported.
- Returns:
- Always true. Correlated subqueries are supported.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
supportsPositionedDelete
public boolean supportsPositionedDelete() throws SQLException
- Indicates if positioned DELETE is supported.
- Returns:
- Always true. Positioned DELETE is supported.
- Throws: SQLException
- If an error occurs.
supportsPositionedUpdate
public boolean supportsPositionedUpdate() throws SQLException
- Indicates if positioned UPDATE is supported.
- Returns:
- Always true. Positioned UPDATE is supported.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
supportsSelectForUpdate
public boolean supportsSelectForUpdate() throws SQLException
- Indicates if SELECT for UPDATE is supported.
- Returns:
- Always true. SELECT for UPDATE is supported.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() throws SQLException
- Indicates if subqueries in comparisons are supported.
- Returns:
- Always true. Subqueries in comparisons are supported.
- Throws: SQLException
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
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
- If an error occurs.
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() throws SQLException
- Indicates if table correlation names are supported.
- Returns:
- Always true. Table correlation names are supported.
- Throws: SQLException
- If an error occurs.
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level) throws SQLException
- Indicates if the database supports the given transaction
isolation level.
- Parameters:
- level - One of the Connection.TRANSACTION_* values.
- Returns:
- true if the database supports the given transaction
isolation level; false otherwise.
- Throws: SQLException
- If an error occurs.
supportsTransactions
public boolean supportsTransactions() throws SQLException
- Indicates if transactions are supported.
- Returns:
- Always true. Transactions are supported.
- Throws: SQLException
- If an error occurs.
supportsUnion
public boolean supportsUnion() throws SQLException
- Indicates if SQL UNION is supported.
- Returns:
- Always true. SQL UNION is supported.
- Throws: SQLException
- If an error occurs.
supportsUnionAll
public boolean supportsUnionAll() throws SQLException
- Indicates if SQL UNION ALL is supported.
- Returns:
- Always true. SQL UNION ALL is supported.
- Throws: SQLException
- If an error occurs.
toString
public String toString()
- Returns the name of the catalog.
- Returns:
- The name of the catalog.
- Overrides:
- toString in class Object
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
- If an error occurs.
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
- If an error occurs.
All Packages Class Hierarchy This Package Previous Next Index