java.sql
Interface DatabaseMetaData


public interface DatabaseMetaData


Field Summary
static short attributeNoNulls
          A NULL value is not allowed for this attribute.
static short attributeNullable
          A NULL value is allowed for this attribute.
static short attributeNullableUnknown
          It is unknown whether or not NULL values are allowed for this attribute.
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 typePattern, String attributePattern)
           
 ResultSet getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable)
          This method returns the best set of columns for uniquely identifying a row.
 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.
 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 getColumnPrivileges(String catalog, String schema, String tableName, String columnPattern)
          This method returns the access rights that have been granted to the requested columns.
 ResultSet getColumns(String catalog, String schemaPattern, String tablePattern, String columnPattern)
          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 primaryTableName, String foreignCatalog, String foreignSchema, String foreignTableName)
          This method returns a description of how one table imports another table's primary key as a foreign key.
 int getDatabaseMajorVersion()
          This method returns the major version number of the database.
 int getDatabaseMinorVersion()
          This method returns the minor version number of the database.
 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 tableName)
          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 tableName)
          This method returns a list of the table's foreign keys.
 ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate)
          This method returns information about a tables indices and statistics.
 int getJDBCMajorVersion()
          This method returns the major version number of the JDBC driver.
 int getJDBCMinorVersion()
          This method returns the minor version number of the JDBC driver.
 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 tableName)
          This method returns a list of a table's primary key columns.
 ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedurePattern, String columnPattern)
          This method returns a list of the parameter and result columns for the requested stored procedures.
 ResultSet getProcedures(String catalog, String schemaPattern, String procedurePattern)
          This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog.
 String getProcedureTerm()
          This method returns the vendor's term for "procedure".
 int getResultSetHoldability()
          This method returns the default holdability type of ResultSetS retrieved from this database.
 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 getSchemaTerm()
          This method returns the vendor's term for "schema".
 String getSearchStringEscape()
          This method returns the string used to escape wildcards in search strings.
 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 getStringFunctions()
          This method returns a comma separated list of string functions.
 ResultSet getSuperTables(String catalog, String schemaPattern, String tablePattern)
           
 ResultSet getSuperTypes(String catalog, String schemaPattern, String typePattern)
           
 String getSystemFunctions()
          This method returns a comma separated list of of system functions.
 ResultSet getTablePrivileges(String catalog, String schemaPattern, String tablePattern)
          This method returns the access rights that have been granted to the requested tables.
 ResultSet getTables(String catalog, String schemaPattern, String tablePattern, 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.
 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.
 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 typePattern, 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 tableName)
          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 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 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 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()
          This method tests whether the database supports returning multiple ResultSetS from a CallableStatement at once.
 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()
          This method tests whether the database supports named parameters.
 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)
          This method tests if the database supports the specified holdability type.
 boolean supportsResultSetType(int type)
          This method tests whether or not the datbase supports the specified result type.
 boolean supportsSavepoints()
          This method tests whether the databse supports savepoints.
 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.
 

Field Detail

procedureResultUnknown

static final int procedureResultUnknown
It is unknown whether or not the procedure returns a result.

See Also:
Constant Field Values

procedureNoResult

static final int procedureNoResult
The procedure does not return a result.

See Also:
Constant Field Values

procedureReturnsResult

static final int procedureReturnsResult
The procedure returns a result.

See Also:
Constant Field Values

procedureColumnUnknown

static final int procedureColumnUnknown
The column type is unknown.

See Also:
Constant Field Values

procedureColumnIn

static final int procedureColumnIn
The column type is input.

See Also:
Constant Field Values

procedureColumnInOut

static final int procedureColumnInOut
The column type is input/output.

See Also:
Constant Field Values

procedureColumnOut

static final int procedureColumnOut
The column type is output

See Also:
Constant Field Values

procedureColumnReturn

static final int procedureColumnReturn
The column is used for return values.

See Also:
Constant Field Values

