Database (JBoss DNA 0.5 API Reference)

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.jboss.dna.common.jdbc.model.api
Interface Database

All Superinterfaces:: CoreMetaData, Serializable

All Known Implementing Classes:: DatabaseBean

public interface Database
extends CoreMetaData
extends CoreMetaData

Provides RDBMS wide meta data retrieved from java.sql.DatabaseMetaData.

Author:: Sergiy Litsenko

Method Summary
`void`	`addCatalog(Catalog catalog)` Adds Catalog
`void`	`addException(DatabaseMetaDataMethodException exception)` Adds the DatabaseMetaDataMethodException to the DatabaseMetadataProvider exception list
`void`	`addNumericFunction(String functionName)` Adds numeric function
`void`	`addSchema(Schema schema)` Adds Schema
`void`	`addSQLKeyword(String sqlKeyword)` Adds SQL keyword
`void`	`addSqlTypeConversionPair(SqlTypeConversionPair sqlTypeConversionPair)` Adds SqlTypeConversionPair
`void`	`addSqlTypeInfo(SqlTypeInfo sqlTypeInfo)` Adds SqlTypeInfo
`void`	`addStoredProcedure(StoredProcedure storedProcedure)` Adds Stored Procedure
`void`	`addStringFunction(String functionName)` Adds String function
`void`	`addSupportedForwardOnlyResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)` Adds ResultSetConcurrencyType
`void`	`addSupportedResultSetType(ResultSetType resultSetType)` Adds supported ResultSetType
`void`	`addSupportedScrollInsensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)` Adds ResultSetConcurrencyType
`void`	`addSupportedScrollSensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)` Adds resultSetConcurrencyType
`void`	`addSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)` Adds TransactionIsolationLevelType
`void`	`addSystemFunction(String functionName)` Adds System function
`void`	`addTable(Table table)` Adds Table
`void`	`addTableType(TableType tableType)` Adds TableType
`void`	`addTimeDateFunction(String functionName)` Adds Time/Date function
`void`	`addUserDefinedType(UserDefinedType udt)` Adds UDT
`void`	`deleteCatalog(Catalog catalog)` Deletes Catalog
`void`	`deleteNumericFunction(String functionName)` Deletes numeric function
`void`	`deleteSchema(Schema schema)` Deletes Schema
`void`	`deleteSQLKeyword(String sqlKeyword)` Deletes SQL keyword
`void`	`deleteSqlTypeConversionPair(SqlTypeConversionPair sqlTypeConversionPair)` deletes SqlTypeConversionPair
`void`	`deleteSqlTypeInfo(SqlTypeInfo sqlTypeInfo)` Deletes SqlTypeInfo
`void`	`deleteStoredProcedure(StoredProcedure storedProcedure)` Deletes Stored Procedure
`void`	`deleteStringFunction(String functionName)` Deletes String function
`void`	`deleteSupportedForwardOnlyResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)` Deletes ResultSetConcurrencyType
`void`	`deleteSupportedResultSetType(ResultSetType resultSetType)` Deletes supported ResultSetType
`void`	`deleteSupportedScrollInsensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)` Delete ResultSetConcurrencyType
`void`	`deleteSupportedScrollSensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)` delete resultSetConcurrencyType
`void`	`deleteSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)` Deletes TransactionIsolationLevelType
`void`	`deleteSystemFunction(String functionName)` deletes System function
`void`	`deleteTable(Table table)` Deletes Table
`void`	`deleteTableType(TableType tableType)` Deletes TableType
`void`	`deleteTimeDateFunction(String functionName)` deletes Time/Date function
`void`	`deleteUserDefinedType(UserDefinedType udt)` Deletes UDT
`Catalog`	`findCatalogByName(String catalogName)` Finds catalog by its name.
`DatabaseMetaDataMethodException`	`findException(String methodName)` Searches the DatabaseMetaDataMethodException by method name
`Schema`	`findSchemaByName(String catalog, String schemaName)` Finds schema by its name.
`Set<SqlTypeConversionPair>`	`findSqlTypeConversionPairBySrcType(String srcType)` Searches set of SqlTypeConversionPair by SrcType
`SqlTypeInfo`	`findSqlTypeInfoByTypeName(String typeName)` Finds SQL type by its name.
`StoredProcedure`	`findStoredProcedureByName(String catalog, String schema, String procedureName)` Finds stored procedute by its name.
`Table`	`findTableByName(String catalog, String schema, String tableName)` Finds table by its name.
`TableType`	`findTableTypeByTypeName(String typeName)` Finds table type by its name.
`UserDefinedType`	`findUserDefinedTypeByName(String catalog, String schema, String tableName)` Finds UDT by its name.
`Set<Catalog>`	`getCatalogs()` Retrieves the catalogs available in this database
`String`	`getCatalogSeparator()` Retrieves the `String` that this database uses as the separator between a catalog and table name.
`String`	`getCatalogTerm()` Retrieves the database vendor's preferred term for "catalog".
`Integer`	`getDatabaseMajorVersion()` Retrieves the major version number of the underlying database.
`Integer`	`getDatabaseMinorVersion()` Retrieves the minor version number of the underlying database.
`String`	`getDatabaseProductName()` Retrieves the name of this database product.
`String`	`getDatabaseProductVersion()` Retrieves the version number of this database product.
`Integer`	`getDefaultTransactionIsolation()` Retrieves this database's default transaction isolation level.
`Integer`	`getDriverMajorVersion()` Retrieves this JDBC driver's minor version number.
`Integer`	`getDriverMinorVersion()` Retrieves this JDBC driver's minor version number.
`String`	`getDriverName()` Retrieves the name of this JDBC driver.
`String`	`getDriverVersion()` Retrieves the version number of this JDBC driver as a `String`.
`List<DatabaseMetaDataMethodException>`	`getExceptionList()` Returns list of failed database metadata methods through the DatabaseMetaDataMethodExceptions
`String`	`getExtraNameCharacters()` Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
`String`	`getIdentifierQuoteString()` Retrieves the string used to quote SQL identifiers.
`Integer`	`getJDBCMajorVersion()` Retrieves the major JDBC version number for this driver.
`Integer`	`getJDBCMinorVersion()` Retrieves the minor JDBC version number for this driver.
`Integer`	`getMaxBinaryLiteralLength()` Retrieves the maximum number of hex characters this database allows in an inline binary literal.
`Integer`	`getMaxCatalogNameLength()` Retrieves the maximum number of characters that this database allows in a catalog name.
`Integer`	`getMaxCharLiteralLength()` Retrieves the maximum number of characters this database allows for a character literal.
`Integer`	`getMaxColumnNameLength()` Retrieves the maximum number of characters this database allows for a column name.
`Integer`	`getMaxColumnsInGroupBy()` Retrieves the maximum number of columns this database allows in a `GROUP BY` clause.
`Integer`	`getMaxColumnsInIndex()` Retrieves the maximum number of columns this database allows in an index.
`Integer`	`getMaxColumnsInOrderBy()` Retrieves the maximum number of columns this database allows in an `ORDER BY` clause.
`Integer`	`getMaxColumnsInSelect()` Retrieves the maximum number of columns this database allows in a `SELECT` list.
`Integer`	`getMaxColumnsInTable()` Retrieves the maximum number of columns this database allows in a table.
`Integer`	`getMaxConnections()` Retrieves the maximum number of concurrent connections to this database that are possible.
`Integer`	`getMaxCursorNameLength()` Retrieves the maximum number of characters that this database allows in a cursor name.
`Integer`	`getMaxIndexLength()` Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.
`Integer`	`getMaxProcedureNameLength()` Retrieves the maximum number of characters that this database allows in a procedure name.
`Integer`	`getMaxRowSize()` Retrieves the maximum number of bytes this database allows in a single row.
`Integer`	`getMaxSchemaNameLength()` Retrieves the maximum number of characters that this database allows in a schema name.
`Integer`	`getMaxStatementLength()` Retrieves the maximum number of characters this database allows in an SQL statement.
`Integer`	`getMaxStatements()` Retrieves the maximum number of active statements to this database that can be open at the same time.
`Integer`	`getMaxTableNameLength()` Retrieves the maximum number of characters this database allows in a table name.
`Integer`	`getMaxTablesInSelect()` Retrieves the maximum number of tables this database allows in a `SELECT` statement.
`Integer`	`getMaxUserNameLength()` Retrieves the maximum number of characters this database allows in a user name.
`String`	`getName()` Gets database name
`Set<String>`	`getNumericFunctions()` Retrieves a list of math functions available with this database.
`String`	`getProcedureTerm()` Retrieves the database vendor's preferred term for "procedure".
`ResultSetHoldabilityType`	`getResultSetHoldabilityType()` Retrieves the default holdability of this `ResultSet` object.
`Set<Schema>`	`getSchemas()` Retrieves the schemas available in this database.
`String`	`getSchemaTerm()` Retrieves the database vendor's preferred term for "schema".
`String`	`getSearchStringEscape()` Retrieves the string that can be used to escape wildcard characters.
`Set<String>`	`getSQLKeywords()` Retrieves a list of all of this database's SQL keywords that are NOT also SQL92 keywords.
`SQLStateType`	`getSQLStateType()` Indicates whether the SQLSTATE returned by `SQLException.getSQLState` is X/Open (now known as Open Group) SQL CLI or SQL99.
`Set<SqlTypeInfo>`	`getSqlTypeInfos()` Retrieves a description of all the standard SQL types supported by this database
`Set<StoredProcedure>`	`getStoredProcedures()` Retrieves a description of the stored procedures available in the given catalog.
`Set<String>`	`getStringFunctions()` Retrieves a list of string functions available with this database.
`Set<SqlTypeConversionPair>`	`getSupportedConversions()` Retrieves whether this database supports the `CONVERT` for given SQL types.
`Set<ResultSetConcurrencyType>`	`getSupportedForwardOnlyResultSetConcurrencies()` Retrieves database supported concurrencies for the given result set type.
`Set<ResultSetType>`	`getSupportedResultSetTypes()` Retrieves database supported result set types.
`Set<ResultSetConcurrencyType>`	`getSupportedScrollInsensitiveResultSetConcurrencies()` Retrieves database supported concurrencies for the given result set type.
`Set<ResultSetConcurrencyType>`	`getSupportedScrollSensitiveResultSetConcurrencies()` Retrieves database supported concurrencies for the given result set type.
`Set<TransactionIsolationLevelType>`	`getSupportedTransactionIsolationLevels()` Retrieves list of database supported transaction isolation levels.
`Set<String>`	`getSystemFunctions()` Retrieves a list of system functions available with this database.
`Set<Table>`	`getTables()` Retrieves a description of the tables available in the given catalog.
`Set<TableType>`	`getTableTypes()` Retrieves the table types available in this database.
`Set<String>`	`getTimeDateFunctions()` Retrieves a list of the time and date functions available with this database.
`String`	`getURL()` Retrieves the URL for this DBMS.
`Set<UserDefinedType>`	`getUserDefinedTypes()` Retrieves a description of the UDT available in the given catalog.
`String`	`getUserName()` Retrieves the user name as known to this database.
`Boolean`	`isAllProceduresAreCallable()` Retrieves whether the current user can call all the procedures returned by the method `DatabaseMetaData.getProcedures`.
`Boolean`	`isAllTablesAreSelectable()` Retrieves whether the current user can use all the tables returned by the method `DatabaseMetaData.getTables` in a `SELECT` statement.
`Boolean`	`isCatalogAtStart()` Retrieves whether a catalog appears at the start of a fully qualified table name.
`boolean`	`isDatabaseMetaDataMethodFailed(String methodName)` Checks that specified database metadata method of provider is failed or not
`Boolean`	`isDataDefinitionCausesTransactionCommit()` Retrieves whether a data definition statement within a transaction forces the transaction to commit.
`Boolean`	`isDataDefinitionIgnoredInTransactions()` Retrieves whether this database ignores a data definition statement within a transaction.
`Boolean`	`isForwardOnlyResultInsertsAreDetected()` Retrieves whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
`Boolean`	`isForwardOnlyResultSetDeletesAreDetected()` Retrieves whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
`Boolean`	`isForwardOnlyResultSetOthersDeletesAreVisible()` Retrieves whether deletes made by others are visible.
`Boolean`	`isForwardOnlyResultSetOthersInsertsAreVisible()` Retrieves whether inserts made by others are visible.
`Boolean`	`isForwardOnlyResultSetOthersUpdatesAreVisible()` Retrieves whether updates made by others are visible.
`Boolean`	`isForwardOnlyResultSetOwnDeletesAreVisible()` Retrieves whether a result set's own deletes are visible.
`Boolean`	`isForwardOnlyResultSetOwnInsertsAreVisible()` Retrieves whether a result set's own inserts are visible.
`Boolean`	`isForwardOnlyResultSetOwnUpdatesAreVisible()` Retrieves whether for the given type of `ResultSet` object, the result set's own updates are visible.
`Boolean`	`isForwardOnlyResultSetUpdatesAreDetected()` Retrieves whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`Boolean`	`isLocatorsUpdateCopy()` Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
`Boolean`	`isMaxRowSizeIncludeBlobs()` Retrieves whether the return value for the method `getMaxRowSize` includes the SQL data types `LONGVARCHAR` and `LONGVARBINARY`.
`Boolean`	`isNullPlusNonNullIsNull()` Retrieves whether this database supports concatenations between `NULL` and non-`NULL` values being `NULL`.
`Boolean`	`isNullsAreSortedAtEnd()` Retrieves whether `NULL` values are sorted at the end regardless of sort order.
`Boolean`	`isNullsAreSortedAtStart()` Retrieves whether `NULL` values are sorted at the start regardless of sort order.
`Boolean`	`isNullsAreSortedHigh()` Retrieves whether `NULL` values are sorted high.
`Boolean`	`isNullsAreSortedLow()` Retrieves whether `NULL` values are sorted low.
`Boolean`	`isNumericFunctionSupported(String functionName)` Is Numeric function supported
`Boolean`	`isReadOnly()` Retrieves whether this database is in read-only mode.
`Boolean`	`isScrollInsensitiveResultInsertsAreDetected()` Retrieves whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
`Boolean`	`isScrollInsensitiveResultSetDeletesAreDetected()` Retrieves whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
`Boolean`	`isScrollInsensitiveResultSetOthersDeletesAreVisible()` Retrieves whether deletes made by others are visible.
`Boolean`	`isScrollInsensitiveResultSetOthersInsertsAreVisible()` Retrieves whether inserts made by others are visible.
`Boolean`	`isScrollInsensitiveResultSetOthersUpdatesAreVisible()` Retrieves whether updates made by others are visible.
`Boolean`	`isScrollInsensitiveResultSetOwnDeletesAreVisible()` Retrieves whether a result set's own deletes are visible.
`Boolean`	`isScrollInsensitiveResultSetOwnInsertsAreVisible()` Retrieves whether a result set's own inserts are visible.
`Boolean`	`isScrollInsensitiveResultSetOwnUpdatesAreVisible()` Retrieves whether for the given type of `ResultSet` object, the result set's own updates are visible.
`Boolean`	`isScrollInsensitiveResultSetUpdatesAreDetected()` Retrieves whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`Boolean`	`isScrollSensitiveResultInsertsAreDetected()` Retrieves whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
`Boolean`	`isScrollSensitiveResultSetDeletesAreDetected()` Retrieves whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
`Boolean`	`isScrollSensitiveResultSetOthersDeletesAreVisible()` Retrieves whether deletes made by others are visible.
`Boolean`	`isScrollSensitiveResultSetOthersInsertsAreVisible()` Retrieves whether inserts made by others are visible.
`Boolean`	`isScrollSensitiveResultSetOthersUpdatesAreVisible()` Retrieves whether updates made by others are visible.
`Boolean`	`isScrollSensitiveResultSetOwnDeletesAreVisible()` Retrieves whether a result set's own deletes are visible.
`Boolean`	`isScrollSensitiveResultSetOwnInsertsAreVisible()` Retrieves whether a result set's own inserts are visible.
`Boolean`	`isScrollSensitiveResultSetOwnUpdatesAreVisible()` Retrieves whether for the given type of `ResultSet` object, the result set's own updates are visible.
`Boolean`	`isScrollSensitiveResultSetUpdatesAreDetected()` Retrieves whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`Boolean`	`isSQLKeywordSupported(String sqlKeyword)` Is SQL keyword supported
`Boolean`	`isStoresLowerCaseIdentifiers()` Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
`Boolean`	`isStoresLowerCaseQuotedIdentifiers()` Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
`Boolean`	`isStoresMixedCaseIdentifiers()` Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
`Boolean`	`isStoresMixedCaseQuotedIdentifiers()` Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
`Boolean`	`isStoresUpperCaseIdentifiers()` Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
`Boolean`	`isStoresUpperCaseQuotedIdentifiers()` Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
`Boolean`	`isStringFunctionSupported(String functionName)` Is String function supported
`Boolean`	`isSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)` Is supported TransactionIsolationLevelType
`Boolean`	`isSupportsAlterTableWithAddColumn()` Retrieves whether this database supports `ALTER TABLE` with add column.
`Boolean`	`isSupportsAlterTableWithDropColumn()` Retrieves whether this database supports `ALTER TABLE` with drop column.
`Boolean`	`isSupportsANSI92EntryLevelSQL()` Retrieves whether this database supports the ANSI92 entry level SQL grammar.
`Boolean`	`isSupportsANSI92FullSQL()` Retrieves whether this database supports the ANSI92 full SQL grammar supported.
`Boolean`	`isSupportsANSI92IntermediateSQL()` Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
`Boolean`	`isSupportsBatchUpdates()` Retrieves whether this database supports batch updates.
`Boolean`	`isSupportsCatalogsInDataManipulation()` Retrieves whether a catalog name can be used in a data manipulation statement.
`Boolean`	`isSupportsCatalogsInIndexDefinitions()` Retrieves whether a catalog name can be used in an index definition statement.
`Boolean`	`isSupportsCatalogsInPrivilegeDefinitions()` Retrieves whether a catalog name can be used in a privilege definition statement.
`Boolean`	`isSupportsCatalogsInProcedureCalls()` Retrieves whether a catalog name can be used in a procedure call statement.
`Boolean`	`isSupportsCatalogsInTableDefinitions()` Retrieves whether a catalog name can be used in a table definition statement.
`Boolean`	`isSupportsColumnAliasing()` Retrieves whether this database supports column aliasing.
`Boolean`	`isSupportsConvert()` Retrieves whether this database supports the `CONVERT` function between SQL types.
`Boolean`	`isSupportsCoreSQLGrammar()` Retrieves whether this database supports the ODBC Core SQL grammar.
`Boolean`	`isSupportsCorrelatedSubqueries()` Retrieves whether this database supports correlated subqueries.
`Boolean`	`isSupportsDataDefinitionAndDataManipulationTransactions()` Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
`Boolean`	`isSupportsDataManipulationTransactionsOnly()` Retrieves whether this database supports only data manipulation statements within a transaction.
`Boolean`	`isSupportsDifferentTableCorrelationNames()` Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
`Boolean`	`isSupportsExpressionsInOrderBy()` Retrieves whether this database supports expressions in `ORDER BY` lists.
`Boolean`	`isSupportsExtendedSQLGrammar()` Retrieves whether this database supports the ODBC Extended SQL grammar.
`Boolean`	`isSupportsFullOuterJoins()` Retrieves whether this database supports full nested outer joins.
`Boolean`	`isSupportsGetGeneratedKeys()` Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
`Boolean`	`isSupportsGroupBy()` Retrieves whether this database supports some form of `GROUP BY` clause.
`Boolean`	`isSupportsGroupByBeyondSelect()` 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.
`Boolean`	`isSupportsGroupByUnrelated()` Retrieves whether this database supports using a column that is not in the `SELECT` statement in a `GROUP BY` clause.
`Boolean`	`isSupportsIntegrityEnhancementFacility()` Retrieves whether this database supports the SQL Integrity Enhancement Facility.
`Boolean`	`isSupportsLikeEscapeClause()` Retrieves whether this database supports specifying a `LIKE` escape clause.
`Boolean`	`isSupportsLimitedOuterJoins()` Retrieves whether this database provides limited support for outer joins.
`Boolean`	`isSupportsMinimumSQLGrammar()` Retrieves whether this database supports the ODBC Minimum SQL grammar.
`Boolean`	`isSupportsMixedCaseIdentifiers()` Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
`Boolean`	`isSupportsMixedCaseQuotedIdentifiers()` Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
`Boolean`	`isSupportsMultipleOpenResults()` Retrieves whether it is possible to have multiple `ResultSet` objects returned from a `CallableStatement` object simultaneously.
`Boolean`	`isSupportsMultipleResultSets()` Retrieves whether this database supports getting multiple `ResultSet` objects from a single call to the method `execute`.
`Boolean`	`isSupportsMultipleTransactions()` Retrieves whether this database allows having multiple transactions open at once (on different connections).
`Boolean`	`isSupportsNamedParameters()` Retrieves whether this database supports named parameters to callable statements.
`Boolean`	`isSupportsNonNullableColumns()` Retrieves whether columns in this database may be defined as non-nullable.
`Boolean`	`isSupportsOpenCursorsAcrossCommit()` Retrieves whether this database supports keeping cursors open across commits.
`Boolean`	`isSupportsOpenCursorsAcrossRollback()` Retrieves whether this database supports keeping cursors open across rollbacks.
`Boolean`	`isSupportsOpenStatementsAcrossCommit()` Retrieves whether this database supports keeping statements open across commits.
`Boolean`	`isSupportsOpenStatementsAcrossRollback()` Retrieves whether this database supports keeping statements open across rollbacks.
`Boolean`	`isSupportsOrderByUnrelated()` Retrieves whether this database supports using a column that is not in the `SELECT` statement in an `ORDER BY` clause.
`Boolean`	`isSupportsOuterJoins()` Retrieves whether this database supports some form of outer join.
`Boolean`	`isSupportsPositionedDelete()` Retrieves whether this database supports positioned `DELETE` statements.
`Boolean`	`isSupportsPositionedUpdate()` Retrieves whether this database supports positioned `UPDATE` statements.
`Boolean`	`isSupportsResultSetCloseCurrorsAtCommitHoldability()` Retrieves whether this database supports the given result set holdability.
`Boolean`	`isSupportsResultSetHoldCurrorsOverCommitHoldability()` Retrieves whether this database supports the given result set holdability.
`Boolean`	`isSupportsSavepoints()` Retrieves whether this database supports savepoints.
`Boolean`	`isSupportsSchemasInDataManipulation()` Retrieves whether a schema name can be used in a data manipulation statement.
`Boolean`	`isSupportsSchemasInIndexDefinitions()` Retrieves whether a schema name can be used in an index definition statement.
`Boolean`	`isSupportsSchemasInPrivilegeDefinitions()` Retrieves whether a schema name can be used in a privilege definition statement.
`Boolean`	`isSupportsSchemasInProcedureCalls()` Retrieves whether a schema name can be used in a procedure call statement.
`Boolean`	`isSupportsSchemasInTableDefinitions()` Retrieves whether a schema name can be used in a table definition statement.
`Boolean`	`isSupportsSelectForUpdate()` Retrieves whether this database supports `SELECT FOR UPDATE` statements.
`Boolean`	`isSupportsStatementPooling()` Retrieves whether this database supports statement pooling.
`Boolean`	`isSupportsStoredProcedures()` Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
`Boolean`	`isSupportsSubqueriesInComparisons()` Retrieves whether this database supports subqueries in comparison expressions.
`Boolean`	`isSupportsSubqueriesInExists()` Retrieves whether this database supports subqueries in `EXISTS` expressions.
`Boolean`	`isSupportsSubqueriesInIns()` Retrieves whether this database supports subqueries in `IN` statements.
`Boolean`	`isSupportsSubqueriesInQuantifieds()` Retrieves whether this database supports subqueries in quantified expressions.
`Boolean`	`isSupportsTableCorrelationNames()` Retrieves whether this database supports table correlation names.
`Boolean`	`isSupportsTransactions()` Retrieves whether this database supports transactions.
`Boolean`	`isSupportsUnion()` Retrieves whether this database supports SQL `UNION`.
`Boolean`	`isSupportsUnionAll()` Retrieves whether this database supports SQL `UNION ALL`.
`Boolean`	`isSystemFunctionSupported(String functionName)` Is System function supported
`Boolean`	`isTimeDateFunctionSupported(String functionName)` Is Time/Date function supported
`Boolean`	`isUsesLocalFilePerTable()` Retrieves whether this database uses a file for each table.
`Boolean`	`isUsesLocalFiles()` Retrieves whether this database stores tables in a local file.
`void`	`setAllProceduresAreCallable(Boolean allProceduresAreCallable)` sets whether the current user can call all the procedures returned by the method `DatabaseMetaData.getProcedures`.
`void`	`setAllTablesAreSelectable(Boolean allTablesAreSelectable)` Sets whether the current user can use all the tables returned by the method `DatabaseMetaData.getTables` in a `SELECT` statement.
`void`	`setCatalogAtStart(Boolean catalogAtStart)` Sets whether a catalog appears at the start of a fully qualified table name.
`void`	`setCatalogSeparator(String catalogSeparator)` Sets the `String` that this database uses as the separator between a catalog and table name.
`void`	`setCatalogTerm(String catalogTerm)` Sets the database vendor's preferred term for "catalog".
`void`	`setDatabaseMajorVersion(Integer databaseMajorVersion)` Sets the major version number of the underlying database.
`void`	`setDatabaseMinorVersion(Integer databaseMinorVersion)` Sets the minor version number of the underlying database.
`void`	`setDatabaseProductName(String databaseProductName)` Sets the name of this database product.
`void`	`setDatabaseProductVersion(String databaseProductVersion)` Sets the version number of this database product.
`void`	`setDataDefinitionCausesTransactionCommit(Boolean dataDefinitionCausesTransactionCommit)` Sets whether a data definition statement within a transaction forces the transaction to commit.
`void`	`setDataDefinitionIgnoredInTransactions(Boolean dataDefinitionIgnoredInTransactions)` Sets whether this database ignores a data definition statement within a transaction.
`void`	`setDefaultTransactionIsolation(Integer defaultTransactionIsolation)` Sets this database's default transaction isolation level.
`void`	`setDriverMajorVersion(Integer driverMajorVersion)` Sets this JDBC driver's major version number.
`void`	`setDriverMinorVersion(Integer driverMinorVersion)` Sets this JDBC driver's minor version number.
`void`	`setDriverName(String driverName)` Sets the name of this JDBC driver.
`void`	`setDriverVersion(String driverVersion)` Sets the version number of this JDBC driver as a `String`.
`void`	`setExtraNameCharacters(String extraNameCharacters)` Sets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
`void`	`setForwardOnlyResultInsertsAreDetected(Boolean forwardOnlyResultInsertsAreDetected)` Sets whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
`void`	`setForwardOnlyResultSetDeletesAreDetected(Boolean forwardOnlyResultSetDeletesAreDetected)` Sets whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
`void`	`setForwardOnlyResultSetOthersDeletesAreVisible(Boolean forwardOnlyResultSetOthersDeletesAreVisible)` Sets whether deletes made by others are visible.
`void`	`setForwardOnlyResultSetOthersInsertsAreVisible(Boolean forwardOnlyResultSetOthersInsertsAreVisible)` Sets whether inserts made by others are visible.
`void`	`setForwardOnlyResultSetOthersUpdatesAreVisible(Boolean forwardOnlyResultSetOthersUpdatesAreVisible)` Sets whether updates made by others are visible.
`void`	`setForwardOnlyResultSetOwnDeletesAreVisible(Boolean forwardOnlyResultSetOwnDeletesAreVisible)` Sets whether a result set's own deletes are visible.
`void`	`setForwardOnlyResultSetOwnInsertsAreVisible(Boolean forwardOnlyResultSetOwnInsertsAreVisible)` Sets whether a result set's own inserts are visible.
`void`	`setForwardOnlyResultSetOwnUpdatesAreVisible(Boolean forwardOnlyResultSetOwnUpdatesAreVisible)` Sets whether for the given type of `ResultSet` object, the result set's own updates are visible.
`void`	`setForwardOnlyResultSetUpdatesAreDetected(Boolean forwardOnlyResultSetUpdatesAreDetected)` Sets whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`void`	`setIdentifierQuoteString(String identifierQuoteString)` Sets the string used to quote SQL identifiers.
`void`	`setJDBCMajorVersion(Integer jdbcMajorVersion)` Sets the major JDBC version number for this driver.
`void`	`setJDBCMinorVersion(Integer jdbcMinorVersion)` Sets the minor JDBC version number for this driver.
`void`	`setLocatorsUpdateCopy(Boolean locatorsUpdateCopy)` Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
`void`	`setMaxBinaryLiteralLength(Integer maxBinaryLiteralLength)` sets the maximum number of hex characters this database allows in an inline binary literal.
`void`	`setMaxCatalogNameLength(Integer maxCatalogNameLength)` Sets the maximum number of characters that this database allows in a catalog name.
`void`	`setMaxCharLiteralLength(Integer maxCharLiteralLength)` Sets the maximum number of characters this database allows for a character literal.
`void`	`setMaxColumnNameLength(Integer maxColumnNameLength)` Sets the maximum number of characters this database allows for a column name.
`void`	`setMaxColumnsInGroupBy(Integer maxColumnsInGroupBy)` Sets the maximum number of columns this database allows in a `GROUP BY` clause.
`void`	`setMaxColumnsInIndex(Integer maxColumnsInIndex)` Sets the maximum number of columns this database allows in an index.
`void`	`setMaxColumnsInOrderBy(Integer maxColumnsInOrderBy)` Sets the maximum number of columns this database allows in an `ORDER BY` clause.
`void`	`setMaxColumnsInSelect(Integer maxColumnsInSelect)` Sets the maximum number of columns this database allows in a `SELECT` list.
`void`	`setMaxColumnsInTable(Integer maxColumnsInTable)` Sets the maximum number of columns this database allows in a table.
`void`	`setMaxConnections(Integer maxConnections)` Sets the maximum number of concurrent connections to this database that are possible.
`void`	`setMaxCursorNameLength(Integer maxCursorNameLength)` Sets the maximum number of characters that this database allows in a cursor name.
`void`	`setMaxIndexLength(Integer maxIndexLength)` Sets the maximum number of bytes this database allows for an index, including all of the parts of the index.
`void`	`setMaxProcedureNameLength(Integer maxProcedureNameLength)` Sets the maximum number of characters that this database allows in a procedure name.
`void`	`setMaxRowSize(Integer maxRowSize)` Sets the maximum number of bytes this database allows in a single row.
`void`	`setMaxRowSizeIncludeBlobs(Boolean maxRowSizeIncludeBlobs)` Sets whether the return value for the method `getMaxRowSize` includes the SQL data types `LONGVARCHAR` and `LONGVARBINARY`.
`void`	`setMaxSchemaNameLength(Integer maxSchemaNameLength)` Sets the maximum number of characters that this database allows in a schema name.
`void`	`setMaxStatementLength(Integer maxStatementLength)` Sets the maximum number of characters this database allows in an SQL statement.
`void`	`setMaxStatements(Integer maxStatements)` Sets the maximum number of active statements to this database that can be open at the same time.
`void`	`setMaxTableNameLength(Integer maxTableNameLength)` Sets the maximum number of characters this database allows in a table name.
`void`	`setMaxTablesInSelect(Integer maxTablesInSelect)` Sets the maximum number of tables this database allows in a `SELECT` statement.
`void`	`setMaxUserNameLength(Integer maxUserNameLength)` Sets the maximum number of characters this database allows in a user name.
`void`	`setName(String name)` Sets database name
`void`	`setNullPlusNonNullIsNull(Boolean nullPlusNonNullIsNull)` Sets whether this database supports concatenations between `NULL` and non-`NULL` values being `NULL`.
`void`	`setNullsAreSortedAtEnd(Boolean nullsAreSortedAtEnd)` Sets whether `NULL` values are sorted at the end regardless of sort order.
`void`	`setNullsAreSortedAtStart(Boolean nullsAreSortedAtStart)` Sets whether `NULL` values are sorted at the start regardless of sort order.
`void`	`setNullsAreSortedHigh(Boolean nullsAreSortedHigh)` Sets whether `NULL` values are sorted high.
`void`	`setNullsAreSortedLow(Boolean nullsAreSortedLow)` Sets whether `NULL` values are sorted low.
`void`	`setProcedureTerm(String procedureTerm)` Sets the database vendor's preferred term for "procedure".
`void`	`setReadOnly(Boolean readOnly)` Sets whether this database is in read-only mode.
`void`	`setResultSetHoldabilityType(ResultSetHoldabilityType resultSetHoldabilityType)` Sets the default holdability of this `ResultSet` object.
`void`	`setSchemaTerm(String schemaTerm)` Sets the database vendor's preferred term for "schema".
`void`	`setScrollInsensitiveResultInsertsAreDetected(Boolean scrollInsensitiveResultInsertsAreDetected)` Sets whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
`void`	`setScrollInsensitiveResultSetDeletesAreDetected(Boolean scrollInsensitiveResultSetDeletesAreDetected)` Sets whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
`void`	`setScrollInsensitiveResultSetOthersDeletesAreVisible(Boolean scrollInsensitiveResultSetOthersDeletesAreVisible)` Sets whether deletes made by others are visible.
`void`	`setScrollInsensitiveResultSetOthersInsertsAreVisible(Boolean scrollInsensitiveResultSetOthersInsertsAreVisible)` Sets whether inserts made by others are visible.
`void`	`setScrollInsensitiveResultSetOthersUpdatesAreVisible(Boolean scrollInsensitiveResultSetOthersUpdatesAreVisible)` Sets whether updates made by others are visible.
`void`	`setScrollInsensitiveResultSetOwnDeletesAreVisible(Boolean scrollInsensitiveResultSetOwnDeletesAreVisible)` Sets whether a result set's own deletes are visible.
`void`	`setScrollInsensitiveResultSetOwnInsertsAreVisible(Boolean scrollInsensitiveResultSetOwnInsertsAreVisible)` Sets whether a result set's own inserts are visible.
`void`	`setScrollInsensitiveResultSetOwnUpdatesAreVisible(Boolean scrollInsensitiveResultSetOwnUpdatesAreVisible)` Sets whether for the given type of `ResultSet` object, the result set's own updates are visible.
`void`	`setScrollInsensitiveResultSetUpdatesAreDetected(Boolean scrollInsensitiveResultSetUpdatesAreDetected)` Sets whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`void`	`setScrollSensitiveResultInsertsAreDetected(Boolean scrollSensitiveResultInsertsAreDetected)` Sets whether or not a visible row insert can be detected by calling the method `ResultSet.rowInserted`.
`void`	`setScrollSensitiveResultSetDeletesAreDetected(Boolean scrollSensitiveResultSetDeletesAreDetected)` Sets whether or not a visible row delete can be detected by calling the method `ResultSet.rowDeleted`.
`void`	`setScrollSensitiveResultSetOthersDeletesAreVisible(Boolean scrollSensitiveResultSetOthersDeletesAreVisible)` Sets whether deletes made by others are visible.
`void`	`setScrollSensitiveResultSetOthersInsertsAreVisible(Boolean scrollSensitiveResultSetOthersInsertsAreVisible)` Sets whether inserts made by others are visible.
`void`	`setScrollSensitiveResultSetOthersUpdatesAreVisible(Boolean scrollSensitiveResultSetOthersUpdatesAreVisible)` Sets whether updates made by others are visible.
`void`	`setScrollSensitiveResultSetOwnDeletesAreVisible(Boolean scrollSensitiveResultSetOwnDeletesAreVisible)` Sets whether a result set's own deletes are visible.
`void`	`setScrollSensitiveResultSetOwnInsertsAreVisible(Boolean scrollSensitiveResultSetOwnInsertsAreVisible)` Sets whether a result set's own inserts are visible.
`void`	`setScrollSensitiveResultSetOwnUpdatesAreVisible(Boolean scrollSensitiveResultSetOwnUpdatesAreVisible)` Sets whether for the given type of `ResultSet` object, the result set's own updates are visible.
`void`	`setScrollSensitiveResultSetUpdatesAreDetected(Boolean scrollSensitiveResultSetUpdatesAreDetected)` Sets whether or not a visible row update can be detected by calling the method `ResultSet.rowUpdated`.
`void`	`setSearchStringEscape(String searchStringEscape)` Sets the string that can be used to escape wildcard characters.
`void`	`setSQLStateType(SQLStateType sqlStateType)` Indicates whether the SQLSTATE returned by `SQLException.getSQLState` is X/Open (now known as Open Group) SQL CLI or SQL99.
`void`	`setStoresLowerCaseIdentifiers(Boolean storesLowerCaseIdentifiers)` sets whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
`void`	`setStoresLowerCaseQuotedIdentifiers(Boolean storesLowerCaseQuotedIdentifiers)` Sets whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
`void`	`setStoresMixedCaseIdentifiers(Boolean storesMixedCaseIdentifiers)` Sets whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
`void`	`setStoresMixedCaseQuotedIdentifiers(Boolean storesMixedCaseQuotedIdentifiers)` Sets whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
`void`	`setStoresUpperCaseIdentifiers(Boolean storesUpperCaseIdentifiers)` Sets whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
`void`	`setStoresUpperCaseQuotedIdentifiers(Boolean storesUpperCaseQuotedIdentifiers)` Sets whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
`void`	`setSupportsAlterTableWithAddColumn(Boolean supportsAlterTableWithAddColumn)` Sets whether this database supports `ALTER TABLE` with add column.
`void`	`setSupportsAlterTableWithDropColumn(Boolean supportsAlterTableWithDropColumn)` Sets whether this database supports `ALTER TABLE` with drop column.
`void`	`setSupportsANSI92EntryLevelSQL(Boolean supportsANSI92EntryLevelSQL)` Sets whether this database supports the ANSI92 entry level SQL grammar.
`void`	`setSupportsANSI92FullSQL(Boolean supportsANSI92FullSQL)` Sets whether this database supports the ANSI92 full SQL grammar supported.
`void`	`setSupportsANSI92IntermediateSQL(Boolean supportsANSI92IntermediateSQL)` Sets whether this database supports the ANSI92 intermediate SQL grammar supported.
`void`	`setSupportsBatchUpdates(Boolean supportsBatchUpdates)` Sets whether this database supports batch updates.
`void`	`setSupportsCatalogsInDataManipulation(Boolean supportsCatalogsInDataManipulation)` Sets whether a catalog name can be used in a data manipulation statement.
`void`	`setSupportsCatalogsInIndexDefinitions(Boolean supportsCatalogsInIndexDefinitions)` Sets whether a catalog name can be used in an index definition statement.
`void`	`setSupportsCatalogsInPrivilegeDefinitions(Boolean supportsCatalogsInPrivilegeDefinitions)` Sets whether a catalog name can be used in a privilege definition statement.
`void`	`setSupportsCatalogsInProcedureCalls(Boolean supportsCatalogsInProcedureCalls)` Sets whether a catalog name can be used in a procedure call statement.
`void`	`setSupportsCatalogsInTableDefinitions(Boolean supportsCatalogsInTableDefinitions)` Sets whether a catalog name can be used in a table definition statement.
`void`	`setSupportsColumnAliasing(Boolean supportsColumnAliasing)` Sets whether this database supports column aliasing.
`void`	`setSupportsConvert(Boolean supportsConvert)` Sets whether this database supports the `CONVERT` function between SQL types.
`void`	`setSupportsCoreSQLGrammar(Boolean supportsCoreSQLGrammar)` Sets whether this database supports the ODBC Core SQL grammar.
`void`	`setSupportsCorrelatedSubqueries(Boolean supportsCorrelatedSubqueries)` Sets whether this database supports correlated subqueries.
`void`	`setSupportsDataDefinitionAndDataManipulationTransactions(Boolean supportsDataDefinitionAndDataManipulationTransactions)` Sets whether this database supports both data definition and data manipulation statements within a transaction.
`void`	`setSupportsDataManipulationTransactionsOnly(Boolean supportsDataManipulationTransactionsOnly)` Sets whether this database supports only data manipulation statements within a transaction.
`void`	`setSupportsDifferentTableCorrelationNames(Boolean supportsDifferentTableCorrelationNames)` Sets whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
`void`	`setSupportsExpressionsInOrderBy(Boolean supportsExpressionsInOrderBy)` Sets whether this database supports expressions in `ORDER BY` lists.
`void`	`setSupportsExtendedSQLGrammar(Boolean supportsExtendedSQLGrammar)` Sets whether this database supports the ODBC Extended SQL grammar.
`void`	`setSupportsFullOuterJoins(Boolean supportsFullOuterJoins)` Sets whether this database supports full nested outer joins.
`void`	`setSupportsGetGeneratedKeys(Boolean supportsGetGeneratedKeys)` Sets whether auto-generated keys can be retrieved after a statement has been executed.
`void`	`setSupportsGroupBy(Boolean supportsGroupBy)` Sets whether this database supports some form of `GROUP BY` clause.
`void`	`setSupportsGroupByBeyondSelect(Boolean supportsGroupByBeyondSelect)` Sets 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.
`void`	`setSupportsGroupByUnrelated(Boolean supportsGroupByUnrelated)` Sets whether this database supports using a column that is not in the `SELECT` statement in a `GROUP BY` clause.
`void`	`setSupportsIntegrityEnhancementFacility(Boolean supportsIntegrityEnhancementFacility)` Sets whether this database supports the SQL Integrity Enhancement Facility.
`void`	`setSupportsLikeEscapeClause(Boolean supportsLikeEscapeClause)` Sets whether this database supports specifying a `LIKE` escape clause.
`void`	`setSupportsLimitedOuterJoins(Boolean supportsLimitedOuterJoins)` Sets whether this database provides limited support for outer joins.
`void`	`setSupportsMinimumSQLGrammar(Boolean supportsMinimumSQLGrammar)` Sets whether this database supports the ODBC Minimum SQL grammar.
`void`	`setSupportsMixedCaseIdentifiers(Boolean supportsMixedCaseIdentifiers)` Sets whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
`void`	`setSupportsMixedCaseQuotedIdentifiers(Boolean supportsMixedCaseQuotedIdentifiers)` Sets whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
`void`	`setSupportsMultipleOpenResults(Boolean supportsMultipleOpenResults)` Sets whether it is possible to have multiple `ResultSet` objects returned from a `CallableStatement` object simultaneously.
`void`	`setSupportsMultipleResultSets(Boolean supportsMultipleResultSets)` Sets whether this database supports getting multiple `ResultSet` objects from a single call to the method `execute`.
`void`	`setSupportsMultipleTransactions(Boolean supportsMultipleTransactions)` Sets whether this database allows having multiple transactions open at once (on different connections).
`void`	`setSupportsNamedParameters(Boolean supportsNamedParameters)` Sets whether this database supports named parameters to callable statements.
`void`	`setSupportsNonNullableColumns(Boolean supportsNonNullableColumns)` Sets whether columns in this database may be defined as non-nullable.
`void`	`setSupportsOpenCursorsAcrossCommit(Boolean supportsOpenCursorsAcrossCommit)` Sets whether this database supports keeping cursors open across commits.
`void`	`setSupportsOpenCursorsAcrossRollback(Boolean supportsOpenCursorsAcrossRollback)` Sets whether this database supports keeping cursors open across rollbacks.
`void`	`setSupportsOpenStatementsAcrossCommit(Boolean supportsOpenStatementsAcrossCommit)` sets whether this database supports keeping statements open across commits.
`void`	`setSupportsOpenStatementsAcrossRollback(Boolean supportsOpenStatementsAcrossRollback)` Sets whether this database supports keeping statements open across rollbacks.
`void`	`setSupportsOrderByUnrelated(Boolean supportsOrderByUnrelated)` Sets whether this database supports using a column that is not in the `SELECT` statement in an `ORDER BY` clause.
`void`	`setSupportsOuterJoins(Boolean supportsOuterJoins)` Sets whether this database supports some form of outer join.
`void`	`setSupportsPositionedDelete(Boolean supportsPositionedDelete)` Sets whether this database supports positioned `DELETE` statements.
`void`	`setSupportsPositionedUpdate(Boolean supportsPositionedUpdate)` Sets whether this database supports positioned `UPDATE` statements.
`void`	`setSupportsResultSetCloseCurrorsAtCommitHoldability(Boolean supportsResultSetCloseCurrorsAtCommitHoldability)` Sets whether this database supports the given result set holdability.
`void`	`setSupportsResultSetHoldCurrorsOverCommitHoldability(Boolean supportsResultSetHoldCurrorsOverCommitHoldability)` Sets whether this database supports the given result set holdability.
`void`	`setSupportsSavepoints(Boolean supportsSavepoints)` Sets whether this database supports savepoints.
`void`	`setSupportsSchemasInDataManipulation(Boolean supportsSchemasInDataManipulation)` Sets whether a schema name can be used in a data manipulation statement.
`void`	`setSupportsSchemasInIndexDefinitions(Boolean supportsSchemasInIndexDefinitions)` Sets whether a schema name can be used in an index definition statement.
`void`	`setSupportsSchemasInPrivilegeDefinitions(Boolean supportsSchemasInPrivilegeDefinitions)` Sets whether a schema name can be used in a privilege definition statement.
`void`	`setSupportsSchemasInProcedureCalls(Boolean supportsSchemasInProcedureCalls)` Sets whether a schema name can be used in a procedure call statement.
`void`	`setSupportsSchemasInTableDefinitions(Boolean supportsSchemasInTableDefinitions)` Sets whether a schema name can be used in a table definition statement.
`void`	`setSupportsSelectForUpdate(Boolean supportsSelectForUpdate)` Sets whether this database supports `SELECT FOR UPDATE` statements.
`void`	`setSupportsStatementPooling(Boolean supportsStatementPooling)` Sets whether this database supports statement pooling.
`void`	`setSupportsStoredProcedures(Boolean supportsStoredProcedures)` Sets whether this database supports stored procedure calls that use the stored procedure escape syntax.
`void`	`setSupportsSubqueriesInComparisons(Boolean supportsSubqueriesInComparisons)` Retrieves whether this database supports subqueries in comparison expressions.
`void`	`setSupportsSubqueriesInExists(Boolean supportsSubqueriesInExists)` Sets whether this database supports subqueries in `EXISTS` expressions.
`void`	`setSupportsSubqueriesInIns(Boolean supportsSubqueriesInIns)` Sets whether this database supports subqueries in `IN` statements.
`void`	`setSupportsSubqueriesInQuantifieds(Boolean supportsSubqueriesInQuantifieds)` Sets whether this database supports subqueries in quantified expressions.
`void`	`setSupportsTableCorrelationNames(Boolean supportsTableCorrelationNames)` Sets whether this database supports table correlation names.
`void`	`setSupportsTransactions(Boolean supportsTransactions)` Sets whether this database supports transactions.
`void`	`setSupportsUnion(Boolean supportsUnion)` Sets whether this database supports SQL `UNION`.
`void`	`setSupportsUnionAll(Boolean supportsUnionAll)` Sets whether this database supports SQL `UNION ALL`.
`void`	`setURL(String url)` Sets the URL for this DBMS.
`void`	`setUserName(String userName)` Sets the user name as known to this database.
`void`	`setUsesLocalFilePerTable(Boolean usesLocalFilePerTable)` Sets whether this database uses a file for each table.
`void`	`setUsesLocalFiles(Boolean usesLocalFiles)` Sets whether this database stores tables in a local file.

