Package com.apple.foundationdb.relational.api

Interface RelationalDatabaseMetaData

All Superinterfaces:

DatabaseMetaData, Wrapper

public interface RelationalDatabaseMetaData
extends DatabaseMetaData

Represents the MetaData about a database (schemas, tables, indexes, and so on).

Field Summary

Fields

Modifier and Type	Field	Description
static final String	DATABASE_PRODUCT_NAME	Name of the Relational product.

Fields inherited from interface java.sql.DatabaseMetaData

attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

Method Summary

Modifier and Type	Method	Description
default boolean	allProceduresAreCallable()
default boolean	allTablesAreSelectable()
default boolean	autoCommitFailureClosesAllResultSets()
default boolean	dataDefinitionCausesTransactionCommit()
default boolean	dataDefinitionIgnoredInTransactions()
default boolean	deletesAreDetected(int type)
default boolean	doesMaxRowSizeIncludeBlobs()
default boolean	generatedKeyAlwaysReturned()
default ResultSet	getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
default ResultSet	getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)
default ResultSet	getCatalogs()
default String	getCatalogSeparator()
default String	getCatalogTerm()
default ResultSet	getClientInfoProperties()
default ResultSet	getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
RelationalResultSet	getColumns(String catalog, String schema, String table, String column)	Get the columns for the specified table within the specified schema, as a ResultSet.
default Connection	getConnection()
default ResultSet	getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)
default int	getDatabaseMajorVersion()
default int	getDatabaseMinorVersion()
default String	getDatabaseProductName()
default String	getDatabaseProductVersion()
default int	getDefaultTransactionIsolation()
default int	getDriverMajorVersion()
default int	getDriverMinorVersion()
default String	getDriverName()
default String	getDriverVersion()
default ResultSet	getExportedKeys(String catalog, String schema, String table)
default String	getExtraNameCharacters()
default ResultSet	getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)
default ResultSet	getFunctions(String catalog, String schemaPattern, String functionNamePattern)
default String	getIdentifierQuoteString()
default ResultSet	getImportedKeys(String catalog, String schema, String table)
RelationalResultSet	getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)
default int	getJDBCMajorVersion()
default int	getJDBCMinorVersion()
default int	getMaxBinaryLiteralLength()
default int	getMaxCatalogNameLength()
default int	getMaxCharLiteralLength()
default int	getMaxColumnNameLength()
default int	getMaxColumnsInGroupBy()
default int	getMaxColumnsInIndex()
default int	getMaxColumnsInOrderBy()
default int	getMaxColumnsInSelect()
default int	getMaxColumnsInTable()
default int	getMaxConnections()
default int	getMaxCursorNameLength()
default int	getMaxIndexLength()
default int	getMaxProcedureNameLength()
default int	getMaxRowSize()
default int	getMaxSchemaNameLength()
default int	getMaxStatementLength()
default int	getMaxStatements()
default int	getMaxTableNameLength()
default int	getMaxTablesInSelect()
default int	getMaxUserNameLength()
default String	getNumericFunctions()
RelationalResultSet	getPrimaryKeys(String catalog, String schema, String table)	Retrieves a description of the given table's primary key columns.
default ResultSet	getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
default ResultSet	getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
default String	getProcedureTerm()
default ResultSet	getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
default int	getResultSetHoldability()
default RowIdLifetime	getRowIdLifetime()
RelationalResultSet	getSchemas()	Get the Schemas for the specified schema pattern within this database, as a ResultSet.
RelationalResultSet	getSchemas(String catalog, String schemaPattern)	Get the Schemas for the specified schema pattern within the specified database, as a ResultSet.
default String	getSchemaTerm()
default String	getSearchStringEscape()
default String	getSQLKeywords()
default int	getSQLStateType()
default String	getStringFunctions()
default ResultSet	getSuperTables(String catalog, String schemaPattern, String tableNamePattern)
default ResultSet	getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
default String	getSystemFunctions()
default ResultSet	getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
RelationalResultSet	getTables(String catalog, String schema, String tableName, String[] types)	Get the tables for the specified schema within this database, as a ResultSet.
default ResultSet	getTableTypes()
default String	getTimeDateFunctions()
default ResultSet	getTypeInfo()
default ResultSet	getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
default String	getURL()
default String	getUserName()
default ResultSet	getVersionColumns(String catalog, String schema, String table)
default boolean	insertsAreDetected(int type)
default boolean	isCatalogAtStart()
default boolean	isReadOnly()
default boolean	isWrapperFor(Class<?> iface)
default boolean	locatorsUpdateCopy()
default boolean	nullPlusNonNullIsNull()
default boolean	nullsAreSortedAtEnd()
default boolean	nullsAreSortedAtStart()
default boolean	nullsAreSortedHigh()
default boolean	nullsAreSortedLow()
default boolean	othersDeletesAreVisible(int type)
default boolean	othersInsertsAreVisible(int type)
default boolean	othersUpdatesAreVisible(int type)
default boolean	ownDeletesAreVisible(int type)
default boolean	ownInsertsAreVisible(int type)
default boolean	ownUpdatesAreVisible(int type)
default boolean	storesLowerCaseIdentifiers()
default boolean	storesLowerCaseQuotedIdentifiers()
default boolean	storesMixedCaseIdentifiers()
default boolean	storesMixedCaseQuotedIdentifiers()
default boolean	storesUpperCaseIdentifiers()
default boolean	storesUpperCaseQuotedIdentifiers()
default boolean	supportsAlterTableWithAddColumn()
default boolean	supportsAlterTableWithDropColumn()
default boolean	supportsANSI92EntryLevelSQL()
default boolean	supportsANSI92FullSQL()
default boolean	supportsANSI92IntermediateSQL()
default boolean	supportsBatchUpdates()
default boolean	supportsCatalogsInDataManipulation()
default boolean	supportsCatalogsInIndexDefinitions()
default boolean	supportsCatalogsInPrivilegeDefinitions()
default boolean	supportsCatalogsInProcedureCalls()
default boolean	supportsCatalogsInTableDefinitions()
default boolean	supportsColumnAliasing()
default boolean	supportsConvert()
default boolean	supportsConvert(int fromType, int toType)
default boolean	supportsCoreSQLGrammar()
default boolean	supportsCorrelatedSubqueries()
default boolean	supportsDataDefinitionAndDataManipulationTransactions()
default boolean	supportsDataManipulationTransactionsOnly()
default boolean	supportsDifferentTableCorrelationNames()
default boolean	supportsExpressionsInOrderBy()
default boolean	supportsExtendedSQLGrammar()
default boolean	supportsFullOuterJoins()
default boolean	supportsGetGeneratedKeys()
default boolean	supportsGroupBy()
default boolean	supportsGroupByBeyondSelect()
default boolean	supportsGroupByUnrelated()
default boolean	supportsIntegrityEnhancementFacility()
default boolean	supportsLikeEscapeClause()
default boolean	supportsLimitedOuterJoins()
default boolean	supportsMinimumSQLGrammar()
default boolean	supportsMixedCaseIdentifiers()
default boolean	supportsMixedCaseQuotedIdentifiers()
default boolean	supportsMultipleOpenResults()
default boolean	supportsMultipleResultSets()
default boolean	supportsMultipleTransactions()
default boolean	supportsNamedParameters()
default boolean	supportsNonNullableColumns()
default boolean	supportsOpenCursorsAcrossCommit()
default boolean	supportsOpenCursorsAcrossRollback()
default boolean	supportsOpenStatementsAcrossCommit()
default boolean	supportsOpenStatementsAcrossRollback()
default boolean	supportsOrderByUnrelated()
default boolean	supportsOuterJoins()
default boolean	supportsPositionedDelete()
default boolean	supportsPositionedUpdate()
default boolean	supportsResultSetConcurrency(int type, int concurrency)
default boolean	supportsResultSetHoldability(int holdability)
default boolean	supportsResultSetType(int type)
default boolean	supportsSavepoints()
default boolean	supportsSchemasInDataManipulation()
default boolean	supportsSchemasInIndexDefinitions()
default boolean	supportsSchemasInPrivilegeDefinitions()
default boolean	supportsSchemasInProcedureCalls()
default boolean	supportsSchemasInTableDefinitions()
default boolean	supportsSelectForUpdate()
default boolean	supportsStatementPooling()
default boolean	supportsStoredFunctionsUsingCallSyntax()
default boolean	supportsStoredProcedures()
default boolean	supportsSubqueriesInComparisons()
default boolean	supportsSubqueriesInExists()
default boolean	supportsSubqueriesInIns()
default boolean	supportsSubqueriesInQuantifieds()
default boolean	supportsTableCorrelationNames()
default boolean	supportsTransactionIsolationLevel(int level)
default boolean	supportsTransactions()
default boolean	supportsUnion()
default boolean	supportsUnionAll()
default <T> T	unwrap(Class<T> iface)
default boolean	updatesAreDetected(int type)
default boolean	usesLocalFilePerTable()
default boolean	usesLocalFiles()