procedureColumnResult

static final int procedureColumnResult
The column is used for storing results

See Also:
Constant Field Values

procedureNoNulls

static final int procedureNoNulls
NULL values are not allowed.

See Also:
Constant Field Values

procedureNullable

static final int procedureNullable
NULL values are allowed.

See Also:
Constant Field Values

procedureNullableUnknown

static final int procedureNullableUnknown
It is unknown whether or not NULL values are allowed.

See Also:
Constant Field Values

columnNoNulls

static final int columnNoNulls
The column does not allow NULL

See Also:
Constant Field Values

columnNullable

static final int columnNullable
The column does allow NULL

See Also:
Constant Field Values

columnNullableUnknown

static final int columnNullableUnknown
It is unknown whether or not the column allows NULL

See Also:
Constant Field Values

bestRowTemporary

static final int bestRowTemporary
The best row's scope is only guaranteed to be valid so long as the row is actually being used.

See Also:
Constant Field Values

bestRowTransaction

static final int bestRowTransaction
The best row identifier is valid to the end of the transaction.

See Also:
Constant Field Values

bestRowSession

static final int bestRowSession
The best row identifier is valid to the end of the session.

See Also:
Constant Field Values

bestRowUnknown

static final int bestRowUnknown
The best row may or may not be a pseudo-column.

See Also:
Constant Field Values

bestRowNotPseudo

static final int bestRowNotPseudo
The best row identifier is not a pseudo-column.

See Also:
Constant Field Values

bestRowPseudo

static final int bestRowPseudo
The best row identifier is a pseudo-column.

See Also:
Constant Field Values

versionColumnUnknown

static final int versionColumnUnknown
It is unknown whether or not the version column is a pseudo-column.

See Also:
Constant Field Values

versionColumnNotPseudo

static final int versionColumnNotPseudo
The version column is not a pseudo-column

See Also:
Constant Field Values

versionColumnPseudo

static final int versionColumnPseudo
The version column is a pseudo-column

See Also:
Constant Field Values

importedKeyCascade

static final int importedKeyCascade
Foreign key changes are cascaded in updates or deletes.

See Also:
Constant Field Values

importedKeyRestrict

static final int importedKeyRestrict
Column may not be updated or deleted in use as a foreign key.

See Also:
Constant Field Values

importedKeySetNull

static final int importedKeySetNull
When primary key is updated or deleted, the foreign key is set to NULL.

See Also:
Constant Field Values

importedKeyNoAction

static final int importedKeyNoAction
If the primary key is a foreign key, it cannot be udpated or deleted.

See Also:
Constant Field Values

importedKeySetDefault

static final int importedKeySetDefault
If the primary key is updated or deleted, the foreign key is set to a default value.

See Also:
Constant Field Values

importedKeyInitiallyDeferred

static final int importedKeyInitiallyDeferred
Wish I knew what this meant.

See Also:
Constant Field Values

importedKeyInitiallyImmediate

static final int importedKeyInitiallyImmediate
Wish I knew what this meant.

See Also:
Constant Field Values

importedKeyNotDeferrable

static final int importedKeyNotDeferrable
Wish I knew what this meant.

See Also:
Constant Field Values

typeNoNulls

static final int typeNoNulls
A NULL value is not allowed for this data type.

See Also:
Constant Field Values

typeNullable

static final int typeNullable
A NULL value is allowed for this data type.

See Also:
Constant Field Values

typeNullableUnknown

static final int typeNullableUnknown
It is unknown whether or not NULL values are allowed for this data type.

See Also:
Constant Field Values

typePredNone

static final int typePredNone
Where clauses are not supported for this type.

See Also:
Constant Field Values

typePredChar

static final int typePredChar
Only "WHERE..LIKE" style WHERE clauses are allowed on this data type.

See Also:
Constant Field Values

typePredBasic

static final int typePredBasic
All WHERE clauses except "WHERE..LIKE" style are allowed on this data type.