Method Detail

getExceptionList

List<DatabaseMetaDataMethodException> getExceptionList()

Returns list of failed database metadata methods through the DatabaseMetaDataMethodExceptions

Returns:: list of failed database metadata methods through the DatabaseMetaDataMethodExceptions

addException

void addException(DatabaseMetaDataMethodException exception)

Adds the DatabaseMetaDataMethodException to the DatabaseMetadataProvider exception list

Parameters:: exception - the DatabaseMetaDataMethodException

findException

DatabaseMetaDataMethodException findException(String methodName)

Searches the DatabaseMetaDataMethodException by method name

Parameters:: methodName - the name of method that caused exception
Returns:: the DatabaseMetaDataMethodException if found, otherwise returns null

isDatabaseMetaDataMethodFailed

boolean isDatabaseMetaDataMethodFailed(String methodName)

Checks that specified database metadata method of provider is failed or not

Parameters:: methodName - the name of method that caused exception
Returns:: true if method failed; false otherwise

getName

String getName()

Gets database name

Returns:: database name

setName

void setName(String name)

Sets database name

Parameters:: name - the database name

isAllProceduresAreCallable

Boolean isAllProceduresAreCallable()

Retrieves whether the current user can call all the procedures returned by the method DatabaseMetaData.getProcedures.

