-
- All Implemented Interfaces:
public final class Database
Provides a wrapper around DatabaseMetaData.
-
-
Field Summary
Fields Modifier and Type Field Description private final String
defaultCatalog
private final String
defaultSchema
-
Constructor Summary
Constructors Constructor Description Database(DatabaseMetaData metadata, String defaultCatalog, String defaultSchema)
Create empty Database Database(DatabaseMetaData metadata, String defaultCatalog)
Create empty Database Database(DatabaseMetaData metadata)
Create empty Database
-
Method Summary
Modifier and Type Method Description final String
getDefaultCatalog()
final String
getDefaultSchema()
final Boolean
allProceduresAreCallable()
All procedures are callable final Boolean
allTablesAreSelectable()
All tables are selectable final Boolean
autoCommitFailureClosesAllResultSets()
Auto commit failure closes all result sets final Boolean
dataDefinitionCausesTransactionCommit()
Data definition causes transaction commit final Boolean
dataDefinitionIgnoredInTransactions()
Data definition ignored in transactions final Boolean
deletesAreDetected(ResultSetType resultSetType)
Deletes are detected final Boolean
doesMaxRowSizeIncludeBlobs()
Does max row size include blobs final Boolean
generatedKeyAlwaysReturned()
Generated key always returned final List<String>
getCatalogs()
Get list of catalogs final String
getCatalogSeparator()
Get catalog separator final String
getCatalogTerm()
Get catalog term final List<ClientInfoProperties>
getClientInfoProperties()
Get client info properties, converted to ClientInfoProperties final Connection
getConnection()
Get connection final List<Key>
getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)
Get cross reference, converted to Keyif not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema final List<Key>
getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignTable)
Get cross reference, converted to Keyif not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema final List<Key>
getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignTable)
Get cross reference, converted to Keyif not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema final List<Key>
getCrossReference(String parentCatalog, String parentTable, String foreignTable)
Get cross reference, converted to Keyif not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema final List<Key>
getCrossReference(String parentTable, String foreignTable)
Get cross reference, converted to Keyif not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema final Integer
getDatabaseMajorVersion()
Get database major version final Integer
getDatabaseMinorVersion()
Get database minor version final String
getDatabaseProductName()
Get database product name final String
getDatabaseProductVersion()
Get database product version final TransactionIsolation
getDefaultTransactionIsolation()
Get default transaction isolation, converted to TransactionIsolation final String
getDriverName()
Get driver name final String
getDriverVersion()
Get driver version final Integer
getDriverMajorVersion()
Get driver major version final Integer
getDriverMinorVersion()
Get driver minor version final String
getExtraNameCharacters()
Get extra name characters final List<Function>
getFunctions(String namePattern)
Gets functions using specified namePattern along with defaultCatalog and defaultCatalog to filter results. final List<Function>
getFunctions()
Gets functions using specified namePattern along with defaultCatalog and defaultCatalog to filter results. final List<Function>
getFunctions(String catalog, String schemaPattern, String namePattern)
Gets functions using the catalog, schemaPattern, and namePattern to filter results. final String
getIdentifierQuoteString()
Get identifier quote string final Integer
getJDBCMajorVersion()
Get JDBC major version final Integer
getJDBCMinorVersion()
Get JDBC minor version final Integer
getMaxBinaryLiteralLength()
Get max binary literal length final Integer
getMaxCharLiteralLength()
Get max char literal length final Integer
getMaxColumnNameLength()
Get max column name length final Integer
getMaxColumnsInGroupBy()
Get max columns in group by final Integer
getMaxColumnsInIndex()
Get max columns in index final Integer
getMaxColumnsInOrderBy()
Get max columns in order by final Integer
getMaxColumnsInSelect()
Get max columns in select final Integer
getMaxColumnsInTable()
Get max columns in table final Integer
getMaxConnections()
Get max connections final Integer
getMaxCursorNameLength()
Get max cursor name length final Integer
getMaxIndexLength()
Get max index length final Integer
getMaxSchemaNameLength()
Get max schema name length final Integer
getMaxProcedureNameLength()
Get max procedure name length final Integer
getMaxCatalogNameLength()
Get max catalog name length final Integer
getMaxRowSize()
Get max row size final Integer
getMaxStatementLength()
Get max statement length final Integer
getMaxStatements()
Get max statements final Integer
getMaxTableNameLength()
Get max table name length final Integer
getMaxTablesInSelect()
Get max tables in select final Integer
getMaxUserNameLength()
Get max username length final Long
getMaxLogicalLobSize()
Get max logical lob size final List<String>
getNumericFunctions()
Get numeric function names final List<Procedure>
getProcedures(String namePattern)
Get procedures based on specified namePattern as well as defaultCatalog and defaultSchema final List<Procedure>
getProcedures()
Get procedures based on specified namePattern as well as defaultCatalog and defaultSchema final List<Procedure>
getProcedures(String catalog, String schemaPattern, String namePattern)
Get procedures. final String
getProcedureTerm()
Get procedure term final ResultSetHoldability
getResultSetHoldability()
Get result set holdability final RowIdLifetime
getRowIdLifetime()
Get row id lifetime final List<Schema>
getSchemas()
Get schemas final String
getSchemaTerm()
Get schema term final String
getSearchStringEscape()
Get search string escape final List<String>
getSQLKeywords()
Get SQL keywords final SQLStateType
getSQLStateType()
Get SQL state type final List<String>
getStringFunctions()
Get string function names final List<String>
getSystemFunctions()
Get system function names final List<Table>
getTables(String tableNamePattern, Array<String> types)
Get tables with specified tableNamePattern and types, as well as defaultCatalog and defaultSchema final List<Table>
getTables(String tableNamePattern)
Get tables with specified tableNamePattern and types, as well as defaultCatalog and defaultSchema final List<Table>
getTables()
Get tables with specified tableNamePattern and types, as well as defaultCatalog and defaultSchema final List<Table>
getTables(String catalog, String schemaPattern, String tableNamePattern, Array<String> types)
Get tables. final List<String>
getTableTypes()
Get table types final List<String>
getTimeDateFunctions()
Get time date function names final List<TypeInfo>
getTypeInfo()
Get type info final String
getURL()
Get URL for database connection final List<UserDefinedType>
getUserDefinedTypes(String namePattern, Array<JDBCType> types)
Get user defined types based on specified namePattern and types as well as defaultCatalog and defaultSchema final List<UserDefinedType>
getUserDefinedTypes(String namePattern)
Get user defined types based on specified namePattern and types as well as defaultCatalog and defaultSchema final List<UserDefinedType>
getUserDefinedTypes()
Get user defined types based on specified namePattern and types as well as defaultCatalog and defaultSchema final List<UserDefinedType>
getUserDefinedTypes(String catalog, String schemaPattern, String namePattern, Array<JDBCType> types)
Get user defined types. final String
getUserName()
Get username final Boolean
insertsAreDetected(ResultSetType resultSetType)
Inserts are detected final Boolean
isCatalogAtStart()
Is catalog at start final Boolean
isReadOnly()
Is read only final Boolean
locatorsUpdateCopy()
Locators update copy final Boolean
nullsAreSortedAtEnd()
Nulls are sorted at end final Boolean
nullsAreSortedAtStart()
Nulls are sorted at start final Boolean
nullsAreSortedHigh()
Nulls are sorted high final Boolean
nullsAreSortedLow()
Nulls are sorted low final Boolean
nullPlusNonNullIsNull()
Null plus non null is null final Boolean
othersUpdatesAreVisible(ResultSetType resultSetType)
Others updates are visible final Boolean
othersDeletesAreVisible(ResultSetType resultSetType)
Others deletes are visible final Boolean
othersInsertsAreVisible(ResultSetType resultSetType)
Others inserts are visible final Boolean
ownUpdatesAreVisible(ResultSetType resultSetType)
Own updates are visible final Boolean
ownDeletesAreVisible(ResultSetType resultSetType)
Own deletes are visible final Boolean
ownInsertsAreVisible(ResultSetType resultSetType)
Own inserts are visible final Boolean
storesUpperCaseIdentifiers()
Stores upper case identifiers final Boolean
storesLowerCaseIdentifiers()
Stores lower case identifiers final Boolean
storesMixedCaseIdentifiers()
Stores mixed case identifiers final Boolean
storesUpperCaseQuotedIdentifiers()
Stores upper case quoted identifiers final Boolean
storesLowerCaseQuotedIdentifiers()
Stores lower case quoted identifiers final Boolean
storesMixedCaseQuotedIdentifiers()
Stores mixed case quoted identifiers final Boolean
supportsAlterTableWithAddColumn()
Supports alter table with add column final Boolean
supportsAlterTableWithDropColumn()
Supports alter table with drop column final Boolean
supportsANSI92EntryLevelSQL()
Supports a n s i92entry level s q l final Boolean
supportsANSI92IntermediateSQL()
Supports a n s i92intermediate s q l final Boolean
supportsANSI92FullSQL()
Supports a n s i92full s q l final Boolean
supportsBatchUpdates()
Supports batch updates final Boolean
supportsCatalogsInDataManipulation()
Supports catalogs in data manipulation final Boolean
supportsCatalogsInProcedureCalls()
Supports catalogs in procedure calls final Boolean
supportsCatalogsInTableDefinitions()
Supports catalogs in table definitions final Boolean
supportsCatalogsInIndexDefinitions()
Supports catalogs in index definitions final Boolean
supportsCatalogsInPrivilegeDefinitions()
Supports catalogs in privilege definitions final Boolean
supportsColumnAliasing()
Supports column aliasing final Boolean
supportsConvert()
Supports convert final Boolean
supportsConvert(JDBCType fromType, JDBCType toType)
Supports convert final Boolean
supportsCorrelatedSubqueries()
Supports correlated subqueries final Boolean
supportsCoreSQLGrammar()
Supports core s q l grammar final Boolean
supportsDataDefinitionAndDataManipulationTransactions()
Supports data definition and data manipulation transactions final Boolean
supportsDataManipulationTransactionsOnly()
Supports data manipulation transactions only final Boolean
supportsDifferentTableCorrelationNames()
Supports different table correlation names final Boolean
supportsExtendedSQLGrammar()
Supports extended s q l grammar final Boolean
supportsExpressionsInOrderBy()
Supports expressions in order by final Boolean
supportsFullOuterJoins()
Supports full outer joins final Boolean
supportsGetGeneratedKeys()
Supports get generated keys final Boolean
supportsGroupBy()
Supports group by final Boolean
supportsGroupByUnrelated()
Supports group by unrelated final Boolean
supportsGroupByBeyondSelect()
Supports group by beyond select final Boolean
supportsIntegrityEnhancementFacility()
Supports integrity enhancement facility final Boolean
supportsLikeEscapeClause()
Supports like escape clause final Boolean
supportsLimitedOuterJoins()
Supports limited outer joins final Boolean
supportsMinimumSQLGrammar()
Supports minimum s q l grammar final Boolean
supportsMixedCaseIdentifiers()
Supports mixed case identifiers final Boolean
supportsMixedCaseQuotedIdentifiers()
Supports mixed case quoted identifiers final Boolean
supportsMultipleResultSets()
Supports multiple result sets final Boolean
supportsMultipleTransactions()
Supports multiple transactions final Boolean
supportsMultipleOpenResults()
Supports multiple open results final Boolean
supportsNamedParameters()
Supports named parameters final Boolean
supportsNonNullableColumns()
Supports non nullable columns final Boolean
supportsOpenCursorsAcrossCommit()
Supports open cursors across commit final Boolean
supportsOpenCursorsAcrossRollback()
Supports open cursors across rollback final Boolean
supportsOpenStatementsAcrossCommit()
Supports open statements across commit final Boolean
supportsOpenStatementsAcrossRollback()
Supports open statements across rollback final Boolean
supportsOrderByUnrelated()
Supports order by unrelated final Boolean
supportsOuterJoins()
Supports outer joins final Boolean
supportsPositionedDelete()
Supports positioned delete final Boolean
supportsPositionedUpdate()
Supports positioned update final Boolean
supportsRefCursors()
Supports ref cursors final Boolean
supportsResultSetConcurrency(ResultSetType resultSetType, ResultSetConcurrency resultSetConcurrency)
Supports result set concurrency final Boolean
supportsResultSetHoldability(ResultSetHoldability resultSetHoldability)
Supports result set holdability final Boolean
supportsResultSetType(ResultSetType resultSetType)
Supports result set type final Boolean
supportsSavepoints()
Supports savepoints final Boolean
supportsSharding()
Supports sharding final Boolean
supportsStatementPooling()
Supports statement pooling final Boolean
supportsStoredFunctionsUsingCallSyntax()
Supports stored functions using call syntax final Boolean
supportsSchemasInDataManipulation()
Supports schemas in data manipulation final Boolean
supportsSchemasInProcedureCalls()
Supports schemas in procedure calls final Boolean
supportsSchemasInTableDefinitions()
Supports schemas in table definitions final Boolean
supportsSchemasInIndexDefinitions()
Supports schemas in index definitions final Boolean
supportsSchemasInPrivilegeDefinitions()
Supports schemas in privilege definitions final Boolean
supportsSelectForUpdate()
Supports select for update final Boolean
supportsStoredProcedures()
Supports stored procedures final Boolean
supportsSubqueriesInComparisons()
Supports subqueries in comparisons final Boolean
supportsSubqueriesInExists()
Supports subqueries in exists final Boolean
supportsSubqueriesInIns()
Supports subqueries in ins final Boolean
supportsSubqueriesInQuantifieds()
Supports subqueries in quantifieds final Boolean
supportsTableCorrelationNames()
Supports table correlation names final Boolean
supportsTransactions()
Supports transactions final Boolean
supportsTransactionIsolationLevel(TransactionIsolation transactionIsolation)
Supports transaction isolation level final Boolean
supportsUnion()
Supports union final Boolean
supportsUnionAll()
Supports union all final Boolean
updatesAreDetected(ResultSetType resultSetType)
Updates are detected final Boolean
usesLocalFilePerTable()
Uses local file per table final Boolean
usesLocalFiles()
Uses local files -
-
Constructor Detail
-
Database
Database(DatabaseMetaData metadata, String defaultCatalog, String defaultSchema)
Create empty Database
-
Database
Database(DatabaseMetaData metadata, String defaultCatalog)
Create empty Database
-
Database
Database(DatabaseMetaData metadata)
Create empty Database
-
-
Method Detail
-
getDefaultCatalog
final String getDefaultCatalog()
-
getDefaultSchema
final String getDefaultSchema()
-
allProceduresAreCallable
final Boolean allProceduresAreCallable()
All procedures are callable
-
allTablesAreSelectable
final Boolean allTablesAreSelectable()
All tables are selectable
-
autoCommitFailureClosesAllResultSets
final Boolean autoCommitFailureClosesAllResultSets()
Auto commit failure closes all result sets
-
dataDefinitionCausesTransactionCommit
final Boolean dataDefinitionCausesTransactionCommit()
Data definition causes transaction commit
-
dataDefinitionIgnoredInTransactions
final Boolean dataDefinitionIgnoredInTransactions()
Data definition ignored in transactions
-
deletesAreDetected
final Boolean deletesAreDetected(ResultSetType resultSetType)
Deletes are detected
-
doesMaxRowSizeIncludeBlobs
final Boolean doesMaxRowSizeIncludeBlobs()
Does max row size include blobs
-
generatedKeyAlwaysReturned
final Boolean generatedKeyAlwaysReturned()
Generated key always returned
-
getCatalogs
final List<String> getCatalogs()
Get list of catalogs
-
getCatalogSeparator
final String getCatalogSeparator()
Get catalog separator
-
getCatalogTerm
final String getCatalogTerm()
Get catalog term
-
getClientInfoProperties
final List<ClientInfoProperties> getClientInfoProperties()
Get client info properties, converted to ClientInfoProperties
-
getConnection
final Connection getConnection()
Get connection
-
getCrossReference
@JvmOverloads() final List<Key> getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)
Get cross reference, converted to Key
if not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema
-
getCrossReference
@JvmOverloads() final List<Key> getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignTable)
Get cross reference, converted to Key
if not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema
-
getCrossReference
@JvmOverloads() final List<Key> getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignTable)
Get cross reference, converted to Key
if not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema
-
getCrossReference
@JvmOverloads() final List<Key> getCrossReference(String parentCatalog, String parentTable, String foreignTable)
Get cross reference, converted to Key
if not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema
-
getCrossReference
@JvmOverloads() final List<Key> getCrossReference(String parentTable, String foreignTable)
Get cross reference, converted to Key
if not specified, parentCatalog and foreignCatalog default to defaultCatalog, and parentSchema and foreignSchema default to defaultSchema
-
getDatabaseMajorVersion
final Integer getDatabaseMajorVersion()
Get database major version
-
getDatabaseMinorVersion
final Integer getDatabaseMinorVersion()
Get database minor version
-
getDatabaseProductName
final String getDatabaseProductName()
Get database product name
-
getDatabaseProductVersion
final String getDatabaseProductVersion()
Get database product version
-
getDefaultTransactionIsolation
final TransactionIsolation getDefaultTransactionIsolation()
Get default transaction isolation, converted to TransactionIsolation
-
getDriverName
final String getDriverName()
Get driver name
-
getDriverVersion
final String getDriverVersion()
Get driver version
-
getDriverMajorVersion
final Integer getDriverMajorVersion()
Get driver major version
-
getDriverMinorVersion
final Integer getDriverMinorVersion()
Get driver minor version
-
getExtraNameCharacters
final String getExtraNameCharacters()
Get extra name characters
-
getFunctions
@JvmOverloads() final List<Function> getFunctions(String namePattern)
Gets functions using specified namePattern along with defaultCatalog and defaultCatalog to filter results.
-
getFunctions
@JvmOverloads() final List<Function> getFunctions()
Gets functions using specified namePattern along with defaultCatalog and defaultCatalog to filter results.
-
getFunctions
final List<Function> getFunctions(String catalog, String schemaPattern, String namePattern)
Gets functions using the catalog, schemaPattern, and namePattern to filter results. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema
-
getIdentifierQuoteString
final String getIdentifierQuoteString()
Get identifier quote string
-
getJDBCMajorVersion
final Integer getJDBCMajorVersion()
Get JDBC major version
-
getJDBCMinorVersion
final Integer getJDBCMinorVersion()
Get JDBC minor version
-
getMaxBinaryLiteralLength
final Integer getMaxBinaryLiteralLength()
Get max binary literal length
-
getMaxCharLiteralLength
final Integer getMaxCharLiteralLength()
Get max char literal length
-
getMaxColumnNameLength
final Integer getMaxColumnNameLength()
Get max column name length
-
getMaxColumnsInGroupBy
final Integer getMaxColumnsInGroupBy()
Get max columns in group by
-
getMaxColumnsInIndex
final Integer getMaxColumnsInIndex()
Get max columns in index
-
getMaxColumnsInOrderBy
final Integer getMaxColumnsInOrderBy()
Get max columns in order by
-
getMaxColumnsInSelect
final Integer getMaxColumnsInSelect()
Get max columns in select
-
getMaxColumnsInTable
final Integer getMaxColumnsInTable()
Get max columns in table
-
getMaxConnections
final Integer getMaxConnections()
Get max connections
-
getMaxCursorNameLength
final Integer getMaxCursorNameLength()
Get max cursor name length
-
getMaxIndexLength
final Integer getMaxIndexLength()
Get max index length
-
getMaxSchemaNameLength
final Integer getMaxSchemaNameLength()
Get max schema name length
-
getMaxProcedureNameLength
final Integer getMaxProcedureNameLength()
Get max procedure name length
-
getMaxCatalogNameLength
final Integer getMaxCatalogNameLength()
Get max catalog name length
-
getMaxRowSize
final Integer getMaxRowSize()
Get max row size
-
getMaxStatementLength
final Integer getMaxStatementLength()
Get max statement length
-
getMaxStatements
final Integer getMaxStatements()
Get max statements
-
getMaxTableNameLength
final Integer getMaxTableNameLength()
Get max table name length
-
getMaxTablesInSelect
final Integer getMaxTablesInSelect()
Get max tables in select
-
getMaxUserNameLength
final Integer getMaxUserNameLength()
Get max username length
-
getMaxLogicalLobSize
final Long getMaxLogicalLobSize()
Get max logical lob size
-
getNumericFunctions
final List<String> getNumericFunctions()
Get numeric function names
-
getProcedures
@JvmOverloads() final List<Procedure> getProcedures(String namePattern)
Get procedures based on specified namePattern as well as defaultCatalog and defaultSchema
-
getProcedures
@JvmOverloads() final List<Procedure> getProcedures()
Get procedures based on specified namePattern as well as defaultCatalog and defaultSchema
-
getProcedures
final List<Procedure> getProcedures(String catalog, String schemaPattern, String namePattern)
Get procedures. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema
-
getProcedureTerm
final String getProcedureTerm()
Get procedure term
-
getResultSetHoldability
final ResultSetHoldability getResultSetHoldability()
Get result set holdability
-
getRowIdLifetime
final RowIdLifetime getRowIdLifetime()
Get row id lifetime
-
getSchemas
final List<Schema> getSchemas()
Get schemas
-
getSchemaTerm
final String getSchemaTerm()
Get schema term
-
getSearchStringEscape
final String getSearchStringEscape()
Get search string escape
-
getSQLKeywords
final List<String> getSQLKeywords()
Get SQL keywords
-
getSQLStateType
final SQLStateType getSQLStateType()
Get SQL state type
-
getStringFunctions
final List<String> getStringFunctions()
Get string function names
-
getSystemFunctions
final List<String> getSystemFunctions()
Get system function names
-
getTables
@JvmOverloads() final List<Table> getTables(String tableNamePattern, Array<String> types)
Get tables with specified tableNamePattern and types, as well as defaultCatalog and defaultSchema
-
getTables
@JvmOverloads() final List<Table> getTables(String tableNamePattern)
Get tables with specified tableNamePattern and types, as well as defaultCatalog and defaultSchema
-
getTables
@JvmOverloads() final List<Table> getTables()
Get tables with specified tableNamePattern and types, as well as defaultCatalog and defaultSchema
-
getTables
final List<Table> getTables(String catalog, String schemaPattern, String tableNamePattern, Array<String> types)
Get tables. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema
-
getTableTypes
final List<String> getTableTypes()
Get table types
-
getTimeDateFunctions
final List<String> getTimeDateFunctions()
Get time date function names
-
getTypeInfo
final List<TypeInfo> getTypeInfo()
Get type info
-
getUserDefinedTypes
@JvmOverloads() final List<UserDefinedType> getUserDefinedTypes(String namePattern, Array<JDBCType> types)
Get user defined types based on specified namePattern and types as well as defaultCatalog and defaultSchema
-
getUserDefinedTypes
@JvmOverloads() final List<UserDefinedType> getUserDefinedTypes(String namePattern)
Get user defined types based on specified namePattern and types as well as defaultCatalog and defaultSchema
-
getUserDefinedTypes
@JvmOverloads() final List<UserDefinedType> getUserDefinedTypes()
Get user defined types based on specified namePattern and types as well as defaultCatalog and defaultSchema
-
getUserDefinedTypes
final List<UserDefinedType> getUserDefinedTypes(String catalog, String schemaPattern, String namePattern, Array<JDBCType> types)
Get user defined types. If not specified, catalog defaults to defaultCatalog and schemaPattern defaults to defaultSchema
-
getUserName
final String getUserName()
Get username
-
insertsAreDetected
final Boolean insertsAreDetected(ResultSetType resultSetType)
Inserts are detected
-
isCatalogAtStart
final Boolean isCatalogAtStart()
Is catalog at start
-
isReadOnly
final Boolean isReadOnly()
Is read only
-
locatorsUpdateCopy
final Boolean locatorsUpdateCopy()
Locators update copy
-
nullsAreSortedAtEnd
final Boolean nullsAreSortedAtEnd()
Nulls are sorted at end
-
nullsAreSortedAtStart
final Boolean nullsAreSortedAtStart()
Nulls are sorted at start
-
nullsAreSortedHigh
final Boolean nullsAreSortedHigh()
Nulls are sorted high
-
nullsAreSortedLow
final Boolean nullsAreSortedLow()
Nulls are sorted low
-
nullPlusNonNullIsNull
final Boolean nullPlusNonNullIsNull()
Null plus non null is null
-
othersUpdatesAreVisible
final Boolean othersUpdatesAreVisible(ResultSetType resultSetType)
Others updates are visible
-
othersDeletesAreVisible
final Boolean othersDeletesAreVisible(ResultSetType resultSetType)
Others deletes are visible
-
othersInsertsAreVisible
final Boolean othersInsertsAreVisible(ResultSetType resultSetType)
Others inserts are visible
-
ownUpdatesAreVisible
final Boolean ownUpdatesAreVisible(ResultSetType resultSetType)
Own updates are visible
-
ownDeletesAreVisible
final Boolean ownDeletesAreVisible(ResultSetType resultSetType)
Own deletes are visible
-
ownInsertsAreVisible
final Boolean ownInsertsAreVisible(ResultSetType resultSetType)
Own inserts are visible
-
storesUpperCaseIdentifiers
final Boolean storesUpperCaseIdentifiers()
Stores upper case identifiers
-
storesLowerCaseIdentifiers
final Boolean storesLowerCaseIdentifiers()
Stores lower case identifiers
-
storesMixedCaseIdentifiers
final Boolean storesMixedCaseIdentifiers()
Stores mixed case identifiers
-
storesUpperCaseQuotedIdentifiers
final Boolean storesUpperCaseQuotedIdentifiers()
Stores upper case quoted identifiers
-
storesLowerCaseQuotedIdentifiers
final Boolean storesLowerCaseQuotedIdentifiers()
Stores lower case quoted identifiers
-
storesMixedCaseQuotedIdentifiers
final Boolean storesMixedCaseQuotedIdentifiers()
Stores mixed case quoted identifiers
-
supportsAlterTableWithAddColumn
final Boolean supportsAlterTableWithAddColumn()
Supports alter table with add column
-
supportsAlterTableWithDropColumn
final Boolean supportsAlterTableWithDropColumn()
Supports alter table with drop column
-
supportsANSI92EntryLevelSQL
final Boolean supportsANSI92EntryLevelSQL()
Supports a n s i92entry level s q l
-
supportsANSI92IntermediateSQL
final Boolean supportsANSI92IntermediateSQL()
Supports a n s i92intermediate s q l
-
supportsANSI92FullSQL
final Boolean supportsANSI92FullSQL()
Supports a n s i92full s q l
-
supportsBatchUpdates
final Boolean supportsBatchUpdates()
Supports batch updates
-
supportsCatalogsInDataManipulation
final Boolean supportsCatalogsInDataManipulation()
Supports catalogs in data manipulation
-
supportsCatalogsInProcedureCalls
final Boolean supportsCatalogsInProcedureCalls()
Supports catalogs in procedure calls
-
supportsCatalogsInTableDefinitions
final Boolean supportsCatalogsInTableDefinitions()
Supports catalogs in table definitions
-
supportsCatalogsInIndexDefinitions
final Boolean supportsCatalogsInIndexDefinitions()
Supports catalogs in index definitions
-
supportsCatalogsInPrivilegeDefinitions
final Boolean supportsCatalogsInPrivilegeDefinitions()
Supports catalogs in privilege definitions
-
supportsColumnAliasing
final Boolean supportsColumnAliasing()
Supports column aliasing
-
supportsConvert
final Boolean supportsConvert()
Supports convert
-
supportsConvert
final Boolean supportsConvert(JDBCType fromType, JDBCType toType)
Supports convert
-
supportsCorrelatedSubqueries
final Boolean supportsCorrelatedSubqueries()
Supports correlated subqueries
-
supportsCoreSQLGrammar
final Boolean supportsCoreSQLGrammar()
Supports core s q l grammar
-
supportsDataDefinitionAndDataManipulationTransactions
final Boolean supportsDataDefinitionAndDataManipulationTransactions()
Supports data definition and data manipulation transactions
-
supportsDataManipulationTransactionsOnly
final Boolean supportsDataManipulationTransactionsOnly()
Supports data manipulation transactions only
-
supportsDifferentTableCorrelationNames
final Boolean supportsDifferentTableCorrelationNames()
Supports different table correlation names
-
supportsExtendedSQLGrammar
final Boolean supportsExtendedSQLGrammar()
Supports extended s q l grammar
-
supportsExpressionsInOrderBy
final Boolean supportsExpressionsInOrderBy()
Supports expressions in order by
-
supportsFullOuterJoins
final Boolean supportsFullOuterJoins()
Supports full outer joins
-
supportsGetGeneratedKeys
final Boolean supportsGetGeneratedKeys()
Supports get generated keys
-
supportsGroupBy
final Boolean supportsGroupBy()
Supports group by
-
supportsGroupByUnrelated
final Boolean supportsGroupByUnrelated()
Supports group by unrelated
-
supportsGroupByBeyondSelect
final Boolean supportsGroupByBeyondSelect()
Supports group by beyond select
-
supportsIntegrityEnhancementFacility
final Boolean supportsIntegrityEnhancementFacility()
Supports integrity enhancement facility
-
supportsLikeEscapeClause
final Boolean supportsLikeEscapeClause()
Supports like escape clause
-
supportsLimitedOuterJoins
final Boolean supportsLimitedOuterJoins()
Supports limited outer joins
-
supportsMinimumSQLGrammar
final Boolean supportsMinimumSQLGrammar()
Supports minimum s q l grammar
-
supportsMixedCaseIdentifiers
final Boolean supportsMixedCaseIdentifiers()
Supports mixed case identifiers
-
supportsMixedCaseQuotedIdentifiers
final Boolean supportsMixedCaseQuotedIdentifiers()
Supports mixed case quoted identifiers
-
supportsMultipleResultSets
final Boolean supportsMultipleResultSets()
Supports multiple result sets
-
supportsMultipleTransactions
final Boolean supportsMultipleTransactions()
Supports multiple transactions
-
supportsMultipleOpenResults
final Boolean supportsMultipleOpenResults()
Supports multiple open results
-
supportsNamedParameters
final Boolean supportsNamedParameters()
Supports named parameters
-
supportsNonNullableColumns
final Boolean supportsNonNullableColumns()
Supports non nullable columns
-
supportsOpenCursorsAcrossCommit
final Boolean supportsOpenCursorsAcrossCommit()
Supports open cursors across commit
-
supportsOpenCursorsAcrossRollback
final Boolean supportsOpenCursorsAcrossRollback()
Supports open cursors across rollback
-
supportsOpenStatementsAcrossCommit
final Boolean supportsOpenStatementsAcrossCommit()
Supports open statements across commit
-
supportsOpenStatementsAcrossRollback
final Boolean supportsOpenStatementsAcrossRollback()
Supports open statements across rollback
-
supportsOrderByUnrelated
final Boolean supportsOrderByUnrelated()
Supports order by unrelated
-
supportsOuterJoins
final Boolean supportsOuterJoins()
Supports outer joins
-
supportsPositionedDelete
final Boolean supportsPositionedDelete()
Supports positioned delete
-
supportsPositionedUpdate
final Boolean supportsPositionedUpdate()
Supports positioned update
-
supportsRefCursors
final Boolean supportsRefCursors()
Supports ref cursors
-
supportsResultSetConcurrency
final Boolean supportsResultSetConcurrency(ResultSetType resultSetType, ResultSetConcurrency resultSetConcurrency)
Supports result set concurrency
-
supportsResultSetHoldability
final Boolean supportsResultSetHoldability(ResultSetHoldability resultSetHoldability)
Supports result set holdability
-
supportsResultSetType
final Boolean supportsResultSetType(ResultSetType resultSetType)
Supports result set type
-
supportsSavepoints
final Boolean supportsSavepoints()
Supports savepoints
-
supportsSharding
final Boolean supportsSharding()
Supports sharding
-
supportsStatementPooling
final Boolean supportsStatementPooling()
Supports statement pooling
-
supportsStoredFunctionsUsingCallSyntax
final Boolean supportsStoredFunctionsUsingCallSyntax()
Supports stored functions using call syntax
-
supportsSchemasInDataManipulation
final Boolean supportsSchemasInDataManipulation()
Supports schemas in data manipulation
-
supportsSchemasInProcedureCalls
final Boolean supportsSchemasInProcedureCalls()
Supports schemas in procedure calls
-
supportsSchemasInTableDefinitions
final Boolean supportsSchemasInTableDefinitions()
Supports schemas in table definitions
-
supportsSchemasInIndexDefinitions
final Boolean supportsSchemasInIndexDefinitions()
Supports schemas in index definitions
-
supportsSchemasInPrivilegeDefinitions
final Boolean supportsSchemasInPrivilegeDefinitions()
Supports schemas in privilege definitions
-
supportsSelectForUpdate
final Boolean supportsSelectForUpdate()
Supports select for update
-
supportsStoredProcedures
final Boolean supportsStoredProcedures()
Supports stored procedures
-
supportsSubqueriesInComparisons
final Boolean supportsSubqueriesInComparisons()
Supports subqueries in comparisons
-
supportsSubqueriesInExists
final Boolean supportsSubqueriesInExists()
Supports subqueries in exists
-
supportsSubqueriesInIns
final Boolean supportsSubqueriesInIns()
Supports subqueries in ins
-
supportsSubqueriesInQuantifieds
final Boolean supportsSubqueriesInQuantifieds()
Supports subqueries in quantifieds
-
supportsTableCorrelationNames
final Boolean supportsTableCorrelationNames()
Supports table correlation names
-
supportsTransactions
final Boolean supportsTransactions()
Supports transactions
-
supportsTransactionIsolationLevel
final Boolean supportsTransactionIsolationLevel(TransactionIsolation transactionIsolation)
Supports transaction isolation level
-
supportsUnion
final Boolean supportsUnion()
Supports union
-
supportsUnionAll
final Boolean supportsUnionAll()
Supports union all
-
updatesAreDetected
final Boolean updatesAreDetected(ResultSetType resultSetType)
Updates are detected
-
usesLocalFilePerTable
final Boolean usesLocalFilePerTable()
Uses local file per table
-
usesLocalFiles
final Boolean usesLocalFiles()
Uses local files
-
-
-
-