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