Methods inherited from interface java.sql.DatabaseMetaData

getMaxLogicalLobSize, supportsRefCursors, supportsSharding

Field Details

DATABASE_PRODUCT_NAME

static final String DATABASE_PRODUCT_NAME

Name of the Relational product. What we return when you call getDatabaseProductName()

See Also:

• Constant Field Values

Method Details

getSchemas

@Nonnull
RelationalResultSet getSchemas()
                        throws SQLException

Get the Schemas for the specified schema pattern within this database, as a ResultSet. Equivalent to calling getSchemas(currentDatabase(),null). The returned columns are: 1. TABLE_SCHEM String -- schema name 2. TABLE_CATALOG String -- The path of the database. Unlike in the superinterface definition, the returned results for this method are not required to be ordered.

Specified by:

getSchemas in interface DatabaseMetaData

Returns:

a list of schemas contained in the currently connected database.

Throws:

SQLException - if something goes wrong.

getSchemas

RelationalResultSet getSchemas(String catalog,
 String schemaPattern)
                        throws SQLException

Get the Schemas for the specified schema pattern within the specified database, as a ResultSet. For the moment, the only valid schemaPattern is null (TODO). Any other patterns will be ignored. The returned columns are: 1. TABLE_SCHEM String -- schema name 2. TABLE_CATALOG String -- The path of the database. Unlike in the superinterface definition, the returned results for this method are not required to be ordered.

Specified by:

getSchemas in interface DatabaseMetaData

Parameters:

catalog - the database path to get schemas for.

schemaPattern - the schema pattern to use in searching. Currently ignored

Returns:

a list of schemas contained in the specified database

Throws:

SQLException - if something goes wrong.

getTables

@Nonnull
RelationalResultSet getTables(String catalog,
 String schema,
 String tableName,
 String[] types)
                       throws SQLException

Get the tables for the specified schema within this database, as a ResultSet. The returned resultset has the following fields:

1. TABLE_CAT = the full path of the database
2. TABLE_SCHEM = the name of the schema
3. TABLE_NAME = the name of the table
4. TABLE_VERSION = the version of the Schema Template where this table was created

Note that the TABLE_VERSION field is not always known (due to data pre-existing the creation of Relational); in these cases NULL will be returned

Specified by:

getTables in interface DatabaseMetaData

Parameters:

catalog - the name of the database to search.

schema - the name of the schema to search.

tableName - the name of the table to search.

types - the type of tables to filter.

Returns:

a resultset with a schema listing.

Throws:

SQLException - with ErrorCode ErrorCode.UNDEFINED_SCHEMA if the schema does not exist within this database; a different error code if something systemic goes wrong.

getColumns

@Nonnull
RelationalResultSet getColumns(String catalog,
 String schema,
 String table,
 String column)
                        throws SQLException

Get the columns for the specified table within the specified schema, as a ResultSet. The returned resultset has the following fields:

1. TABLE_CAT = the name of the database
2. TABLE_SCHEM = the name of the schema
3. TABLE_NAME = the name of the table
4. COLUMN_NAME = the name of the column
5. TYPE_NAME = a string-formatted representation of the type of the column
6. BL_INDEX_TYPE = the index of the column within the type
7. BL_OPTIONS = a json-style string holding all the options set on that field by the descriptor.

Specified by:

getColumns in interface DatabaseMetaData

Parameters:

catalog - the database of interest.

schema - the schema of interest.

table - the table of interest. There must be a table with this name in the specified schema, or a ErrorCode.UNDEFINED_TABLE will be thrown.

column - the column of interest.

Returns:

a ResultSet with a column listing for the table.

Throws:

SQLException - if something goes wrong.

getIndexInfo

RelationalResultSet getIndexInfo(String catalog,
 String schema,
 String table,
 boolean unique,
 boolean approximate)
                          throws SQLException

Specified by:

getIndexInfo in interface DatabaseMetaData

Throws:

SQLException

getPrimaryKeys

RelationalResultSet getPrimaryKeys(String catalog,
 String schema,
 String table)
                            throws SQLException

Retrieves a description of the given table's primary key columns.

Each primary key column description has the following columns:

1. TABLE_CAT String => table catalog (may be null)
2. TABLE_SCHEM String => table schema (may be null)
3. TABLE_NAME String => table name
4. COLUMN_NAME String => column name
5. KEY_SEQ short => sequence number within primary key( a value of 1 represents the first column of the primary key, a value of 2 would represent the second column within the primary key).

Unlike in the superinterface definition, the rows are not guaranteed to return in any order.

Specified by:

getPrimaryKeys in interface DatabaseMetaData

Parameters:

catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search

schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search

table - a table name; must match the table name as it is stored in the database

Returns:

ResultSet - each row is a primary key column description

Throws:

SQLException - if a database access error occurs

getCatalogs

default ResultSet getCatalogs()
                       throws SQLException

Specified by:

getCatalogs in interface DatabaseMetaData

Throws:

SQLException

getTableTypes

default ResultSet getTableTypes()
                         throws SQLException

Specified by:

getTableTypes in interface DatabaseMetaData

Throws:

SQLException

allProceduresAreCallable

default boolean allProceduresAreCallable()
                                  throws SQLException

Specified by:

allProceduresAreCallable in interface DatabaseMetaData

Throws:

SQLException

allTablesAreSelectable

default boolean allTablesAreSelectable()
                                throws SQLException

Specified by:

allTablesAreSelectable in interface DatabaseMetaData

Throws:

SQLException

getURL

default String getURL()
               throws SQLException

Specified by:

getURL in interface DatabaseMetaData

Throws:

SQLException

getUserName

default String getUserName()
                    throws SQLException

Specified by:

getUserName in interface DatabaseMetaData

Throws:

SQLException

isReadOnly

default boolean isReadOnly()
                    throws SQLException

Specified by:

isReadOnly in interface DatabaseMetaData

Throws:

SQLException

nullsAreSortedHigh

default boolean nullsAreSortedHigh()
                            throws SQLException

Specified by:

nullsAreSortedHigh in interface DatabaseMetaData

Throws:

SQLException

nullsAreSortedLow

default boolean nullsAreSortedLow()
                           throws SQLException

Specified by:

nullsAreSortedLow in interface DatabaseMetaData

Throws:

SQLException

nullsAreSortedAtStart

default boolean nullsAreSortedAtStart()
                               throws SQLException

Specified by:

nullsAreSortedAtStart in interface DatabaseMetaData

Throws:

SQLException

nullsAreSortedAtEnd

default boolean nullsAreSortedAtEnd()
                             throws SQLException

Specified by:

nullsAreSortedAtEnd in interface DatabaseMetaData

Throws:

SQLException

getDatabaseProductName

default String getDatabaseProductName()
                               throws SQLException

Specified by:

getDatabaseProductName in interface DatabaseMetaData

Throws:

SQLException

getDatabaseProductVersion

default String getDatabaseProductVersion()
                                  throws SQLException

Specified by:

getDatabaseProductVersion in interface DatabaseMetaData

Throws:

SQLException

getDriverName

default String getDriverName()
                      throws SQLException

Specified by:

getDriverName in interface DatabaseMetaData

Throws:

SQLException

getDriverVersion

default String getDriverVersion()
                         throws SQLException

Specified by:

getDriverVersion in interface DatabaseMetaData

Throws:

SQLException

getDriverMajorVersion

default int getDriverMajorVersion()

Specified by:

getDriverMajorVersion in interface DatabaseMetaData

getDriverMinorVersion

default int getDriverMinorVersion()

Specified by:

getDriverMinorVersion in interface DatabaseMetaData

usesLocalFiles

default boolean usesLocalFiles()
                        throws SQLException

Specified by:

usesLocalFiles in interface DatabaseMetaData

Throws:

SQLException

usesLocalFilePerTable

default boolean usesLocalFilePerTable()
                               throws SQLException

Specified by:

usesLocalFilePerTable in interface DatabaseMetaData

Throws:

SQLException

supportsMixedCaseIdentifiers

default boolean supportsMixedCaseIdentifiers()
                                      throws SQLException

Specified by:

supportsMixedCaseIdentifiers in interface DatabaseMetaData

Throws:

SQLException

storesUpperCaseIdentifiers

default boolean storesUpperCaseIdentifiers()
                                    throws SQLException

Specified by:

storesUpperCaseIdentifiers in interface DatabaseMetaData

Throws:

SQLException

storesLowerCaseIdentifiers

default boolean storesLowerCaseIdentifiers()
                                    throws SQLException

Specified by:

storesLowerCaseIdentifiers in interface DatabaseMetaData

Throws:

SQLException

storesMixedCaseIdentifiers

default boolean storesMixedCaseIdentifiers()
                                    throws SQLException

Specified by:

storesMixedCaseIdentifiers in interface DatabaseMetaData

Throws:

SQLException

supportsMixedCaseQuotedIdentifiers

default boolean supportsMixedCaseQuotedIdentifiers()
                                            throws SQLException

Specified by:

supportsMixedCaseQuotedIdentifiers in interface DatabaseMetaData

