java.sql

Interface DatabaseMetaData

public interface DatabaseMetaData

Field Summary
`static short`	`attributeNoNulls`
`static short`	`attributeNullable`
`static short`	`attributeNullableUnknown`
`static int`	`bestRowNotPseudo` The best row identifier is not a pseudo-column.
`static int`	`bestRowPseudo` The best row identifier is a pseudo-column.
`static int`	`bestRowSession` The best row identifier is valid to the end of the session.
`static int`	`bestRowTemporary` The best row's scope is only guaranteed to be valid so long as the row is actually being used.
`static int`	`bestRowTransaction` The best row identifier is valid to the end of the transaction.
`static int`	`bestRowUnknown` The best row may or may not be a pseudo-column.
`static int`	`columnNoNulls` The column does not allow NULL
`static int`	`columnNullable` The column does allow NULL
`static int`	`columnNullableUnknown` It is unknown whether or not the column allows NULL
`static int`	`importedKeyCascade` Foreign key changes are cascaded in updates or deletes.
`static int`	`importedKeyInitiallyDeferred` Wish I knew what this meant.
`static int`	`importedKeyInitiallyImmediate` Wish I knew what this meant.
`static int`	`importedKeyNoAction` If the primary key is a foreign key, it cannot be udpated or deleted.
`static int`	`importedKeyNotDeferrable` Wish I knew what this meant.
`static int`	`importedKeyRestrict` Column may not be updated or deleted in use as a foreign key.
`static int`	`importedKeySetDefault` If the primary key is updated or deleted, the foreign key is set to a default value.
`static int`	`importedKeySetNull` When primary key is updated or deleted, the foreign key is set to NULL.
`static int`	`procedureColumnIn` The column type is input.
`static int`	`procedureColumnInOut` The column type is input/output.
`static int`	`procedureColumnOut` The column type is output
`static int`	`procedureColumnResult` The column is used for storing results
`static int`	`procedureColumnReturn` The column is used for return values.
`static int`	`procedureColumnUnknown` The column type is unknown.
`static int`	`procedureNoNulls` NULL values are not allowed.
`static int`	`procedureNoResult` The procedure does not return a result.
`static int`	`procedureNullable` NULL values are allowed.
`static int`	`procedureNullableUnknown` It is unknown whether or not NULL values are allowed.
`static int`	`procedureResultUnknown` It is unknown whether or not the procedure returns a result.
`static int`	`procedureReturnsResult` The procedure returns a result.
`static int`	`sqlStateSQL99`
`static int`	`sqlStateXOpen`
`static short`	`tableIndexClustered` This table index is clustered.
`static short`	`tableIndexHashed` This table index is hashed.
`static short`	`tableIndexOther` This table index is of another type.
`static short`	`tableIndexStatistic` This column contains table statistics.
`static int`	`typeNoNulls` A NULL value is not allowed for this data type.
`static int`	`typeNullable` A NULL value is allowed for this data type.
`static int`	`typeNullableUnknown` It is unknown whether or not NULL values are allowed for this data type.
`static int`	`typePredBasic` All WHERE clauses except "WHERE..LIKE" style are allowed on this data type.
`static int`	`typePredChar` Only "WHERE..LIKE" style WHERE clauses are allowed on this data type.
`static int`	`typePredNone` Where clauses are not supported for this type.
`static int`	`typeSearchable` Any type of WHERE clause is allowed for this data type.
`static int`	`versionColumnNotPseudo` The version column is not a pseudo-column
`static int`	`versionColumnPseudo` The version column is a pseudo-column
`static int`	`versionColumnUnknown` It is unknown whether or not the version column is a pseudo-column.

