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