Returns:: true if so; false otherwise

setAllProceduresAreCallable

void setAllProceduresAreCallable(Boolean allProceduresAreCallable)

sets whether the current user can call all the procedures returned by the method DatabaseMetaData.getProcedures.

Parameters:: allProceduresAreCallable - true if so; false otherwise

isAllTablesAreSelectable

Boolean isAllTablesAreSelectable()

Retrieves whether the current user can use all the tables returned by the method DatabaseMetaData.getTables in a SELECT statement.

Returns:: true if so; false otherwise

setAllTablesAreSelectable

void setAllTablesAreSelectable(Boolean allTablesAreSelectable)

Sets whether the current user can use all the tables returned by the method DatabaseMetaData.getTables in a SELECT statement.

Parameters:: allTablesAreSelectable - true if so; false otherwise

getURL

String getURL()

Retrieves the URL for this DBMS.

Returns:: the URL for this DBMS or null if it cannot be generated

setURL

void setURL(String url)

Sets the URL for this DBMS.

Parameters:: url - the URL for this DBMS or null if it cannot be generated

getUserName

String getUserName()

Retrieves the user name as known to this database.

Returns:: the database user name

setUserName

void setUserName(String userName)

Sets the user name as known to this database.

Parameters:: userName - the database user name

isReadOnly