Method Summary
`boolean`	`allProceduresAreCallable()` This method tests whether or not all the procedures returned by the `getProcedures` method can be called by this user.
`boolean`	`allTablesAreSelectable()` This method tests whether or not all the table returned by the `getTables` method can be selected by this user.
`boolean`	`dataDefinitionCausesTransactionCommit()` This method tests whether or not a DDL statement will cause the current transaction to be automatically committed.
`boolean`	`dataDefinitionIgnoredInTransactions()` This method tests whether or not DDL statements are ignored in transactions.
`boolean`	`deletesAreDetected(int type)` This method tests whether or not the specified result set type can detect a visible delete by calling the `rowUpdated` method.
`boolean`	`doesMaxRowSizeIncludeBlobs()` This method tests whether or not the maximum row size includes BLOB's
`ResultSet`	`getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)`
`ResultSet`	`getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)` This method returns the best set of columns for uniquely identifying a row.
`String`	`getCatalogSeparator()` This method returns the separator between the catalog name and the table name.
`String`	`getCatalogTerm()` This method returns the vendor's term for "catalog".
`ResultSet`	`getCatalogs()` This method returns the list of database catalogs as a `ResultSet` with one column - TABLE_CAT - that is the name of the catalog.
`ResultSet`	`getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)` This method returns the access rights that have been granted to the requested columns.
`ResultSet`	`getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)` This method returns a list of the tables columns for the requested tables.
`Connection`	`getConnection()` This method returns the `Connection` object that was used to generate the metadata in this object.
`ResultSet`	`getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)` This method returns a description of how one table imports another table's primary key as a foreign key.
`int`	`getDatabaseMajorVersion()`
`int`	`getDatabaseMinorVersion()`
`String`	`getDatabaseProductName()` This method returns the name of the database product.
`String`	`getDatabaseProductVersion()` This method returns the version of the database product.
`int`	`getDefaultTransactionIsolation()` This method returns the default transaction isolation level of the database.
`int`	`getDriverMajorVersion()` This method returns the major version number of the JDBC driver.
`int`	`getDriverMinorVersion()` This method returns the minor version number of the JDBC driver.
`String`	`getDriverName()` This method returns the name of the JDBC driver.
`String`	`getDriverVersion()` This method returns the version of the JDBC driver.
`ResultSet`	`getExportedKeys(String catalog, String schema, String table)` This method returns a list of the table's which use this table's primary key as a foreign key.
`String`	`getExtraNameCharacters()` This methods returns non-standard characters that can appear in unquoted identifiers.
`String`	`getIdentifierQuoteString()` This metohd returns the quote string for SQL identifiers.
`ResultSet`	`getImportedKeys(String catalog, String schema, String table)` This method returns a list of the table's foreign keys.
`ResultSet`	`getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)` This method returns information about a tables indices and statistics.
`int`	`getJDBCMajorVersion()`
`int`	`getJDBCMinorVersion()`
`int`	`getMaxBinaryLiteralLength()` This method returns the number of hex characters allowed in an inline binary literal.
`int`	`getMaxCatalogNameLength()` This method returns the maximum length of a catalog name.
`int`	`getMaxCharLiteralLength()` This method returns the maximum length of a character literal.
`int`	`getMaxColumnNameLength()` This method returns the maximum length of a column name.
`int`	`getMaxColumnsInGroupBy()` This method returns the maximum number of columns in a GROUP BY statement.
`int`	`getMaxColumnsInIndex()` This method returns the maximum number of columns in an index.
`int`	`getMaxColumnsInOrderBy()` This method returns the maximum number of columns in an ORDER BY statement.
`int`	`getMaxColumnsInSelect()` This method returns the maximum number of columns in a SELECT statement.
`int`	`getMaxColumnsInTable()` This method returns the maximum number of columns in a table.
`int`	`getMaxConnections()` This method returns the maximum number of connections this client can have to the database.
`int`	`getMaxCursorNameLength()` This method returns the maximum length of a cursor name.
`int`	`getMaxIndexLength()` This method returns the maximum length of an index.
`int`	`getMaxProcedureNameLength()` This method returns the maximum length of a procedure name.
`int`	`getMaxRowSize()` This method returns the maximum size of a row in bytes.
`int`	`getMaxSchemaNameLength()` This method returns the maximum length of a schema name.
`int`	`getMaxStatementLength()` This method includes the maximum length of a SQL statement.
`int`	`getMaxStatements()` This method returns the maximum number of statements that can be active at any time.
`int`	`getMaxTableNameLength()` This method returns the maximum length of a table name.
`int`	`getMaxTablesInSelect()` This method returns the maximum number of tables that may be referenced in a SELECT statement.
`int`	`getMaxUserNameLength()` This method returns the maximum length of a user name.
`String`	`getNumericFunctions()` This method returns a comma separated list of math functions.
`ResultSet`	`getPrimaryKeys(String catalog, String schema, String table)` This method returns a list of a table's primary key columns.
`ResultSet`	`getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)` This method returns a list of the parameter and result columns for the requested stored procedures.
`String`	`getProcedureTerm()` This method returns the vendor's term for "procedure".
`ResultSet`	`getProcedures(String catalog, String schemaPattern, String procedureNamePattern)` This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog.
`int`	`getResultSetHoldability()`
`String`	`getSQLKeywords()` This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.
`int`	`getSQLStateType()`
`String`	`getSchemaTerm()` This method returns the vendor's term for "schema".
`ResultSet`	`getSchemas()` This method returns the list of database schemas as a `ResultSet`, with one column - TABLE_SCHEM - that is the name of the schema.
`String`	`getSearchStringEscape()` This method returns the string used to escape wildcards in search strings.
`String`	`getStringFunctions()` This method returns a comma separated list of string functions.
`ResultSet`	`getSuperTables(String catalog, String schemaPattern, String tableNamePattern)`
`ResultSet`	`getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)`
`String`	`getSystemFunctions()` This method returns a comma separated list of of system functions.
`ResultSet`	`getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)` This method returns the access rights that have been granted to the requested tables.
`ResultSet`	`getTableTypes()` This method returns the list of database table types as a `ResultSet` with one column - TABLE_TYPE - that is the name of the table type.
`ResultSet`	`getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)` This method returns a list of the requested table as a `ResultSet` with the following columns: TABLE_CAT - The catalog the table is in, which may be `null`. TABLE_SCHEM - The schema the table is in, which may be `null`. TABLE_NAME - The name of the table. TABLE_TYPE - A string describing the table type.
`String`	`getTimeDateFunctions()` This method returns comma separated list of time/date functions.
`ResultSet`	`getTypeInfo()` This method returns a list of the SQL types supported by this database.
`ResultSet`	`getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)` This method returns the list of user defined data types in use.
`String`	`getURL()` This method returns the URL for this database.
`String`	`getUserName()` This method returns the database username for this connection.
`ResultSet`	`getVersionColumns(String catalog, String schema, String table)` This method returns the set of columns that are automatically updated when the row is update.
`boolean`	`insertsAreDetected(int type)` This method tests whether or not the specified result set type can detect a visible insert by calling the `rowUpdated` method.
`boolean`	`isCatalogAtStart()` This method tests whether a catalog name appears at the beginning of a fully qualified table name.
`boolean`	`isReadOnly()` This method tests whether or not the database is in read only mode.
`boolean`	`locatorsUpdateCopy()`
`boolean`	`nullPlusNonNullIsNull()` This method tests whether the concatenation of a NULL and non-NULL value results in a NULL.
`boolean`	`nullsAreSortedAtEnd()` This method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order.
`boolean`	`nullsAreSortedAtStart()` This method tests whether or not NULL's sort as high values.
`boolean`	`nullsAreSortedHigh()` This method tests whether or not NULL's sort as high values.
`boolean`	`nullsAreSortedLow()` This method tests whether or not NULL's sort as low values.
`boolean`	`othersDeletesAreVisible(int type)` This method tests whether or not the specified result set type sees deletes committed by others.
`boolean`	`othersInsertsAreVisible(int type)` This method tests whether or not the specified result set type sees inserts committed by others.
`boolean`	`othersUpdatesAreVisible(int type)` This method tests whether or not the specified result set type sees updates committed by others.
`boolean`	`ownDeletesAreVisible(int type)` This method tests whether or not the specified result set type sees its own deletes.
`boolean`	`ownInsertsAreVisible(int type)` This method tests whether or not the specified result set type sees its own inserts.
`boolean`	`ownUpdatesAreVisible(int type)` This method tests whether or not the specified result set type sees its own updates.
`boolean`	`storesLowerCaseIdentifiers()` This method tests whether or not the database treats mixed case identifiers as all lower case.
`boolean`	`storesLowerCaseQuotedIdentifiers()` This method tests whether or not the database treats mixed case quoted identifiers as all lower case.
`boolean`	`storesMixedCaseIdentifiers()` This method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive.
`boolean`	`storesMixedCaseQuotedIdentifiers()` This method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive.
`boolean`	`storesUpperCaseIdentifiers()` This method tests whether or not the database treats mixed case identifiers as all upper case.
`boolean`	`storesUpperCaseQuotedIdentifiers()` This method tests whether or not the database treats mixed case quoted identifiers as all upper case.
`boolean`	`supportsANSI92EntryLevelSQL()` This method tests whether or not the ANSI92 entry level SQL grammar is supported.
`boolean`	`supportsANSI92FullSQL()` This method tests whether or not the ANSI92 full SQL grammar is supported.
`boolean`	`supportsANSI92IntermediateSQL()` This method tests whether or not the ANSI92 intermediate SQL grammar is supported.
`boolean`	`supportsAlterTableWithAddColumn()` This method tests whether or not the database supports "ALTER TABLE ADD COLUMN"
`boolean`	`supportsAlterTableWithDropColumn()` This method tests whether or not the database supports "ALTER TABLE DROP COLUMN"
`boolean`	`supportsBatchUpdates()` This method tests whether or not the database supports batch updates.
`boolean`	`supportsCatalogsInDataManipulation()` This method tests whether a catalog name can appear in a data manipulation statement.
`boolean`	`supportsCatalogsInIndexDefinitions()` This method tests whether a catalog name can appear in an index definition.
`boolean`	`supportsCatalogsInPrivilegeDefinitions()` This method tests whether a catalog name can appear in privilege definitions.
`boolean`	`supportsCatalogsInProcedureCalls()` This method tests whether a catalog name can appear in a procedure call
`boolean`	`supportsCatalogsInTableDefinitions()` This method tests whether a catalog name can appear in a table definition.
`boolean`	`supportsColumnAliasing()` This method tests whether or not column aliasing is supported.
`boolean`	`supportsConvert()` Tests whether or not CONVERT is supported.
`boolean`	`supportsConvert(int fromType, int toType)` This method tests whether or not CONVERT can be performed between the specified types.
`boolean`	`supportsCoreSQLGrammar()` This method tests whether or not the core grammer for ODBC is supported.
`boolean`	`supportsCorrelatedSubqueries()` This method test whether or not correlated subqueries are allowed.
`boolean`	`supportsDataDefinitionAndDataManipulationTransactions()` This method tests whether or not DDL and DML statements allowed within the same transaction.
`boolean`	`supportsDataManipulationTransactionsOnly()` This method tests whether or not only DML statement are allowed inside a transaction.
`boolean`	`supportsDifferentTableCorrelationNames()` This method tests whether correlation names must be different from the name of the table.
`boolean`	`supportsExpressionsInOrderBy()` This method tests whether or not expressions are allowed in an ORDER BY lists.
`boolean`	`supportsExtendedSQLGrammar()` This method tests whether or not the extended grammer for ODBC is supported.
`boolean`	`supportsFullOuterJoins()` This method tests whether or not the database supports full outer joins.
`boolean`	`supportsGetGeneratedKeys()`
`boolean`	`supportsGroupBy()` This method tests whether or not GROUP BY is supported.
`boolean`	`supportsGroupByBeyondSelect()` This method tests whether or not a GROUP BY can add columns not in the select if it includes all the columns in the select.
`boolean`	`supportsGroupByUnrelated()` This method tests whether GROUP BY on a non-selected column is allowed.
`boolean`	`supportsIntegrityEnhancementFacility()` This method tests whether or not the SQL integrity enhancement facility is supported.
`boolean`	`supportsLikeEscapeClause()` This method tests whether or not the escape character is supported in LIKE expressions.
`boolean`	`supportsLimitedOuterJoins()` This method tests whether or not the database supports limited outer joins.
`boolean`	`supportsMinimumSQLGrammar()` This method tests whether or not the minimum grammer for ODBC is supported.
`boolean`	`supportsMixedCaseIdentifiers()` This method tests whether or not the database supports identifiers with mixed case.
`boolean`	`supportsMixedCaseQuotedIdentifiers()` This method tests whether or not the database supports quoted identifiers with mixed case.
`boolean`	`supportsMultipleOpenResults()`
`boolean`	`supportsMultipleResultSets()` This method tests whether multiple result sets for a single statement are supported.
`boolean`	`supportsMultipleTransactions()` This method test whether or not multiple transactions may be open at once, as long as they are on different connections.
`boolean`	`supportsNamedParameters()`
`boolean`	`supportsNonNullableColumns()` This method tests whether or not columns can be defined as NOT NULL.
`boolean`	`supportsOpenCursorsAcrossCommit()` This method tests whether or not the database supports cursors remaining open across commits.
`boolean`	`supportsOpenCursorsAcrossRollback()` This method tests whether or not the database supports cursors remaining open across rollbacks.
`boolean`	`supportsOpenStatementsAcrossCommit()` This method tests whether or not the database supports statements remaining open across commits.
`boolean`	`supportsOpenStatementsAcrossRollback()` This method tests whether or not the database supports statements remaining open across rollbacks.
`boolean`	`supportsOrderByUnrelated()` This method tests whether or ORDER BY on a non-selected column is allowed.
`boolean`	`supportsOuterJoins()` This method tests whether or not the database supports outer joins.
`boolean`	`supportsPositionedDelete()` This method tests whether or not that database supports positioned deletes.
`boolean`	`supportsPositionedUpdate()` This method tests whether or not that database supports positioned updates.
`boolean`	`supportsResultSetConcurrency(int type, int concurrency)` This method tests whether the specified result set type and result set concurrency type are supported by the database.
`boolean`	`supportsResultSetHoldability(int holdability)`
`boolean`	`supportsResultSetType(int type)` This method tests whether or not the datbase supports the specified result type.
`boolean`	`supportsSavepoints()`
`boolean`	`supportsSchemasInDataManipulation()` This method tests whether a catalog name can appear in a data manipulation statement.
`boolean`	`supportsSchemasInIndexDefinitions()` This method tests whether a catalog name can appear in an index definition.
`boolean`	`supportsSchemasInPrivilegeDefinitions()` This method tests whether a catalog name can appear in privilege definitions.
`boolean`	`supportsSchemasInProcedureCalls()` This method tests whether a catalog name can appear in a procedure call
`boolean`	`supportsSchemasInTableDefinitions()` This method tests whether a catalog name can appear in a table definition.
`boolean`	`supportsSelectForUpdate()` This method tests whether or not SELECT FOR UPDATE is supported by the database.
`boolean`	`supportsStatementPooling()`
`boolean`	`supportsStoredProcedures()` This method tests whether or not stored procedures are supported on this database.
`boolean`	`supportsSubqueriesInComparisons()` This method tests whether or not subqueries are allowed in comparisons.
`boolean`	`supportsSubqueriesInExists()` This method tests whether or not subqueries are allowed in exists expressions.
`boolean`	`supportsSubqueriesInIns()` This method tests whether subqueries are allowed in IN statements.
`boolean`	`supportsSubqueriesInQuantifieds()` This method tests whether or not subqueries are allowed in quantified expressions.
`boolean`	`supportsTableCorrelationNames()` This method tests whether or not table correlation names are supported.
`boolean`	`supportsTransactionIsolationLevel(int level)` This method tests whether or not the database supports the specified transaction isolation level.
`boolean`	`supportsTransactions()` This method tests whether or not the database supports transactions.
`boolean`	`supportsUnion()` This method tests whether or not the UNION statement is supported.
`boolean`	`supportsUnionAll()` This method tests whether or not the UNION ALL statement is supported.
`boolean`	`updatesAreDetected(int type)` This method tests whether or not the specified result set type can detect a visible update by calling the `rowUpdated` method.
`boolean`	`usesLocalFilePerTable()` This method tests whether or not the database uses a separate file for each table.
`boolean`	`usesLocalFiles()` This method tests whether or not the database uses local files to store tables.