See Also:
Constant Field Values

typeSearchable

static final int typeSearchable
Any type of WHERE clause is allowed for this data type.

See Also:
Constant Field Values

tableIndexStatistic

static final short tableIndexStatistic
This column contains table statistics.

See Also:
Constant Field Values

tableIndexClustered

static final short tableIndexClustered
This table index is clustered.

See Also:
Constant Field Values

tableIndexHashed

static final short tableIndexHashed
This table index is hashed.

See Also:
Constant Field Values

tableIndexOther

static final short tableIndexOther
This table index is of another type.

See Also:
Constant Field Values

attributeNoNulls

static final short attributeNoNulls
A NULL value is not allowed for this attribute.

See Also:
Constant Field Values

attributeNullable

static final short attributeNullable
A NULL value is allowed for this attribute.

See Also:
Constant Field Values

attributeNullableUnknown

static final short attributeNullableUnknown
It is unknown whether or not NULL values are allowed for this attribute.

See Also:
Constant Field Values

sqlStateXOpen

static final int sqlStateXOpen
See Also:
Constant Field Values

sqlStateSQL99

static final int sqlStateSQL99
See Also:
Constant Field Values
Method Detail

allProceduresAreCallable

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

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.

getURL

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

String getUserName()
                   throws SQLException
This method returns the database username for this connection.

Returns:
The database username.
Throws:
SQLException - If an error occurs.

isReadOnly

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.

nullsAreSortedHigh

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

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.

nullsAreSortedAtStart

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.

nullsAreSortedAtEnd

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.

getDatabaseProductName

String getDatabaseProductName()
                              throws SQLException
This method returns the name of the database product.

Returns:
The database product.
Throws:
SQLException - If an error occurs.

getDatabaseProductVersion

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.

getDriverName

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

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.

getDriverMajorVersion

int getDriverMajorVersion()
This method returns the major version number of the JDBC driver.

Returns:
The major version number of the JDBC driver.

getDriverMinorVersion

int getDriverMinorVersion()
This method returns the minor version number of the JDBC driver.

Returns:
The minor version number of the JDBC driver.

usesLocalFiles

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.

usesLocalFilePerTable

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.

supportsMixedCaseIdentifiers

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.

storesUpperCaseIdentifiers

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.

storesLowerCaseIdentifiers

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.

storesMixedCaseIdentifiers

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.

supportsMixedCaseQuotedIdentifiers

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.

storesUpperCaseQuotedIdentifiers

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.

storesLowerCaseQuotedIdentifiers

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.

storesMixedCaseQuotedIdentifiers

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.

getIdentifierQuoteString

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.

getSQLKeywords

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.

getNumericFunctions

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.

getStringFunctions

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.

getSystemFunctions

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.

getTimeDateFunctions

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.

getSearchStringEscape

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.

getExtraNameCharacters

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.

supportsAlterTableWithAddColumn

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

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.

supportsColumnAliasing

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.

nullPlusNonNullIsNull

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.

supportsConvert

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

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.
Throws:
SQLException
See Also:
Types

supportsTableCorrelationNames

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.

supportsDifferentTableCorrelationNames

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

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.

supportsOrderByUnrelated

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.

supportsGroupBy

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.

supportsGroupByUnrelated

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.

supportsGroupByBeyondSelect

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.

supportsLikeEscapeClause

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.

supportsMultipleResultSets

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

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.

supportsNonNullableColumns

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.

supportsMinimumSQLGrammar

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.

supportsCoreSQLGrammar

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.

supportsExtendedSQLGrammar

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.

supportsANSI92EntryLevelSQL

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.

supportsANSI92IntermediateSQL

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.

supportsANSI92FullSQL

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.

supportsIntegrityEnhancementFacility

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.

supportsOuterJoins

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.

supportsFullOuterJoins

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.

supportsLimitedOuterJoins

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.

getSchemaTerm

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.