Boolean isReadOnly()

Retrieves whether this database is in read-only mode.

Returns:: true if so; false otherwise

setReadOnly

void setReadOnly(Boolean readOnly)

Sets whether this database is in read-only mode.

Parameters:: readOnly - true if so; false otherwise

isNullsAreSortedHigh

Boolean isNullsAreSortedHigh()

Retrieves whether NULL values are sorted high. Sorted high means that NULL values sort higher than any other value in a domain. In an ascending order, if this method returns true, NULL values will appear at the end. By contrast, the method DatabaseMetaData.nullsAreSortedAtEnd indicates whether NULL values are sorted at the end regardless of sort order.

Returns:: true if so; false otherwise

setNullsAreSortedHigh

void setNullsAreSortedHigh(Boolean nullsAreSortedHigh)

Sets whether NULL values are sorted high. Sorted high means that NULL values sort higher than any other value in a domain. In an ascending order, if this method returns true, NULL values will appear at the end. By contrast, the method DatabaseMetaData.nullsAreSortedAtEnd indicates whether NULL values are sorted at the end regardless of sort order.

Parameters:: nullsAreSortedHigh - true if so; false otherwise

isNullsAreSortedLow

Boolean isNullsAreSortedLow()

Retrieves whether NULL values are sorted low. Sorted low means that NULL values sort lower than any other value in a domain. In an ascending order, if this method returns true, NULL values will appear at the beginning. By contrast, the method DatabaseMetaData.nullsAreSortedAtStart indicates whether NULL values are sorted at the beginning regardless of sort order.

Returns:: true if so; false otherwise

setNullsAreSortedLow

void setNullsAreSortedLow(Boolean nullsAreSortedLow)

Sets whether NULL values are sorted low. Sorted low means that NULL values sort lower than any other value in a domain. In an ascending order, if this method returns true, NULL values will appear at the beginning. By contrast, the method DatabaseMetaData.nullsAreSortedAtStart indicates whether NULL values are sorted at the beginning regardless of sort order.

Parameters:: nullsAreSortedLow - true if so; false otherwise

isNullsAreSortedAtStart

Boolean isNullsAreSortedAtStart()

Retrieves whether NULL values are sorted at the start regardless of sort order.

Returns:: true if so; false otherwise

setNullsAreSortedAtStart

void setNullsAreSortedAtStart(Boolean nullsAreSortedAtStart)

Sets whether NULL values are sorted at the start regardless of sort order.

Parameters:: nullsAreSortedAtStart - true if so; false otherwise

isNullsAreSortedAtEnd

Boolean isNullsAreSortedAtEnd()

Retrieves whether NULL values are sorted at the end regardless of sort order.

Returns:: true if so; false otherwise

setNullsAreSortedAtEnd

void setNullsAreSortedAtEnd(Boolean nullsAreSortedAtEnd)

Sets whether NULL values are sorted at the end regardless of sort order.

Parameters:: nullsAreSortedAtEnd - true if so; false otherwise

getDatabaseProductName

String getDatabaseProductName()

Retrieves the name of this database product.

Returns:: database product name

setDatabaseProductName

void setDatabaseProductName(String databaseProductName)

Sets the name of this database product.

Parameters:: databaseProductName - database product name

getDatabaseProductVersion

String getDatabaseProductVersion()

Retrieves the version number of this database product.

Returns:: database version number

setDatabaseProductVersion

void setDatabaseProductVersion(String databaseProductVersion)

Sets the version number of this database product.

Parameters:: databaseProductVersion - database version number

getDriverName

String getDriverName()

Retrieves the name of this JDBC driver.

Returns:: JDBC driver name

setDriverName

void setDriverName(String driverName)

Sets the name of this JDBC driver.

Parameters:: driverName - JDBC driver name

getDriverVersion

String getDriverVersion()

Retrieves the version number of this JDBC driver as a String.

Returns:: JDBC driver version

setDriverVersion

void setDriverVersion(String driverVersion)

Sets the version number of this JDBC driver as a String.

Parameters:: driverVersion - the JDBC driver version

getDriverMajorVersion

Integer getDriverMajorVersion()

Retrieves this JDBC driver's minor version number.

Returns:: JDBC driver minor version number

setDriverMajorVersion

void setDriverMajorVersion(Integer driverMajorVersion)

Sets this JDBC driver's major version number.

Parameters:: driverMajorVersion - the JDBC driver major version

getDriverMinorVersion

Integer getDriverMinorVersion()

Retrieves this JDBC driver's minor version number.

Returns:: JDBC driver minor version number

setDriverMinorVersion

void setDriverMinorVersion(Integer driverMinorVersion)

Sets this JDBC driver's minor version number.

Parameters:: driverMinorVersion - the JDBC driver minor version number

isUsesLocalFiles

Boolean isUsesLocalFiles()

Retrieves whether this database stores tables in a local file.

Returns:: true if so; false otherwise

setUsesLocalFiles

void setUsesLocalFiles(Boolean usesLocalFiles)

Sets whether this database stores tables in a local file.

Parameters:: usesLocalFiles - true if so; false otherwise

isUsesLocalFilePerTable

Boolean isUsesLocalFilePerTable()

Retrieves whether this database uses a file for each table.

Returns:: true if this database uses a local file for each table; false otherwise

setUsesLocalFilePerTable

void setUsesLocalFilePerTable(Boolean usesLocalFilePerTable)

Sets whether this database uses a file for each table.

Parameters:: usesLocalFilePerTable - true if this database uses a local file for each table; false otherwise

isSupportsMixedCaseIdentifiers

Boolean isSupportsMixedCaseIdentifiers()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

Returns:: true if so; false otherwise

setSupportsMixedCaseIdentifiers

void setSupportsMixedCaseIdentifiers(Boolean supportsMixedCaseIdentifiers)

Sets whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

Parameters:: supportsMixedCaseIdentifiers - true if so; false otherwise

isStoresUpperCaseIdentifiers

Boolean isStoresUpperCaseIdentifiers()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

Returns:: true if so; false otherwise

setStoresUpperCaseIdentifiers

void setStoresUpperCaseIdentifiers(Boolean storesUpperCaseIdentifiers)

Sets whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

Parameters:: storesUpperCaseIdentifiers - true if so; false otherwise

isStoresLowerCaseIdentifiers

Boolean isStoresLowerCaseIdentifiers()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

Returns:: true if so; false otherwise

setStoresLowerCaseIdentifiers

void setStoresLowerCaseIdentifiers(Boolean storesLowerCaseIdentifiers)

sets whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

Parameters:: storesLowerCaseIdentifiers - true if so; false otherwise

isStoresMixedCaseIdentifiers

Boolean isStoresMixedCaseIdentifiers()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

Returns:: true if so; false otherwise

setStoresMixedCaseIdentifiers

void setStoresMixedCaseIdentifiers(Boolean storesMixedCaseIdentifiers)

Sets whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

Parameters:: storesMixedCaseIdentifiers - true if so; false otherwise

isSupportsMixedCaseQuotedIdentifiers

Boolean isSupportsMixedCaseQuotedIdentifiers()

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

Returns:: true if so; false otherwise

setSupportsMixedCaseQuotedIdentifiers

void setSupportsMixedCaseQuotedIdentifiers(Boolean supportsMixedCaseQuotedIdentifiers)

Sets whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

Parameters:: supportsMixedCaseQuotedIdentifiers - true if so; false otherwise

isStoresUpperCaseQuotedIdentifiers

Boolean isStoresUpperCaseQuotedIdentifiers()

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

Returns:: true if so; false otherwise

setStoresUpperCaseQuotedIdentifiers

void setStoresUpperCaseQuotedIdentifiers(Boolean storesUpperCaseQuotedIdentifiers)

Sets whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

Parameters:: storesUpperCaseQuotedIdentifiers - true if so; false otherwise

isStoresLowerCaseQuotedIdentifiers

Boolean isStoresLowerCaseQuotedIdentifiers()

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

Returns:: true if so; false otherwise

setStoresLowerCaseQuotedIdentifiers

void setStoresLowerCaseQuotedIdentifiers(Boolean storesLowerCaseQuotedIdentifiers)

Sets whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

Parameters:: storesLowerCaseQuotedIdentifiers - true if so; false otherwise

isStoresMixedCaseQuotedIdentifiers

Boolean isStoresMixedCaseQuotedIdentifiers()

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

Returns:: true if so; false otherwise

setStoresMixedCaseQuotedIdentifiers

void setStoresMixedCaseQuotedIdentifiers(Boolean storesMixedCaseQuotedIdentifiers)

Sets whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

Parameters:: storesMixedCaseQuotedIdentifiers - true if so; false otherwise

getIdentifierQuoteString

String getIdentifierQuoteString()

Retrieves the string used to quote SQL identifiers. This method returns a space " " if identifier quoting is not supported.

Returns:: the quoting string or a space if quoting is not supported

setIdentifierQuoteString

void setIdentifierQuoteString(String identifierQuoteString)

Sets the string used to quote SQL identifiers. This method returns a space " " if identifier quoting is not supported.

Parameters:: identifierQuoteString - the quoting string or a space if quoting is not supported

getSQLKeywords

Set<String> getSQLKeywords()

Retrieves a list of all of this database's SQL keywords that are NOT also SQL92 keywords.

Returns:: the list of this database's keywords that are not also SQL92 keywords

addSQLKeyword

void addSQLKeyword(String sqlKeyword)

Adds SQL keyword

Parameters:: sqlKeyword - the SQL keyword to add

deleteSQLKeyword

void deleteSQLKeyword(String sqlKeyword)

Deletes SQL keyword

Parameters:: sqlKeyword - the SQL keyword to delete

isSQLKeywordSupported

Boolean isSQLKeywordSupported(String sqlKeyword)

Is SQL keyword supported

Parameters:: sqlKeyword - the SQL keyword to search
Returns:: true if supported; false otherwiose

getNumericFunctions

Set<String> getNumericFunctions()

Retrieves a list of math functions available with this database. These are the Open /Open CLI math function names used in the JDBC function escape clause.

Returns:: the list of math functions supported by this database

addNumericFunction

void addNumericFunction(String functionName)

Adds numeric function

Parameters:: functionName - the name of numeric function to add

deleteNumericFunction

void deleteNumericFunction(String functionName)

Deletes numeric function

Parameters:: functionName - the name of numeric function to delete

isNumericFunctionSupported

Boolean isNumericFunctionSupported(String functionName)

Is Numeric function supported

Parameters:: functionName - the name of numeric function
Returns:: true is supported; false otherwise

getStringFunctions

Set<String> getStringFunctions()

Retrieves a list of string functions available with this database. These are the Open Group CLI string function names used in the JDBC function escape clause.

Returns:: the list of string functions supported by this database

addStringFunction

void addStringFunction(String functionName)

Adds String function

Parameters:: functionName - the name of String function to add

deleteStringFunction

void deleteStringFunction(String functionName)

Deletes String function

Parameters:: functionName - the name of String function to delete

isStringFunctionSupported

Boolean isStringFunctionSupported(String functionName)

Is String function supported

Parameters:: functionName - the name of String function
Returns:: true is supported; false otherwise

getSystemFunctions

Set<String> getSystemFunctions()

Retrieves a list of system functions available with this database. These are the Open Group CLI system function names used in the JDBC function escape clause.

Returns:: a list of system functions supported by this database

addSystemFunction

void addSystemFunction(String functionName)

Adds System function

Parameters:: functionName - the name of System function to add

deleteSystemFunction

void deleteSystemFunction(String functionName)

deletes System function

Parameters:: functionName - the name of System function to delete

isSystemFunctionSupported

Boolean isSystemFunctionSupported(String functionName)

Is System function supported

Parameters:: functionName - the name of System function
Returns:: true is supported; false otherwise

getTimeDateFunctions

Set<String> getTimeDateFunctions()

Retrieves a list of the time and date functions available with this database.

Returns:: the list of time and date functions supported by this database

addTimeDateFunction

void addTimeDateFunction(String functionName)

Adds Time/Date function

Parameters:: functionName - the name of Time/Date function to add

deleteTimeDateFunction

void deleteTimeDateFunction(String functionName)

deletes Time/Date function

Parameters:: functionName - the name of Time/Date function to delete

isTimeDateFunctionSupported

Boolean isTimeDateFunctionSupported(String functionName)

Is Time/Date function supported

Parameters:: functionName - the name of Time/Date function
Returns:: true is supported; false otherwise

getSearchStringEscape

String getSearchStringEscape()

Retrieves the string that can be used to escape wildcard characters. This is the string that can be used to escape '_' or '%' in the catalog search parameters that are a pattern (and therefore use one of the wildcard characters).

The '_' character represents any single character; the '%' character represents any sequence of zero or more characters.

Returns:: the string used to escape wildcard characters

setSearchStringEscape

void setSearchStringEscape(String searchStringEscape)

Sets the string that can be used to escape wildcard characters. This is the string that can be used to escape '_' or '%' in the catalog search parameters that are a pattern (and therefore use one of the wildcard characters).

The '_' character represents any single character; the '%' character represents any sequence of zero or more characters.

Parameters:: searchStringEscape - the string used to escape wildcard characters

getExtraNameCharacters

String getExtraNameCharacters()

Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

Returns:: the string containing the extra characters

setExtraNameCharacters

void setExtraNameCharacters(String extraNameCharacters)

Sets all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

Parameters:: extraNameCharacters - the string containing the extra characters

isSupportsAlterTableWithAddColumn

Boolean isSupportsAlterTableWithAddColumn()

Retrieves whether this database supports ALTER TABLE with add column.

Returns:: true if so; false otherwise

setSupportsAlterTableWithAddColumn

void setSupportsAlterTableWithAddColumn(Boolean supportsAlterTableWithAddColumn)

Sets whether this database supports ALTER TABLE with add column.

Parameters:: supportsAlterTableWithAddColumn - true if so; false otherwise

isSupportsAlterTableWithDropColumn

Boolean isSupportsAlterTableWithDropColumn()

Retrieves whether this database supports ALTER TABLE with drop column.

Returns:: true if so; false otherwise

setSupportsAlterTableWithDropColumn

void setSupportsAlterTableWithDropColumn(Boolean supportsAlterTableWithDropColumn)

Sets whether this database supports ALTER TABLE with drop column.

Parameters:: supportsAlterTableWithDropColumn - true if so; false otherwise

isSupportsColumnAliasing

Boolean isSupportsColumnAliasing()

Retrieves whether this database supports column aliasing.

If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.

Returns:: true if so; false otherwise

setSupportsColumnAliasing

void setSupportsColumnAliasing(Boolean supportsColumnAliasing)

Sets whether this database supports column aliasing.

If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.

Parameters:: supportsColumnAliasing - true if so; false otherwise

isNullPlusNonNullIsNull

Boolean isNullPlusNonNullIsNull()

Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.

Returns:: true if so; false otherwise

setNullPlusNonNullIsNull

void setNullPlusNonNullIsNull(Boolean nullPlusNonNullIsNull)

Sets whether this database supports concatenations between NULL and non-NULL values being NULL.

Parameters:: nullPlusNonNullIsNull - true if so; false otherwise

isSupportsConvert

Boolean isSupportsConvert()

Retrieves whether this database supports the CONVERT function between SQL types.

Returns:: true if so; false otherwise

setSupportsConvert

void setSupportsConvert(Boolean supportsConvert)

Sets whether this database supports the CONVERT function between SQL types.

Parameters:: supportsConvert - true if so; false otherwise

getSupportedConversions

Set<SqlTypeConversionPair> getSupportedConversions()

Retrieves whether this database supports the CONVERT for given SQL types. It uses original DatabaseMetaData.supportsConvert to check common (NOT ALL POSSIBLE) conversions.

Returns:: list of common (NOT ALL POSSIBLE) conversions.
See Also:: Types

addSqlTypeConversionPair

void addSqlTypeConversionPair(SqlTypeConversionPair sqlTypeConversionPair)

Adds SqlTypeConversionPair

Parameters:: sqlTypeConversionPair - the SqlTypeConversionPair

deleteSqlTypeConversionPair

void deleteSqlTypeConversionPair(SqlTypeConversionPair sqlTypeConversionPair)

deletes SqlTypeConversionPair

Parameters:: sqlTypeConversionPair - the SqlTypeConversionPair

findSqlTypeConversionPairBySrcType

Set<SqlTypeConversionPair> findSqlTypeConversionPairBySrcType(String srcType)

Searches set of SqlTypeConversionPair by SrcType

Parameters:: srcType - the source type
Returns:: set of SqlTypeConversionPair

isSupportsTableCorrelationNames

Boolean isSupportsTableCorrelationNames()