attributeNoNulls

public static final short attributeNoNulls

Field Value:
0

attributeNullable

public static final short attributeNullable

Field Value:
1

attributeNullableUnknown

public static final short attributeNullableUnknown

Field Value:
2

bestRowNotPseudo

public static final int bestRowNotPseudo

The best row identifier is not a pseudo-column.
Field Value:
1

bestRowPseudo

public static final int bestRowPseudo

The best row identifier is a pseudo-column.
Field Value:
2

bestRowSession

public static final int bestRowSession

The best row identifier is valid to the end of the session.
Field Value:
2

bestRowTemporary

public static final int bestRowTemporary

The best row's scope is only guaranteed to be valid so long as the row is actually being used.
Field Value:
0

bestRowTransaction

public static final int bestRowTransaction

The best row identifier is valid to the end of the transaction.
Field Value:
1

bestRowUnknown

public static final int bestRowUnknown

The best row may or may not be a pseudo-column.
Field Value:
0

columnNoNulls

public static final int columnNoNulls

The column does not allow NULL
Field Value:
0

columnNullable

public static final int columnNullable

The column does allow NULL
Field Value:
1

columnNullableUnknown

public static final int columnNullableUnknown

It is unknown whether or not the column allows NULL
Field Value:
2

importedKeyCascade

public static final int importedKeyCascade

Foreign key changes are cascaded in updates or deletes.
Field Value:
0

importedKeyInitiallyDeferred

public static final int importedKeyInitiallyDeferred

Wish I knew what this meant.
Field Value:
5

importedKeyInitiallyImmediate

public static final int importedKeyInitiallyImmediate

Wish I knew what this meant.
Field Value:
6

importedKeyNoAction

public static final int importedKeyNoAction

If the primary key is a foreign key, it cannot be udpated or deleted.
Field Value:
3

importedKeyNotDeferrable

public static final int importedKeyNotDeferrable

Wish I knew what this meant.
Field Value:
7

importedKeyRestrict

public static final int importedKeyRestrict

Column may not be updated or deleted in use as a foreign key.
Field Value:
1

importedKeySetDefault

public static final int importedKeySetDefault

If the primary key is updated or deleted, the foreign key is set to a default value.
Field Value:
4

importedKeySetNull

public static final int importedKeySetNull

When primary key is updated or deleted, the foreign key is set to NULL.
Field Value:
2

procedureColumnIn

public static final int procedureColumnIn

The column type is input.
Field Value:
1

procedureColumnInOut

public static final int procedureColumnInOut

The column type is input/output.
Field Value:
2

procedureColumnOut

public static final int procedureColumnOut

The column type is output
Field Value:
4

procedureColumnResult

public static final int procedureColumnResult

The column is used for storing results
Field Value:
3

procedureColumnReturn

public static final int procedureColumnReturn

The column is used for return values.
Field Value:
5

procedureColumnUnknown

public static final int procedureColumnUnknown

The column type is unknown.
Field Value:
0

procedureNoNulls

public static final int procedureNoNulls

NULL values are not allowed.
Field Value:
0

procedureNoResult

public static final int procedureNoResult

The procedure does not return a result.
Field Value:
1

procedureNullable

public static final int procedureNullable

NULL values are allowed.
Field Value:
1

procedureNullableUnknown

public static final int procedureNullableUnknown

It is unknown whether or not NULL values are allowed.
Field Value:
2

procedureResultUnknown

public static final int procedureResultUnknown

It is unknown whether or not the procedure returns a result.
Field Value:
0

procedureReturnsResult

public static final int procedureReturnsResult

The procedure returns a result.
Field Value:
2

sqlStateSQL99

public static final int sqlStateSQL99

Field Value:
2

sqlStateXOpen

public static final int sqlStateXOpen

Field Value:
1

tableIndexClustered

public static final short tableIndexClustered

This table index is clustered.
Field Value:
1

tableIndexHashed

public static final short tableIndexHashed

This table index is hashed.
Field Value:
2

tableIndexOther

public static final short tableIndexOther

This table index is of another type.
Field Value:
3

tableIndexStatistic

public static final short tableIndexStatistic

This column contains table statistics.
Field Value:
0

typeNoNulls

public static final int typeNoNulls

A NULL value is not allowed for this data type.
Field Value:
0

typeNullable

public static final int typeNullable

A NULL value is allowed for this data type.
Field Value:
1

typeNullableUnknown

public static final int typeNullableUnknown

It is unknown whether or not NULL values are allowed for this data type.
Field Value:
2

typePredBasic

public static final int typePredBasic

All WHERE clauses except "WHERE..LIKE" style are allowed on this data type.
Field Value:
2

typePredChar

public static final int typePredChar

Only "WHERE..LIKE" style WHERE clauses are allowed on this data type.
Field Value:
1

typePredNone

public static final int typePredNone

Where clauses are not supported for this type.
Field Value:
0

typeSearchable

public static final int typeSearchable

Any type of WHERE clause is allowed for this data type.
Field Value:
3

versionColumnNotPseudo

public static final int versionColumnNotPseudo

The version column is not a pseudo-column
Field Value:
1

versionColumnPseudo

public static final int versionColumnPseudo

The version column is a pseudo-column
Field Value:
2

versionColumnUnknown

public static final int versionColumnUnknown

It is unknown whether or not the version column is a pseudo-column.
Field Value:
0

allProceduresAreCallable

public boolean allProceduresAreCallable()
            throws SQLException

This method tests whether or not all the procedures returned by the getProcedures method can be called by this user.
Returns:
true if all the procedures can be called, false otherwise.
Throws:
SQLException - If an error occurs.

allTablesAreSelectable

public boolean allTablesAreSelectable()
            throws SQLException

This method tests whether or not all the table returned by the getTables method can be selected by this user.
Returns:
true if all the procedures can be called, false otherwise.
Throws:
SQLException - If an error occurs.

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()
            throws SQLException

This method tests whether or not a DDL statement will cause the current transaction to be automatically committed.
Returns:
true if DDL causes an immediate transaction commit, false otherwise.
Throws:
SQLException - If an error occurs.

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()
            throws SQLException

This method tests whether or not DDL statements are ignored in transactions.
Returns:
true if DDL statements are ignored in transactions, false otherwise.
Throws:
SQLException - If an error occurs.

deletesAreDetected

public boolean deletesAreDetected(int type)
            throws SQLException

This method tests whether or not the specified result set type can detect a visible delete by calling the rowUpdated method.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type can detect visible deletes using rowUpdated, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()
            throws SQLException

This method tests whether or not the maximum row size includes BLOB's
Returns:
true if the maximum row size includes BLOB's, false otherwise.
Throws:
SQLException - If an error occurs.

getAttributes

public ResultSet getAttributes(String catalog,
                               String schemaPattern,
                               String typeNamePattern,
                               String attributeNamePattern)
            throws SQLException

Since:
1.4

getBestRowIdentifier

public ResultSet getBestRowIdentifier(String catalog,
                                      String schema,
                                      String table,
                                      int scope,
                                      boolean nullable)
            throws SQLException

This method returns the best set of columns for uniquely identifying a row. It returns this information as a ResultSet with the following columns:
SCOPE - The scope of the results returned. This is one of the constants defined in this class (bestRowTemporary, bestRowTransaction, or bestRowSession).
COLUMN_NAME - The name of the column.
DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
TYPE_NAME - The string name of the data type for this column.
COLUMN_SIZE - The precision of the columns
BUFFER_LENGTH - Unused
DECIMAL_DIGITS - The scale of the column.
PSEUDO_COLUMN - Whether or not the best row identifier is a pseudo_column. This is one of the constants defined in this class (bestRowUnknown, bestRowNotPseudo, or bestRowPseudo).

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
scope - One of the best row id scope constants from this class.
nullable - true to include columns that are nullable, false otherwise.
Returns:
A ResultSet with the best row identifier.
Throws:
SQLException - If an error occurs.

getCatalogSeparator

public String getCatalogSeparator()
            throws SQLException

This method returns the separator between the catalog name and the table name.
Returns:
The separator between the catalog name and the table name.
Throws:
SQLException - If an error occurs.