Throws:

SQLException

storesUpperCaseQuotedIdentifiers

default boolean storesUpperCaseQuotedIdentifiers()
                                          throws SQLException

Specified by:

storesUpperCaseQuotedIdentifiers in interface DatabaseMetaData

Throws:

SQLException

storesLowerCaseQuotedIdentifiers

default boolean storesLowerCaseQuotedIdentifiers()
                                          throws SQLException

Specified by:

storesLowerCaseQuotedIdentifiers in interface DatabaseMetaData

Throws:

SQLException

storesMixedCaseQuotedIdentifiers

default boolean storesMixedCaseQuotedIdentifiers()
                                          throws SQLException

Specified by:

storesMixedCaseQuotedIdentifiers in interface DatabaseMetaData

Throws:

SQLException

getIdentifierQuoteString

default String getIdentifierQuoteString()
                                 throws SQLException

Specified by:

getIdentifierQuoteString in interface DatabaseMetaData

Throws:

SQLException

getSQLKeywords

default String getSQLKeywords()
                       throws SQLException

Specified by:

getSQLKeywords in interface DatabaseMetaData

Throws:

SQLException

getNumericFunctions

default String getNumericFunctions()
                            throws SQLException

Specified by:

getNumericFunctions in interface DatabaseMetaData

Throws:

SQLException

getStringFunctions

default String getStringFunctions()
                           throws SQLException

Specified by:

getStringFunctions in interface DatabaseMetaData

Throws:

SQLException

getSystemFunctions

default String getSystemFunctions()
                           throws SQLException

Specified by:

getSystemFunctions in interface DatabaseMetaData

Throws:

SQLException

getTimeDateFunctions

default String getTimeDateFunctions()
                             throws SQLException

Specified by:

getTimeDateFunctions in interface DatabaseMetaData

Throws:

SQLException

getSearchStringEscape

default String getSearchStringEscape()
                              throws SQLException

Specified by:

getSearchStringEscape in interface DatabaseMetaData

Throws:

SQLException

getExtraNameCharacters

default String getExtraNameCharacters()
                               throws SQLException

Specified by:

getExtraNameCharacters in interface DatabaseMetaData

Throws:

SQLException

supportsAlterTableWithAddColumn

default boolean supportsAlterTableWithAddColumn()
                                         throws SQLException

Specified by:

supportsAlterTableWithAddColumn in interface DatabaseMetaData

Throws:

SQLException

supportsAlterTableWithDropColumn

default boolean supportsAlterTableWithDropColumn()
                                          throws SQLException

Specified by:

supportsAlterTableWithDropColumn in interface DatabaseMetaData

Throws:

SQLException

supportsColumnAliasing

default boolean supportsColumnAliasing()
                                throws SQLException

Specified by:

supportsColumnAliasing in interface DatabaseMetaData

Throws:

SQLException

nullPlusNonNullIsNull

default boolean nullPlusNonNullIsNull()
                               throws SQLException

Specified by:

nullPlusNonNullIsNull in interface DatabaseMetaData

Throws:

SQLException

supportsConvert

default boolean supportsConvert()
                         throws SQLException

Specified by:

supportsConvert in interface DatabaseMetaData

Throws:

SQLException

supportsConvert

default boolean supportsConvert(int fromType,
 int toType)
                         throws SQLException

Specified by:

supportsConvert in interface DatabaseMetaData

Throws:

SQLException

supportsTableCorrelationNames

default boolean supportsTableCorrelationNames()
                                       throws SQLException

Specified by:

supportsTableCorrelationNames in interface DatabaseMetaData

Throws:

SQLException

supportsDifferentTableCorrelationNames

default boolean supportsDifferentTableCorrelationNames()
                                                throws SQLException

Specified by:

supportsDifferentTableCorrelationNames in interface DatabaseMetaData

Throws:

SQLException

supportsExpressionsInOrderBy

default boolean supportsExpressionsInOrderBy()
                                      throws SQLException

Specified by:

supportsExpressionsInOrderBy in interface DatabaseMetaData

Throws:

SQLException

supportsOrderByUnrelated

default boolean supportsOrderByUnrelated()
                                  throws SQLException

Specified by:

supportsOrderByUnrelated in interface DatabaseMetaData

Throws:

SQLException

supportsGroupBy

default boolean supportsGroupBy()
                         throws SQLException

Specified by:

supportsGroupBy in interface DatabaseMetaData

Throws:

SQLException

supportsGroupByUnrelated

default boolean supportsGroupByUnrelated()
                                  throws SQLException

Specified by:

supportsGroupByUnrelated in interface DatabaseMetaData

Throws:

SQLException

supportsGroupByBeyondSelect

default boolean supportsGroupByBeyondSelect()
                                     throws SQLException

Specified by:

supportsGroupByBeyondSelect in interface DatabaseMetaData

Throws:

SQLException

supportsLikeEscapeClause

default boolean supportsLikeEscapeClause()
                                  throws SQLException

Specified by:

supportsLikeEscapeClause in interface DatabaseMetaData

Throws:

SQLException

supportsMultipleResultSets

default boolean supportsMultipleResultSets()
                                    throws SQLException

Specified by:

supportsMultipleResultSets in interface DatabaseMetaData

Throws:

SQLException

supportsMultipleTransactions

default boolean supportsMultipleTransactions()
                                      throws SQLException

Specified by:

supportsMultipleTransactions in interface DatabaseMetaData

Throws:

SQLException

supportsNonNullableColumns

default boolean supportsNonNullableColumns()
                                    throws SQLException

Specified by:

supportsNonNullableColumns in interface DatabaseMetaData

Throws:

SQLException

supportsMinimumSQLGrammar

default boolean supportsMinimumSQLGrammar()
                                   throws SQLException

Specified by:

supportsMinimumSQLGrammar in interface DatabaseMetaData

Throws:

SQLException

supportsCoreSQLGrammar

default boolean supportsCoreSQLGrammar()
                                throws SQLException

Specified by:

supportsCoreSQLGrammar in interface DatabaseMetaData