Retrieves whether this database supports table correlation names.

Returns:: true if so; false otherwise

setSupportsTableCorrelationNames

void setSupportsTableCorrelationNames(Boolean supportsTableCorrelationNames)

Sets whether this database supports table correlation names.

Parameters:: supportsTableCorrelationNames - true if so; false otherwise

isSupportsDifferentTableCorrelationNames

Boolean isSupportsDifferentTableCorrelationNames()

Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.

Returns:: true if so; false otherwise

setSupportsDifferentTableCorrelationNames

void setSupportsDifferentTableCorrelationNames(Boolean supportsDifferentTableCorrelationNames)

Sets whether, when table correlation names are supported, they are restricted to being different from the names of the tables.

Parameters:: supportsDifferentTableCorrelationNames - true if so; false otherwise

isSupportsExpressionsInOrderBy

Boolean isSupportsExpressionsInOrderBy()

Retrieves whether this database supports expressions in ORDER BY lists.

Returns:: true if so; false otherwise

setSupportsExpressionsInOrderBy

void setSupportsExpressionsInOrderBy(Boolean supportsExpressionsInOrderBy)

Sets whether this database supports expressions in ORDER BY lists.

Parameters:: supportsExpressionsInOrderBy - true if so; false otherwise

isSupportsOrderByUnrelated

Boolean isSupportsOrderByUnrelated()

Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.

Returns:: true if so; false otherwise

setSupportsOrderByUnrelated

void setSupportsOrderByUnrelated(Boolean supportsOrderByUnrelated)

Sets whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.

Parameters:: supportsOrderByUnrelated - true if so; false otherwise

isSupportsGroupBy

Boolean isSupportsGroupBy()

Retrieves whether this database supports some form of GROUP BY clause.

Returns:: true if so; false otherwise

setSupportsGroupBy

void setSupportsGroupBy(Boolean supportsGroupBy)

Sets whether this database supports some form of GROUP BY clause.

Parameters:: supportsGroupBy - true if so; false otherwise

isSupportsGroupByUnrelated

Boolean isSupportsGroupByUnrelated()

Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.

Returns:: true if so; false otherwise

setSupportsGroupByUnrelated

void setSupportsGroupByUnrelated(Boolean supportsGroupByUnrelated)

Sets whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.

Parameters:: supportsGroupByUnrelated - true if so; false otherwise

isSupportsGroupByBeyondSelect

Boolean isSupportsGroupByBeyondSelect()

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.

Returns:: true if so; false otherwise

setSupportsGroupByBeyondSelect

void setSupportsGroupByBeyondSelect(Boolean supportsGroupByBeyondSelect)

Sets 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.

Parameters:: supportsGroupByBeyondSelect - true if so; false otherwise

isSupportsLikeEscapeClause

Boolean isSupportsLikeEscapeClause()

Retrieves whether this database supports specifying a LIKE escape clause.

Returns:: true if so; false otherwise

setSupportsLikeEscapeClause

void setSupportsLikeEscapeClause(Boolean supportsLikeEscapeClause)

Sets whether this database supports specifying a LIKE escape clause.

Parameters:: supportsLikeEscapeClause - true if so; false otherwise

isSupportsMultipleResultSets

Boolean isSupportsMultipleResultSets()

Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.

Returns:: true if so; false otherwise

setSupportsMultipleResultSets

void setSupportsMultipleResultSets(Boolean supportsMultipleResultSets)

Sets whether this database supports getting multiple ResultSet objects from a single call to the method execute.

Parameters:: supportsMultipleResultSets - true if so; false otherwise

isSupportsMultipleTransactions

Boolean isSupportsMultipleTransactions()

Retrieves whether this database allows having multiple transactions open at once (on different connections).

Returns:: true if so; false otherwise

setSupportsMultipleTransactions

void setSupportsMultipleTransactions(Boolean supportsMultipleTransactions)

Sets whether this database allows having multiple transactions open at once (on different connections).

Parameters:: supportsMultipleTransactions - true if so; false otherwise

isSupportsNonNullableColumns

Boolean isSupportsNonNullableColumns()

Retrieves whether columns in this database may be defined as non-nullable.

Returns:: true if so; false otherwise

setSupportsNonNullableColumns

void setSupportsNonNullableColumns(Boolean supportsNonNullableColumns)

Sets whether columns in this database may be defined as non-nullable.

Parameters:: supportsNonNullableColumns - true if so; false otherwise

isSupportsMinimumSQLGrammar

Boolean isSupportsMinimumSQLGrammar()

Retrieves whether this database supports the ODBC Minimum SQL grammar.

Returns:: true if so; false otherwise

setSupportsMinimumSQLGrammar

void setSupportsMinimumSQLGrammar(Boolean supportsMinimumSQLGrammar)

Sets whether this database supports the ODBC Minimum SQL grammar.

Parameters:: supportsMinimumSQLGrammar - true if so; false otherwise

isSupportsCoreSQLGrammar

Boolean isSupportsCoreSQLGrammar()

Retrieves whether this database supports the ODBC Core SQL grammar.

Returns:: true if so; false otherwise

setSupportsCoreSQLGrammar

void setSupportsCoreSQLGrammar(Boolean supportsCoreSQLGrammar)

Sets whether this database supports the ODBC Core SQL grammar.

Parameters:: supportsCoreSQLGrammar - true if so; false otherwise

isSupportsExtendedSQLGrammar

Boolean isSupportsExtendedSQLGrammar()

Retrieves whether this database supports the ODBC Extended SQL grammar.

Returns:: true if so; false otherwise

setSupportsExtendedSQLGrammar

void setSupportsExtendedSQLGrammar(Boolean supportsExtendedSQLGrammar)

Sets whether this database supports the ODBC Extended SQL grammar.

Parameters:: supportsExtendedSQLGrammar - true if so; false otherwise

isSupportsANSI92EntryLevelSQL

Boolean isSupportsANSI92EntryLevelSQL()

Retrieves whether this database supports the ANSI92 entry level SQL grammar.

Returns:: true if so; false otherwise

setSupportsANSI92EntryLevelSQL

void setSupportsANSI92EntryLevelSQL(Boolean supportsANSI92EntryLevelSQL)

Sets whether this database supports the ANSI92 entry level SQL grammar.

Parameters:: supportsANSI92EntryLevelSQL - true if so; false otherwise

isSupportsANSI92IntermediateSQL

Boolean isSupportsANSI92IntermediateSQL()

Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.

Returns:: true if so; false otherwise

setSupportsANSI92IntermediateSQL

void setSupportsANSI92IntermediateSQL(Boolean supportsANSI92IntermediateSQL)

Sets whether this database supports the ANSI92 intermediate SQL grammar supported.

Parameters:: supportsANSI92IntermediateSQL - true if so; false otherwise

isSupportsANSI92FullSQL

Boolean isSupportsANSI92FullSQL()

Retrieves whether this database supports the ANSI92 full SQL grammar supported.

Returns:: true if so; false otherwise

setSupportsANSI92FullSQL

void setSupportsANSI92FullSQL(Boolean supportsANSI92FullSQL)

Sets whether this database supports the ANSI92 full SQL grammar supported.

Parameters:: supportsANSI92FullSQL - true if so; false otherwise

isSupportsIntegrityEnhancementFacility

Boolean isSupportsIntegrityEnhancementFacility()

Retrieves whether this database supports the SQL Integrity Enhancement Facility.

Returns:: true if so; false otherwise

setSupportsIntegrityEnhancementFacility

void setSupportsIntegrityEnhancementFacility(Boolean supportsIntegrityEnhancementFacility)

Sets whether this database supports the SQL Integrity Enhancement Facility.

Parameters:: supportsIntegrityEnhancementFacility - true if so; false otherwise

isSupportsOuterJoins

Boolean isSupportsOuterJoins()

Retrieves whether this database supports some form of outer join.

Returns:: true if so; false otherwise

setSupportsOuterJoins

void setSupportsOuterJoins(Boolean supportsOuterJoins)

Sets whether this database supports some form of outer join.

Parameters:: supportsOuterJoins - true if so; false otherwise

isSupportsFullOuterJoins

Boolean isSupportsFullOuterJoins()

Retrieves whether this database supports full nested outer joins.

Returns:: true if so; false otherwise

setSupportsFullOuterJoins

void setSupportsFullOuterJoins(Boolean supportsFullOuterJoins)

Sets whether this database supports full nested outer joins.

Parameters:: supportsFullOuterJoins - true if so; false otherwise

isSupportsLimitedOuterJoins

Boolean isSupportsLimitedOuterJoins()

Retrieves whether this database provides limited support for outer joins. (This will be true if the method DatabaseMetaData.supportsFullOuterJoins returns true).

Returns:: true if so; false otherwise

setSupportsLimitedOuterJoins

void setSupportsLimitedOuterJoins(Boolean supportsLimitedOuterJoins)

Sets whether this database provides limited support for outer joins. (This will be true if the method DatabaseMetaData.supportsFullOuterJoins returns true).

Parameters:: supportsLimitedOuterJoins - true if so; false otherwise

getSchemaTerm

String getSchemaTerm()

Retrieves the database vendor's preferred term for "schema".

Returns:: the vendor term for "schema"

setSchemaTerm

void setSchemaTerm(String schemaTerm)

Sets the database vendor's preferred term for "schema".

Parameters:: schemaTerm - the vendor term for "schema"

getProcedureTerm

String getProcedureTerm()

Retrieves the database vendor's preferred term for "procedure".

Returns:: the vendor term for "procedure"

setProcedureTerm

void setProcedureTerm(String procedureTerm)

Sets the database vendor's preferred term for "procedure".

Parameters:: procedureTerm - the vendor term for "procedure"

getCatalogTerm

String getCatalogTerm()

Retrieves the database vendor's preferred term for "catalog".

Returns:: the vendor term for "catalog"

setCatalogTerm

void setCatalogTerm(String catalogTerm)

Sets the database vendor's preferred term for "catalog".

Parameters:: catalogTerm - the vendor term for "catalog"

isCatalogAtStart

Boolean isCatalogAtStart()

Retrieves whether a catalog appears at the start of a fully qualified table name. If not, the catalog appears at the end.

Returns:: true if the catalog name appears at the beginning of a fully qualified table name; false otherwise

setCatalogAtStart

void setCatalogAtStart(Boolean catalogAtStart)

Sets whether a catalog appears at the start of a fully qualified table name. If not, the catalog appears at the end.

Parameters:: catalogAtStart - true if the catalog name appears at the beginning of a fully qualified table name; false otherwise

getCatalogSeparator

String getCatalogSeparator()

Retrieves the String that this database uses as the separator between a catalog and table name.

Returns:: the separator string

setCatalogSeparator

void setCatalogSeparator(String catalogSeparator)

Sets the String that this database uses as the separator between a catalog and table name.

Parameters:: catalogSeparator - the separator string

isSupportsSchemasInDataManipulation

Boolean isSupportsSchemasInDataManipulation()

Retrieves whether a schema name can be used in a data manipulation statement.

Returns:: true if so; false otherwise

setSupportsSchemasInDataManipulation

void setSupportsSchemasInDataManipulation(Boolean supportsSchemasInDataManipulation)

Sets whether a schema name can be used in a data manipulation statement.

Parameters:: supportsSchemasInDataManipulation - true if so; false otherwise

isSupportsSchemasInProcedureCalls

Boolean isSupportsSchemasInProcedureCalls()

Retrieves whether a schema name can be used in a procedure call statement.

Returns:: true if so; false otherwise

setSupportsSchemasInProcedureCalls

void setSupportsSchemasInProcedureCalls(Boolean supportsSchemasInProcedureCalls)

Sets whether a schema name can be used in a procedure call statement.

Parameters:: supportsSchemasInProcedureCalls - true if so; false otherwise

isSupportsSchemasInTableDefinitions

Boolean isSupportsSchemasInTableDefinitions()

Retrieves whether a schema name can be used in a table definition statement.

Returns:: true if so; false otherwise

setSupportsSchemasInTableDefinitions

void setSupportsSchemasInTableDefinitions(Boolean supportsSchemasInTableDefinitions)

Sets whether a schema name can be used in a table definition statement.

Parameters:: supportsSchemasInTableDefinitions - true if so; false otherwise

isSupportsSchemasInIndexDefinitions

Boolean isSupportsSchemasInIndexDefinitions()

Retrieves whether a schema name can be used in an index definition statement.

Returns:: true if so; false otherwise

setSupportsSchemasInIndexDefinitions

void setSupportsSchemasInIndexDefinitions(Boolean supportsSchemasInIndexDefinitions)

Sets whether a schema name can be used in an index definition statement.

Parameters:: supportsSchemasInIndexDefinitions - true if so; false otherwise

isSupportsSchemasInPrivilegeDefinitions

Boolean isSupportsSchemasInPrivilegeDefinitions()

Retrieves whether a schema name can be used in a privilege definition statement.

Returns:: true if so; false otherwise

setSupportsSchemasInPrivilegeDefinitions

void setSupportsSchemasInPrivilegeDefinitions(Boolean supportsSchemasInPrivilegeDefinitions)

Sets whether a schema name can be used in a privilege definition statement.

Parameters:: supportsSchemasInPrivilegeDefinitions - true if so; false otherwise

isSupportsCatalogsInDataManipulation

Boolean isSupportsCatalogsInDataManipulation()

Retrieves whether a catalog name can be used in a data manipulation statement.

Returns:: true if so; false otherwise

setSupportsCatalogsInDataManipulation

void setSupportsCatalogsInDataManipulation(Boolean supportsCatalogsInDataManipulation)

Sets whether a catalog name can be used in a data manipulation statement.

Parameters:: supportsCatalogsInDataManipulation - true if so; false otherwise

isSupportsCatalogsInProcedureCalls

Boolean isSupportsCatalogsInProcedureCalls()

Retrieves whether a catalog name can be used in a procedure call statement.

Returns:: true if so; false otherwise

setSupportsCatalogsInProcedureCalls

void setSupportsCatalogsInProcedureCalls(Boolean supportsCatalogsInProcedureCalls)

Sets whether a catalog name can be used in a procedure call statement.

Parameters:: supportsCatalogsInProcedureCalls - true if so; false otherwise

isSupportsCatalogsInTableDefinitions

Boolean isSupportsCatalogsInTableDefinitions()

Retrieves whether a catalog name can be used in a table definition statement.

Returns:: true if so; false otherwise

setSupportsCatalogsInTableDefinitions

void setSupportsCatalogsInTableDefinitions(Boolean supportsCatalogsInTableDefinitions)

Sets whether a catalog name can be used in a table definition statement.

Parameters:: supportsCatalogsInTableDefinitions - true if so; false otherwise

isSupportsCatalogsInIndexDefinitions

Boolean isSupportsCatalogsInIndexDefinitions()

Retrieves whether a catalog name can be used in an index definition statement.

Returns:: true if so; false otherwise

setSupportsCatalogsInIndexDefinitions

void setSupportsCatalogsInIndexDefinitions(Boolean supportsCatalogsInIndexDefinitions)

Sets whether a catalog name can be used in an index definition statement.

Parameters:: supportsCatalogsInIndexDefinitions - true if so; false otherwise

isSupportsCatalogsInPrivilegeDefinitions

Boolean isSupportsCatalogsInPrivilegeDefinitions()

Retrieves whether a catalog name can be used in a privilege definition statement.

Returns:: true if so; false otherwise

setSupportsCatalogsInPrivilegeDefinitions

void setSupportsCatalogsInPrivilegeDefinitions(Boolean supportsCatalogsInPrivilegeDefinitions)

Sets whether a catalog name can be used in a privilege definition statement.

Parameters:: supportsCatalogsInPrivilegeDefinitions - true if so; false otherwise

isSupportsPositionedDelete

Boolean isSupportsPositionedDelete()

Retrieves whether this database supports positioned DELETE statements.

Returns:: true if so; false otherwise

setSupportsPositionedDelete

void setSupportsPositionedDelete(Boolean supportsPositionedDelete)

Sets whether this database supports positioned DELETE statements.

Parameters:: supportsPositionedDelete - true if so; false otherwise

isSupportsPositionedUpdate

Boolean isSupportsPositionedUpdate()

Retrieves whether this database supports positioned UPDATE statements.

Returns:: true if so; false otherwise

setSupportsPositionedUpdate

void setSupportsPositionedUpdate(Boolean supportsPositionedUpdate)

Sets whether this database supports positioned UPDATE statements.

Parameters:: supportsPositionedUpdate - true if so; false otherwise

isSupportsSelectForUpdate

Boolean isSupportsSelectForUpdate()

Retrieves whether this database supports SELECT FOR UPDATE statements.

Returns:: true if so; false otherwise

setSupportsSelectForUpdate

void setSupportsSelectForUpdate(Boolean supportsSelectForUpdate)

