|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
public interface Database

Provides RDBMS wide meta data retrieved from java.sql.DatabaseMetaData.
| 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 |
|---|
List<DatabaseMetaDataMethodException> getExceptionList()
void addException(DatabaseMetaDataMethodException exception)
exception - the DatabaseMetaDataMethodExceptionDatabaseMetaDataMethodException findException(String methodName)
methodName - the name of method that caused exception
boolean isDatabaseMetaDataMethodFailed(String methodName)
methodName - the name of method that caused exception
String getName()
void setName(String name)
name - the database nameBoolean isAllProceduresAreCallable()
DatabaseMetaData.getProcedures.
true if so; false otherwisevoid setAllProceduresAreCallable(Boolean allProceduresAreCallable)
DatabaseMetaData.getProcedures.
allProceduresAreCallable - true if so; false otherwiseBoolean isAllTablesAreSelectable()
DatabaseMetaData.getTables in
a SELECT statement.
true if so; false otherwisevoid setAllTablesAreSelectable(Boolean allTablesAreSelectable)
DatabaseMetaData.getTables in a
SELECT statement.
allTablesAreSelectable - true if so; false otherwiseString getURL()
null if it cannot be generatedvoid setURL(String url)
url - the URL for this DBMS or null if it cannot be generatedString getUserName()
void setUserName(String userName)
userName - the database user nameBoolean isReadOnly()
true if so; false otherwisevoid setReadOnly(Boolean readOnly)
readOnly - true if so; false otherwiseBoolean isNullsAreSortedHigh()
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.
true if so; false otherwisevoid setNullsAreSortedHigh(Boolean nullsAreSortedHigh)
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.
nullsAreSortedHigh - true if so; false otherwiseBoolean isNullsAreSortedLow()
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.
true if so; false otherwisevoid setNullsAreSortedLow(Boolean nullsAreSortedLow)
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.
nullsAreSortedLow - true if so; false otherwiseBoolean isNullsAreSortedAtStart()
NULL values are sorted at the start regardless of sort order.
true if so; false otherwisevoid setNullsAreSortedAtStart(Boolean nullsAreSortedAtStart)
NULL values are sorted at the start regardless of sort order.
nullsAreSortedAtStart - true if so; false otherwiseBoolean isNullsAreSortedAtEnd()
NULL values are sorted at the end regardless of sort order.
true if so; false otherwisevoid setNullsAreSortedAtEnd(Boolean nullsAreSortedAtEnd)
NULL values are sorted at the end regardless of sort order.
nullsAreSortedAtEnd - true if so; false otherwiseString getDatabaseProductName()
void setDatabaseProductName(String databaseProductName)
databaseProductName - database product nameString getDatabaseProductVersion()
void setDatabaseProductVersion(String databaseProductVersion)
databaseProductVersion - database version numberString getDriverName()
void setDriverName(String driverName)
driverName - JDBC driver nameString getDriverVersion()
String.
void setDriverVersion(String driverVersion)
String.
driverVersion - the JDBC driver versionInteger getDriverMajorVersion()
void setDriverMajorVersion(Integer driverMajorVersion)
driverMajorVersion - the JDBC driver major versionInteger getDriverMinorVersion()
void setDriverMinorVersion(Integer driverMinorVersion)
driverMinorVersion - the JDBC driver minor version numberBoolean isUsesLocalFiles()
true if so; false otherwisevoid setUsesLocalFiles(Boolean usesLocalFiles)
usesLocalFiles - true if so; false otherwiseBoolean isUsesLocalFilePerTable()
true if this database uses a local file for each table; false otherwisevoid setUsesLocalFilePerTable(Boolean usesLocalFilePerTable)
usesLocalFilePerTable - true if this database uses a local file for each table; false
otherwiseBoolean isSupportsMixedCaseIdentifiers()
true if so; false otherwisevoid setSupportsMixedCaseIdentifiers(Boolean supportsMixedCaseIdentifiers)
supportsMixedCaseIdentifiers - true if so; false otherwiseBoolean isStoresUpperCaseIdentifiers()
true if so; false otherwisevoid setStoresUpperCaseIdentifiers(Boolean storesUpperCaseIdentifiers)
storesUpperCaseIdentifiers - true if so; false otherwiseBoolean isStoresLowerCaseIdentifiers()
true if so; false otherwisevoid setStoresLowerCaseIdentifiers(Boolean storesLowerCaseIdentifiers)
storesLowerCaseIdentifiers - true if so; false otherwiseBoolean isStoresMixedCaseIdentifiers()
true if so; false otherwisevoid setStoresMixedCaseIdentifiers(Boolean storesMixedCaseIdentifiers)
storesMixedCaseIdentifiers - true if so; false otherwiseBoolean isSupportsMixedCaseQuotedIdentifiers()
true if so; false otherwisevoid setSupportsMixedCaseQuotedIdentifiers(Boolean supportsMixedCaseQuotedIdentifiers)
supportsMixedCaseQuotedIdentifiers - true if so; false otherwiseBoolean isStoresUpperCaseQuotedIdentifiers()
true if so; false otherwisevoid setStoresUpperCaseQuotedIdentifiers(Boolean storesUpperCaseQuotedIdentifiers)
storesUpperCaseQuotedIdentifiers - true if so; false otherwiseBoolean isStoresLowerCaseQuotedIdentifiers()
true if so; false otherwisevoid setStoresLowerCaseQuotedIdentifiers(Boolean storesLowerCaseQuotedIdentifiers)
storesLowerCaseQuotedIdentifiers - true if so; false otherwiseBoolean isStoresMixedCaseQuotedIdentifiers()
true if so; false otherwisevoid setStoresMixedCaseQuotedIdentifiers(Boolean storesMixedCaseQuotedIdentifiers)
storesMixedCaseQuotedIdentifiers - true if so; false otherwiseString getIdentifierQuoteString()
void setIdentifierQuoteString(String identifierQuoteString)
identifierQuoteString - the quoting string or a space if quoting is not supportedSet<String> getSQLKeywords()
void addSQLKeyword(String sqlKeyword)
sqlKeyword - the SQL keyword to addvoid deleteSQLKeyword(String sqlKeyword)
sqlKeyword - the SQL keyword to deleteBoolean isSQLKeywordSupported(String sqlKeyword)
sqlKeyword - the SQL keyword to search
Set<String> getNumericFunctions()
void addNumericFunction(String functionName)
functionName - the name of numeric function to addvoid deleteNumericFunction(String functionName)
functionName - the name of numeric function to deleteBoolean isNumericFunctionSupported(String functionName)
functionName - the name of numeric function
Set<String> getStringFunctions()
void addStringFunction(String functionName)
functionName - the name of String function to addvoid deleteStringFunction(String functionName)
functionName - the name of String function to deleteBoolean isStringFunctionSupported(String functionName)
functionName - the name of String function
Set<String> getSystemFunctions()
void addSystemFunction(String functionName)
functionName - the name of System function to addvoid deleteSystemFunction(String functionName)
functionName - the name of System function to deleteBoolean isSystemFunctionSupported(String functionName)
functionName - the name of System function
Set<String> getTimeDateFunctions()
void addTimeDateFunction(String functionName)
functionName - the name of Time/Date function to addvoid deleteTimeDateFunction(String functionName)
functionName - the name of Time/Date function to deleteBoolean isTimeDateFunctionSupported(String functionName)
functionName - the name of Time/Date function
String getSearchStringEscape()
The '_' character represents any single character; the '%' character represents any sequence of zero or more characters.
void setSearchStringEscape(String searchStringEscape)
The '_' character represents any single character; the '%' character represents any sequence of zero or more characters.
searchStringEscape - the string used to escape wildcard charactersString getExtraNameCharacters()
void setExtraNameCharacters(String extraNameCharacters)
extraNameCharacters - the string containing the extra charactersBoolean isSupportsAlterTableWithAddColumn()
ALTER TABLE with add column.
true if so; false otherwisevoid setSupportsAlterTableWithAddColumn(Boolean supportsAlterTableWithAddColumn)
ALTER TABLE with add column.
supportsAlterTableWithAddColumn - true if so; false otherwiseBoolean isSupportsAlterTableWithDropColumn()
ALTER TABLE with drop column.
true if so; false otherwisevoid setSupportsAlterTableWithDropColumn(Boolean supportsAlterTableWithDropColumn)
ALTER TABLE with drop column.
supportsAlterTableWithDropColumn - true if so; false otherwiseBoolean isSupportsColumnAliasing()
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.
true if so; false otherwisevoid setSupportsColumnAliasing(Boolean supportsColumnAliasing)
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.
supportsColumnAliasing - true if so; false otherwiseBoolean isNullPlusNonNullIsNull()
NULL and non-NULL values being
NULL.
true if so; false otherwisevoid setNullPlusNonNullIsNull(Boolean nullPlusNonNullIsNull)
NULL and non-NULL values being
NULL.
nullPlusNonNullIsNull - true if so; false otherwiseBoolean isSupportsConvert()
CONVERT function between SQL types.
true if so; false otherwisevoid setSupportsConvert(Boolean supportsConvert)
CONVERT function between SQL types.
supportsConvert - true if so; false otherwiseSet<SqlTypeConversionPair> getSupportedConversions()
CONVERT for given SQL types. It uses original
DatabaseMetaData.supportsConvert to check common (NOT ALL POSSIBLE) conversions.
Typesvoid addSqlTypeConversionPair(SqlTypeConversionPair sqlTypeConversionPair)
sqlTypeConversionPair - the SqlTypeConversionPairvoid deleteSqlTypeConversionPair(SqlTypeConversionPair sqlTypeConversionPair)
sqlTypeConversionPair - the SqlTypeConversionPairSet<SqlTypeConversionPair> findSqlTypeConversionPairBySrcType(String srcType)
srcType - the source type
Boolean isSupportsTableCorrelationNames()
true if so; false otherwisevoid setSupportsTableCorrelationNames(Boolean supportsTableCorrelationNames)
supportsTableCorrelationNames - true if so; false otherwiseBoolean isSupportsDifferentTableCorrelationNames()
true if so; false otherwisevoid setSupportsDifferentTableCorrelationNames(Boolean supportsDifferentTableCorrelationNames)
supportsDifferentTableCorrelationNames - true if so; false otherwiseBoolean isSupportsExpressionsInOrderBy()
ORDER BY lists.
true if so; false otherwisevoid setSupportsExpressionsInOrderBy(Boolean supportsExpressionsInOrderBy)
ORDER BY lists.
supportsExpressionsInOrderBy - true if so; false otherwiseBoolean isSupportsOrderByUnrelated()
SELECT statement in an
ORDER BY clause.
true if so; false otherwisevoid setSupportsOrderByUnrelated(Boolean supportsOrderByUnrelated)
SELECT statement in an
ORDER BY clause.
supportsOrderByUnrelated - true if so; false otherwiseBoolean isSupportsGroupBy()
GROUP BY clause.
true if so; false otherwisevoid setSupportsGroupBy(Boolean supportsGroupBy)
GROUP BY clause.
supportsGroupBy - true if so; false otherwiseBoolean isSupportsGroupByUnrelated()
SELECT statement in a
GROUP BY clause.
true if so; false otherwisevoid setSupportsGroupByUnrelated(Boolean supportsGroupByUnrelated)
SELECT statement in a
GROUP BY clause.
supportsGroupByUnrelated - true if so; false otherwiseBoolean isSupportsGroupByBeyondSelect()
SELECT statement in a
GROUP BY clause provided that all of the columns in the SELECT statement are included in the
GROUP BY clause.
true if so; false otherwisevoid setSupportsGroupByBeyondSelect(Boolean supportsGroupByBeyondSelect)
SELECT statement in a
GROUP BY clause provided that all of the columns in the SELECT statement are included in the
GROUP BY clause.
supportsGroupByBeyondSelect - true if so; false otherwiseBoolean isSupportsLikeEscapeClause()
LIKE escape clause.
true if so; false otherwisevoid setSupportsLikeEscapeClause(Boolean supportsLikeEscapeClause)
LIKE escape clause.
supportsLikeEscapeClause - true if so; false otherwiseBoolean isSupportsMultipleResultSets()
ResultSet objects from a single call to the method
execute.
true if so; false otherwisevoid setSupportsMultipleResultSets(Boolean supportsMultipleResultSets)
ResultSet objects from a single call to the method
execute.
supportsMultipleResultSets - true if so; false otherwiseBoolean isSupportsMultipleTransactions()
true if so; false otherwisevoid setSupportsMultipleTransactions(Boolean supportsMultipleTransactions)
supportsMultipleTransactions - true if so; false otherwiseBoolean isSupportsNonNullableColumns()
true if so; false otherwisevoid setSupportsNonNullableColumns(Boolean supportsNonNullableColumns)
supportsNonNullableColumns - true if so; false otherwiseBoolean isSupportsMinimumSQLGrammar()
true if so; false otherwisevoid setSupportsMinimumSQLGrammar(Boolean supportsMinimumSQLGrammar)
supportsMinimumSQLGrammar - true if so; false otherwiseBoolean isSupportsCoreSQLGrammar()
true if so; false otherwisevoid setSupportsCoreSQLGrammar(Boolean supportsCoreSQLGrammar)
supportsCoreSQLGrammar - true if so; false otherwiseBoolean isSupportsExtendedSQLGrammar()
true if so; false otherwisevoid setSupportsExtendedSQLGrammar(Boolean supportsExtendedSQLGrammar)
supportsExtendedSQLGrammar - true if so; false otherwiseBoolean isSupportsANSI92EntryLevelSQL()
true if so; false otherwisevoid setSupportsANSI92EntryLevelSQL(Boolean supportsANSI92EntryLevelSQL)
supportsANSI92EntryLevelSQL - true if so; false otherwiseBoolean isSupportsANSI92IntermediateSQL()
true if so; false otherwisevoid setSupportsANSI92IntermediateSQL(Boolean supportsANSI92IntermediateSQL)
supportsANSI92IntermediateSQL - true if so; false otherwiseBoolean isSupportsANSI92FullSQL()
true if so; false otherwisevoid setSupportsANSI92FullSQL(Boolean supportsANSI92FullSQL)
supportsANSI92FullSQL - true if so; false otherwiseBoolean isSupportsIntegrityEnhancementFacility()
true if so; false otherwisevoid setSupportsIntegrityEnhancementFacility(Boolean supportsIntegrityEnhancementFacility)
supportsIntegrityEnhancementFacility - true if so; false otherwiseBoolean isSupportsOuterJoins()
true if so; false otherwisevoid setSupportsOuterJoins(Boolean supportsOuterJoins)
supportsOuterJoins - true if so; false otherwiseBoolean isSupportsFullOuterJoins()
true if so; false otherwisevoid setSupportsFullOuterJoins(Boolean supportsFullOuterJoins)
supportsFullOuterJoins - true if so; false otherwiseBoolean isSupportsLimitedOuterJoins()
true if the method
DatabaseMetaData.supportsFullOuterJoins returns true).
true if so; false otherwisevoid setSupportsLimitedOuterJoins(Boolean supportsLimitedOuterJoins)
true if the method
DatabaseMetaData.supportsFullOuterJoins returns true).
supportsLimitedOuterJoins - true if so; false otherwiseString getSchemaTerm()
void setSchemaTerm(String schemaTerm)
schemaTerm - the vendor term for "schema"String getProcedureTerm()
void setProcedureTerm(String procedureTerm)
procedureTerm - the vendor term for "procedure"String getCatalogTerm()
void setCatalogTerm(String catalogTerm)
catalogTerm - the vendor term for "catalog"Boolean isCatalogAtStart()
true if the catalog name appears at the beginning of a fully qualified table name; false
otherwisevoid setCatalogAtStart(Boolean catalogAtStart)
catalogAtStart - true if the catalog name appears at the beginning of a fully qualified table name;
false otherwiseString getCatalogSeparator()
String that this database uses as the separator between a catalog and table name.
void setCatalogSeparator(String catalogSeparator)
String that this database uses as the separator between a catalog and table name.
catalogSeparator - the separator stringBoolean isSupportsSchemasInDataManipulation()
true if so; false otherwisevoid setSupportsSchemasInDataManipulation(Boolean supportsSchemasInDataManipulation)
supportsSchemasInDataManipulation - true if so; false otherwiseBoolean isSupportsSchemasInProcedureCalls()
true if so; false otherwisevoid setSupportsSchemasInProcedureCalls(Boolean supportsSchemasInProcedureCalls)
supportsSchemasInProcedureCalls - true if so; false otherwiseBoolean isSupportsSchemasInTableDefinitions()
true if so; false otherwisevoid setSupportsSchemasInTableDefinitions(Boolean supportsSchemasInTableDefinitions)
supportsSchemasInTableDefinitions - true if so; false otherwiseBoolean isSupportsSchemasInIndexDefinitions()
true if so; false otherwisevoid setSupportsSchemasInIndexDefinitions(Boolean supportsSchemasInIndexDefinitions)
supportsSchemasInIndexDefinitions - true if so; false otherwiseBoolean isSupportsSchemasInPrivilegeDefinitions()
true if so; false otherwisevoid setSupportsSchemasInPrivilegeDefinitions(Boolean supportsSchemasInPrivilegeDefinitions)
supportsSchemasInPrivilegeDefinitions - true if so; false otherwiseBoolean isSupportsCatalogsInDataManipulation()
true if so; false otherwisevoid setSupportsCatalogsInDataManipulation(Boolean supportsCatalogsInDataManipulation)
supportsCatalogsInDataManipulation - true if so; false otherwiseBoolean isSupportsCatalogsInProcedureCalls()
true if so; false otherwisevoid setSupportsCatalogsInProcedureCalls(Boolean supportsCatalogsInProcedureCalls)
supportsCatalogsInProcedureCalls - true if so; false otherwiseBoolean isSupportsCatalogsInTableDefinitions()
true if so; false otherwisevoid setSupportsCatalogsInTableDefinitions(Boolean supportsCatalogsInTableDefinitions)
supportsCatalogsInTableDefinitions - true if so; false otherwiseBoolean isSupportsCatalogsInIndexDefinitions()
true if so; false otherwisevoid setSupportsCatalogsInIndexDefinitions(Boolean supportsCatalogsInIndexDefinitions)
supportsCatalogsInIndexDefinitions - true if so; false otherwiseBoolean isSupportsCatalogsInPrivilegeDefinitions()
true if so; false otherwisevoid setSupportsCatalogsInPrivilegeDefinitions(Boolean supportsCatalogsInPrivilegeDefinitions)
supportsCatalogsInPrivilegeDefinitions - true if so; false otherwiseBoolean isSupportsPositionedDelete()
DELETE statements.
true if so; false otherwisevoid setSupportsPositionedDelete(Boolean supportsPositionedDelete)
DELETE statements.
supportsPositionedDelete - true if so; false otherwiseBoolean isSupportsPositionedUpdate()
UPDATE statements.
true if so; false otherwisevoid setSupportsPositionedUpdate(Boolean supportsPositionedUpdate)
UPDATE statements.
supportsPositionedUpdate - true if so; false otherwiseBoolean isSupportsSelectForUpdate()
SELECT FOR UPDATE statements.
true if so; false otherwisevoid setSupportsSelectForUpdate(Boolean supportsSelectForUpdate)
SELECT FOR UPDATE statements.
supportsSelectForUpdate - true if so; false otherwiseBoolean isSupportsStoredProcedures()
true if so; false otherwisevoid setSupportsStoredProcedures(Boolean supportsStoredProcedures)
supportsStoredProcedures - true if so; false otherwiseBoolean isSupportsSubqueriesInComparisons()
true if so; false otherwisevoid setSupportsSubqueriesInComparisons(Boolean supportsSubqueriesInComparisons)
supportsSubqueriesInComparisons - true if so; false otherwiseBoolean isSupportsSubqueriesInExists()
EXISTS expressions.
true if so; false otherwisevoid setSupportsSubqueriesInExists(Boolean supportsSubqueriesInExists)
EXISTS expressions.
supportsSubqueriesInExists - true if so; false otherwiseBoolean isSupportsSubqueriesInIns()
IN statements.
true if so; false otherwisevoid setSupportsSubqueriesInIns(Boolean supportsSubqueriesInIns)
IN statements.
supportsSubqueriesInIns - true if so; false otherwiseBoolean isSupportsSubqueriesInQuantifieds()
true if so; false otherwisevoid setSupportsSubqueriesInQuantifieds(Boolean supportsSubqueriesInQuantifieds)
supportsSubqueriesInQuantifieds - true if so; false otherwiseBoolean isSupportsCorrelatedSubqueries()
true if so; false otherwisevoid setSupportsCorrelatedSubqueries(Boolean supportsCorrelatedSubqueries)
supportsCorrelatedSubqueries - true if so; false otherwiseBoolean isSupportsUnion()
UNION.
true if so; false otherwisevoid setSupportsUnion(Boolean supportsUnion)
UNION.
supportsUnion - true if so; false otherwiseBoolean isSupportsUnionAll()
UNION ALL.
true if so; false otherwisevoid setSupportsUnionAll(Boolean supportsUnionAll)
UNION ALL.
supportsUnionAll - true if so; false otherwiseBoolean isSupportsOpenCursorsAcrossCommit()
true if cursors always remain open; false if they might not remain openvoid setSupportsOpenCursorsAcrossCommit(Boolean supportsOpenCursorsAcrossCommit)
supportsOpenCursorsAcrossCommit - true if cursors always remain open; false if they might
not remain openBoolean isSupportsOpenCursorsAcrossRollback()
true if cursors always remain open; false if they might not remain openvoid setSupportsOpenCursorsAcrossRollback(Boolean supportsOpenCursorsAcrossRollback)
supportsOpenCursorsAcrossRollback - true if cursors always remain open; false if they might
not remain openBoolean isSupportsOpenStatementsAcrossCommit()
true if statements always remain open; false if they might not remain openvoid setSupportsOpenStatementsAcrossCommit(Boolean supportsOpenStatementsAcrossCommit)
supportsOpenStatementsAcrossCommit - true if statements always remain open; false if they
might not remain openBoolean isSupportsOpenStatementsAcrossRollback()
true if statements always remain open; false if they might not remain openvoid setSupportsOpenStatementsAcrossRollback(Boolean supportsOpenStatementsAcrossRollback)
supportsOpenStatementsAcrossRollback - true if statements always remain open; false if they
might not remain openInteger getMaxBinaryLiteralLength()
void setMaxBinaryLiteralLength(Integer maxBinaryLiteralLength)
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 knownInteger getMaxCharLiteralLength()
void setMaxCharLiteralLength(Integer maxCharLiteralLength)
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 knownInteger getMaxColumnNameLength()
void setMaxColumnNameLength(Integer maxColumnNameLength)
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 knownInteger getMaxColumnsInGroupBy()
GROUP BY clause.
void setMaxColumnsInGroupBy(Integer maxColumnsInGroupBy)
GROUP BY clause.
maxColumnsInGroupBy - the maximum number of columns allowed; a result of zero means that there is no limit or the
limit is not knownInteger getMaxColumnsInIndex()
void setMaxColumnsInIndex(Integer maxColumnsInIndex)
maxColumnsInIndex - the maximum number of columns allowed; a result of zero means that there is no limit or the limit
is not knownInteger getMaxColumnsInOrderBy()
ORDER BY clause.
void setMaxColumnsInOrderBy(Integer maxColumnsInOrderBy)
ORDER BY clause.
maxColumnsInOrderBy - the maximum number of columns allowed; a result of zero means that there is no limit or the
limit is not knownInteger getMaxColumnsInSelect()
SELECT list.
void setMaxColumnsInSelect(Integer maxColumnsInSelect)
SELECT list.
maxColumnsInSelect - the maximum number of columns allowed; a result of zero means that there is no limit or the limit
is not knownInteger getMaxColumnsInTable()
void setMaxColumnsInTable(Integer maxColumnsInTable)
maxColumnsInTable - the maximum number of columns allowed; a result of zero means that there is no limit or the limit
is not knownInteger getMaxConnections()
void setMaxConnections(Integer maxConnections)
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 knownInteger getMaxCursorNameLength()
void setMaxCursorNameLength(Integer maxCursorNameLength)
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 knownInteger getMaxIndexLength()
void setMaxIndexLength(Integer maxIndexLength)
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 knownInteger getMaxSchemaNameLength()
void setMaxSchemaNameLength(Integer maxSchemaNameLength)
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 knownInteger getMaxProcedureNameLength()
void setMaxProcedureNameLength(Integer maxProcedureNameLength)
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 knownInteger getMaxCatalogNameLength()
void setMaxCatalogNameLength(Integer maxCatalogNameLength)
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 knownInteger getMaxRowSize()
void setMaxRowSize(Integer maxRowSize)
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 knownBoolean isMaxRowSizeIncludeBlobs()
getMaxRowSize includes the SQL data types
LONGVARCHAR and LONGVARBINARY.
true if so; false otherwisevoid setMaxRowSizeIncludeBlobs(Boolean maxRowSizeIncludeBlobs)
getMaxRowSize includes the SQL data types
LONGVARCHAR and LONGVARBINARY.
maxRowSizeIncludeBlobs - true if so; false otherwiseInteger getMaxStatementLength()
void setMaxStatementLength(Integer maxStatementLength)
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 knownInteger getMaxStatements()
void setMaxStatements(Integer maxStatements)
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 knownInteger getMaxTableNameLength()
void setMaxTableNameLength(Integer maxTableNameLength)
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 knownInteger getMaxTablesInSelect()
SELECT statement.
SELECT statement; a result of zero means that there is no
limit or the limit is not knownvoid setMaxTablesInSelect(Integer maxTablesInSelect)
SELECT statement.
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 knownInteger getMaxUserNameLength()
void setMaxUserNameLength(Integer maxUserNameLength)
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 knownInteger getDefaultTransactionIsolation()
java.sql.Connection.
Connectionvoid setDefaultTransactionIsolation(Integer defaultTransactionIsolation)
java.sql.Connection.
defaultTransactionIsolation - the default isolation levelConnectionBoolean isSupportsTransactions()
commit is a noop, and the
isolation level is TRANSACTION_NONE.
true if transactions are supported; false otherwisevoid setSupportsTransactions(Boolean supportsTransactions)
commit is a noop, and the
isolation level is TRANSACTION_NONE.
supportsTransactions - true if transactions are supported; false otherwiseSet<TransactionIsolationLevelType> getSupportedTransactionIsolationLevels()
Connectionvoid addSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)
transactionIsolationLevelType - the Transaction Isolation Level Typevoid deleteSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)
transactionIsolationLevelType - the Transaction Isolation Level TypeBoolean isSupportedTransactionIsolationLevelType(TransactionIsolationLevelType transactionIsolationLevelType)
transactionIsolationLevelType - the Transaction Isolation Level Type
Boolean isSupportsDataDefinitionAndDataManipulationTransactions()
true if so; false otherwisevoid setSupportsDataDefinitionAndDataManipulationTransactions(Boolean supportsDataDefinitionAndDataManipulationTransactions)
supportsDataDefinitionAndDataManipulationTransactions - true if so; false otherwiseBoolean isSupportsDataManipulationTransactionsOnly()
true if so; false otherwisevoid setSupportsDataManipulationTransactionsOnly(Boolean supportsDataManipulationTransactionsOnly)
supportsDataManipulationTransactionsOnly - true if so; false otherwiseBoolean isDataDefinitionCausesTransactionCommit()
true if so; false otherwisevoid setDataDefinitionCausesTransactionCommit(Boolean dataDefinitionCausesTransactionCommit)
dataDefinitionCausesTransactionCommit - true if so; false otherwiseBoolean isDataDefinitionIgnoredInTransactions()
true if so; false otherwisevoid setDataDefinitionIgnoredInTransactions(Boolean dataDefinitionIgnoredInTransactions)
dataDefinitionIgnoredInTransactions - true if so; false otherwiseSet<StoredProcedure> getStoredProcedures()
void addStoredProcedure(StoredProcedure storedProcedure)
storedProcedure - the Stored Procedurevoid deleteStoredProcedure(StoredProcedure storedProcedure)
storedProcedure - the Stored Procedure
StoredProcedure findStoredProcedureByName(String catalog,
String schema,
String procedureName)
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 searchschema - 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 searchprocedureName - a procedure name; must match the procedure name as it is stored in the database
Set<Table> getTables()
void addTable(Table table)
table - the table to addvoid deleteTable(Table table)
table - the table to delete
Table findTableByName(String catalog,
String schema,
String tableName)
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 searchschema - 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 searchtableName - a table name; must match the table name as it is stored in the database
Set<Schema> getSchemas()
void addSchema(Schema schema)
schema - the Schemavoid deleteSchema(Schema schema)
schema - the Schema
Schema findSchemaByName(String catalog,
String schemaName)
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 searchschemaName - a schema name; must match the schema name as it is stored in the database;
Set<Catalog> getCatalogs()
void addCatalog(Catalog catalog)
catalog - the catalog to addvoid deleteCatalog(Catalog catalog)
catalog - the catalog to deleteCatalog findCatalogByName(String catalogName)
catalogName - a catalog name; must match the catalog name as it is stored in the database;
Set<TableType> getTableTypes()
The table type is:
void addTableType(TableType tableType)
tableType - the table type to addvoid deleteTableType(TableType tableType)
tableType - the table type to deleteTableType findTableTypeByTypeName(String typeName)
typeName - a table type name; must match the type name as it is stored in the database;
Set<SqlTypeInfo> getSqlTypeInfos()
void addSqlTypeInfo(SqlTypeInfo sqlTypeInfo)
sqlTypeInfo - the SQL type to addvoid deleteSqlTypeInfo(SqlTypeInfo sqlTypeInfo)
sqlTypeInfo - the SQL type to deleteSqlTypeInfo findSqlTypeInfoByTypeName(String typeName)
typeName - a table type name; must match the type name as it is stored in the database;
Set<ResultSetType> getSupportedResultSetTypes()
Connectionvoid addSupportedResultSetType(ResultSetType resultSetType)
resultSetType - the ResultSetTypevoid deleteSupportedResultSetType(ResultSetType resultSetType)
resultSetType - the ResultSetTypeSet<ResultSetConcurrencyType> getSupportedForwardOnlyResultSetConcurrencies()
Connectionvoid addSupportedForwardOnlyResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)
resultSetConcurrencyType - the ResultSetConcurrencyTypevoid deleteSupportedForwardOnlyResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)
resultSetConcurrencyType - the ResultSetConcurrencyTypeSet<ResultSetConcurrencyType> getSupportedScrollInsensitiveResultSetConcurrencies()
Connectionvoid addSupportedScrollInsensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)
resultSetConcurrencyType - the ResultSetConcurrencyTypevoid deleteSupportedScrollInsensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)
resultSetConcurrencyType - the ResultSetConcurrencyTypeSet<ResultSetConcurrencyType> getSupportedScrollSensitiveResultSetConcurrencies()
Connectionvoid addSupportedScrollSensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)
resultSetConcurrencyType - the ResultSetConcurrencyTypevoid deleteSupportedScrollSensitiveResultSetConcurrency(ResultSetConcurrencyType resultSetConcurrencyType)
resultSetConcurrencyType - the ResultSetConcurrencyTypeBoolean isForwardOnlyResultSetOwnUpdatesAreVisible()
ResultSet object, the result set's own updates are visible.
true if updates are visible for the given result set type; false otherwisevoid setForwardOnlyResultSetOwnUpdatesAreVisible(Boolean forwardOnlyResultSetOwnUpdatesAreVisible)
ResultSet object, the result set's own updates are visible.
forwardOnlyResultSetOwnUpdatesAreVisible - true if updates are visible for the given result set type;
false otherwiseBoolean isScrollInsensitiveResultSetOwnUpdatesAreVisible()
ResultSet object, the result set's own updates are visible.
true if updates are visible for the given result set type; false otherwisevoid setScrollInsensitiveResultSetOwnUpdatesAreVisible(Boolean scrollInsensitiveResultSetOwnUpdatesAreVisible)
ResultSet object, the result set's own updates are visible.
scrollInsensitiveResultSetOwnUpdatesAreVisible - true if updates are visible for the given result set
type; false otherwiseBoolean isScrollSensitiveResultSetOwnUpdatesAreVisible()
ResultSet object, the result set's own updates are visible.
true if updates are visible for the given result set type; false otherwisevoid setScrollSensitiveResultSetOwnUpdatesAreVisible(Boolean scrollSensitiveResultSetOwnUpdatesAreVisible)
ResultSet object, the result set's own updates are visible.
scrollSensitiveResultSetOwnUpdatesAreVisible - true if updates are visible for the given result set type;
false otherwiseBoolean isForwardOnlyResultSetOwnDeletesAreVisible()
true if deletes are visible for the given result set type; false otherwisevoid setForwardOnlyResultSetOwnDeletesAreVisible(Boolean forwardOnlyResultSetOwnDeletesAreVisible)
forwardOnlyResultSetOwnDeletesAreVisible - true if deletes are visible for the given result set type;
false otherwiseBoolean isScrollInsensitiveResultSetOwnDeletesAreVisible()
true if deletes are visible for the given result set type; false otherwisevoid setScrollInsensitiveResultSetOwnDeletesAreVisible(Boolean scrollInsensitiveResultSetOwnDeletesAreVisible)
scrollInsensitiveResultSetOwnDeletesAreVisible - true if deletes are visible for the given result set
type; false otherwiseBoolean isScrollSensitiveResultSetOwnDeletesAreVisible()
true if deletes are visible for the given result set type; false otherwisevoid setScrollSensitiveResultSetOwnDeletesAreVisible(Boolean scrollSensitiveResultSetOwnDeletesAreVisible)
scrollSensitiveResultSetOwnDeletesAreVisible - true if deletes are visible for the given result set type;
false otherwiseBoolean isForwardOnlyResultSetOwnInsertsAreVisible()
true if inserts are visible for the given result set type; false otherwisevoid setForwardOnlyResultSetOwnInsertsAreVisible(Boolean forwardOnlyResultSetOwnInsertsAreVisible)
forwardOnlyResultSetOwnInsertsAreVisible - true if inserts are visible for the given result set type;
false otherwiseBoolean isScrollInsensitiveResultSetOwnInsertsAreVisible()
true if inserts are visible for the given result set type; false otherwisevoid setScrollInsensitiveResultSetOwnInsertsAreVisible(Boolean scrollInsensitiveResultSetOwnInsertsAreVisible)
scrollInsensitiveResultSetOwnInsertsAreVisible - true if inserts are visible for the given result set
type; false otherwiseBoolean isScrollSensitiveResultSetOwnInsertsAreVisible()
true if inserts are visible for the given result set type; false otherwisevoid setScrollSensitiveResultSetOwnInsertsAreVisible(Boolean scrollSensitiveResultSetOwnInsertsAreVisible)
scrollSensitiveResultSetOwnInsertsAreVisible - true if inserts are visible for the given result set type;
false otherwiseBoolean isForwardOnlyResultSetOthersUpdatesAreVisible()
true if updates made by others are visible for the given result set type; false otherwisevoid setForwardOnlyResultSetOthersUpdatesAreVisible(Boolean forwardOnlyResultSetOthersUpdatesAreVisible)
forwardOnlyResultSetOthersUpdatesAreVisible - true if updates made by others are visible for the given
result set type; false otherwiseBoolean isScrollInsensitiveResultSetOthersUpdatesAreVisible()
true if updates made by others are visible for the given result set type; false otherwisevoid setScrollInsensitiveResultSetOthersUpdatesAreVisible(Boolean scrollInsensitiveResultSetOthersUpdatesAreVisible)
scrollInsensitiveResultSetOthersUpdatesAreVisible - true if updates made by others are visible for the
given result set type; false otherwiseBoolean isScrollSensitiveResultSetOthersUpdatesAreVisible()
true if updates made by others are visible for the given result set type; false otherwisevoid setScrollSensitiveResultSetOthersUpdatesAreVisible(Boolean scrollSensitiveResultSetOthersUpdatesAreVisible)
scrollSensitiveResultSetOthersUpdatesAreVisible - true if updates made by others are visible for the
given result set type; false otherwiseBoolean isForwardOnlyResultSetOthersDeletesAreVisible()
true if deletes made by others are visible for the given result set type; false otherwisevoid setForwardOnlyResultSetOthersDeletesAreVisible(Boolean forwardOnlyResultSetOthersDeletesAreVisible)
forwardOnlyResultSetOthersDeletesAreVisible - true if deletes made by others are visible for the given
result set type; false otherwiseBoolean isScrollInsensitiveResultSetOthersDeletesAreVisible()
true if deletes made by others are visible for the given result set type; false otherwisevoid setScrollInsensitiveResultSetOthersDeletesAreVisible(Boolean scrollInsensitiveResultSetOthersDeletesAreVisible)
scrollInsensitiveResultSetOthersDeletesAreVisible - true if deletes made by others are visible for the
given result set type; false otherwiseBoolean isScrollSensitiveResultSetOthersDeletesAreVisible()
true if deletes made by others are visible for the given result set type; false otherwisevoid setScrollSensitiveResultSetOthersDeletesAreVisible(Boolean scrollSensitiveResultSetOthersDeletesAreVisible)
scrollSensitiveResultSetOthersDeletesAreVisible - true if deletes made by others are visible for the
given result set type; false otherwiseBoolean isForwardOnlyResultSetOthersInsertsAreVisible()
true if inserts made by others are visible for the given result set type; false otherwisevoid setForwardOnlyResultSetOthersInsertsAreVisible(Boolean forwardOnlyResultSetOthersInsertsAreVisible)
forwardOnlyResultSetOthersInsertsAreVisible - true if inserts made by others are visible for the given
result set type; false otherwiseBoolean isScrollInsensitiveResultSetOthersInsertsAreVisible()
true if inserts made by others are visible for the given result set type; false otherwisevoid setScrollInsensitiveResultSetOthersInsertsAreVisible(Boolean scrollInsensitiveResultSetOthersInsertsAreVisible)
scrollInsensitiveResultSetOthersInsertsAreVisible - true if inserts made by others are visible for the
given result set type; false otherwiseBoolean isScrollSensitiveResultSetOthersInsertsAreVisible()
true if inserts made by others are visible for the given result set type; false otherwisevoid setScrollSensitiveResultSetOthersInsertsAreVisible(Boolean scrollSensitiveResultSetOthersInsertsAreVisible)
scrollSensitiveResultSetOthersInsertsAreVisible - true if inserts made by others are visible for the
given result set type; false otherwiseBoolean isForwardOnlyResultSetUpdatesAreDetected()
ResultSet.rowUpdated.
true if changes are detected by the result set type; false otherwisevoid setForwardOnlyResultSetUpdatesAreDetected(Boolean forwardOnlyResultSetUpdatesAreDetected)
ResultSet.rowUpdated.
forwardOnlyResultSetUpdatesAreDetected - true if changes are detected by the result set type;
false otherwiseBoolean isScrollInsensitiveResultSetUpdatesAreDetected()
ResultSet.rowUpdated.
true if changes are detected by the result set type; false otherwisevoid setScrollInsensitiveResultSetUpdatesAreDetected(Boolean scrollInsensitiveResultSetUpdatesAreDetected)
ResultSet.rowUpdated.
scrollInsensitiveResultSetUpdatesAreDetected - true if changes are detected by the result set type;
false otherwiseBoolean isScrollSensitiveResultSetUpdatesAreDetected()
ResultSet.rowUpdated.
true if changes are detected by the result set type; false otherwisevoid setScrollSensitiveResultSetUpdatesAreDetected(Boolean scrollSensitiveResultSetUpdatesAreDetected)
ResultSet.rowUpdated.
scrollSensitiveResultSetUpdatesAreDetected - true if changes are detected by the result set type;
false otherwiseBoolean isForwardOnlyResultSetDeletesAreDetected()
ResultSet.rowDeleted. If
the method deletesAreDetected returns false, it means that deleted rows are removed from the
result set.
true if deletes are detected by the given result set type; false otherwisevoid setForwardOnlyResultSetDeletesAreDetected(Boolean forwardOnlyResultSetDeletesAreDetected)
ResultSet.rowDeleted. If the
method deletesAreDetected returns false, it means that deleted rows are removed from the result
set.
forwardOnlyResultSetDeletesAreDetected - true if deletes are detected by the given result set type;
false otherwiseBoolean isScrollInsensitiveResultSetDeletesAreDetected()
ResultSet.rowDeleted. If
the method deletesAreDetected returns false, it means that deleted rows are removed from the
result set.
true if deletes are detected by the given result set type; false otherwisevoid setScrollInsensitiveResultSetDeletesAreDetected(Boolean scrollInsensitiveResultSetDeletesAreDetected)
ResultSet.rowDeleted. If the
method deletesAreDetected returns false, it means that deleted rows are removed from the result
set.
scrollInsensitiveResultSetDeletesAreDetected - true if deletes are detected by the given result set type;
false otherwiseBoolean isScrollSensitiveResultSetDeletesAreDetected()
ResultSet.rowDeleted. If
the method deletesAreDetected returns false, it means that deleted rows are removed from the
result set.
true if deletes are detected by the given result set type; false otherwisevoid setScrollSensitiveResultSetDeletesAreDetected(Boolean scrollSensitiveResultSetDeletesAreDetected)
ResultSet.rowDeleted. If the
method deletesAreDetected returns false, it means that deleted rows are removed from the result
set.
scrollSensitiveResultSetDeletesAreDetected - true if deletes are detected by the given result set type;
false otherwiseBoolean isForwardOnlyResultInsertsAreDetected()
ResultSet.rowInserted.
true if changes are detected by the specified result set type; false otherwisevoid setForwardOnlyResultInsertsAreDetected(Boolean forwardOnlyResultInsertsAreDetected)
ResultSet.rowInserted.
forwardOnlyResultInsertsAreDetected - true if changes are detected by the specified result set type;
false otherwiseBoolean isScrollInsensitiveResultInsertsAreDetected()
ResultSet.rowInserted.
true if changes are detected by the specified result set type; false otherwisevoid setScrollInsensitiveResultInsertsAreDetected(Boolean scrollInsensitiveResultInsertsAreDetected)
ResultSet.rowInserted.
scrollInsensitiveResultInsertsAreDetected - true if changes are detected by the specified result set
type; false otherwiseBoolean isScrollSensitiveResultInsertsAreDetected()
ResultSet.rowInserted.
true if changes are detected by the specified result set type; false otherwisevoid setScrollSensitiveResultInsertsAreDetected(Boolean scrollSensitiveResultInsertsAreDetected)
ResultSet.rowInserted.
scrollSensitiveResultInsertsAreDetected - true if changes are detected by the specified result set type;
false otherwiseBoolean isSupportsBatchUpdates()
true if this database supports batch upcates; false otherwisevoid setSupportsBatchUpdates(Boolean supportsBatchUpdates)
supportsBatchUpdates - true if this database supports batch upcates; false otherwiseSet<UserDefinedType> getUserDefinedTypes()
void addUserDefinedType(UserDefinedType udt)
udt - the UDT to addvoid deleteUserDefinedType(UserDefinedType udt)
udt - the UDT to delete
UserDefinedType findUserDefinedTypeByName(String catalog,
String schema,
String tableName)
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 searchschema - 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 searchtableName - a table name; must match the table name as it is stored in the database
Boolean isSupportsSavepoints()
true if savepoints are supported; false otherwisevoid setSupportsSavepoints(Boolean supportsSavepoints)
supportsSavepoints - true if savepoints are supported; false otherwiseBoolean isSupportsNamedParameters()
true if named parameters are supported; false otherwisevoid setSupportsNamedParameters(Boolean supportsNamedParameters)
supportsNamedParameters - true if named parameters are supported; false otherwiseBoolean isSupportsMultipleOpenResults()
ResultSet objects returned from a
CallableStatement object simultaneously.
true if a CallableStatement object can return multiple ResultSet objects
simultaneously; false otherwisevoid setSupportsMultipleOpenResults(Boolean supportsMultipleOpenResults)
ResultSet objects returned from a CallableStatement
object simultaneously.
supportsMultipleOpenResults - true if a CallableStatement object can return multiple
ResultSet objects simultaneously; false otherwiseBoolean isSupportsGetGeneratedKeys()
true if auto-generated keys can be retrieved after a statement has executed; false
otherwisevoid setSupportsGetGeneratedKeys(Boolean supportsGetGeneratedKeys)
supportsGetGeneratedKeys - true if auto-generated keys can be retrieved after a statement has executed;
false otherwiseBoolean isSupportsResultSetHoldCurrorsOverCommitHoldability()
true if so; false otherwiseConnectionvoid setSupportsResultSetHoldCurrorsOverCommitHoldability(Boolean supportsResultSetHoldCurrorsOverCommitHoldability)
supportsResultSetHoldCurrorsOverCommitHoldability - true if so; false otherwiseConnectionBoolean isSupportsResultSetCloseCurrorsAtCommitHoldability()
true if so; false otherwiseConnectionvoid setSupportsResultSetCloseCurrorsAtCommitHoldability(Boolean supportsResultSetCloseCurrorsAtCommitHoldability)
supportsResultSetCloseCurrorsAtCommitHoldability - true if so; false otherwiseConnectionResultSetHoldabilityType getResultSetHoldabilityType()
ResultSet object.
ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITvoid setResultSetHoldabilityType(ResultSetHoldabilityType resultSetHoldabilityType)
ResultSet object.
resultSetHoldabilityType - the ResultSetHoldabilityType
the default holdability; either ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITInteger getDatabaseMajorVersion()
void setDatabaseMajorVersion(Integer databaseMajorVersion)
databaseMajorVersion - the underlying database's major versionInteger getDatabaseMinorVersion()
void setDatabaseMinorVersion(Integer databaseMinorVersion)
databaseMinorVersion - underlying database's minor versionInteger getJDBCMajorVersion()
void setJDBCMajorVersion(Integer jdbcMajorVersion)
jdbcMajorVersion - JDBC version major numberInteger getJDBCMinorVersion()
void setJDBCMinorVersion(Integer jdbcMinorVersion)
jdbcMinorVersion - JDBC version minor numberSQLStateType getSQLStateType()
SQLException.getSQLState is X/Open (now known as Open Group) SQL
CLI or SQL99.
void setSQLStateType(SQLStateType sqlStateType)
SQLException.getSQLState is X/Open (now known as Open Group) SQL
CLI or SQL99.
sqlStateType - the type of SQLSTATE; one of: sqlStateXOpen or sqlStateSQL99Boolean isLocatorsUpdateCopy()
true if updates are made to a copy of the LOB; false if updates are made directly to the
LOBvoid setLocatorsUpdateCopy(Boolean locatorsUpdateCopy)
locatorsUpdateCopy - true if updates are made to a copy of the LOB; false if updates are
made directly to the LOBBoolean isSupportsStatementPooling()
true if so; false otherwisevoid setSupportsStatementPooling(Boolean supportsStatementPooling)
supportsStatementPooling - true if so; false otherwise
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||