Throws:

SQLException

supportsExtendedSQLGrammar

default boolean supportsExtendedSQLGrammar()
                                    throws SQLException

Specified by:

supportsExtendedSQLGrammar in interface DatabaseMetaData

Throws:

SQLException

supportsANSI92EntryLevelSQL

default boolean supportsANSI92EntryLevelSQL()
                                     throws SQLException

Specified by:

supportsANSI92EntryLevelSQL in interface DatabaseMetaData

Throws:

SQLException

supportsANSI92IntermediateSQL

default boolean supportsANSI92IntermediateSQL()
                                       throws SQLException

Specified by:

supportsANSI92IntermediateSQL in interface DatabaseMetaData

Throws:

SQLException

supportsANSI92FullSQL

default boolean supportsANSI92FullSQL()
                               throws SQLException

Specified by:

supportsANSI92FullSQL in interface DatabaseMetaData

Throws:

SQLException

supportsIntegrityEnhancementFacility

default boolean supportsIntegrityEnhancementFacility()
                                              throws SQLException

Specified by:

supportsIntegrityEnhancementFacility in interface DatabaseMetaData

Throws:

SQLException

supportsOuterJoins

default boolean supportsOuterJoins()
                            throws SQLException

Specified by:

supportsOuterJoins in interface DatabaseMetaData

Throws:

SQLException

supportsFullOuterJoins

default boolean supportsFullOuterJoins()
                                throws SQLException

Specified by:

supportsFullOuterJoins in interface DatabaseMetaData

Throws:

SQLException

supportsLimitedOuterJoins

default boolean supportsLimitedOuterJoins()
                                   throws SQLException

Specified by:

supportsLimitedOuterJoins in interface DatabaseMetaData

Throws:

SQLException

getSchemaTerm

default String getSchemaTerm()
                      throws SQLException

Specified by:

getSchemaTerm in interface DatabaseMetaData

Throws:

SQLException

getProcedureTerm

default String getProcedureTerm()
                         throws SQLException

Specified by:

getProcedureTerm in interface DatabaseMetaData

Throws:

SQLException

getCatalogTerm

default String getCatalogTerm()
                       throws SQLException

Specified by:

getCatalogTerm in interface DatabaseMetaData

Throws:

SQLException

isCatalogAtStart

default boolean isCatalogAtStart()
                          throws SQLException

Specified by:

isCatalogAtStart in interface DatabaseMetaData

Throws:

SQLException

getCatalogSeparator

default String getCatalogSeparator()
                            throws SQLException

Specified by:

getCatalogSeparator in interface DatabaseMetaData

Throws:

SQLException

supportsSchemasInDataManipulation

default boolean supportsSchemasInDataManipulation()
                                           throws SQLException

Specified by:

supportsSchemasInDataManipulation in interface DatabaseMetaData

Throws:

SQLException

supportsSchemasInProcedureCalls

default boolean supportsSchemasInProcedureCalls()
                                         throws SQLException

Specified by:

supportsSchemasInProcedureCalls in interface DatabaseMetaData

Throws:

SQLException

supportsSchemasInTableDefinitions

default boolean supportsSchemasInTableDefinitions()
                                           throws SQLException

Specified by:

supportsSchemasInTableDefinitions in interface DatabaseMetaData

Throws:

SQLException

supportsSchemasInIndexDefinitions

default boolean supportsSchemasInIndexDefinitions()
                                           throws SQLException

Specified by:

supportsSchemasInIndexDefinitions in interface DatabaseMetaData

Throws:

SQLException

supportsSchemasInPrivilegeDefinitions

default boolean supportsSchemasInPrivilegeDefinitions()
                                               throws SQLException

Specified by:

supportsSchemasInPrivilegeDefinitions in interface DatabaseMetaData

Throws:

SQLException

supportsCatalogsInDataManipulation

default boolean supportsCatalogsInDataManipulation()
                                            throws SQLException

Specified by:

supportsCatalogsInDataManipulation in interface DatabaseMetaData

Throws:

SQLException

supportsCatalogsInProcedureCalls

default boolean supportsCatalogsInProcedureCalls()
                                          throws SQLException

Specified by:

supportsCatalogsInProcedureCalls in interface DatabaseMetaData

Throws:

SQLException

supportsCatalogsInTableDefinitions

default boolean supportsCatalogsInTableDefinitions()
                                            throws SQLException

Specified by:

supportsCatalogsInTableDefinitions in interface DatabaseMetaData

Throws:

SQLException

supportsCatalogsInIndexDefinitions

default boolean supportsCatalogsInIndexDefinitions()
                                            throws SQLException

Specified by:

supportsCatalogsInIndexDefinitions in interface DatabaseMetaData

Throws:

SQLException

supportsCatalogsInPrivilegeDefinitions

default boolean supportsCatalogsInPrivilegeDefinitions()
                                                throws SQLException

Specified by:

supportsCatalogsInPrivilegeDefinitions in interface DatabaseMetaData

Throws:

SQLException

supportsPositionedDelete

default boolean supportsPositionedDelete()
                                  throws SQLException

Specified by:

supportsPositionedDelete in interface DatabaseMetaData

Throws:

SQLException

supportsPositionedUpdate

default boolean supportsPositionedUpdate()
                                  throws SQLException

Specified by:

supportsPositionedUpdate in interface DatabaseMetaData

Throws:

SQLException

supportsSelectForUpdate

default boolean supportsSelectForUpdate()
                                 throws SQLException

Specified by:

supportsSelectForUpdate in interface DatabaseMetaData

Throws:

SQLException

supportsStoredProcedures

default boolean supportsStoredProcedures()
                                  throws SQLException

Specified by:

supportsStoredProcedures in interface DatabaseMetaData

Throws:

SQLException

supportsSubqueriesInComparisons

default boolean supportsSubqueriesInComparisons()
                                         throws SQLException

Specified by:

supportsSubqueriesInComparisons in interface DatabaseMetaData

Throws:

SQLException

supportsSubqueriesInExists

default boolean supportsSubqueriesInExists()
                                    throws SQLException