Sets whether this database supports SELECT FOR UPDATE statements.

Parameters:: supportsSelectForUpdate - true if so; false otherwise

isSupportsStoredProcedures

Boolean isSupportsStoredProcedures()

Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.

Returns:: true if so; false otherwise

setSupportsStoredProcedures

void setSupportsStoredProcedures(Boolean supportsStoredProcedures)

Sets whether this database supports stored procedure calls that use the stored procedure escape syntax.

Parameters:: supportsStoredProcedures - true if so; false otherwise

isSupportsSubqueriesInComparisons

Boolean isSupportsSubqueriesInComparisons()

Retrieves whether this database supports subqueries in comparison expressions.

Returns:: true if so; false otherwise

setSupportsSubqueriesInComparisons

void setSupportsSubqueriesInComparisons(Boolean supportsSubqueriesInComparisons)

Retrieves whether this database supports subqueries in comparison expressions.

Parameters:: supportsSubqueriesInComparisons - true if so; false otherwise

isSupportsSubqueriesInExists

Boolean isSupportsSubqueriesInExists()

Retrieves whether this database supports subqueries in EXISTS expressions.

Returns:: true if so; false otherwise

setSupportsSubqueriesInExists

void setSupportsSubqueriesInExists(Boolean supportsSubqueriesInExists)

Sets whether this database supports subqueries in EXISTS expressions.

Parameters:: supportsSubqueriesInExists - true if so; false otherwise

isSupportsSubqueriesInIns

Boolean isSupportsSubqueriesInIns()

Retrieves whether this database supports subqueries in IN statements.

Returns:: true if so; false otherwise

setSupportsSubqueriesInIns

void setSupportsSubqueriesInIns(Boolean supportsSubqueriesInIns)

Sets whether this database supports subqueries in IN statements.

Parameters:: supportsSubqueriesInIns - true if so; false otherwise

isSupportsSubqueriesInQuantifieds

Boolean isSupportsSubqueriesInQuantifieds()

Retrieves whether this database supports subqueries in quantified expressions.

Returns:: true if so; false otherwise

setSupportsSubqueriesInQuantifieds

void setSupportsSubqueriesInQuantifieds(Boolean supportsSubqueriesInQuantifieds)

Sets whether this database supports subqueries in quantified expressions.

Parameters:: supportsSubqueriesInQuantifieds - true if so; false otherwise

isSupportsCorrelatedSubqueries

Boolean isSupportsCorrelatedSubqueries()

Retrieves whether this database supports correlated subqueries.

Returns:: true if so; false otherwise

setSupportsCorrelatedSubqueries

void setSupportsCorrelatedSubqueries(Boolean supportsCorrelatedSubqueries)

Sets whether this database supports correlated subqueries.

Parameters:: supportsCorrelatedSubqueries - true if so; false otherwise

isSupportsUnion

Boolean isSupportsUnion()

Retrieves whether this database supports SQL UNION.

Returns:: true if so; false otherwise

setSupportsUnion

void setSupportsUnion(Boolean supportsUnion)

Sets whether this database supports SQL UNION.

Parameters:: supportsUnion - true if so; false otherwise

isSupportsUnionAll

Boolean isSupportsUnionAll()

Retrieves whether this database supports SQL UNION ALL.

Returns:: true if so; false otherwise

setSupportsUnionAll

void setSupportsUnionAll(Boolean supportsUnionAll)

Sets whether this database supports SQL UNION ALL.

Parameters:: supportsUnionAll - true if so; false otherwise

isSupportsOpenCursorsAcrossCommit

Boolean isSupportsOpenCursorsAcrossCommit()

Retrieves whether this database supports keeping cursors open across commits.

Returns:: true if cursors always remain open; false if they might not remain open

setSupportsOpenCursorsAcrossCommit

void setSupportsOpenCursorsAcrossCommit(Boolean supportsOpenCursorsAcrossCommit)

Sets whether this database supports keeping cursors open across commits.

Parameters:: supportsOpenCursorsAcrossCommit - true if cursors always remain open; false if they might not remain open

isSupportsOpenCursorsAcrossRollback

Boolean isSupportsOpenCursorsAcrossRollback()

Retrieves whether this database supports keeping cursors open across rollbacks.

Returns:: true if cursors always remain open; false if they might not remain open

setSupportsOpenCursorsAcrossRollback

void setSupportsOpenCursorsAcrossRollback(Boolean supportsOpenCursorsAcrossRollback)

Sets whether this database supports keeping cursors open across rollbacks.

Parameters:: supportsOpenCursorsAcrossRollback - true if cursors always remain open; false if they might not remain open

isSupportsOpenStatementsAcrossCommit

Boolean isSupportsOpenStatementsAcrossCommit()

Retrieves whether this database supports keeping statements open across commits.

Returns:: true if statements always remain open; false if they might not remain open

setSupportsOpenStatementsAcrossCommit

void setSupportsOpenStatementsAcrossCommit(Boolean supportsOpenStatementsAcrossCommit)

sets whether this database supports keeping statements open across commits.

Parameters:: supportsOpenStatementsAcrossCommit - true if statements always remain open; false if they might not remain open

isSupportsOpenStatementsAcrossRollback

Boolean isSupportsOpenStatementsAcrossRollback()

Retrieves whether this database supports keeping statements open across rollbacks.

Returns:: true if statements always remain open; false if they might not remain open

setSupportsOpenStatementsAcrossRollback

void setSupportsOpenStatementsAcrossRollback(Boolean supportsOpenStatementsAcrossRollback)

Sets whether this database supports keeping statements open across rollbacks.

Parameters:: supportsOpenStatementsAcrossRollback - true if statements always remain open; false if they might not remain open

getMaxBinaryLiteralLength

Integer getMaxBinaryLiteralLength()

Retrieves the maximum number of hex characters this database allows in an inline binary literal.

Returns:: max the maximum length (in hex characters) for a binary literal; a result of zero means that there is no limit or the limit is not known

setMaxBinaryLiteralLength

void setMaxBinaryLiteralLength(Integer maxBinaryLiteralLength)

sets the maximum number of hex characters this database allows in an inline binary literal.

Parameters:: maxBinaryLiteralLength - max the maximum length (in hex characters) for a binary literal; a result of zero means that there is no limit or the limit is not known

getMaxCharLiteralLength

Integer getMaxCharLiteralLength()

Retrieves the maximum number of characters this database allows for a character literal.

Returns:: the maximum number of characters allowed for a character literal; a result of zero means that there is no limit or the limit is not known

setMaxCharLiteralLength

void setMaxCharLiteralLength(Integer maxCharLiteralLength)

Sets the maximum number of characters this database allows for a character literal.

Parameters:: maxCharLiteralLength - the maximum number of characters allowed for a character literal; a result of zero means that there is no limit or the limit is not known

getMaxColumnNameLength

Integer getMaxColumnNameLength()

Retrieves the maximum number of characters this database allows for a column name.

Returns:: the maximum number of characters allowed for a column name; a result of zero means that there is no limit or the limit is not known

setMaxColumnNameLength

void setMaxColumnNameLength(Integer maxColumnNameLength)

Sets the maximum number of characters this database allows for a column name.

Parameters:: maxColumnNameLength - the maximum number of characters allowed for a column name; a result of zero means that there is no limit or the limit is not known

getMaxColumnsInGroupBy

Integer getMaxColumnsInGroupBy()

Retrieves the maximum number of columns this database allows in a GROUP BY clause.

Returns:: the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

setMaxColumnsInGroupBy

void setMaxColumnsInGroupBy(Integer maxColumnsInGroupBy)

Sets the maximum number of columns this database allows in a GROUP BY clause.

Parameters:: maxColumnsInGroupBy - the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

getMaxColumnsInIndex

Integer getMaxColumnsInIndex()

Retrieves the maximum number of columns this database allows in an index.

Returns:: the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

setMaxColumnsInIndex

void setMaxColumnsInIndex(Integer maxColumnsInIndex)

Sets the maximum number of columns this database allows in an index.

Parameters:: maxColumnsInIndex - the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

getMaxColumnsInOrderBy

Integer getMaxColumnsInOrderBy()

Retrieves the maximum number of columns this database allows in an ORDER BY clause.

Returns:: the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

setMaxColumnsInOrderBy

void setMaxColumnsInOrderBy(Integer maxColumnsInOrderBy)

Sets the maximum number of columns this database allows in an ORDER BY clause.

Parameters:: maxColumnsInOrderBy - the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

getMaxColumnsInSelect

Integer getMaxColumnsInSelect()

Retrieves the maximum number of columns this database allows in a SELECT list.

Returns:: the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

setMaxColumnsInSelect

void setMaxColumnsInSelect(Integer maxColumnsInSelect)

Sets the maximum number of columns this database allows in a SELECT list.

Parameters:: maxColumnsInSelect - the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

getMaxColumnsInTable

Integer getMaxColumnsInTable()

Retrieves the maximum number of columns this database allows in a table.

Returns:: the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

setMaxColumnsInTable

void setMaxColumnsInTable(Integer maxColumnsInTable)

Sets the maximum number of columns this database allows in a table.

Parameters:: maxColumnsInTable - the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

getMaxConnections

Integer getMaxConnections()

Retrieves the maximum number of concurrent connections to this database that are possible.

Returns:: the maximum number of active connections possible at one time; a result of zero means that there is no limit or the limit is not known

setMaxConnections

void setMaxConnections(Integer maxConnections)

Sets the maximum number of concurrent connections to this database that are possible.

Parameters:: maxConnections - the maximum number of active connections possible at one time; a result of zero means that there is no limit or the limit is not known

getMaxCursorNameLength

Integer getMaxCursorNameLength()

Retrieves the maximum number of characters that this database allows in a cursor name.

Returns:: the maximum number of characters allowed in a cursor name; a result of zero means that there is no limit or the limit is not known

setMaxCursorNameLength

void setMaxCursorNameLength(Integer maxCursorNameLength)

Sets the maximum number of characters that this database allows in a cursor name.

Parameters:: maxCursorNameLength - the maximum number of characters allowed in a cursor name; a result of zero means that there is no limit or the limit is not known

getMaxIndexLength

Integer getMaxIndexLength()

Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.

Returns:: the maximum number of bytes allowed; this limit includes the composite of all the constituent parts of the index; a result of zero means that there is no limit or the limit is not known

setMaxIndexLength

void setMaxIndexLength(Integer maxIndexLength)

Sets the maximum number of bytes this database allows for an index, including all of the parts of the index.

Parameters:: maxIndexLength - the maximum number of bytes allowed; this limit includes the composite of all the constituent parts of the index; a result of zero means that there is no limit or the limit is not known

getMaxSchemaNameLength

Integer getMaxSchemaNameLength()

Retrieves the maximum number of characters that this database allows in a schema name.

Returns:: the maximum number of characters allowed in a schema name; a result of zero means that there is no limit or the limit is not known

setMaxSchemaNameLength

void setMaxSchemaNameLength(Integer maxSchemaNameLength)

Sets the maximum number of characters that this database allows in a schema name.

Parameters:: maxSchemaNameLength - the maximum number of characters allowed in a schema name; a result of zero means that there is no limit or the limit is not known

getMaxProcedureNameLength

Integer getMaxProcedureNameLength()

Retrieves the maximum number of characters that this database allows in a procedure name.

Returns:: the maximum number of characters allowed in a procedure name; a result of zero means that there is no limit or the limit is not known

setMaxProcedureNameLength

void setMaxProcedureNameLength(Integer maxProcedureNameLength)

Sets the maximum number of characters that this database allows in a procedure name.

Parameters:: maxProcedureNameLength - the maximum number of characters allowed in a procedure name; a result of zero means that there is no limit or the limit is not known

getMaxCatalogNameLength

Integer getMaxCatalogNameLength()

Retrieves the maximum number of characters that this database allows in a catalog name.

Returns:: the maximum number of characters allowed in a catalog name; a result of zero means that there is no limit or the limit is not known

setMaxCatalogNameLength

void setMaxCatalogNameLength(Integer maxCatalogNameLength)

Sets the maximum number of characters that this database allows in a catalog name.

Parameters:: maxCatalogNameLength - the maximum number of characters allowed in a catalog name; a result of zero means that there is no limit or the limit is not known

getMaxRowSize

Integer getMaxRowSize()

Retrieves the maximum number of bytes this database allows in a single row.

Returns:: the maximum number of bytes allowed for a row; a result of zero means that there is no limit or the limit is not known

setMaxRowSize

void setMaxRowSize(Integer maxRowSize)

Sets the maximum number of bytes this database allows in a single row.

Parameters:: maxRowSize - the maximum number of bytes allowed for a row; a result of zero means that there is no limit or the limit is not known

isMaxRowSizeIncludeBlobs

Boolean isMaxRowSizeIncludeBlobs()

Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

Returns:: true if so; false otherwise

setMaxRowSizeIncludeBlobs

void setMaxRowSizeIncludeBlobs(Boolean maxRowSizeIncludeBlobs)

Sets whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

Parameters:: maxRowSizeIncludeBlobs - true if so; false otherwise

getMaxStatementLength

Integer getMaxStatementLength()

Retrieves the maximum number of characters this database allows in an SQL statement.

Returns:: the maximum number of characters allowed for an SQL statement; a result of zero means that there is no limit or the limit is not known

setMaxStatementLength

void setMaxStatementLength(Integer maxStatementLength)

Sets the maximum number of characters this database allows in an SQL statement.

Parameters:: maxStatementLength - the maximum number of characters allowed for an SQL statement; a result of zero means that there is no limit or the limit is not known

getMaxStatements

Integer getMaxStatements()

Retrieves the maximum number of active statements to this database that can be open at the same time.

Returns:: the maximum number of statements that can be open at one time; a result of zero means that there is no limit or the limit is not known

setMaxStatements

void setMaxStatements(Integer maxStatements)

Sets the maximum number of active statements to this database that can be open at the same time.

Parameters:: maxStatements - the maximum number of statements that can be open at one time; a result of zero means that there is no limit or the limit is not known

getMaxTableNameLength

Integer getMaxTableNameLength()

Retrieves the maximum number of characters this database allows in a table name.

Returns:: the maximum number of characters allowed for a table name; a result of zero means that there is no limit or the limit is not known

setMaxTableNameLength

void setMaxTableNameLength(Integer maxTableNameLength)

Sets the maximum number of characters this database allows in a table name.

Parameters:: maxTableNameLength - the maximum number of characters allowed for a table name; a result of zero means that there is no limit or the limit is not known

getMaxTablesInSelect

Integer getMaxTablesInSelect()

Retrieves the maximum number of tables this database allows in a SELECT statement.

Returns:: the maximum number of tables allowed in a SELECT statement; a result of zero means that there is no limit or the limit is not known

setMaxTablesInSelect

void setMaxTablesInSelect(Integer maxTablesInSelect)

Sets the maximum number of tables this database allows in a SELECT statement.

Parameters:: maxTablesInSelect - the maximum number of tables allowed in a SELECT statement; a result of zero means that there is no limit or the limit is not known

getMaxUserNameLength

Integer getMaxUserNameLength()

Retrieves the maximum number of characters this database allows in a user name.

Returns:: the maximum number of characters allowed for a user name; a result of zero means that there is no limit or the limit is not known

setMaxUserNameLength

void setMaxUserNameLength(Integer maxUserNameLength)

Sets the maximum number of characters this database allows in a user name.

Parameters:: maxUserNameLength - the maximum number of characters allowed for a user name; a result of zero means that there is no limit or the limit is not known

getDefaultTransactionIsolation

Integer getDefaultTransactionIsolation()

Retrieves this database's default transaction isolation level. The possible values are defined in java.sql.Connection.

Returns:: the default isolation level
See Also:: Connection

setDefaultTransactionIsolation

void setDefaultTransactionIsolation(Integer defaultTransactionIsolation)

Sets this database's default transaction isolation level. The possible values are defined in java.sql.Connection.

Parameters:: defaultTransactionIsolation - the default isolation level
See Also:: Connection

isSupportsTransactions

Boolean isSupportsTransactions()

Retrieves whether this database supports transactions. If not, invoking the method commit is a noop, and the isolation level is TRANSACTION_NONE.

Returns:: true if transactions are supported; false otherwise

setSupportsTransactions

void setSupportsTransactions(Boolean supportsTransactions)

Sets whether this database supports transactions. If not, invoking the method commit is a noop, and the isolation level is TRANSACTION_NONE.

Parameters:: supportsTransactions - true if transactions are supported; false otherwise

getSupportedTransactionIsolationLevels

Set<TransactionIsolationLevelType> getSupportedTransactionIsolationLevels()

Retrieves list of database supported transaction isolation levels.

Returns:: list of database supported transaction isolation levels.
See Also:: Connection

addSupportedTransactionIsolationLevelType

void addSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)

Adds TransactionIsolationLevelType

Parameters:: transactionIsolationLevelType - the Transaction Isolation Level Type

deleteSupportedTransactionIsolationLevelType

void deleteSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)

Deletes TransactionIsolationLevelType

Parameters:: transactionIsolationLevelType - the Transaction Isolation Level Type

isSupportedTransactionIsolationLevelType

Boolean isSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)

Is supported TransactionIsolationLevelType

Parameters:: transactionIsolationLevelType - the Transaction Isolation Level Type
Returns:: true if supported

isSupportsDataDefinitionAndDataManipulationTransactions

Boolean isSupportsDataDefinitionAndDataManipulationTransactions()

Retrieves whether this database supports both data definition and data manipulation statements within a transaction.

Returns:: true if so; false otherwise

setSupportsDataDefinitionAndDataManipulationTransactions

void setSupportsDataDefinitionAndDataManipulationTransactions(Boolean supportsDataDefinitionAndDataManipulationTransactions)

Sets whether this database supports both data definition and data manipulation statements within a transaction.

Parameters:: supportsDataDefinitionAndDataManipulationTransactions - true if so; false otherwise

isSupportsDataManipulationTransactionsOnly

Boolean isSupportsDataManipulationTransactionsOnly()

Retrieves whether this database supports only data manipulation statements within a transaction.

Returns:: true if so; false otherwise

setSupportsDataManipulationTransactionsOnly

void setSupportsDataManipulationTransactionsOnly(Boolean supportsDataManipulationTransactionsOnly)

Sets whether this database supports only data manipulation statements within a transaction.

Parameters:: supportsDataManipulationTransactionsOnly - true if so; false otherwise

isDataDefinitionCausesTransactionCommit

Boolean isDataDefinitionCausesTransactionCommit()

Retrieves whether a data definition statement within a transaction forces the transaction to commit.

Returns:: true if so; false otherwise

setDataDefinitionCausesTransactionCommit

void setDataDefinitionCausesTransactionCommit(Boolean dataDefinitionCausesTransactionCommit)

Sets whether a data definition statement within a transaction forces the transaction to commit.

Parameters:: dataDefinitionCausesTransactionCommit - true if so; false otherwise

isDataDefinitionIgnoredInTransactions

Boolean isDataDefinitionIgnoredInTransactions()

Retrieves whether this database ignores a data definition statement within a transaction.

Returns:: true if so; false otherwise

setDataDefinitionIgnoredInTransactions

void setDataDefinitionIgnoredInTransactions(Boolean dataDefinitionIgnoredInTransactions)

Sets whether this database ignores a data definition statement within a transaction.

Parameters:: dataDefinitionIgnoredInTransactions - true if so; false otherwise

getStoredProcedures

Set<StoredProcedure> getStoredProcedures()

Retrieves a description of the stored procedures available in the given catalog.

Returns:: a set of stored procedures available

addStoredProcedure

void addStoredProcedure(StoredProcedure storedProcedure)

Adds Stored Procedure

Parameters:: storedProcedure - the Stored Procedure

deleteStoredProcedure

void deleteStoredProcedure(StoredProcedure storedProcedure)

Deletes Stored Procedure

Parameters:: storedProcedure - the Stored Procedure

findStoredProcedureByName

StoredProcedure findStoredProcedureByName(String catalog,
                                          String schema,
                                          String procedureName)

Finds stored procedute by its name.

Parameters:: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search; schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search; procedureName - a procedure name; must match the procedure name as it is stored in the database
Returns:: stored procedure or null if not found

getTables

Set<Table> getTables()

Retrieves a description of the tables available in the given catalog.

Returns:: a set of tables available

addTable

void addTable(Table table)

Adds Table

Parameters:: table - the table to add

deleteTable

void deleteTable(Table table)

Deletes Table

Parameters:: table - the table to delete

findTableByName

Table findTableByName(String catalog,
                      String schema,
                      String tableName)

Finds table by its name.

Parameters:: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search; schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search; tableName - a table name; must match the table name as it is stored in the database
Returns:: table or null if not found

getSchemas

Set<Schema> getSchemas()

Retrieves the schemas available in this database. The results are ordered by schema name.

Returns:: schemas available in this database.

addSchema

void addSchema(Schema schema)

Adds Schema

Parameters:: schema - the Schema

deleteSchema

void deleteSchema(Schema schema)

Deletes Schema

Parameters:: schema - the Schema

findSchemaByName

Schema findSchemaByName(String catalog,
                        String schemaName)

Finds schema by its name.

Parameters:: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search; schemaName - a schema name; must match the schema name as it is stored in the database;
Returns:: schema or null if not found

getCatalogs

Set<Catalog> getCatalogs()

Retrieves the catalogs available in this database

Returns:: catalogs available in this database

addCatalog

void addCatalog(Catalog catalog)

Adds Catalog

Parameters:: catalog - the catalog to add

deleteCatalog

void deleteCatalog(Catalog catalog)

Deletes Catalog

Parameters:: catalog - the catalog to delete

findCatalogByName

Catalog findCatalogByName(String catalogName)

Finds catalog by its name.

Parameters:: catalogName - a catalog name; must match the catalog name as it is stored in the database;
Returns:: catalog or null if not found

getTableTypes

Set<TableType> getTableTypes()

Retrieves the table types available in this database. The results are ordered by table type.

The table type is:

TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

Returns:: table types available in this database

addTableType

void addTableType(TableType tableType)

Adds TableType

Parameters:: tableType - the table type to add

deleteTableType

void deleteTableType(TableType tableType)

Deletes TableType

Parameters:: tableType - the table type to delete

findTableTypeByTypeName

TableType findTableTypeByTypeName(String typeName)

Finds table type by its name.

Parameters:: typeName - a table type name; must match the type name as it is stored in the database;
Returns:: table type or null if not found

getSqlTypeInfos

Set<SqlTypeInfo> getSqlTypeInfos()

Retrieves a description of all the standard SQL types supported by this database

Returns:: all the standard SQL types supported by this database

addSqlTypeInfo

void addSqlTypeInfo(SqlTypeInfo sqlTypeInfo)

Adds SqlTypeInfo

Parameters:: sqlTypeInfo - the SQL type to add

deleteSqlTypeInfo

void deleteSqlTypeInfo(SqlTypeInfo sqlTypeInfo)

Deletes SqlTypeInfo

Parameters:: sqlTypeInfo - the SQL type to delete

findSqlTypeInfoByTypeName

SqlTypeInfo findSqlTypeInfoByTypeName(String typeName)

Finds SQL type by its name.

Parameters:: typeName - a table type name; must match the type name as it is stored in the database;
Returns:: table type or null if not found

getSupportedResultSetTypes

Set<ResultSetType> getSupportedResultSetTypes()

Retrieves database supported result set types.

Returns:: database supported result set types.
Since:: 1.2 (JDBC 2.0)
See Also:: Connection

addSupportedResultSetType

void addSupportedResultSetType(ResultSetType resultSetType)

Adds supported ResultSetType

Parameters:: resultSetType - the ResultSetType

deleteSupportedResultSetType

void deleteSupportedResultSetType(ResultSetType resultSetType)

Deletes supported ResultSetType

Parameters:: resultSetType - the ResultSetType

getSupportedForwardOnlyResultSetConcurrencies

Set<ResultSetConcurrencyType> getSupportedForwardOnlyResultSetConcurrencies()

Retrieves database supported concurrencies for the given result set type.

Returns:: database supported concurrencies for the given result set type.
Since:: 1.2 (JDBC 2.0)
See Also:: Connection

addSupportedForwardOnlyResultSetConcurrency

void addSupportedForwardOnlyResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)

Adds ResultSetConcurrencyType

Parameters:: resultSetConcurrencyType - the ResultSetConcurrencyType

deleteSupportedForwardOnlyResultSetConcurrency

void deleteSupportedForwardOnlyResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)

Deletes ResultSetConcurrencyType

Parameters:: resultSetConcurrencyType - the ResultSetConcurrencyType

getSupportedScrollInsensitiveResultSetConcurrencies

Set<ResultSetConcurrencyType> getSupportedScrollInsensitiveResultSetConcurrencies()

Retrieves database supported concurrencies for the given result set type.

Returns:: database supported concurrencies for the given result set type.
Since:: 1.2 (JDBC 2.0)
See Also:: Connection

addSupportedScrollInsensitiveResultSetConcurrency

void addSupportedScrollInsensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)

Adds ResultSetConcurrencyType

Parameters:: resultSetConcurrencyType - the ResultSetConcurrencyType

deleteSupportedScrollInsensitiveResultSetConcurrency

void deleteSupportedScrollInsensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)

Delete ResultSetConcurrencyType

Parameters:: resultSetConcurrencyType - the ResultSetConcurrencyType

getSupportedScrollSensitiveResultSetConcurrencies

Set<ResultSetConcurrencyType> getSupportedScrollSensitiveResultSetConcurrencies()

Retrieves database supported concurrencies for the given result set type.

Returns:: database supported concurrencies for the given result set type.
Since:: 1.2 (JDBC 2.0)
See Also:: Connection

addSupportedScrollSensitiveResultSetConcurrency

void addSupportedScrollSensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)

Adds resultSetConcurrencyType

Parameters:: resultSetConcurrencyType - the ResultSetConcurrencyType

deleteSupportedScrollSensitiveResultSetConcurrency

void deleteSupportedScrollSensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)

delete resultSetConcurrencyType

Parameters:: resultSetConcurrencyType - the ResultSetConcurrencyType

isForwardOnlyResultSetOwnUpdatesAreVisible

Boolean isForwardOnlyResultSetOwnUpdatesAreVisible()

Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

Returns:: true if updates are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetOwnUpdatesAreVisible

void setForwardOnlyResultSetOwnUpdatesAreVisible(Boolean forwardOnlyResultSetOwnUpdatesAreVisible)

Sets whether for the given type of ResultSet object, the result set's own updates are visible.

Parameters:: forwardOnlyResultSetOwnUpdatesAreVisible - true if updates are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetOwnUpdatesAreVisible

Boolean isScrollInsensitiveResultSetOwnUpdatesAreVisible()

Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

Returns:: true if updates are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetOwnUpdatesAreVisible

void setScrollInsensitiveResultSetOwnUpdatesAreVisible(Boolean scrollInsensitiveResultSetOwnUpdatesAreVisible)

Sets whether for the given type of ResultSet object, the result set's own updates are visible.

Parameters:: scrollInsensitiveResultSetOwnUpdatesAreVisible - true if updates are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetOwnUpdatesAreVisible

Boolean isScrollSensitiveResultSetOwnUpdatesAreVisible()

Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

Returns:: true if updates are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetOwnUpdatesAreVisible

void setScrollSensitiveResultSetOwnUpdatesAreVisible(Boolean scrollSensitiveResultSetOwnUpdatesAreVisible)

Sets whether for the given type of ResultSet object, the result set's own updates are visible.

Parameters:: scrollSensitiveResultSetOwnUpdatesAreVisible - true if updates are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetOwnDeletesAreVisible

Boolean isForwardOnlyResultSetOwnDeletesAreVisible()

Retrieves whether a result set's own deletes are visible.

Returns:: true if deletes are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetOwnDeletesAreVisible

void setForwardOnlyResultSetOwnDeletesAreVisible(Boolean forwardOnlyResultSetOwnDeletesAreVisible)

Sets whether a result set's own deletes are visible.

Parameters:: forwardOnlyResultSetOwnDeletesAreVisible - true if deletes are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetOwnDeletesAreVisible

Boolean isScrollInsensitiveResultSetOwnDeletesAreVisible()

Retrieves whether a result set's own deletes are visible.

Returns:: true if deletes are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetOwnDeletesAreVisible

void setScrollInsensitiveResultSetOwnDeletesAreVisible(Boolean scrollInsensitiveResultSetOwnDeletesAreVisible)

Sets whether a result set's own deletes are visible.

Parameters:: scrollInsensitiveResultSetOwnDeletesAreVisible - true if deletes are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetOwnDeletesAreVisible

Boolean isScrollSensitiveResultSetOwnDeletesAreVisible()

Retrieves whether a result set's own deletes are visible.

Returns:: true if deletes are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetOwnDeletesAreVisible

void setScrollSensitiveResultSetOwnDeletesAreVisible(Boolean scrollSensitiveResultSetOwnDeletesAreVisible)

Sets whether a result set's own deletes are visible.

Parameters:: scrollSensitiveResultSetOwnDeletesAreVisible - true if deletes are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetOwnInsertsAreVisible

Boolean isForwardOnlyResultSetOwnInsertsAreVisible()

Retrieves whether a result set's own inserts are visible.

Returns:: true if inserts are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetOwnInsertsAreVisible

void setForwardOnlyResultSetOwnInsertsAreVisible(Boolean forwardOnlyResultSetOwnInsertsAreVisible)

Sets whether a result set's own inserts are visible.

Parameters:: forwardOnlyResultSetOwnInsertsAreVisible - true if inserts are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetOwnInsertsAreVisible

Boolean isScrollInsensitiveResultSetOwnInsertsAreVisible()

Retrieves whether a result set's own inserts are visible.

Returns:: true if inserts are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetOwnInsertsAreVisible

void setScrollInsensitiveResultSetOwnInsertsAreVisible(Boolean scrollInsensitiveResultSetOwnInsertsAreVisible)

Sets whether a result set's own inserts are visible.

Parameters:: scrollInsensitiveResultSetOwnInsertsAreVisible - true if inserts are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetOwnInsertsAreVisible

Boolean isScrollSensitiveResultSetOwnInsertsAreVisible()

Retrieves whether a result set's own inserts are visible.

Returns:: true if inserts are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetOwnInsertsAreVisible

void setScrollSensitiveResultSetOwnInsertsAreVisible(Boolean scrollSensitiveResultSetOwnInsertsAreVisible)

Sets whether a result set's own inserts are visible.

Parameters:: scrollSensitiveResultSetOwnInsertsAreVisible - true if inserts are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetOthersUpdatesAreVisible

Boolean isForwardOnlyResultSetOthersUpdatesAreVisible()

Retrieves whether updates made by others are visible.

Returns:: true if updates made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetOthersUpdatesAreVisible

void setForwardOnlyResultSetOthersUpdatesAreVisible(Boolean forwardOnlyResultSetOthersUpdatesAreVisible)

Sets whether updates made by others are visible.

Parameters:: forwardOnlyResultSetOthersUpdatesAreVisible - true if updates made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetOthersUpdatesAreVisible

Boolean isScrollInsensitiveResultSetOthersUpdatesAreVisible()

Retrieves whether updates made by others are visible.

Returns:: true if updates made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetOthersUpdatesAreVisible

void setScrollInsensitiveResultSetOthersUpdatesAreVisible(Boolean scrollInsensitiveResultSetOthersUpdatesAreVisible)

Sets whether updates made by others are visible.

Parameters:: scrollInsensitiveResultSetOthersUpdatesAreVisible - true if updates made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetOthersUpdatesAreVisible

Boolean isScrollSensitiveResultSetOthersUpdatesAreVisible()

Retrieves whether updates made by others are visible.

Returns:: true if updates made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetOthersUpdatesAreVisible

void setScrollSensitiveResultSetOthersUpdatesAreVisible(Boolean scrollSensitiveResultSetOthersUpdatesAreVisible)

Sets whether updates made by others are visible.

Parameters:: scrollSensitiveResultSetOthersUpdatesAreVisible - true if updates made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetOthersDeletesAreVisible

Boolean isForwardOnlyResultSetOthersDeletesAreVisible()

Retrieves whether deletes made by others are visible.

Returns:: true if deletes made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetOthersDeletesAreVisible

void setForwardOnlyResultSetOthersDeletesAreVisible(Boolean forwardOnlyResultSetOthersDeletesAreVisible)

Sets whether deletes made by others are visible.

Parameters:: forwardOnlyResultSetOthersDeletesAreVisible - true if deletes made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetOthersDeletesAreVisible

Boolean isScrollInsensitiveResultSetOthersDeletesAreVisible()

Retrieves whether deletes made by others are visible.

Returns:: true if deletes made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetOthersDeletesAreVisible

void setScrollInsensitiveResultSetOthersDeletesAreVisible(Boolean scrollInsensitiveResultSetOthersDeletesAreVisible)

Sets whether deletes made by others are visible.

Parameters:: scrollInsensitiveResultSetOthersDeletesAreVisible - true if deletes made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetOthersDeletesAreVisible

Boolean isScrollSensitiveResultSetOthersDeletesAreVisible()

Retrieves whether deletes made by others are visible.

Returns:: true if deletes made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetOthersDeletesAreVisible

void setScrollSensitiveResultSetOthersDeletesAreVisible(Boolean scrollSensitiveResultSetOthersDeletesAreVisible)