getCatalogTerm

public String getCatalogTerm()
            throws SQLException

This method returns the vendor's term for "catalog".
Returns:
The vendor's term for catalog.
Throws:
SQLException - if an error occurs.

getCatalogs

public ResultSet getCatalogs()
            throws SQLException

This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the name of the catalog.
Returns:
A ResultSet with all the requested catalogs.
Throws:
SQLException - If an error occurs.

getColumnPrivileges

public ResultSet getColumnPrivileges(String catalog,
                                     String schema,
                                     String table,
                                     String columnNamePattern)
            throws SQLException

This method returns the access rights that have been granted to the requested columns. This information is returned as a ResultSet with the following columns:
TABLE_CAT - The catalog the table is in, which may be null.
TABLE_SCHEM - The schema the tables is in, which may be null.
TABLE_NAME - The name of the table.
COLUMN_NAME - The name of the column.
GRANTOR - The entity that granted the access.
GRANTEE - The entity granted the access.
PRIVILEGE - The name of the privilege granted.
IS_GRANTABLE - "YES" if the grantee can grant the privilege to others, "NO" if not, and null if unknown.

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
Returns:
A ResultSet with all the requested privileges.
Throws:
SQLException - If an error occurs.

getColumns

public ResultSet getColumns(String catalog,
                            String schemaPattern,
                            String tableNamePattern,
                            String columnNamePattern)
            throws SQLException

This method returns a list of the tables columns for the requested tables. This is returned in the form of a ResultSet with the following columns:

TABLE_CAT - The catalog the table is in, which may be null.
TABLE_SCHEM - The schema the tables is in, which may be null.
TABLE_NAME - The name of the table.
COLUMN_NAME - The name of the column
DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
TYPE_NAME - The string name of the data type for this column.
COLUMN_SIZE - The size of the column.
Unused
NUM_PREC_RADIX - The radix of the column.
NULLABLE - Whether or not the column is NULLABLE. This is one of the constants defined in this class (tableNoNulls, tableNullable, or tableNullableUnknown)
REMARKS - A description of the column.
COLUMN_DEF - The default value for the column, may be null.
SQL_DATA_TYPE - Unused
SQL_DATETIME_SUB - Unused
CHAR_OCTET_LENGTH - For character columns, the maximum number of bytes in the column.
ORDINAL_POSITION - The index of the column in the table.
IS_NULLABLE - "NO" means no, "YES" means maybe, and an empty string means unknown.

Parameters:
catalog - The name of the catalog to return table from, or "" to return tables from all catalogs.
schemaPattern - A schema pattern for the schemas to return tables from, or "" to return tables from all schemas.
Throws:
SQLException - If an error occurs.

getConnection

public Connection getConnection()
            throws SQLException

This method returns the Connection object that was used to generate the metadata in this object.
Returns:
The connection for this object.
Throws:
SQLException - If an error occurs.

getCrossReference

public ResultSet getCrossReference(String primaryCatalog,
                                   String primarySchema,
                                   String primaryTable,
                                   String foreignCatalog,
                                   String foreignSchema,
                                   String foreignTable)
            throws SQLException

This method returns a description of how one table imports another table's primary key as a foreign key. The information is returned as a ResultSet with the following columns:
PKTABLE_CAT - The catalog of the table the key was imported from.
PKTABLE_SCHEM - The schema of the table the key was imported from.
PKTABLE_NAME - The name of the table the key was imported from.
PKCOLUMN_NAME - The name of the column that was imported.
FKTABLE_CAT - The foreign key catalog name.
FKTABLE_SCHEM - The foreign key schema name.
FKTABLE_NAME - The foreign key table name.
FKCOLUMN_NAME - The foreign key column name.
KEY_SEQ - The sequence number of the column within the foreign key.
UPDATE_RULE - How the foreign key behaves when the primary key is updated. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, importedKeySetDefault, or importedKeyRestrict).
DELETE_RULE - How the foreign key behaves when the primary key is deleted. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, or importedKeySetDefault)
FK_NAME - The name of the foreign key.
PK_NAME - The name of the primary key.
DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).

Parameters:
Returns:
A ResultSet with the requested information
Throws:
SQLException - If an error occurs.

getDatabaseMajorVersion

public int getDatabaseMajorVersion()
            throws SQLException

Since:
1.4

getDatabaseMinorVersion

public int getDatabaseMinorVersion()
            throws SQLException

Since:
1.4

getDatabaseProductName

public String getDatabaseProductName()
            throws SQLException

This method returns the name of the database product.
Returns:
The database product.
Throws:
SQLException - If an error occurs.

getDatabaseProductVersion

public String getDatabaseProductVersion()
            throws SQLException

This method returns the version of the database product.
Returns:
The version of the database product.
Throws:
SQLException - If an error occurs.

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()
            throws SQLException

This method returns the default transaction isolation level of the database.
Returns:
The default transaction isolation level of the database.
Throws:
SQLException - If an error occurs.
See Also:
Connection

getDriverMajorVersion

public int getDriverMajorVersion()

This method returns the major version number of the JDBC driver.
Returns:
The major version number of the JDBC driver.

getDriverMinorVersion

public int getDriverMinorVersion()

This method returns the minor version number of the JDBC driver.
Returns:
The minor version number of the JDBC driver.

getDriverName

public String getDriverName()
            throws SQLException

This method returns the name of the JDBC driver.
Returns:
The name of the JDBC driver.
Throws:
SQLException - If an error occurs.

getDriverVersion

public String getDriverVersion()
            throws SQLException

This method returns the version of the JDBC driver.
Returns:
The version of the JDBC driver.
Throws:
SQLException - If an error occurs.

getExportedKeys

public ResultSet getExportedKeys(String catalog,
                                 String schema,
                                 String table)
            throws SQLException

This method returns a list of the table's which use this table's primary key as a foreign key. The information is returned as a ResultSet with the following columns:
PKTABLE_CAT - The catalog of the table the key was imported from.
PKTABLE_SCHEM - The schema of the table the key was imported from.
PKTABLE_NAME - The name of the table the key was imported from.
PKCOLUMN_NAME - The name of the column that was imported.
FKTABLE_CAT - The foreign key catalog name.
FKTABLE_SCHEM - The foreign key schema name.
FKTABLE_NAME - The foreign key table name.
FKCOLUMN_NAME - The foreign key column name.
KEY_SEQ - The sequence number of the column within the foreign key.
UPDATE_RULE - How the foreign key behaves when the primary key is updated. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, importedKeySetDefault, or importedKeyRestrict).
DELETE_RULE - How the foreign key behaves when the primary key is deleted. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, or importedKeySetDefault)
FK_NAME - The name of the foreign key.
PK_NAME - The name of the primary key.
DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
Returns:
A ResultSet with the requested information
Throws:
SQLException - If an error occurs.

getExtraNameCharacters

public String getExtraNameCharacters()
            throws SQLException

This methods returns non-standard characters that can appear in unquoted identifiers.
Returns:
Non-standard characters that can appear in unquoted identifiers.
Throws:
SQLException - If an error occurs.

getIdentifierQuoteString

public String getIdentifierQuoteString()
            throws SQLException

This metohd returns the quote string for SQL identifiers.
Returns:
The quote string for SQL identifers, or a space if quoting is not supported.
Throws:
SQLException - If an error occurs.

getImportedKeys

public ResultSet getImportedKeys(String catalog,
                                 String schema,
                                 String table)
            throws SQLException

This method returns a list of the table's foreign keys. These are returned as a ResultSet with the following columns:
PKTABLE_CAT - The catalog of the table the key was imported from.
PKTABLE_SCHEM - The schema of the table the key was imported from.
PKTABLE_NAME - The name of the table the key was imported from.
PKCOLUMN_NAME - The name of the column that was imported.
FKTABLE_CAT - The foreign key catalog name.
FKTABLE_SCHEM - The foreign key schema name.
FKTABLE_NAME - The foreign key table name.
FKCOLUMN_NAME - The foreign key column name.
KEY_SEQ - The sequence number of the column within the foreign key.
UPDATE_RULE - How the foreign key behaves when the primary key is updated. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, importedKeySetDefault, or importedKeyRestrict).
DELETE_RULE - How the foreign key behaves when the primary key is deleted. This is one of the constants defined in this class (importedNoAction, importedKeyCascade, importedKeySetNull, or importedKeySetDefault)
FK_NAME - The name of the foreign key.
PK_NAME - The name of the primary key.
DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
Returns:
A ResultSet with the foreign key columns.
Throws:
SQLException - If an error occurs.

getIndexInfo

public ResultSet getIndexInfo(String catalog,
                              String schema,
                              String table,
                              boolean unique,
                              boolean approximate)
            throws SQLException

This method returns information about a tables indices and statistics. It is returned as a ResultSet with the following columns:
TABLE_CAT - The catalog of the table, which may be null.
TABLE_SCHEM - The schema of the table, which may be null.
TABLE_NAME - The name of the table.
NON_UNIQUE - Are index values non-unique?
INDEX_QUALIFIER The index catalog, which may be null
INDEX_NAME - The name of the index.
TYPE - The type of index, which will be one of the constants defined in this interface (tableIndexStatistic, tableIndexClustered, tableIndexHashed, or tableIndexOther).
ORDINAL_POSITION - The sequence number of this column in the index. This will be 0 when the index type is tableIndexStatistic.
COLUMN_NAME - The name of this column in the index.
ASC_OR_DESC - "A" for an ascending sort sequence, "D" for a descending sort sequence or null if a sort sequence is not supported.
CARDINALITY - The number of unique rows in the index, or the number of rows in the table if the index type is tableIndexStatistic.
PAGES - The number of pages used for the index, or the number of pages in the table if the index type is tableIndexStatistic.
FILTER_CONDITION - The filter condition for this index, which may be null.

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
unique - true to return only unique indexes, false otherwise.
Returns:
A ResultSet with the requested index information
Throws:
SQLException - If an error occurs.

