Method Summary |
|
public boolean | allProceduresAreCallable() Retrieves whether the current user can call all the procedures returned by the method getProcedures. |
public boolean | allTablesAreSelectable() Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement. |
protected boolean | checkCatalogAndSchema(String catalog, String schemaPattern) Check catalog and schema name pattern. |
protected boolean | checkTableTypes(String[] types) Check the table types. |
public boolean | dataDefinitionCausesTransactionCommit() Retrieves whether a data definition statement within a transaction forces the transaction to commit. |
public boolean | dataDefinitionIgnoredInTransactions() Retrieves whether this database ignores a data definition statement within a transaction. |
public boolean | deletesAreDetected(int type) Retrieves whether or not a visible row delete can be detected by calling
the method ResultSet.rowDeleted. |
public boolean | doesMaxRowSizeIncludeBlobs() Retrieves whether the return value for the method getMaxRowSize includes
the SQL data types LONGVARCHAR and LONGVARBINARY. |
public ResultSet | getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) Retrieves a description of the given attribute of the given type for a user-defined type (UDT)
that is available in the given schema and catalog. |
public ResultSet | getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) Retrieves a description of a table's optimal set of columns that uniquely identifies a row. |
public String | getCatalogSeparator() Retrieves the String that this database uses as the separator between a catalog and table name. |
public String | getCatalogTerm() Retrieves the database vendor's preferred term for "catalog". |
public ResultSet | getCatalogs() Retrieves the catalog names available in this database. |
public ResultSet | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) Retrieves a description of the access rights for a table's columns. |
public Connection | getConnection() |
public ResultSet | getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) Retrieves a description of the foreign key columns in the given foreign key table that
reference the primary key columns of the given primary key table. |
public int | getDatabaseMajorVersion() Retrieves the major version number of the underlying database. |
public int | getDatabaseMinorVersion() Retrieves the minor version number of the underlying database. |
public String | getDatabaseProductName() Retrieves the name of this database product. |
public String | getDatabaseProductVersion() Retrieves the version number of this database product. |
public int | getDefaultTransactionIsolation() Retrieves this database's default transaction isolation level. |
public String | getDriverVersion() Retrieves the version number of this JDBC driver as a String. |
public ResultSet | getExportedKeys(String catalog, String schema, String table) Retrieves a description of the foreign key columns that reference the given table's primary key columns. |
public String | getExtraNameCharacters() Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). |
public String | getIdentifierQuoteString() Retrieves the string used to quote SQL identifiers. |
public ResultSet | getImportedKeys(String catalog, String schema, String table) Retrieves a description of the primary key columns that are referenced by a table's foreign key columns
(the primary keys imported by a table). |
public ResultSet | getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) Retrieves a description of the given table's indices and statistics. |
public int | getJDBCMajorVersion() Retrieves the major JDBC version number for this driver. |
public int | getJDBCMinorVersion() Retrieves the minor JDBC version number for this driver. |
public int | getMaxBinaryLiteralLength() Retrieves the maximum number of hex characters this database allows in an inline binary literal. |
public int | getMaxCatalogNameLength() Retrieves the maximum number of characters that this database allows in a catalog name. |
public int | getMaxCharLiteralLength() Retrieves the maximum number of characters this database allows for a character literal. |
public int | getMaxColumnNameLength() Retrieves the maximum number of characters this database allows for a column name. |
public int | getMaxColumnsInGroupBy() Retrieves the maximum number of columns this database allows in a GROUP BY clause. |
public int | getMaxColumnsInIndex() Retrieves the maximum number of columns this database allows in an index. |
public int | getMaxColumnsInOrderBy() Retrieves the maximum number of columns this database allows in an ORDER BY clause. |
public int | getMaxColumnsInSelect() Retrieves the maximum number of columns this database allows in a SELECT list. |
public int | getMaxColumnsInTable() Retrieves the maximum number of columns this database allows in a table. |
public int | getMaxConnections() Retrieves the maximum number of concurrent connections to this database that are possible. |
public int | getMaxCursorNameLength() Retrieves the maximum number of characters that this database allows in a cursor name. |
public int | getMaxIndexLength() Retrieves the maximum number of bytes this database allows for an index,
including all of the parts of the index. |
public int | getMaxProcedureNameLength() Retrieves the maximum number of characters that this database allows in a procedure name. |
public int | getMaxRowSize() Retrieves the maximum number of bytes this database allows in a single row. |
public int | getMaxSchemaNameLength() Retrieves the maximum number of characters that this database allows in a schema name. |
public int | getMaxStatementLength() Retrieves the maximum number of characters this database allows in an SQL statement. |
public int | getMaxStatements() Retrieves the maximum number of active statements to this database that can be open at the same time. |
public int | getMaxTableNameLength() Retrieves the maximum number of characters this database allows in a table name. |
public int | getMaxTablesInSelect() Retrieves the maximum number of tables this database allows in a SELECT statement. |
public int | getMaxUserNameLength() Retrieves the maximum number of characters this database allows in a user name. |
public String | getNumericFunctions() Retrieves a comma-separated list of math functions available with this database. |
public ResultSet | getPrimaryKeys(String catalog, String schema, String table) Retrieves a description of the given table's primary key columns. |
public ResultSet | getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) Retrieves a description of the given catalog's stored procedure parameter and result columns. |
public String | getProcedureTerm() Retrieves the database vendor's preferred term for "procedure". |
public ResultSet | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) Retrieves a description of the stored procedures available in the given catalog. |
public int | getResultSetHoldability() Retrieves the default holdability of this ResultSet object. |
public String | getSQLKeywords() Retrieves a comma-separated list of all of this database's SQL keywords that are
NOT also SQL92 keywords. |
public int | getSQLStateType() Indicates whether the SQLSTATEs returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL99. |
public String | getSchemaTerm() Retrieves the database vendor's preferred term for "schema". |
public ResultSet | getSchemas() Retrieves the schema names available in this database. |
public String | getSearchStringEscape() Retrieves the string that can be used to escape wildcard characters. |
public String | getStringFunctions() Retrieves a comma-separated list of string functions available with this database. |
public ResultSet | getSuperTables(String catalog, String schemaPattern, String tableNamePattern) Retrieves a description of the table hierarchies defined in a particular schema in this database. |
public ResultSet | getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema
in this database. |
public String | getSystemFunctions() Retrieves a comma-separated list of system functions available with this database. |
public ResultSet | getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) Retrieves a description of the access rights for each table available in a catalog. |
public ResultSet | getTableTypes() Retrieves the table types available in this database. |
public String | getTimeDateFunctions() Retrieves a comma-separated list of the time and date functions available with this database. |
public ResultSet | getTypeInfo() Retrieves a description of all the standard SQL types supported by this database. |
public ResultSet | getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) Retrieves a description of the user-defined types (UDTs) defined in a particular schema. |
public String | getURL() Retrieves the URL for this DBMS. |
public String | getUserName() Retrieves the user name as known to this database. |
public ResultSet | getVersionColumns(String catalog, String schema, String table) Retrieves a description of a table's columns that are automatically updated when any value in a row is updated. |
public boolean | insertsAreDetected(int type) Retrieves whether or not a visible row insert can be detected by
calling the method ResultSet.rowInserted. |
public boolean | isCatalogAtStart() Retrieves whether a catalog appears at the start of a fully qualified table name. |
public boolean | isReadOnly() Retrieves whether this database is in read-only mode. |
public boolean | locatorsUpdateCopy() Indicates whether updates made to a LOB are made on a copy or directly to the LOB. |
public boolean | nullPlusNonNullIsNull() Retrieves whether this database supports concatenations between NULL
and non-NULL values being NULL. |
public boolean | nullsAreSortedAtEnd() Retrieves whether NULL values are sorted at the end regardless of sort order. |
public boolean | nullsAreSortedAtStart() Retrieves whether NULL values are sorted at the start regardless of sort order. |
public boolean | nullsAreSortedHigh() Retrieves whether NULL values are sorted high. |
public boolean | nullsAreSortedLow() Retrieves whether NULL values are sorted low. |
public boolean | othersDeletesAreVisible(int type) Retrieves whether deletes made by others are visible. |
public boolean | othersInsertsAreVisible(int type) Retrieves whether inserts made by others are visible. |
public boolean | othersUpdatesAreVisible(int type) Retrieves whether updates made by others are visible. |
public boolean | ownDeletesAreVisible(int type) Retrieves whether a result set's own deletes are visible. |
public boolean | ownInsertsAreVisible(int type) Retrieves whether a result set's own inserts are visible. |
public boolean | ownUpdatesAreVisible(int type) Retrieves whether for the given type of ResultSet object, the result set's own updates are visible. |
public boolean | storesLowerCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL
identifiers as case insensitive and stores them in lower case. |
public boolean | storesLowerCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case
insensitive and stores them in lower case. |
public boolean | storesMixedCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL
identifiers as case sensitive and as a result stores them in mixed case. |
public boolean | storesMixedCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers
as case sensitive and as a result stores them in mixed case. |
public boolean | storesUpperCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL identifiers
as case insensitive and stores them in upper case. |
public boolean | storesUpperCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case
insensitive and stores them in upper case. |
public boolean | supportsANSI92EntryLevelSQL() Retrieves whether this database supports the ANSI92 entry level SQL grammar. |
public boolean | supportsANSI92FullSQL() Retrieves whether this database supports the ANSI92 full SQL grammar supported. |
public boolean | supportsANSI92IntermediateSQL() Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported. |
public boolean | supportsAlterTableWithAddColumn() Retrieves whether this database supports ALTER TABLE with add column. |
public boolean | supportsAlterTableWithDropColumn() Retrieves whether this database supports ALTER TABLE with drop column. |
public boolean | supportsBatchUpdates() Retrieves whether this database supports batch updates. |
public boolean | supportsCatalogsInDataManipulation() Retrieves whether a catalog name can be used in a data manipulation statement. |
public boolean | supportsCatalogsInIndexDefinitions() Retrieves whether a catalog name can be used in an index definition statement. |
public boolean | supportsCatalogsInPrivilegeDefinitions() Retrieves whether a catalog name can be used in a privilege definition statement. |
public boolean | supportsCatalogsInProcedureCalls() Retrieves whether a catalog name can be used in a procedure call statement. |
public boolean | supportsCatalogsInTableDefinitions() Retrieves whether a catalog name can be used in a table definition statement. |
public boolean | supportsColumnAliasing() Retrieves whether this database supports column aliasing. |
public boolean | supportsConvert() Retrieves whether this database supports the CONVERT function between SQL types. |
public boolean | supportsConvert(int fromType, int toType) Retrieves whether this database supports the CONVERT for two given SQL types. |
public boolean | supportsCoreSQLGrammar() Retrieves whether this database supports the ODBC Core SQL grammar. |
public boolean | supportsCorrelatedSubqueries() Retrieves whether this database supports correlated subqueries. |
public boolean | supportsDataDefinitionAndDataManipulationTransactions() Retrieves whether this database supports both data definition and data manipulation statements within a transaction. |
public boolean | supportsDataManipulationTransactionsOnly() Retrieves whether this database supports only data manipulation statements within a transaction. |
public boolean | supportsDifferentTableCorrelationNames() Retrieves whether, when table correlation names are supported, they are restricted
to being different from the names of the tables. |
public boolean | supportsExpressionsInOrderBy() Retrieves whether this database supports expressions in ORDER BY lists. |
public boolean | supportsExtendedSQLGrammar() Retrieves whether this database supports the ODBC Extended SQL grammar. |
public boolean | supportsFullOuterJoins() Retrieves whether this database supports full nested outer joins. |
public boolean | supportsGetGeneratedKeys() Retrieves whether auto-generated keys can be retrieved after a statement has been executed. |
public boolean | supportsGroupBy() Retrieves whether this database supports some form of GROUP BY clause. |
public boolean | supportsGroupByBeyondSelect() Retrieves whether this database supports using columns not included
in the SELECT statement in a GROUP BY clause provided that all of the
columns in the SELECT statement are included in the GROUP BY clause. |
public boolean | supportsGroupByUnrelated() Retrieves whether this database supports using a column that is not in the
SELECT statement in a GROUP BY clause. |
public boolean | supportsIntegrityEnhancementFacility() Retrieves whether this database supports the SQL Integrity Enhancement Facility. |
public boolean | supportsLikeEscapeClause() Retrieves whether this database supports specifying a LIKE escape clause. |
public boolean | supportsLimitedOuterJoins() Retrieves whether this database provides limited support for outer joins. |
public boolean | supportsMinimumSQLGrammar() Retrieves whether this database supports the ODBC Minimum SQL grammar. |
public boolean | supportsMixedCaseIdentifiers() Retrieves whether this database treats mixed case unquoted SQL identifiers as
case insensitive and stores them in mixed case. |
public boolean | supportsMixedCaseQuotedIdentifiers() Retrieves whether this database treats mixed case quoted SQL identifiers as case
sensitive and as a result stores them in mixed case. |
public boolean | supportsMultipleOpenResults() Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously. |
public boolean | supportsMultipleResultSets() Retrieves whether this database supports getting multiple ResultSet
objects from a single call to the method execute. |
public boolean | supportsMultipleTransactions() Retrieves whether this database allows having multiple transactions
open at once (on different connections). |
public boolean | supportsNamedParameters() Retrieves whether this database supports named parameters to callable statements. |
public boolean | supportsNonNullableColumns() Retrieves whether columns in this database may be defined as non-nullable. |
public boolean | supportsOpenCursorsAcrossCommit() Retrieves whether this database supports keeping cursors open across commits. |
public boolean | supportsOpenCursorsAcrossRollback() Retrieves whether this database supports keeping cursors open across rollbacks. |
public boolean | supportsOpenStatementsAcrossCommit() Retrieves whether this database supports keeping statements open across commits. |
public boolean | supportsOpenStatementsAcrossRollback() Retrieves whether this database supports keeping statements open across rollbacks. |
public boolean | supportsOrderByUnrelated() Retrieves whether this database supports using a column that is not
in the SELECT statement in an ORDER BY clause. |
public boolean | supportsOuterJoins() Retrieves whether this database supports some form of outer join. |
public boolean | supportsPositionedDelete() Retrieves whether this database supports positioned DELETE statements. |
public boolean | supportsPositionedUpdate() Retrieves whether this database supports positioned UPDATE statements. |
public boolean | supportsResultSetConcurrency(int type, int concurrency) Retrieves whether this database supports the given concurrency type in combination with the given result set type. |
public boolean | supportsResultSetHoldability(int holdability) Retrieves whether this database supports the given result set holdability. |
public boolean | supportsResultSetType(int type) Retrieves whether this database supports the given result set type. |
public boolean | supportsSavepoints() Retrieves whether this database supports savepoints. |
public boolean | supportsSchemasInDataManipulation() Retrieves whether a schema name can be used in a data manipulation statement. |
public boolean | supportsSchemasInIndexDefinitions() Retrieves whether a schema name can be used in an index definition statement. |
public boolean | supportsSchemasInPrivilegeDefinitions() Retrieves whether a schema name can be used in a privilege definition statement. |
public boolean | supportsSchemasInProcedureCalls() Retrieves whether a schema name can be used in a procedure call statement. |
public boolean | supportsSchemasInTableDefinitions() Retrieves whether a schema name can be used in a table definition statement. |
public boolean | supportsSelectForUpdate() Retrieves whether this database supports SELECT FOR UPDATE statements. |
public boolean | supportsStatementPooling() Indicates whether statement pooling is supported. |
public boolean | supportsStoredProcedures() Retrieves whether this database supports stored procedure calls that use
the stored procedure escape syntax. |
public boolean | supportsSubqueriesInComparisons() Retrieves whether this database supports subqueries in comparison expressions. |
public boolean | supportsSubqueriesInExists() Retrieves whether this database supports subqueries in EXISTS expressions. |
public boolean | supportsSubqueriesInIns() Retrieves whether this database supports subqueries in IN statements. |
public boolean | supportsSubqueriesInQuantifieds() Retrieves whether this database supports subqueries in quantified expressions. |
public boolean | supportsTableCorrelationNames() Retrieves whether this database supports table correlation names. |
public boolean | supportsTransactionIsolationLevel(int level) Retrieves whether this database supports the given transaction isolation level. |
public boolean | supportsTransactions() Retrieves whether this database supports transactions. |
public boolean | supportsUnion() Retrieves whether this database supports SQL UNION. |
public boolean | supportsUnionAll() Retrieves whether this database supports SQL UNION ALL. |
public boolean | updatesAreDetected(int type) Retrieves whether or not a visible row update can be detected by calling
the method ResultSet.rowUpdated. |
public boolean | usesLocalFilePerTable() Retrieves whether this database uses a file for each table. |