getProcedureTerm

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.

getCatalogTerm

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.

isCatalogAtStart

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.

getCatalogSeparator

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.

supportsSchemasInDataManipulation

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.

supportsSchemasInProcedureCalls

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

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.

supportsSchemasInIndexDefinitions

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

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.

supportsCatalogsInDataManipulation

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.

supportsCatalogsInProcedureCalls

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

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.

supportsCatalogsInIndexDefinitions

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

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.

supportsPositionedDelete

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

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.

supportsSelectForUpdate

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.

supportsStoredProcedures

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

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

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

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

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.

supportsCorrelatedSubqueries

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.

supportsUnion

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

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.

supportsOpenCursorsAcrossCommit

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

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

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

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.

getMaxBinaryLiteralLength

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.

getMaxCharLiteralLength

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

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

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

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

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

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

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

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.
Throws:
SQLException

getMaxCursorNameLength

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

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.

getMaxSchemaNameLength

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.

getMaxProcedureNameLength

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.

getMaxCatalogNameLength

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.

getMaxRowSize

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.

doesMaxRowSizeIncludeBlobs

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.

getMaxStatementLength

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

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

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

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

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.

getDefaultTransactionIsolation

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

supportsTransactions

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.

supportsTransactionIsolationLevel

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.

supportsDataDefinitionAndDataManipulationTransactions

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

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.

dataDefinitionCausesTransactionCommit

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

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.

getProcedures

ResultSet getProcedures(String catalog,
                        String schemaPattern,
                        String procedurePattern)
                        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:

  1. PROCEDURE_CAT - The catalog the procedure is in, which may be null.
  2. PROCEDURE_SCHEM - The schema the procedures is in, which may be null.
  3. PROCEDURE_NAME - The name of the procedure.
  4. Unused
  5. Unused
  6. Unused
  7. REMARKS - A description of the procedure
  8. 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.
procedurePattern - The pattern of procedure names to return.
Throws:
SQLException - If an error occurs.

getProcedureColumns

ResultSet getProcedureColumns(String catalog,
                              String schemaPattern,
                              String procedurePattern,
                              String columnPattern)
                              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:

  1. PROCEDURE_CAT - The catalog the procedure is in, which may be null.
  2. PROCEDURE_SCHEM - The schema the procedures is in, which may be null.
  3. PROCEDURE_NAME - The name of the procedure.
  4. COLUMN_NAME - The name of the column
  5. 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).
  6. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
  7. TYPE_NAME - The string name of the data type for this column.
  8. PRECISION - The precision of the column.
  9. LENGTH - The length of the column in bytes
  10. SCALE - The scale of the column.
  11. RADIX - The radix of the column.
  12. NULLABLE - Whether or not the column is NULLABLE. This is one of the constants defined in this class (procedureNoNulls, procedureNullable, or procedureNullableUnknown)
  13. 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.
procedurePattern - The pattern of procedures names to return.
columnPattern - The pattern of column names to return.
Throws:
SQLException - If an error occurs.

getTables

ResultSet getTables(String catalog,
                    String schemaPattern,
                    String tablePattern,
                    String[] types)
                    throws SQLException
This method returns a list of the requested table as a ResultSet with the following columns:
  1. TABLE_CAT - The catalog the table is in, which may be null.
  2. TABLE_SCHEM - The schema the table is in, which may be null.
  3. TABLE_NAME - The name of the table.
  4. TABLE_TYPE - A string describing the table type. This will be one of the values returned by the getTableTypes() method.
  5. 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.
tablePattern - The pattern of table names to return.
types - The list of table types to include; null returns all types.
Throws:
SQLException - If an error occurs.

getSchemas

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.

getCatalogs

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.

getTableTypes

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.

getColumns