Specified by:

supportsSubqueriesInExists in interface DatabaseMetaData

Throws:

SQLException

supportsSubqueriesInIns

default boolean supportsSubqueriesInIns()
                                 throws SQLException

Specified by:

supportsSubqueriesInIns in interface DatabaseMetaData

Throws:

SQLException

supportsSubqueriesInQuantifieds

default boolean supportsSubqueriesInQuantifieds()
                                         throws SQLException

Specified by:

supportsSubqueriesInQuantifieds in interface DatabaseMetaData

Throws:

SQLException

supportsCorrelatedSubqueries

default boolean supportsCorrelatedSubqueries()
                                      throws SQLException

Specified by:

supportsCorrelatedSubqueries in interface DatabaseMetaData

Throws:

SQLException

supportsUnion

default boolean supportsUnion()
                       throws SQLException

Specified by:

supportsUnion in interface DatabaseMetaData

Throws:

SQLException

supportsUnionAll

default boolean supportsUnionAll()
                          throws SQLException

Specified by:

supportsUnionAll in interface DatabaseMetaData

Throws:

SQLException

supportsOpenCursorsAcrossCommit

default boolean supportsOpenCursorsAcrossCommit()
                                         throws SQLException

Specified by:

supportsOpenCursorsAcrossCommit in interface DatabaseMetaData

Throws:

SQLException

supportsOpenCursorsAcrossRollback

default boolean supportsOpenCursorsAcrossRollback()
                                           throws SQLException

Specified by:

supportsOpenCursorsAcrossRollback in interface DatabaseMetaData

Throws:

SQLException

supportsOpenStatementsAcrossCommit

default boolean supportsOpenStatementsAcrossCommit()
                                            throws SQLException

Specified by:

supportsOpenStatementsAcrossCommit in interface DatabaseMetaData

Throws:

SQLException

supportsOpenStatementsAcrossRollback

default boolean supportsOpenStatementsAcrossRollback()
                                              throws SQLException

Specified by:

supportsOpenStatementsAcrossRollback in interface DatabaseMetaData

Throws:

SQLException

getMaxBinaryLiteralLength

default int getMaxBinaryLiteralLength()
                               throws SQLException

Specified by:

getMaxBinaryLiteralLength in interface DatabaseMetaData

Throws:

SQLException

getMaxCharLiteralLength

default int getMaxCharLiteralLength()
                             throws SQLException

Specified by:

getMaxCharLiteralLength in interface DatabaseMetaData

Throws:

SQLException

getMaxColumnNameLength

default int getMaxColumnNameLength()
                            throws SQLException

Specified by:

getMaxColumnNameLength in interface DatabaseMetaData

Throws:

SQLException

getMaxColumnsInGroupBy

default int getMaxColumnsInGroupBy()
                            throws SQLException

Specified by:

getMaxColumnsInGroupBy in interface DatabaseMetaData

Throws:

SQLException

getMaxColumnsInIndex

default int getMaxColumnsInIndex()
                          throws SQLException

Specified by:

getMaxColumnsInIndex in interface DatabaseMetaData

Throws:

SQLException

getMaxColumnsInOrderBy

default int getMaxColumnsInOrderBy()
                            throws SQLException

Specified by:

getMaxColumnsInOrderBy in interface DatabaseMetaData

Throws:

SQLException

getMaxColumnsInSelect

default int getMaxColumnsInSelect()
                           throws SQLException

Specified by:

getMaxColumnsInSelect in interface DatabaseMetaData

Throws:

SQLException

getMaxColumnsInTable

default int getMaxColumnsInTable()
                          throws SQLException

Specified by:

getMaxColumnsInTable in interface DatabaseMetaData

Throws:

SQLException

getMaxConnections

default int getMaxConnections()
                       throws SQLException

Specified by:

getMaxConnections in interface DatabaseMetaData

Throws:

SQLException

getMaxCursorNameLength

default int getMaxCursorNameLength()
                            throws SQLException

Specified by:

getMaxCursorNameLength in interface DatabaseMetaData

Throws:

SQLException

getMaxIndexLength

default int getMaxIndexLength()
                       throws SQLException

Specified by:

getMaxIndexLength in interface DatabaseMetaData

Throws:

SQLException

getMaxSchemaNameLength

default int getMaxSchemaNameLength()
                            throws SQLException

Specified by:

getMaxSchemaNameLength in interface DatabaseMetaData

Throws:

SQLException

getMaxProcedureNameLength

default int getMaxProcedureNameLength()
                               throws SQLException

Specified by:

getMaxProcedureNameLength in interface DatabaseMetaData

Throws:

SQLException

getMaxCatalogNameLength

default int getMaxCatalogNameLength()
                             throws SQLException

Specified by:

getMaxCatalogNameLength in interface DatabaseMetaData

Throws:

SQLException

getMaxRowSize

default int getMaxRowSize()
                   throws SQLException

Specified by:

getMaxRowSize in interface DatabaseMetaData

Throws:

SQLException

doesMaxRowSizeIncludeBlobs

default boolean doesMaxRowSizeIncludeBlobs()
                                    throws SQLException

Specified by:

doesMaxRowSizeIncludeBlobs in interface DatabaseMetaData

Throws:

SQLException

getMaxStatementLength

default int getMaxStatementLength()
                           throws SQLException

Specified by:

getMaxStatementLength in interface DatabaseMetaData

Throws:

SQLException

getMaxStatements

default int getMaxStatements()
                      throws SQLException

Specified by:

getMaxStatements in interface DatabaseMetaData

Throws:

SQLException

getMaxTableNameLength

default int getMaxTableNameLength()
                           throws SQLException

Specified by:

getMaxTableNameLength in interface DatabaseMetaData

Throws:

SQLException

getMaxTablesInSelect

default int getMaxTablesInSelect()
                          throws SQLException

Specified by:

getMaxTablesInSelect in interface DatabaseMetaData

Throws:

SQLException

getMaxUserNameLength

default int getMaxUserNameLength()
                          throws SQLException

Specified by:

getMaxUserNameLength in interface DatabaseMetaData

Throws:

SQLException

getDefaultTransactionIsolation

default int getDefaultTransactionIsolation()
                                    throws SQLException

Specified by:

getDefaultTransactionIsolation in interface DatabaseMetaData

Throws:

SQLException

supportsTransactions

default boolean supportsTransactions()
                              throws SQLException

Specified by:

supportsTransactions in interface DatabaseMetaData

Throws:

SQLException

supportsTransactionIsolationLevel

default boolean supportsTransactionIsolationLevel(int level)
                                           throws SQLException

Specified by:

supportsTransactionIsolationLevel in interface DatabaseMetaData

Throws:

SQLException

supportsDataDefinitionAndDataManipulationTransactions

default boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                               throws SQLException

Specified by:

supportsDataDefinitionAndDataManipulationTransactions in interface DatabaseMetaData

Throws:

SQLException

supportsDataManipulationTransactionsOnly

default boolean supportsDataManipulationTransactionsOnly()
                                                  throws SQLException

Specified by:

supportsDataManipulationTransactionsOnly in interface DatabaseMetaData

Throws:

SQLException

dataDefinitionCausesTransactionCommit

default boolean dataDefinitionCausesTransactionCommit()
                                               throws SQLException

Specified by:

dataDefinitionCausesTransactionCommit in interface DatabaseMetaData

Throws:

SQLException

dataDefinitionIgnoredInTransactions

default boolean dataDefinitionIgnoredInTransactions()
                                             throws SQLException

Specified by:

dataDefinitionIgnoredInTransactions in interface DatabaseMetaData

Throws:

SQLException

getProcedures

default ResultSet getProcedures(String catalog,
 String schemaPattern,
 String procedureNamePattern)
                         throws SQLException

Specified by:

getProcedures in interface DatabaseMetaData

Throws:

SQLException

getProcedureColumns

default ResultSet getProcedureColumns(String catalog,
 String schemaPattern,
 String procedureNamePattern,
 String columnNamePattern)
                               throws SQLException

Specified by:

getProcedureColumns in interface DatabaseMetaData

Throws:

SQLException

getColumnPrivileges

default ResultSet getColumnPrivileges(String catalog,
 String schema,
 String table,
 String columnNamePattern)
                               throws SQLException

Specified by:

getColumnPrivileges in interface DatabaseMetaData

Throws:

SQLException

getTablePrivileges

default ResultSet getTablePrivileges(String catalog,
 String schemaPattern,
 String tableNamePattern)
                              throws SQLException

Specified by:

getTablePrivileges in interface DatabaseMetaData

Throws:

SQLException

getBestRowIdentifier

default ResultSet getBestRowIdentifier(String catalog,
 String schema,
 String table,
 int scope,
 boolean nullable)
                                throws SQLException

Specified by:

getBestRowIdentifier in interface DatabaseMetaData

Throws:

SQLException

getVersionColumns

default ResultSet getVersionColumns(String catalog,
 String schema,
 String table)
                             throws SQLException

Specified by:

getVersionColumns in interface DatabaseMetaData

Throws:

SQLException

getImportedKeys

default ResultSet getImportedKeys(String catalog,
 String schema,
 String table)
                           throws SQLException

Specified by:

getImportedKeys in interface DatabaseMetaData

Throws:

SQLException

getExportedKeys

default ResultSet getExportedKeys(String catalog,
 String schema,
 String table)
                           throws SQLException

Specified by:

getExportedKeys in interface DatabaseMetaData

Throws:

SQLException

getCrossReference

default ResultSet getCrossReference(String parentCatalog,
 String parentSchema,
 String parentTable,
 String foreignCatalog,
 String foreignSchema,
 String foreignTable)
                             throws SQLException

Specified by:

getCrossReference in interface DatabaseMetaData

Throws:

SQLException

getTypeInfo

default ResultSet getTypeInfo()
                       throws SQLException

Specified by:

getTypeInfo in interface DatabaseMetaData

Throws:

SQLException

supportsResultSetType

default boolean supportsResultSetType(int type)
                               throws SQLException

Specified by:

supportsResultSetType in interface DatabaseMetaData

Throws:

SQLException

supportsResultSetConcurrency

default boolean supportsResultSetConcurrency(int type,
 int concurrency)
                                      throws SQLException

Specified by:

supportsResultSetConcurrency in interface DatabaseMetaData

Throws:

SQLException

ownUpdatesAreVisible

default boolean ownUpdatesAreVisible(int type)
                              throws SQLException

Specified by:

ownUpdatesAreVisible in interface DatabaseMetaData

Throws:

SQLException

ownDeletesAreVisible

default boolean ownDeletesAreVisible(int type)
                              throws SQLException

Specified by:

ownDeletesAreVisible in interface DatabaseMetaData

Throws:

SQLException

ownInsertsAreVisible

default boolean ownInsertsAreVisible(int type)
                              throws SQLException

Specified by:

ownInsertsAreVisible in interface DatabaseMetaData

Throws:

SQLException

othersUpdatesAreVisible

default boolean othersUpdatesAreVisible(int type)
                                 throws SQLException

Specified by:

othersUpdatesAreVisible in interface DatabaseMetaData

Throws:

SQLException

othersDeletesAreVisible

default boolean othersDeletesAreVisible(int type)
                                 throws SQLException

Specified by:

othersDeletesAreVisible in interface DatabaseMetaData

Throws:

SQLException

othersInsertsAreVisible

default boolean othersInsertsAreVisible(int type)
                                 throws SQLException

Specified by:

othersInsertsAreVisible in interface DatabaseMetaData

Throws:

SQLException

updatesAreDetected

default boolean updatesAreDetected(int type)
                            throws SQLException

Specified by:

updatesAreDetected in interface DatabaseMetaData

Throws:

SQLException

deletesAreDetected

default boolean deletesAreDetected(int type)
                            throws SQLException

Specified by:

deletesAreDetected in interface DatabaseMetaData

Throws:

SQLException

insertsAreDetected

default boolean insertsAreDetected(int type)
                            throws SQLException