getJDBCMajorVersion

public int getJDBCMajorVersion()
            throws SQLException

Since:
1.4

getJDBCMinorVersion

public int getJDBCMinorVersion()
            throws SQLException

Since:
1.4

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()
            throws SQLException

This method returns the number of hex characters allowed in an inline binary literal.
Returns:
The number of hex characters allowed in a binary literal, 0 meaning either an unknown or unlimited number.
Throws:
SQLException - If an error occurs.

getMaxCatalogNameLength

public int getMaxCatalogNameLength()
            throws SQLException

This method returns the maximum length of a catalog name.
Returns:
The maximum length of a catalog name.
Throws:
SQLException - If an error occurs.

getMaxCharLiteralLength

public int getMaxCharLiteralLength()
            throws SQLException

This method returns the maximum length of a character literal.
Returns:
The maximum length of a character literal.
Throws:
SQLException - If an error occurs.

getMaxColumnNameLength

public int getMaxColumnNameLength()
            throws SQLException

This method returns the maximum length of a column name.
Returns:
The maximum length of a column name.
Throws:
SQLException - If an error occurs.

getMaxColumnsInGroupBy

public int getMaxColumnsInGroupBy()
            throws SQLException

This method returns the maximum number of columns in a GROUP BY statement.
Returns:
The maximum number of columns in a GROUP BY statement.
Throws:
SQLException - If an error occurs.

getMaxColumnsInIndex

public int getMaxColumnsInIndex()
            throws SQLException

This method returns the maximum number of columns in an index.
Returns:
The maximum number of columns in an index.
Throws:
SQLException - If an error occurs.

getMaxColumnsInOrderBy

public int getMaxColumnsInOrderBy()
            throws SQLException

This method returns the maximum number of columns in an ORDER BY statement.
Returns:
The maximum number of columns in an ORDER BY statement.
Throws:
SQLException - If an error occurs.

getMaxColumnsInSelect

public int getMaxColumnsInSelect()
            throws SQLException

This method returns the maximum number of columns in a SELECT statement.
Returns:
The maximum number of columns in a SELECT statement.
Throws:
SQLException - If an error occurs.

getMaxColumnsInTable

public int getMaxColumnsInTable()
            throws SQLException

This method returns the maximum number of columns in a table.
Returns:
The maximum number of columns in a table.
Throws:
SQLException - If an error occurs.

getMaxConnections

public int getMaxConnections()
            throws SQLException

This method returns the maximum number of connections this client can have to the database.
Returns:
The maximum number of database connections.

getMaxCursorNameLength

public int getMaxCursorNameLength()
            throws SQLException

This method returns the maximum length of a cursor name.
Returns:
The maximum length of a cursor name.
Throws:
SQLException - If an error occurs.

getMaxIndexLength

public int getMaxIndexLength()
            throws SQLException

This method returns the maximum length of an index.
Returns:
The maximum length of an index.
Throws:
SQLException - If an error occurs.

getMaxProcedureNameLength

public int getMaxProcedureNameLength()
            throws SQLException

This method returns the maximum length of a procedure name.
Returns:
The maximum length of a procedure name.
Throws:
SQLException - If an error occurs.

getMaxRowSize

public int getMaxRowSize()
            throws SQLException

This method returns the maximum size of a row in bytes.
Returns:
The maximum size of a row.
Throws:
SQLException - If an error occurs.

getMaxSchemaNameLength

public int getMaxSchemaNameLength()
            throws SQLException

This method returns the maximum length of a schema name.
Returns:
The maximum length of a schema name.
Throws:
SQLException - If an error occurs.

getMaxStatementLength

public int getMaxStatementLength()
            throws SQLException

This method includes the maximum length of a SQL statement.
Returns:
The maximum length of a SQL statement.
Throws:
SQLException - If an error occurs.

getMaxStatements

public int getMaxStatements()
            throws SQLException

This method returns the maximum number of statements that can be active at any time.
Returns:
The maximum number of statements that can be active at any time.
Throws:
SQLException - If an error occurs.

getMaxTableNameLength

public int getMaxTableNameLength()
            throws SQLException

This method returns the maximum length of a table name.
Returns:
The maximum length of a table name.
Throws:
SQLException - If an error occurs.

getMaxTablesInSelect

public int getMaxTablesInSelect()
            throws SQLException

This method returns the maximum number of tables that may be referenced in a SELECT statement.
Returns:
The maximum number of tables allowed in a SELECT statement.
Throws:
SQLException - If an error occurs.

getMaxUserNameLength

public int getMaxUserNameLength()
            throws SQLException

This method returns the maximum length of a user name.
Returns:
The maximum length of a user name.
Throws:
SQLException - If an error occurs.

getNumericFunctions

public String getNumericFunctions()
            throws SQLException

This method returns a comma separated list of math functions.
Returns:
The list of math functions.
Throws:
SQLException - If an error occurs.

getPrimaryKeys

public ResultSet getPrimaryKeys(String catalog,
                                String schema,
                                String table)
            throws SQLException

This method returns a list of a table's primary key columns. These are returned as a ResultSet with the following columns.
TABLE_CAT - The catalog of the table, which may be null.
TABLE_SCHEM - The schema of the table, which may be null.
TABLE_NAME - The name of the table.
COLUMN_NAME - The name of the column.
KEY_SEQ - The sequence number of the column within the primary key.
PK_NAME - The name of the primary key, which may be null.

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
Returns:
A ResultSet with the primary key columns.
Throws:
SQLException - If an error occurs.

getProcedureColumns

public ResultSet getProcedureColumns(String catalog,
                                     String schemaPattern,
                                     String procedureNamePattern,
                                     String columnNamePattern)
            throws SQLException

This method returns a list of the parameter and result columns for the requested stored procedures. This is returned in the form of a ResultSet with the following columns:

PROCEDURE_CAT - The catalog the procedure is in, which may be null.
PROCEDURE_SCHEM - The schema the procedures is in, which may be null.
PROCEDURE_NAME - The name of the procedure.
COLUMN_NAME - The name of the column
COLUMN_TYPE - The type of the column, which will be one of the contants defined in this class (procedureColumnUnknown, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnReturn, or procedureColumnResult).
DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
TYPE_NAME - The string name of the data type for this column.
PRECISION - The precision of the column.
LENGTH - The length of the column in bytes
SCALE - The scale of the column.
RADIX - The radix of the column.
NULLABLE - Whether or not the column is NULLABLE. This is one of the constants defined in this class (procedureNoNulls, procedureNullable, or procedureNullableUnknown)
REMARKS - A description of the column.

Parameters:
catalog - The name of the catalog to return stored procedured from, or "" to return procedures from all catalogs.
schemaPattern - A schema pattern for the schemas to return stored procedures from, or "" to return procedures from all schemas.
Throws:
SQLException - If an error occurs.

getProcedureTerm

public String getProcedureTerm()
            throws SQLException

This method returns the vendor's term for "procedure".
Returns:
The vendor's term for procedure.
Throws:
SQLException - if an error occurs.

getProcedures

public ResultSet getProcedures(String catalog,
                               String schemaPattern,
                               String procedureNamePattern)
            throws SQLException

This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog. This is returned a ResultSet with the following columns:

PROCEDURE_CAT - The catalog the procedure is in, which may be null.
PROCEDURE_SCHEM - The schema the procedures is in, which may be null.
PROCEDURE_NAME - The name of the procedure.
Unused
Unused
Unused
REMARKS - A description of the procedure
PROCEDURE_TYPE - Indicates the return type of the procedure, which is one of the contstants defined in this class (procedureResultUnknown, procedureNoResult, or procedureReturnsResult).

Parameters:
catalog - The name of the catalog to return stored procedured from, or "" to return procedures from all catalogs.
schemaPattern - A schema pattern for the schemas to return stored procedures from, or "" to return procedures from all schemas.
Throws:
SQLException - If an error occurs.

getResultSetHoldability

public int getResultSetHoldability()
            throws SQLException

Since:
1.4

getSQLKeywords

public String getSQLKeywords()
            throws SQLException

This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.
Returns:
The list of SQL keywords not in SQL92.
Throws:
SQLException - If an error occurs.

getSQLStateType

public int getSQLStateType()
            throws SQLException

Since:
1.4

getSchemaTerm

public String getSchemaTerm()
            throws SQLException

This method returns the vendor's term for "schema".
Returns:
The vendor's term for schema.
Throws:
SQLException - if an error occurs.

getSchemas

public ResultSet getSchemas()
            throws SQLException

This method returns the list of database schemas as a ResultSet, with one column - TABLE_SCHEM - that is the name of the schema.
Returns:
A ResultSet with all the requested schemas.
Throws:
SQLException - If an error occurs.

getSearchStringEscape

public String getSearchStringEscape()
            throws SQLException

This method returns the string used to escape wildcards in search strings.
Returns:
The string used to escape wildcards in search strings.
Throws:
SQLException - If an error occurs.

getStringFunctions

public String getStringFunctions()
            throws SQLException