ResultSet getColumns(String catalog,
                     String schemaPattern,
                     String tablePattern,
                     String columnPattern)
                     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:

  1. TABLE_CAT - The catalog the table is in, which may be null.
  2. TABLE_SCHEM - The schema the tables is in, which may be null.
  3. TABLE_NAME - The name of the table.
  4. COLUMN_NAME - The name of the column
  5. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
  6. TYPE_NAME - The string name of the data type for this column.
  7. COLUMN_SIZE - The size of the column.
  8. Unused
  9. NUM_PREC_RADIX - The radix of the column.
  10. NULLABLE - Whether or not the column is NULLABLE. This is one of the constants defined in this class (tableNoNulls, tableNullable, or tableNullableUnknown)
  11. REMARKS - A description of the column.
  12. COLUMN_DEF - The default value for the column, may be null.
  13. SQL_DATA_TYPE - Unused
  14. SQL_DATETIME_SUB - Unused
  15. CHAR_OCTET_LENGTH - For character columns, the maximum number of bytes in the column.
  16. ORDINAL_POSITION - The index of the column in the table.
  17. 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.
tablePattern - The pattern of table names to return.
columnPattern - The pattern of column names to return.
Throws:
SQLException - If an error occurs.

getColumnPrivileges

ResultSet getColumnPrivileges(String catalog,
                              String schema,
                              String tableName,
                              String columnPattern)
                              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:
  1. TABLE_CAT - The catalog the table is in, which may be null.
  2. TABLE_SCHEM - The schema the tables is in, which may be null.
  3. TABLE_NAME - The name of the table.
  4. COLUMN_NAME - The name of the column.
  5. GRANTOR - The entity that granted the access.
  6. GRANTEE - The entity granted the access.
  7. PRIVILEGE - The name of the privilege granted.
  8. 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.
tableName - The table name to return information for.
columnPattern - A pattern of column names to return information for.
Returns:
A ResultSet with all the requested privileges.
Throws:
SQLException - If an error occurs.

getTablePrivileges

ResultSet getTablePrivileges(String catalog,
                             String schemaPattern,
                             String tablePattern)
                             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:
  1. TABLE_CAT - The catalog the table is in, which may be null.
  2. TABLE_SCHEM - The schema the tables is in, which may be null.
  3. TABLE_NAME - The name of the table.
  4. GRANTOR - The entity that granted the access.
  5. GRANTEE - The entity granted the access.
  6. PRIVILEGE - The name of the privilege granted.
  7. 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.
schemaPattern - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
tablePattern - The table name pattern of tables to return information for.
Returns:
A ResultSet with all the requested privileges.
Throws:
SQLException - If an error occurs.

getBestRowIdentifier