Specified by:

insertsAreDetected in interface DatabaseMetaData

Throws:

SQLException

supportsBatchUpdates

default boolean supportsBatchUpdates()
                              throws SQLException

Specified by:

supportsBatchUpdates in interface DatabaseMetaData

Throws:

SQLException

getUDTs

default ResultSet getUDTs(String catalog,
 String schemaPattern,
 String typeNamePattern,
 int[] types)
                   throws SQLException

Specified by:

getUDTs in interface DatabaseMetaData

Throws:

SQLException

getConnection

default Connection getConnection()
                          throws SQLException

Specified by:

getConnection in interface DatabaseMetaData

Throws:

SQLException

supportsSavepoints

default boolean supportsSavepoints()
                            throws SQLException

Specified by:

supportsSavepoints in interface DatabaseMetaData

Throws:

SQLException

supportsNamedParameters

default boolean supportsNamedParameters()
                                 throws SQLException

Specified by:

supportsNamedParameters in interface DatabaseMetaData

Throws:

SQLException

supportsMultipleOpenResults

default boolean supportsMultipleOpenResults()
                                     throws SQLException

Specified by:

supportsMultipleOpenResults in interface DatabaseMetaData

Throws:

SQLException

supportsGetGeneratedKeys

default boolean supportsGetGeneratedKeys()
                                  throws SQLException

Specified by:

supportsGetGeneratedKeys in interface DatabaseMetaData

Throws:

SQLException

getSuperTypes

default ResultSet getSuperTypes(String catalog,
 String schemaPattern,
 String typeNamePattern)
                         throws SQLException

Specified by:

getSuperTypes in interface DatabaseMetaData

Throws:

SQLException

getSuperTables

default ResultSet getSuperTables(String catalog,
 String schemaPattern,
 String tableNamePattern)
                          throws SQLException

Specified by:

getSuperTables in interface DatabaseMetaData

Throws:

SQLException

getAttributes

default ResultSet getAttributes(String catalog,
 String schemaPattern,
 String typeNamePattern,
 String attributeNamePattern)
                         throws SQLException

Specified by:

getAttributes in interface DatabaseMetaData

Throws:

SQLException

supportsResultSetHoldability

default boolean supportsResultSetHoldability(int holdability)
                                      throws SQLException

Specified by:

supportsResultSetHoldability in interface DatabaseMetaData

Throws:

SQLException

getResultSetHoldability

default int getResultSetHoldability()
                             throws SQLException

Specified by:

getResultSetHoldability in interface DatabaseMetaData

Throws:

SQLException

getDatabaseMajorVersion

default int getDatabaseMajorVersion()
                             throws SQLException

Specified by:

getDatabaseMajorVersion in interface DatabaseMetaData

Throws:

SQLException

getDatabaseMinorVersion

default int getDatabaseMinorVersion()
                             throws SQLException

Specified by:

getDatabaseMinorVersion in interface DatabaseMetaData

Throws:

SQLException

getJDBCMajorVersion

default int getJDBCMajorVersion()
                         throws SQLException

Specified by:

getJDBCMajorVersion in interface DatabaseMetaData

Throws:

SQLException

getJDBCMinorVersion

default int getJDBCMinorVersion()
                         throws SQLException

Specified by:

getJDBCMinorVersion in interface DatabaseMetaData

Throws:

SQLException

getSQLStateType

default int getSQLStateType()
                     throws SQLException

Specified by:

getSQLStateType in interface DatabaseMetaData

Throws:

SQLException

locatorsUpdateCopy

default boolean locatorsUpdateCopy()
                            throws SQLException

Specified by:

locatorsUpdateCopy in interface DatabaseMetaData

Throws:

SQLException

supportsStatementPooling

default boolean supportsStatementPooling()
                                  throws SQLException

Specified by:

supportsStatementPooling in interface DatabaseMetaData

Throws:

SQLException

getRowIdLifetime

default RowIdLifetime getRowIdLifetime()
                                throws SQLException

Specified by:

getRowIdLifetime in interface DatabaseMetaData

Throws:

SQLException

supportsStoredFunctionsUsingCallSyntax

default boolean supportsStoredFunctionsUsingCallSyntax()
                                                throws SQLException

Specified by:

supportsStoredFunctionsUsingCallSyntax in interface DatabaseMetaData

Throws:

SQLException

autoCommitFailureClosesAllResultSets

default boolean autoCommitFailureClosesAllResultSets()
                                              throws SQLException

Specified by:

autoCommitFailureClosesAllResultSets in interface DatabaseMetaData

Throws:

SQLException

getClientInfoProperties

default ResultSet getClientInfoProperties()
                                   throws SQLException

Specified by:

getClientInfoProperties in interface DatabaseMetaData

Throws:

SQLException

getFunctions

default ResultSet getFunctions(String catalog,
 String schemaPattern,
 String functionNamePattern)
                        throws SQLException

Specified by:

getFunctions in interface DatabaseMetaData

Throws:

SQLException

getFunctionColumns

default ResultSet getFunctionColumns(String catalog,
 String schemaPattern,
 String functionNamePattern,
 String columnNamePattern)
                              throws SQLException

Specified by:

getFunctionColumns in interface DatabaseMetaData

Throws:

SQLException

getPseudoColumns

default ResultSet getPseudoColumns(String catalog,
 String schemaPattern,
 String tableNamePattern,
 String columnNamePattern)
                            throws SQLException

Specified by:

getPseudoColumns in interface DatabaseMetaData

Throws:

SQLException

generatedKeyAlwaysReturned

default boolean generatedKeyAlwaysReturned()
                                    throws SQLException

Specified by:

generatedKeyAlwaysReturned in interface DatabaseMetaData

Throws:

SQLException

unwrap

default <T> T unwrap(Class<T> iface)
              throws SQLException

Specified by:

unwrap in interface Wrapper

Throws:

SQLException

isWrapperFor

default boolean isWrapperFor(Class<?> iface)
                      throws SQLException

Specified by:

isWrapperFor in interface Wrapper

Throws:

SQLException