This method returns a comma separated list of string functions.
Returns:
The list of string functions.
Throws:
SQLException - If an error occurs.

getSuperTables

public ResultSet getSuperTables(String catalog,
                                String schemaPattern,
                                String tableNamePattern)
            throws SQLException

Since:
1.4

getSuperTypes

public ResultSet getSuperTypes(String catalog,
                               String schemaPattern,
                               String typeNamePattern)
            throws SQLException

Since:
1.4

getSystemFunctions

public String getSystemFunctions()
            throws SQLException

This method returns a comma separated list of of system functions.
Returns:
A comma separated list of system functions.
Throws:
SQLException - If an error occurs.

getTablePrivileges

public ResultSet getTablePrivileges(String catalog,
                                    String schemaPattern,
                                    String tableNamePattern)
            throws SQLException

This method returns the access rights that have been granted to the requested tables. This information is returned as a ResultSet with the following columns:
TABLE_CAT - The catalog the table is in, which may be null.
TABLE_SCHEM - The schema the tables is in, which may be null.
TABLE_NAME - The name of the table.
GRANTOR - The entity that granted the access.
GRANTEE - The entity granted the access.
PRIVILEGE - The name of the privilege granted.
IS_GRANTABLE - "YES" if the grantee can grant the privilege to others, "NO" if not, and null if unknown.

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
Returns:
A ResultSet with all the requested privileges.
Throws:
SQLException - If an error occurs.

getTableTypes

public ResultSet getTableTypes()
            throws SQLException

This method returns the list of database table types as a ResultSet with one column - TABLE_TYPE - that is the name of the table type.
Returns:
A ResultSet with all the requested table types.
Throws:
SQLException - If an error occurs.

getTables

public ResultSet getTables(String catalog,
                           String schemaPattern,
                           String tableNamePattern,
                           String[] types)
            throws SQLException

This method returns a list of the requested table as a ResultSet with the following columns:
TABLE_CAT - The catalog the table is in, which may be null.
TABLE_SCHEM - The schema the table is in, which may be null.
TABLE_NAME - The name of the table.
TABLE_TYPE - A string describing the table type. This will be one of the values returned by the getTableTypes() method.
REMARKS - Comments about the table.

Parameters:
catalog - The name of the catalog to return tables from, or "" to return tables from all catalogs.
schemaPattern - A schema pattern for the schemas to return tables from, or "" to return tables from all schemas.
types - The list of table types to include; null returns all types.
Throws:
SQLException - If an error occurs.

getTimeDateFunctions

public String getTimeDateFunctions()
            throws SQLException

This method returns comma separated list of time/date functions.
Returns:
The list of time/date functions.
Throws:
SQLException - If an error occurs.

getTypeInfo

public ResultSet getTypeInfo()
            throws SQLException

This method returns a list of the SQL types supported by this database. The information is returned as a ResultSet with the following columns:
TYPE_NAME - The name of the data type.
DATA_TYPE - A data type constant from Types for this type.
PRECISION - The maximum precision of this type.
LITERAL_PREFIX - Prefix value used to quote a literal, which may be null.
LITERAL_SUFFIX - Suffix value used to quote a literal, which may be null.
CREATE_PARAMS - The parameters used to create the type, which may be null.
NULLABLE - Whether or not this type supports NULL values. This will be one of the constants defined in this interface (typeNoNulls, typeNullable, or typeNullableUnknown).
CASE_SENSITIVE - Whether or not the value is case sensitive.
SEARCHABLE - Whether or not "LIKE" expressions are supported in WHERE clauses for this type. This will be one of the constants defined in this interface (typePredNone, typePredChar, typePredBasic, or typeSearchable).
UNSIGNED_ATTRIBUTE - Is the value of this type unsigned.
FIXED_PREC_SCALE - Whether or not this type can be used for money.
AUTO_INCREMENT - Whether or not this type supports auto-incrementing.
LOCAL_TYPE_NAME - A localized name for this data type.
MINIMUM_SCALE - The minimum scale supported by this type.
MAXIMUM_SCALE - The maximum scale supported by this type.
SQL_DATA_TYPE - Unused.
SQL_DATETIME_SUB - Unused.
NUM_PREC_RADIX - The radix of this data type.

Returns:
A ResultSet with the list of available data types.
Throws:
SQLException - If an error occurs.

getUDTs

public ResultSet getUDTs(String catalog,
                         String schemaPattern,
                         String typeNamePattern,
                         int[] types)
            throws SQLException

This method returns the list of user defined data types in use. These are returned as a ResultSet with the following columns:
TYPE_CAT - The catalog name, which may be null.
TYPE_SCEHM - The schema name, which may be null.
TYPE_NAME - The user defined data type name.
CLASS_NAME - The Java class name this type maps to.
DATA_TYPE - A type identifier from Types for this type. This will be one of JAVA_OBJECT, STRUCT, or DISTINCT.
REMARKS - Comments about this data type.

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
types - The type identifier patterns (from Types) to match.
Returns:
A ResultSet with the requested type information
Throws:
SQLException - If an error occurs.

getURL

public String getURL()
            throws SQLException

This method returns the URL for this database.
Returns:
The URL string for this database, or null if it is not known.
Throws:
SQLException - If an error occurs.

getUserName

public String getUserName()
            throws SQLException

This method returns the database username for this connection.
Returns:
The database username.
Throws:
SQLException - If an error occurs.

getVersionColumns

public ResultSet getVersionColumns(String catalog,
                                   String schema,
                                   String table)
            throws SQLException

This method returns the set of columns that are automatically updated when the row is update. It returns this information as a ResultSet with the following columns:
SCOPE - Unused
COLUMN_NAME - The name of the column.
DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
TYPE_NAME - The string name of the data type for this column.
COLUMN_SIZE - The precision of the columns
BUFFER_LENGTH - Unused
DECIMAL_DIGITS - The scale of the column.
PSEUDO_COLUMN - Whether or not the best row identifier is a pseudo_column. This is one of the constants defined in this class (versionRowUnknown, versionRowNotPseudo, or versionRowPseudo).

Parameters:
catalog - The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, or null to return information from all catalogs.
schema - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
table - The table name to return information for.
Returns:
A ResultSet with the version columns.
Throws:
SQLException - If an error occurs.

insertsAreDetected

public boolean insertsAreDetected(int type)
            throws SQLException

This method tests whether or not the specified result set type can detect a visible insert by calling the rowUpdated method.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type can detect visible inserts using rowUpdated, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

isCatalogAtStart

public boolean isCatalogAtStart()
            throws SQLException

This method tests whether a catalog name appears at the beginning of a fully qualified table name.
Returns:
true if the catalog name appears at the beginning, false if it appears at the end.
Throws:
SQLException - If an error occurs.

isReadOnly

public boolean isReadOnly()
            throws SQLException

This method tests whether or not the database is in read only mode.
Returns:
true if the database is in read only mode, false otherwise.
Throws:
SQLException - If an error occurs.

locatorsUpdateCopy

public boolean locatorsUpdateCopy()
            throws SQLException

Since:
1.4

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()
            throws SQLException

This method tests whether the concatenation of a NULL and non-NULL value results in a NULL. This will always be true in fully JDBC compliant drivers.
Returns:
true if concatenating NULL and a non-NULL value returns a NULL, false otherwise.
Throws:
SQLException - If an error occurs.

nullsAreSortedAtEnd

public boolean nullsAreSortedAtEnd()
            throws SQLException

This method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order.
Returns:
true if NULL's always sort to the end, false otherwise.
Throws:
SQLException - If an error occurs.

nullsAreSortedAtStart

public boolean nullsAreSortedAtStart()
            throws SQLException

This method tests whether or not NULL's sort as high values.
Returns:
true if NULL's sort as high values, false otherwise.
Throws:
SQLException - If an error occurs.

nullsAreSortedHigh

public boolean nullsAreSortedHigh()
            throws SQLException

This method tests whether or not NULL's sort as high values.
Returns:
true if NULL's sort as high values, false otherwise.
Throws:
SQLException - If an error occurs.

nullsAreSortedLow

public boolean nullsAreSortedLow()
            throws SQLException

This method tests whether or not NULL's sort as low values.
Returns:
true if NULL's sort as low values, false otherwise.
Throws:
SQLException - If an error occurs.

othersDeletesAreVisible

public boolean othersDeletesAreVisible(int type)
            throws SQLException

This method tests whether or not the specified result set type sees deletes committed by others.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type sees other deletes, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

othersInsertsAreVisible

public boolean othersInsertsAreVisible(int type)
            throws SQLException

This method tests whether or not the specified result set type sees inserts committed by others.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type sees other inserts, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

othersUpdatesAreVisible

public boolean othersUpdatesAreVisible(int type)
            throws SQLException

This method tests whether or not the specified result set type sees updates committed by others.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type sees other updates, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

ownDeletesAreVisible

public boolean ownDeletesAreVisible(int type)
            throws SQLException

This method tests whether or not the specified result set type sees its own deletes.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type sees its own deletes, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

ownInsertsAreVisible

public boolean ownInsertsAreVisible(int type)
            throws SQLException

This method tests whether or not the specified result set type sees its own inserts.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type sees its own inserts, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

ownUpdatesAreVisible

public boolean ownUpdatesAreVisible(int type)
            throws SQLException

This method tests whether or not the specified result set type sees its own updates.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type sees its own updates, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()
            throws SQLException

This method tests whether or not the database treats mixed case identifiers as all lower case.
Returns:
true if the database treats all identifiers as lower case, false otherwise.
Throws:
SQLException - If an error occurs.