ResultSet getBestRowIdentifier(String catalog,
                               String schema,
                               String tableName,
                               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:
  1. SCOPE - The scope of the results returned. This is one of the constants defined in this class (bestRowTemporary, bestRowTransaction, or bestRowSession).
  2. COLUMN_NAME - The name of the column.
  3. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
  4. TYPE_NAME - The string name of the data type for this column.
  5. COLUMN_SIZE - The precision of the columns
  6. BUFFER_LENGTH - Unused
  7. DECIMAL_DIGITS - The scale of the column.
  8. 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.
tableName - 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.

getVersionColumns

ResultSet getVersionColumns(String catalog,
                            String schema,
                            String tableName)
                            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:
  1. SCOPE - Unused
  2. COLUMN_NAME - The name of the column.
  3. DATA_TYPE - The SQL type of the column. This is one of the constants defined in Types.
  4. TYPE_NAME - The string name of the data type for this column.
  5. COLUMN_SIZE - The precision of the columns
  6. BUFFER_LENGTH - Unused
  7. DECIMAL_DIGITS - The scale of the column.
  8. 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.
tableName - The table name to return information for
Returns:
A ResultSet with the version columns.
Throws:
SQLException - If an error occurs.

getPrimaryKeys

ResultSet getPrimaryKeys(String catalog,
                         String schema,
                         String tableName)
                         throws SQLException
This method returns a list of a table's primary key columns. These are returned as a ResultSet with the following columns.
  1. TABLE_CAT - The catalog of the table, which may be null.
  2. TABLE_SCHEM - The schema of the table, which may be null.
  3. TABLE_NAME - The name of the table.
  4. COLUMN_NAME - The name of the column.
  5. KEY_SEQ - The sequence number of the column within the primary key.
  6. 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.
tableName - The table name to return information for.
Returns:
A ResultSet with the primary key columns.
Throws:
SQLException - If an error occurs.

getImportedKeys

ResultSet getImportedKeys(String catalog,
                          String schema,
                          String tableName)
                          throws SQLException
This method returns a list of the table's foreign keys. These are returned as a ResultSet with the following columns:
  1. PKTABLE_CAT - The catalog of the table the key was imported from.
  2. PKTABLE_SCHEM - The schema of the table the key was imported from.
  3. PKTABLE_NAME - The name of the table the key was imported from.
  4. PKCOLUMN_NAME - The name of the column that was imported.
  5. FKTABLE_CAT - The foreign key catalog name.
  6. FKTABLE_SCHEM - The foreign key schema name.
  7. FKTABLE_NAME - The foreign key table name.
  8. FKCOLUMN_NAME - The foreign key column name.
  9. KEY_SEQ - The sequence number of the column within the foreign key.
  10. 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).
  11. 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)
  12. FK_NAME - The name of the foreign key.
  13. PK_NAME - The name of the primary key.
  14. 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.
tableName - The table name to return information for.
Returns:
A ResultSet with the foreign key columns.
Throws:
SQLException - If an error occurs.

getExportedKeys

ResultSet getExportedKeys(String catalog,
                          String schema,
                          String tableName)
                          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:
  1. PKTABLE_CAT - The catalog of the table the key was imported from.
  2. PKTABLE_SCHEM - The schema of the table the key was imported from.
  3. PKTABLE_NAME - The name of the table the key was imported from.
  4. PKCOLUMN_NAME - The name of the column that was imported.
  5. FKTABLE_CAT - The foreign key catalog name.
  6. FKTABLE_SCHEM - The foreign key schema name.
  7. FKTABLE_NAME - The foreign key table name.
  8. FKCOLUMN_NAME - The foreign key column name.
  9. KEY_SEQ - The sequence number of the column within the foreign key.
  10. 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).
  11. 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)
  12. FK_NAME - The name of the foreign key.
  13. PK_NAME - The name of the primary key.
  14. 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.
tableName - The table name to return information for.
Returns:
A ResultSet with the requested information
Throws:
SQLException - If an error occurs.

getCrossReference

ResultSet getCrossReference(String primaryCatalog,
                            String primarySchema,
                            String primaryTableName,
                            String foreignCatalog,
                            String foreignSchema,
                            String foreignTableName)
                            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:
  1. PKTABLE_CAT - The catalog of the table the key was imported from.
  2. PKTABLE_SCHEM - The schema of the table the key was imported from.
  3. PKTABLE_NAME - The name of the table the key was imported from.
  4. PKCOLUMN_NAME - The name of the column that was imported.
  5. FKTABLE_CAT - The foreign key catalog name.
  6. FKTABLE_SCHEM - The foreign key schema name.
  7. FKTABLE_NAME - The foreign key table name.
  8. FKCOLUMN_NAME - The foreign key column name.
  9. KEY_SEQ - The sequence number of the column within the foreign key.
  10. 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).
  11. 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)
  12. FK_NAME - The name of the foreign key.
  13. PK_NAME - The name of the primary key.
  14. DEFERRABILITY - The deferrability value. This is one of the constants defined in this table (importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, or importedKeyNotDeferrable).

