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