storesLowerCaseQuotedIdentifiers

public boolean storesLowerCaseQuotedIdentifiers()
            throws SQLException

This method tests whether or not the database treats mixed case quoted identifiers as all lower case.
Returns:
true if the database treats all quoted identifiers as lower case, false otherwise.
Throws:
SQLException - If an error occurs.

storesMixedCaseIdentifiers

public boolean storesMixedCaseIdentifiers()
            throws SQLException

This method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive.
Returns:
true if the database stores mixed case identifiers, false otherwise.
Throws:
SQLException - If an error occurs.

storesMixedCaseQuotedIdentifiers

public boolean storesMixedCaseQuotedIdentifiers()
            throws SQLException

This method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive.
Returns:
true if the database stores mixed case quoted identifiers, false otherwise.
Throws:
SQLException - If an error occurs.

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()
            throws SQLException

This method tests whether or not the database treats mixed case identifiers as all upper case.
Returns:
true if the database treats all identifiers as upper case, false otherwise.
Throws:
SQLException - If an error occurs.

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()
            throws SQLException

This method tests whether or not the database treats mixed case quoted identifiers as all upper case.
Returns:
true if the database treats all quoted identifiers as upper case, false otherwise.
Throws:
SQLException - If an error occurs.

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()
            throws SQLException

This method tests whether or not the ANSI92 entry level SQL grammar is supported. A fully JDBC compliant drivers must return true.
Returns:
true if the ANSI92 entry level SQL grammar is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()
            throws SQLException

This method tests whether or not the ANSI92 full SQL grammar is supported.
Returns:
true if the ANSI92 full SQL grammar is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsANSI92IntermediateSQL

public boolean supportsANSI92IntermediateSQL()
            throws SQLException

This method tests whether or not the ANSI92 intermediate SQL grammar is supported.
Returns:
true if the ANSI92 intermediate SQL grammar is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()
            throws SQLException

This method tests whether or not the database supports "ALTER TABLE ADD COLUMN"
Returns:
true if column add supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsAlterTableWithDropColumn

public boolean supportsAlterTableWithDropColumn()
            throws SQLException

This method tests whether or not the database supports "ALTER TABLE DROP COLUMN"
Returns:
true if column drop supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsBatchUpdates

public boolean supportsBatchUpdates()
            throws SQLException

This method tests whether or not the database supports batch updates.
Returns:
true if batch updates are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsCatalogsInDataManipulation

public boolean supportsCatalogsInDataManipulation()
            throws SQLException

This method tests whether a catalog name can appear in a data manipulation statement.
Returns:
true if a catalog name can appear in a data manipulation statement, false otherwise.
Throws:
SQLException - If an error occurs.

supportsCatalogsInIndexDefinitions

public boolean supportsCatalogsInIndexDefinitions()
            throws SQLException

This method tests whether a catalog name can appear in an index definition.
Returns:
true if a catalog name can appear in an index definition, false otherwise.
Throws:
SQLException - If an error occurs.

supportsCatalogsInPrivilegeDefinitions

public boolean supportsCatalogsInPrivilegeDefinitions()
            throws SQLException

This method tests whether a catalog name can appear in privilege definitions.
Returns:
true if a catalog name can appear in privilege definition, false otherwise.
Throws:
SQLException - If an error occurs.

supportsCatalogsInProcedureCalls

public boolean supportsCatalogsInProcedureCalls()
            throws SQLException

This method tests whether a catalog name can appear in a procedure call
Returns:
true if a catalog name can appear in a procedure call, false otherwise.
Throws:
SQLException - If an error occurs.

supportsCatalogsInTableDefinitions

public boolean supportsCatalogsInTableDefinitions()
            throws SQLException

This method tests whether a catalog name can appear in a table definition.
Returns:
true if a catalog name can appear in a table definition, false otherwise.
Throws:
SQLException - If an error occurs.

supportsColumnAliasing

public boolean supportsColumnAliasing()
            throws SQLException

This method tests whether or not column aliasing is supported.
Returns:
true if column aliasing is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsConvert

public boolean supportsConvert()
            throws SQLException

Tests whether or not CONVERT is supported.
Returns:
true if CONVERT is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsConvert

public boolean supportsConvert(int fromType,
                               int toType)
            throws SQLException

This method tests whether or not CONVERT can be performed between the specified types. The types are contants from Types.
Parameters:
fromType - The SQL type to convert from.
toType - The SQL type to convert to.
Returns:
true if the conversion can be performed, false otherwise.
See Also:
Types

supportsCoreSQLGrammar

public boolean supportsCoreSQLGrammar()
            throws SQLException

This method tests whether or not the core grammer for ODBC is supported.
Returns:
true if the ODBC core grammar is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()
            throws SQLException

This method test whether or not correlated subqueries are allowed. A fully JDBC compliant driver will always return true.
Returns:
true if correlated subqueries are allowed, false otherwise.
Throws:
SQLException - If an error occurs.

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()
            throws SQLException

This method tests whether or not DDL and DML statements allowed within the same transaction.
Returns:
true if DDL and DML statements are allowed in the same transaction, false otherwise.
Throws:
SQLException - If an error occurs.

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()
            throws SQLException

This method tests whether or not only DML statement are allowed inside a transaction.
Returns:
true if only DML statements are allowed in transactions, false otherwise.
Throws:
SQLException - If an error occurs.

supportsDifferentTableCorrelationNames

public boolean supportsDifferentTableCorrelationNames()
            throws SQLException

This method tests whether correlation names must be different from the name of the table.
Returns:
true if the correlation name must be different from the table name, false otherwise.
Throws:
SQLException - If an error occurs.

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()
            throws SQLException

This method tests whether or not expressions are allowed in an ORDER BY lists.
Returns:
true if expressions are allowed in ORDER BY lists, false otherwise.
Throws:
SQLException - If an error occurs.

supportsExtendedSQLGrammar

public boolean supportsExtendedSQLGrammar()
            throws SQLException

This method tests whether or not the extended grammer for ODBC is supported.
Returns:
true if the ODBC extended grammar is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
            throws SQLException

This method tests whether or not the database supports full outer joins.
Returns:
true if full outer joins are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()
            throws SQLException

Since:
1.4

supportsGroupBy

public boolean supportsGroupBy()
            throws SQLException

This method tests whether or not GROUP BY is supported.
Returns:
true if GROUP BY is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsGroupByBeyondSelect

public boolean supportsGroupByBeyondSelect()
            throws SQLException

This method tests whether or not a GROUP BY can add columns not in the select if it includes all the columns in the select.
Returns:
true if GROUP BY an add columns provided it includes all columns in the select, false otherwise.
Throws:
SQLException - If an error occurs.

supportsGroupByUnrelated

public boolean supportsGroupByUnrelated()
            throws SQLException

This method tests whether GROUP BY on a non-selected column is allowed.
Returns:
true if a non-selected column can be used in a GROUP BY, false otherwise.
Throws:
SQLException - If an error occurs.

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()
            throws SQLException

This method tests whether or not the SQL integrity enhancement facility is supported.
Returns:
true if the integrity enhancement facility is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()
            throws SQLException

This method tests whether or not the escape character is supported in LIKE expressions. A fully JDBC compliant driver will always return true.
Returns:
true if escapes are supported in LIKE expressions, false otherwise.
Throws:
SQLException - If an error occurs.

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()
            throws SQLException

This method tests whether or not the database supports limited outer joins.
Returns:
true if limited outer joins are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsMinimumSQLGrammar

public boolean supportsMinimumSQLGrammar()
            throws SQLException

This method tests whether or not the minimum grammer for ODBC is supported. A fully JDBC compliant driver will always return true.
Returns:
true if the ODBC minimum grammar is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsMixedCaseIdentifiers

public boolean supportsMixedCaseIdentifiers()
            throws SQLException

This method tests whether or not the database supports identifiers with mixed case.
Returns:
true if the database supports mixed case identifiers, false otherwise.
Throws:
SQLException - If an error occurs.

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()
            throws SQLException

This method tests whether or not the database supports quoted identifiers with mixed case.
Returns:
true if the database supports mixed case quoted identifiers, false otherwise.
Throws:
SQLException - If an error occurs.

supportsMultipleOpenResults

public boolean supportsMultipleOpenResults()
            throws SQLException

Since:
1.4

supportsMultipleResultSets

public boolean supportsMultipleResultSets()
            throws SQLException

This method tests whether multiple result sets for a single statement are supported.
Returns:
true if multiple result sets are supported for a single statement, false otherwise.
Throws:
SQLException - If an error occurs.

supportsMultipleTransactions

public boolean supportsMultipleTransactions()
            throws SQLException

This method test whether or not multiple transactions may be open at once, as long as they are on different connections.
Returns:
true if multiple transactions on different connections are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsNamedParameters

public boolean supportsNamedParameters()
            throws SQLException

Since:
1.4

supportsNonNullableColumns

public boolean supportsNonNullableColumns()
            throws SQLException

This method tests whether or not columns can be defined as NOT NULL. A fully JDBC compliant driver always returns true.
Returns:
true if NOT NULL columns are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()
            throws SQLException

This method tests whether or not the database supports cursors remaining open across commits.
Returns:
true if cursors can remain open across commits, false otherwise.
Throws:
SQLException - If an error occurs.

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()
            throws SQLException