Parameters:
primaryCatalog - 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, on the exporting side.
primarySchema - The schema to retrieve information from, or the empty string to return entities not associated with a schema, on the exporting side.
primaryTableName - The table name to return information for, on the exporting side.
foreignCatalog - 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, on the importing side.
foreignSchema - The schema to retrieve information from, or the empty string to return entities not associated with a schema on the importing side.
foreignTableName - The table name to return information for on the importing side.
Returns:
A ResultSet with the requested information
Throws:
SQLException - If an error occurs.

getTypeInfo

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:
  1. TYPE_NAME - The name of the data type.
  2. DATA_TYPE - A data type constant from Types for this type.
  3. PRECISION - The maximum precision of this type.
  4. LITERAL_PREFIX - Prefix value used to quote a literal, which may be null.
  5. LITERAL_SUFFIX - Suffix value used to quote a literal, which may be null.
  6. CREATE_PARAMS - The parameters used to create the type, which may be null.
  7. NULLABLE - Whether or not this type supports NULL values. This will be one of the constants defined in this interface (typeNoNulls, typeNullable, or typeNullableUnknown).
  8. CASE_SENSITIVE - Whether or not the value is case sensitive.
  9. 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).
  10. UNSIGNED_ATTRIBUTE - Is the value of this type unsigned.
  11. FIXED_PREC_SCALE - Whether or not this type can be used for money.
  12. AUTO_INCREMENT - Whether or not this type supports auto-incrementing.
  13. LOCAL_TYPE_NAME - A localized name for this data type.
  14. MINIMUM_SCALE - The minimum scale supported by this type.
  15. MAXIMUM_SCALE - The maximum scale supported by this type.
  16. SQL_DATA_TYPE - Unused.
  17. SQL_DATETIME_SUB - Unused.
  18. 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.

getIndexInfo