Sets whether deletes made by others are visible.

Parameters:: scrollSensitiveResultSetOthersDeletesAreVisible - true if deletes made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetOthersInsertsAreVisible

Boolean isForwardOnlyResultSetOthersInsertsAreVisible()

Retrieves whether inserts made by others are visible.

Returns:: true if inserts made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetOthersInsertsAreVisible

void setForwardOnlyResultSetOthersInsertsAreVisible(Boolean forwardOnlyResultSetOthersInsertsAreVisible)

Sets whether inserts made by others are visible.

Parameters:: forwardOnlyResultSetOthersInsertsAreVisible - true if inserts made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetOthersInsertsAreVisible

Boolean isScrollInsensitiveResultSetOthersInsertsAreVisible()

Retrieves whether inserts made by others are visible.

Returns:: true if inserts made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetOthersInsertsAreVisible

void setScrollInsensitiveResultSetOthersInsertsAreVisible(Boolean scrollInsensitiveResultSetOthersInsertsAreVisible)

Sets whether inserts made by others are visible.

Parameters:: scrollInsensitiveResultSetOthersInsertsAreVisible - true if inserts made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetOthersInsertsAreVisible

Boolean isScrollSensitiveResultSetOthersInsertsAreVisible()

Retrieves whether inserts made by others are visible.

Returns:: true if inserts made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetOthersInsertsAreVisible

void setScrollSensitiveResultSetOthersInsertsAreVisible(Boolean scrollSensitiveResultSetOthersInsertsAreVisible)

Sets whether inserts made by others are visible.

Parameters:: scrollSensitiveResultSetOthersInsertsAreVisible - true if inserts made by others are visible for the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetUpdatesAreDetected

Boolean isForwardOnlyResultSetUpdatesAreDetected()

Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

Returns:: true if changes are detected by the result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetUpdatesAreDetected

void setForwardOnlyResultSetUpdatesAreDetected(Boolean forwardOnlyResultSetUpdatesAreDetected)

Sets whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

Parameters:: forwardOnlyResultSetUpdatesAreDetected - true if changes are detected by the result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetUpdatesAreDetected

Boolean isScrollInsensitiveResultSetUpdatesAreDetected()

Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

Returns:: true if changes are detected by the result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetUpdatesAreDetected

void setScrollInsensitiveResultSetUpdatesAreDetected(Boolean scrollInsensitiveResultSetUpdatesAreDetected)

Sets whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

Parameters:: scrollInsensitiveResultSetUpdatesAreDetected - true if changes are detected by the result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetUpdatesAreDetected

Boolean isScrollSensitiveResultSetUpdatesAreDetected()

Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

Returns:: true if changes are detected by the result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetUpdatesAreDetected

void setScrollSensitiveResultSetUpdatesAreDetected(Boolean scrollSensitiveResultSetUpdatesAreDetected)

Sets whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

Parameters:: scrollSensitiveResultSetUpdatesAreDetected - true if changes are detected by the result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultSetDeletesAreDetected

Boolean isForwardOnlyResultSetDeletesAreDetected()

Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted. If the method deletesAreDetected returns false, it means that deleted rows are removed from the result set.

Returns:: true if deletes are detected by the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultSetDeletesAreDetected

void setForwardOnlyResultSetDeletesAreDetected(Boolean forwardOnlyResultSetDeletesAreDetected)

Sets whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted. If the method deletesAreDetected returns false, it means that deleted rows are removed from the result set.

Parameters:: forwardOnlyResultSetDeletesAreDetected - true if deletes are detected by the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultSetDeletesAreDetected

Boolean isScrollInsensitiveResultSetDeletesAreDetected()

Returns:: true if deletes are detected by the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultSetDeletesAreDetected

void setScrollInsensitiveResultSetDeletesAreDetected(Boolean scrollInsensitiveResultSetDeletesAreDetected)

Parameters:: scrollInsensitiveResultSetDeletesAreDetected - true if deletes are detected by the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultSetDeletesAreDetected

Boolean isScrollSensitiveResultSetDeletesAreDetected()

Returns:: true if deletes are detected by the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultSetDeletesAreDetected

void setScrollSensitiveResultSetDeletesAreDetected(Boolean scrollSensitiveResultSetDeletesAreDetected)

Parameters:: scrollSensitiveResultSetDeletesAreDetected - true if deletes are detected by the given result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isForwardOnlyResultInsertsAreDetected

Boolean isForwardOnlyResultInsertsAreDetected()

Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

Returns:: true if changes are detected by the specified result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setForwardOnlyResultInsertsAreDetected

void setForwardOnlyResultInsertsAreDetected(Boolean forwardOnlyResultInsertsAreDetected)

Sets whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

Parameters:: forwardOnlyResultInsertsAreDetected - true if changes are detected by the specified result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollInsensitiveResultInsertsAreDetected

Boolean isScrollInsensitiveResultInsertsAreDetected()

Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

Returns:: true if changes are detected by the specified result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollInsensitiveResultInsertsAreDetected

void setScrollInsensitiveResultInsertsAreDetected(Boolean scrollInsensitiveResultInsertsAreDetected)

Sets whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

Parameters:: scrollInsensitiveResultInsertsAreDetected - true if changes are detected by the specified result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isScrollSensitiveResultInsertsAreDetected

Boolean isScrollSensitiveResultInsertsAreDetected()

Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

Returns:: true if changes are detected by the specified result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

setScrollSensitiveResultInsertsAreDetected

void setScrollSensitiveResultInsertsAreDetected(Boolean scrollSensitiveResultInsertsAreDetected)

Sets whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

Parameters:: scrollSensitiveResultInsertsAreDetected - true if changes are detected by the specified result set type; false otherwise
Since:: 1.2 (JDBC 2.0)

isSupportsBatchUpdates

Boolean isSupportsBatchUpdates()

Retrieves whether this database supports batch updates.

Returns:: true if this database supports batch upcates; false otherwise
Since:: 1.2 (JDBC 2.0)

setSupportsBatchUpdates

void setSupportsBatchUpdates(Boolean supportsBatchUpdates)

Sets whether this database supports batch updates.

Parameters:: supportsBatchUpdates - true if this database supports batch upcates; false otherwise
Since:: 1.2 (JDBC 2.0)

getUserDefinedTypes

Set<UserDefinedType> getUserDefinedTypes()

Retrieves a description of the UDT available in the given catalog.

Returns:: a set of UDT available

addUserDefinedType

void addUserDefinedType(UserDefinedType udt)

Adds UDT

Parameters:: udt - the UDT to add

deleteUserDefinedType

void deleteUserDefinedType(UserDefinedType udt)

Deletes UDT

Parameters:: udt - the UDT to delete

findUserDefinedTypeByName

UserDefinedType findUserDefinedTypeByName(String catalog,
                                          String schema,
                                          String tableName)

Finds UDT by its name.

Parameters:: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search; schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search; tableName - a table name; must match the table name as it is stored in the database
Returns:: table or null if not found

isSupportsSavepoints

Boolean isSupportsSavepoints()

Retrieves whether this database supports savepoints.

Returns:: true if savepoints are supported; false otherwise
Since:: 1.4 (JDBC 3.0)

setSupportsSavepoints

void setSupportsSavepoints(Boolean supportsSavepoints)

Sets whether this database supports savepoints.

Parameters:: supportsSavepoints - true if savepoints are supported; false otherwise
Since:: 1.4 (JDBC 3.0)

isSupportsNamedParameters

Boolean isSupportsNamedParameters()

Retrieves whether this database supports named parameters to callable statements.

Returns:: true if named parameters are supported; false otherwise
Since:: 1.4 (JDBC 3.0)

setSupportsNamedParameters

void setSupportsNamedParameters(Boolean supportsNamedParameters)

Sets whether this database supports named parameters to callable statements.

Parameters:: supportsNamedParameters - true if named parameters are supported; false otherwise
Since:: 1.4 (JDBC 3.0)

isSupportsMultipleOpenResults

Boolean isSupportsMultipleOpenResults()

Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.

Returns:: true if a CallableStatement object can return multiple ResultSet objects simultaneously; false otherwise
Since:: 1.4 (JDBC 3.0)

setSupportsMultipleOpenResults

void setSupportsMultipleOpenResults(Boolean supportsMultipleOpenResults)

Sets whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.

Parameters:: supportsMultipleOpenResults - true if a CallableStatement object can return multiple ResultSet objects simultaneously; false otherwise
Since:: 1.4 (JDBC 3.0)

isSupportsGetGeneratedKeys

Boolean isSupportsGetGeneratedKeys()

Retrieves whether auto-generated keys can be retrieved after a statement has been executed.

Returns:: true if auto-generated keys can be retrieved after a statement has executed; false otherwise
Since:: 1.4 (JDBC 3.0)

setSupportsGetGeneratedKeys

void setSupportsGetGeneratedKeys(Boolean supportsGetGeneratedKeys)

Sets whether auto-generated keys can be retrieved after a statement has been executed.

Parameters:: supportsGetGeneratedKeys - true if auto-generated keys can be retrieved after a statement has executed; false otherwise
Since:: 1.4 (JDBC 3.0)

isSupportsResultSetHoldCurrorsOverCommitHoldability

Boolean isSupportsResultSetHoldCurrorsOverCommitHoldability()

Retrieves whether this database supports the given result set holdability.

Returns:: true if so; false otherwise
Since:: 1.4 (JDBC 3.0)
See Also:: Connection

setSupportsResultSetHoldCurrorsOverCommitHoldability

void setSupportsResultSetHoldCurrorsOverCommitHoldability(Boolean supportsResultSetHoldCurrorsOverCommitHoldability)

Sets whether this database supports the given result set holdability.

Parameters:: supportsResultSetHoldCurrorsOverCommitHoldability - true if so; false otherwise
Since:: 1.4 (JDBC 3.0)
See Also:: Connection

isSupportsResultSetCloseCurrorsAtCommitHoldability

Boolean isSupportsResultSetCloseCurrorsAtCommitHoldability()

Retrieves whether this database supports the given result set holdability.

Returns:: true if so; false otherwise
Since:: 1.4 (JDBC 3.0)
See Also:: Connection

setSupportsResultSetCloseCurrorsAtCommitHoldability

void setSupportsResultSetCloseCurrorsAtCommitHoldability(Boolean supportsResultSetCloseCurrorsAtCommitHoldability)

Sets whether this database supports the given result set holdability.

Parameters:: supportsResultSetCloseCurrorsAtCommitHoldability - true if so; false otherwise
Since:: 1.4 (JDBC 3.0)
See Also:: Connection

getResultSetHoldabilityType

ResultSetHoldabilityType getResultSetHoldabilityType()

Retrieves the default holdability of this ResultSet object.

Returns:: the default holdability; either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Since:: 1.4

setResultSetHoldabilityType

void setResultSetHoldabilityType(ResultSetHoldabilityType resultSetHoldabilityType)

Sets the default holdability of this ResultSet object.

Parameters:: resultSetHoldabilityType - the ResultSetHoldabilityType the default holdability; either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Since:: 1.4

getDatabaseMajorVersion

Integer getDatabaseMajorVersion()

Retrieves the major version number of the underlying database.

Returns:: the underlying database's major version
Since:: 1.4 (JDBC 3.0)

setDatabaseMajorVersion

void setDatabaseMajorVersion(Integer databaseMajorVersion)

Sets the major version number of the underlying database.

Parameters:: databaseMajorVersion - the underlying database's major version
Since:: 1.4 (JDBC 3.0)

getDatabaseMinorVersion

Integer getDatabaseMinorVersion()

Retrieves the minor version number of the underlying database.

Returns:: underlying database's minor version
Since:: 1.4 (JDBC 3.0)

setDatabaseMinorVersion

void setDatabaseMinorVersion(Integer databaseMinorVersion)

Sets the minor version number of the underlying database.

Parameters:: databaseMinorVersion - underlying database's minor version
Since:: 1.4 (JDBC 3.0)

getJDBCMajorVersion

Integer getJDBCMajorVersion()

Retrieves the major JDBC version number for this driver.

Returns:: JDBC version major number
Since:: 1.4 (JDBC 3.0)

setJDBCMajorVersion

void setJDBCMajorVersion(Integer jdbcMajorVersion)

Sets the major JDBC version number for this driver.

Parameters:: jdbcMajorVersion - JDBC version major number
Since:: 1.4 (JDBC 3.0)

getJDBCMinorVersion

Integer getJDBCMinorVersion()

Retrieves the minor JDBC version number for this driver.

Returns:: JDBC version minor number
Since:: 1.4 (JDBC 3.0)

setJDBCMinorVersion

void setJDBCMinorVersion(Integer jdbcMinorVersion)

Sets the minor JDBC version number for this driver.

Parameters:: jdbcMinorVersion - JDBC version minor number
Since:: 1.4 (JDBC 3.0)

getSQLStateType

SQLStateType getSQLStateType()

Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL99.

Returns:: the type of SQLSTATE; one of: sqlStateXOpen or sqlStateSQL99
Since:: 1.4 (JDBC 3.0)

setSQLStateType

void setSQLStateType(SQLStateType sqlStateType)

Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL99.

Parameters:: sqlStateType - the type of SQLSTATE; one of: sqlStateXOpen or sqlStateSQL99
Since:: 1.4 (JDBC 3.0)

isLocatorsUpdateCopy

Boolean isLocatorsUpdateCopy()

Indicates whether updates made to a LOB are made on a copy or directly to the LOB.

Returns:: true if updates are made to a copy of the LOB; false if updates are made directly to the LOB
Since:: 1.4 (JDBC 3.0)

setLocatorsUpdateCopy

void setLocatorsUpdateCopy(Boolean locatorsUpdateCopy)

Indicates whether updates made to a LOB are made on a copy or directly to the LOB.

Parameters:: locatorsUpdateCopy - true if updates are made to a copy of the LOB; false if updates are made directly to the LOB
Since:: 1.4 (JDBC 3.0)

isSupportsStatementPooling

Boolean isSupportsStatementPooling()

Retrieves whether this database supports statement pooling.

Returns:: true if so; false otherwise
Since:: 1.4 (JDBC 3.0)

setSupportsStatementPooling

void setSupportsStatementPooling(Boolean supportsStatementPooling)

Sets whether this database supports statement pooling.

Parameters:: supportsStatementPooling - true if so; false otherwise
Since:: 1.4 (JDBC 3.0)

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.jboss.dna.common.jdbc.model.api Interface Database

getExceptionList

addException

findException

isDatabaseMetaDataMethodFailed

getName

setName

isAllProceduresAreCallable

setAllProceduresAreCallable

isAllTablesAreSelectable

setAllTablesAreSelectable

getURL

setURL

getUserName

setUserName

isReadOnly

setReadOnly

isNullsAreSortedHigh

setNullsAreSortedHigh

isNullsAreSortedLow

setNullsAreSortedLow

isNullsAreSortedAtStart

setNullsAreSortedAtStart

isNullsAreSortedAtEnd

setNullsAreSortedAtEnd

getDatabaseProductName

setDatabaseProductName

getDatabaseProductVersion

setDatabaseProductVersion

getDriverName

setDriverName

getDriverVersion

setDriverVersion

getDriverMajorVersion

setDriverMajorVersion

getDriverMinorVersion

setDriverMinorVersion

isUsesLocalFiles

setUsesLocalFiles

isUsesLocalFilePerTable

setUsesLocalFilePerTable

isSupportsMixedCaseIdentifiers

setSupportsMixedCaseIdentifiers

isStoresUpperCaseIdentifiers

setStoresUpperCaseIdentifiers

isStoresLowerCaseIdentifiers

setStoresLowerCaseIdentifiers

isStoresMixedCaseIdentifiers

setStoresMixedCaseIdentifiers

isSupportsMixedCaseQuotedIdentifiers

setSupportsMixedCaseQuotedIdentifiers

isStoresUpperCaseQuotedIdentifiers

setStoresUpperCaseQuotedIdentifiers

isStoresLowerCaseQuotedIdentifiers

setStoresLowerCaseQuotedIdentifiers

isStoresMixedCaseQuotedIdentifiers

setStoresMixedCaseQuotedIdentifiers

getIdentifierQuoteString

setIdentifierQuoteString

getSQLKeywords

addSQLKeyword

deleteSQLKeyword

isSQLKeywordSupported

getNumericFunctions

addNumericFunction

deleteNumericFunction

isNumericFunctionSupported

getStringFunctions

addStringFunction

deleteStringFunction

isStringFunctionSupported

getSystemFunctions

addSystemFunction

deleteSystemFunction

isSystemFunctionSupported

getTimeDateFunctions

addTimeDateFunction

deleteTimeDateFunction

isTimeDateFunctionSupported

getSearchStringEscape

org.jboss.dna.common.jdbc.model.api
Interface Database