This method tests whether or not the database supports cursors remaining open across rollbacks.
Returns:
true if cursors can remain open across rollbacks, false otherwise.
Throws:
SQLException - If an error occurs.

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()
            throws SQLException

This method tests whether or not the database supports statements remaining open across commits.
Returns:
true if statements can remain open across commits, false otherwise.
Throws:
SQLException - If an error occurs.

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()
            throws SQLException

This method tests whether or not the database supports statements remaining open across rollbacks.
Returns:
true if statements can remain open across rollbacks, false otherwise.
Throws:
SQLException - If an error occurs.

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()
            throws SQLException

This method tests whether or ORDER BY on a non-selected column is allowed.
Returns:
true if a non-selected column can be used in an ORDER BY, false otherwise.
Throws:
SQLException - If an error occurs.

supportsOuterJoins

public boolean supportsOuterJoins()
            throws SQLException

This method tests whether or not the database supports outer joins.
Returns:
true if outer joins are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsPositionedDelete

public boolean supportsPositionedDelete()
            throws SQLException

This method tests whether or not that database supports positioned deletes.
Returns:
true if positioned deletes are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsPositionedUpdate

public boolean supportsPositionedUpdate()
            throws SQLException

This method tests whether or not that database supports positioned updates.
Returns:
true if positioned updates are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsResultSetConcurrency

public boolean supportsResultSetConcurrency(int type,
                                            int concurrency)
            throws SQLException

This method tests whether the specified result set type and result set concurrency type are supported by the database.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type is supported, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

supportsResultSetHoldability

public boolean supportsResultSetHoldability(int holdability)
            throws SQLException

Since:
1.4

supportsResultSetType

public boolean supportsResultSetType(int type)
            throws SQLException

This method tests whether or not the datbase supports the specified result type.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type is supported, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

supportsSavepoints

public boolean supportsSavepoints()
            throws SQLException

Since:
1.4

supportsSchemasInDataManipulation

public boolean supportsSchemasInDataManipulation()
            throws SQLException

This method tests whether a catalog name can appear in a data manipulation statement.
Returns:
true if a catalog name can appear in a data manipulation statement, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSchemasInIndexDefinitions

public boolean supportsSchemasInIndexDefinitions()
            throws SQLException

This method tests whether a catalog name can appear in an index definition.
Returns:
true if a catalog name can appear in an index definition, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSchemasInPrivilegeDefinitions

public boolean supportsSchemasInPrivilegeDefinitions()
            throws SQLException

This method tests whether a catalog name can appear in privilege definitions.
Returns:
true if a catalog name can appear in privilege definition, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSchemasInProcedureCalls

public boolean supportsSchemasInProcedureCalls()
            throws SQLException

This method tests whether a catalog name can appear in a procedure call
Returns:
true if a catalog name can appear in a procedure call, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSchemasInTableDefinitions

public boolean supportsSchemasInTableDefinitions()
            throws SQLException

This method tests whether a catalog name can appear in a table definition.
Returns:
true if a catalog name can appear in a table definition, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSelectForUpdate

public boolean supportsSelectForUpdate()
            throws SQLException

This method tests whether or not SELECT FOR UPDATE is supported by the database.
Returns:
true if SELECT FOR UPDATE is supported false otherwise.
Throws:
SQLException - If an error occurs.

supportsStatementPooling

public boolean supportsStatementPooling()
            throws SQLException

Since:
1.4

supportsStoredProcedures

public boolean supportsStoredProcedures()
            throws SQLException

This method tests whether or not stored procedures are supported on this database.
Returns:
true if stored procedures are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()
            throws SQLException

This method tests whether or not subqueries are allowed in comparisons. A fully JDBC compliant driver will always return true.
Returns:
true if subqueries are allowed in comparisons, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSubqueriesInExists

public boolean supportsSubqueriesInExists()
            throws SQLException

This method tests whether or not subqueries are allowed in exists expressions. A fully JDBC compliant driver will always return true.
Returns:
true if subqueries are allowed in exists expressions, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSubqueriesInIns

public boolean supportsSubqueriesInIns()
            throws SQLException

This method tests whether subqueries are allowed in IN statements. A fully JDBC compliant driver will always return true.
Returns:
true if the driver supports subqueries in IN statements, false otherwise.
Throws:
SQLException - If an error occurs.

supportsSubqueriesInQuantifieds

public boolean supportsSubqueriesInQuantifieds()
            throws SQLException

This method tests whether or not subqueries are allowed in quantified expressions. A fully JDBC compliant driver will always return true.
Returns:
true if subqueries are allowed in quantified expressions, false otherwise.
Throws:
SQLException - If an error occurs.

supportsTableCorrelationNames

public boolean supportsTableCorrelationNames()
            throws SQLException

This method tests whether or not table correlation names are supported. This will be always be true in a fully JDBC compliant driver.
Returns:
true if table correlation names are supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsTransactionIsolationLevel

public boolean supportsTransactionIsolationLevel(int level)
            throws SQLException

This method tests whether or not the database supports the specified transaction isolation level.
Parameters:
level - The transaction isolation level.
Returns:
true if the specified transaction isolation level is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsTransactions

public boolean supportsTransactions()
            throws SQLException

This method tests whether or not the database supports transactions.
Returns:
true if the database supports transactions, false otherwise.
Throws:
SQLException - If an error occurs.

supportsUnion

public boolean supportsUnion()
            throws SQLException

This method tests whether or not the UNION statement is supported.
Returns:
true if UNION is supported, false otherwise.
Throws:
SQLException - If an error occurs.

supportsUnionAll

public boolean supportsUnionAll()
            throws SQLException

This method tests whether or not the UNION ALL statement is supported.
Returns:
true if UNION ALL is supported, false otherwise.
Throws:
SQLException - If an error occurs.

updatesAreDetected

public boolean updatesAreDetected(int type)
            throws SQLException

This method tests whether or not the specified result set type can detect a visible update by calling the rowUpdated method.
Parameters:
type - The desired result type, which is one of the constants defined in ResultSet.
Returns:
true if the result set type can detect visible updates using rowUpdated, false otherwise.
Throws:
SQLException - If an error occurs.
See Also:
ResultSet

usesLocalFilePerTable

public boolean usesLocalFilePerTable()
            throws SQLException

This method tests whether or not the database uses a separate file for each table.
Returns:
true if the database uses a separate file for each table false otherwise.
Throws:
SQLException - If an error occurs.

usesLocalFiles

public boolean usesLocalFiles()
            throws SQLException

This method tests whether or not the database uses local files to store tables.
Returns:
true if the database uses local files, false otherwise.
Throws:
SQLException - If an error occurs.

DatabaseMetaData.java -- Information about the database itself. Copyright (C) 1999, 2000, 2001, 2002 Free Software Foundation, Inc. This file is part of GNU Classpath. GNU Classpath is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2, or (at your option) any later version. GNU Classpath is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with GNU Classpath; see the file COPYING. If not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. Linking this library statically or dynamically with other modules is making a combined work based on this library. Thus, the terms and conditions of the GNU General Public License cover the whole combination. As a special exception, the copyright holders of this library give you permission to link this library with independent modules to produce an executable, regardless of the license terms of these independent modules, and to copy and distribute the resulting executable under terms of your choice, provided that you also meet, for each linked independent module, the terms and conditions of the license of that module. An independent module is a module which is not derived from or based on this library. If you modify this library, you may extend this exception to your version of the library, but you are not obligated to do so. If you do not wish to do so, delete this exception statement from your version.

Overview Package Class Source Tree Index Deprecated About
Prev Class \| Next Class	Frames \| No Frames
Summary: Nested \| Field \| Method \| Constr	Detail: Nested \| Field \| Method \| Constr

java.sql

Interface DatabaseMetaData

Field Summary

Method Summary

Field Details

attributeNoNulls

attributeNullable

attributeNullableUnknown

bestRowNotPseudo

bestRowPseudo

bestRowSession

bestRowTemporary

bestRowTransaction

bestRowUnknown

columnNoNulls

columnNullable

columnNullableUnknown

importedKeyCascade

importedKeyInitiallyDeferred

importedKeyInitiallyImmediate

importedKeyNoAction

importedKeyNotDeferrable

importedKeyRestrict

importedKeySetDefault

importedKeySetNull

procedureColumnIn

procedureColumnInOut

procedureColumnOut

procedureColumnResult

procedureColumnReturn

procedureColumnUnknown

procedureNoNulls

procedureNoResult

procedureNullable

procedureNullableUnknown

procedureResultUnknown

procedureReturnsResult

sqlStateSQL99

sqlStateXOpen

tableIndexClustered

tableIndexHashed

tableIndexOther

tableIndexStatistic

typeNoNulls

typeNullable

typeNullableUnknown

typePredBasic

typePredChar

typePredNone

typeSearchable

versionColumnNotPseudo

versionColumnPseudo

versionColumnUnknown

Method Details

allProceduresAreCallable

allTablesAreSelectable

dataDefinitionCausesTransactionCommit

dataDefinitionIgnoredInTransactions

deletesAreDetected

doesMaxRowSizeIncludeBlobs

getAttributes

getBestRowIdentifier

getCatalogSeparator

getCatalogTerm

getCatalogs

getColumnPrivileges

getColumns

getConnection

getCrossReference

getDatabaseMajorVersion

getDatabaseMinorVersion

getDatabaseProductName

getDatabaseProductVersion

getDefaultTransactionIsolation

getDriverMajorVersion

getDriverMinorVersion

getDriverName

getDriverVersion

getExportedKeys

getExtraNameCharacters