ResultSet getIndexInfo(String catalog,
                       String schema,
                       String tableName,
                       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:
  1. TABLE_CAT - The catalog of the table, which may be null.
  2. TABLE_SCHEM - The schema of the table, which may be null.
  3. TABLE_NAME - The name of the table.
  4. NON_UNIQUE - Are index values non-unique?
  5. INDEX_QUALIFIER The index catalog, which may be null
  6. INDEX_NAME - The name of the index.
  7. TYPE - The type of index, which will be one of the constants defined in this interface (tableIndexStatistic, tableIndexClustered, tableIndexHashed, or tableIndexOther).
  8. ORDINAL_POSITION - The sequence number of this column in the index. This will be 0 when the index type is tableIndexStatistic.
  9. COLUMN_NAME - The name of this column in the index.
  10. ASC_OR_DESC - "A" for an ascending sort sequence, "D" for a descending sort sequence or null if a sort sequence is not supported.
  11. CARDINALITY - The number of unique rows in the index, or the number of rows in the table if the index type is tableIndexStatistic.
  12. PAGES - The number of pages used for the index, or the number of pages in the table if the index type is tableIndexStatistic.
  13. 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.
tableName - The table name to return information for.
unique - true to return only unique indexes, false otherwise.
approximate - true if data values can be approximations, false otherwise.
Returns:
A ResultSet with the requested index information
Throws:
SQLException - If an error occurs.

supportsResultSetType

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

supportsResultSetConcurrency

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.
concurrency - The desired concurrency 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

ownUpdatesAreVisible

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

ownDeletesAreVisible

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

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

othersUpdatesAreVisible

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

othersDeletesAreVisible

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

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

updatesAreDetected

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

deletesAreDetected

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

insertsAreDetected

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

supportsBatchUpdates

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.

getUDTs

ResultSet getUDTs(String catalog,
                  String schemaPattern,
                  String typePattern,
                  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:
  1. TYPE_CAT - The catalog name, which may be null.
  2. TYPE_SCEHM - The schema name, which may be null.
  3. TYPE_NAME - The user defined data type name.
  4. CLASS_NAME - The Java class name this type maps to.
  5. DATA_TYPE - A type identifier from Types for this type. This will be one of JAVA_OBJECT, STRUCT, or DISTINCT.
  6. 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.
schemaPattern - The schema to retrieve information from, or the empty string to return entities not associated with a schema.
typePattern - The type name pattern to match.
types - The type identifier patterns (from Types) to match.
Returns:
A ResultSet with the requested type information
Throws:
SQLException - If an error occurs.

getConnection

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.

supportsSavepoints

boolean supportsSavepoints()
                           throws SQLException
This method tests whether the databse supports savepoints.

Returns:
true if the database supports savepoints, false if it does not.
Throws:
SQLException - If an error occurs.
Since:
1.4
See Also:
Savepoint

supportsNamedParameters

boolean supportsNamedParameters()
                                throws SQLException
This method tests whether the database supports named parameters.

Returns:
true if the database supports named parameters, false if it does not.
Throws:
SQLException - If an error occurs.
Since:
1.4

supportsMultipleOpenResults

boolean supportsMultipleOpenResults()
                                    throws SQLException
This method tests whether the database supports returning multiple ResultSetS from a CallableStatement at once.

Returns:
true if the database supports returnig multiple results at once, false if it does not.
Throws:
SQLException - If an error occurs.
Since:
1.4

supportsGetGeneratedKeys

boolean supportsGetGeneratedKeys()
                                 throws SQLException
Throws:
SQLException
Since:
1.4

getSuperTypes

ResultSet getSuperTypes(String catalog,
                        String schemaPattern,
                        String typePattern)
                        throws SQLException
Throws:
SQLException
Since:
1.4

getSuperTables

ResultSet getSuperTables(String catalog,
                         String schemaPattern,
                         String tablePattern)
                         throws SQLException
Throws:
SQLException
Since:
1.4

getAttributes

ResultSet getAttributes(String catalog,
                        String schemaPattern,
                        String typePattern,
                        String attributePattern)
                        throws SQLException
Throws:
SQLException
Since:
1.4

supportsResultSetHoldability

boolean supportsResultSetHoldability(int holdability)
                                     throws SQLException
This method tests if the database supports the specified holdability type. Valid values for this parameter are specified in the ResultSet class.

Parameters:
holdability - The holdability type to test.
Returns:
true if the database supports the holdability type, false if it does not.
Throws:
SQLException - If an error occurs.
Since:
1.4
See Also:
ResultSet

getResultSetHoldability

int getResultSetHoldability()
                            throws SQLException
This method returns the default holdability type of ResultSetS retrieved from this database. The possible values are specified in the ResultSet class.

Returns:
The default holdability type.
Throws:
SQLException - If an error occurs.
Since:
1.4

getDatabaseMajorVersion

int getDatabaseMajorVersion()
                            throws SQLException
This method returns the major version number of the database.

Returns:
The major version number of the database.
Throws:
SQLException - If an error occurs.
Since:
1.4

getDatabaseMinorVersion

int getDatabaseMinorVersion()
                            throws SQLException
This method returns the minor version number of the database.

Returns:
The minor version number of the database.
Throws:
SQLException - If an error occurs.
Since:
1.4

getJDBCMajorVersion

int getJDBCMajorVersion()
                        throws SQLException
This method returns the major version number of the JDBC driver.

Returns:
The major version number of the JDBC driver.
Throws:
SQLException - If an error occurs.
Since:
1.4

getJDBCMinorVersion

int getJDBCMinorVersion()
                        throws SQLException
This method returns the minor version number of the JDBC driver.

Returns:
The minor version number of the database.
Throws:
SQLException - If an error occurs.
Since:
1.4

getSQLStateType

int getSQLStateType()
                    throws SQLException
Throws:
SQLException
Since:
1.4

locatorsUpdateCopy

boolean locatorsUpdateCopy()
                           throws SQLException
Throws:
SQLException
Since:
1.4

supportsStatementPooling

boolean supportsStatementPooling()
                                 throws SQLException
Throws:
SQLException
Since:
1.4