JDBC Driver - DatabaseMetaData - Flags

On this page

These are the values reported by the JDBC Driver 3.1 implementation of java.sql.DatabaseMetaData. They include fixed defaults and JDBC compatibility flags, which can be broader than the features the driver implements. For example, supportsNamedParameters() reports true while prepared SQL uses positional markers and CallableStatement is unsupported.

A zero value in a getMax* method means the driver provides no limit information. It does not assert that every server and store has unlimited capacity.

Capability flags

Method Reported value JDBC meaning
allProceduresAreCallable() true Indicates whether all procedures in the database are callable by the user.
allTablesAreSelectable() true Indicates whether all tables in the database are selectable by the user.
isReadOnly() false Indicates whether the database is in read-only mode.
nullsAreSortedHigh() false Indicates whether NULL values are sorted at the high end of the sort order.
nullsAreSortedLow() false Indicates whether NULL values are sorted at the low end of the sort order.
nullsAreSortedAtStart() false Indicates whether NULL values are sorted at the start of the sorted data.
nullsAreSortedAtEnd() true Indicates whether NULL values are sorted at the end of the sorted data.
usesLocalFiles() false Indicates whether the database uses local files to store data.
usesLocalFilePerTable() false Indicates whether the database uses a separate local file for each table to store data.
supportsMixedCaseIdentifiers() true Indicates if the database supports mixed-case (e.g., both upper and lower case) identifiers.
storesUpperCaseIdentifiers() false Indicates if the database stores identifiers in upper case.
storesLowerCaseIdentifiers() false Indicates if the database stores identifiers in lower case.
storesMixedCaseIdentifiers() true Indicates if the database stores identifiers in mixed case.
supportsMixedCaseQuotedIdentifiers() false Indicates if the database supports mixed-case quoted identifiers.
storesUpperCaseQuotedIdentifiers() false Indicates if the database stores quoted identifiers in upper case.
storesLowerCaseQuotedIdentifiers() false Indicates if the database stores quoted identifiers in lower case.
storesMixedCaseQuotedIdentifiers() false Indicates if the database stores quoted identifiers in mixed case.
getIdentifierQuoteString() " " Retrieves the string used to quote SQL identifiers. This can vary between databases.
getSearchStringEscape() the backslash character (\) Retrieves the string that can be used to escape wildcard characters in a LIKE clause.
getExtraNameCharacters() "" Retrieves any extra characters that are allowed in a database name.
supportsAlterTableWithAddColumn() false Indicates whether the database supports the ALTER TABLE command with the ADD COLUMN variant.
supportsAlterTableWithDropColumn() false Indicates whether the database supports the ALTER TABLE command with the DROP COLUMN variant.
supportsColumnAliasing() true Indicates whether the database supports column aliasing.
nullPlusNonNullIsNull() true Indicates whether an arithmetic operation involving a NULL always results in a NULL.
supportsConvert() false Indicates whether the database supports the CONVERT SQL function.
supportsConvert(int fromType, int toType) false Indicates whether the database supports the CONVERT SQL function for the specified types.
supportsTableCorrelationNames() false Indicates whether the database supports table correlation names.
supportsDifferentTableCorrelationNames() false Indicates whether the database supports table correlation names that are different from the table names.
supportsExpressionsInOrderBy() true Indicates whether the database supports using expressions in an ORDER BY clause.
supportsOrderByUnrelated() true Indicates whether the database supports ordering by a column that isn’t in the SELECT statement.
supportsGroupBy() true Indicates whether the database supports the SQL GROUP BY clause.
supportsGroupByUnrelated() true Indicates whether the database supports using a GROUP BY clause that includes columns not in the SELECT.
supportsGroupByBeyondSelect() true Indicates whether the database supports using a GROUP BY clause that includes columns from a table not in the SELECT.
supportsLikeEscapeClause() true Indicates whether the database supports the LIKE escape clause.
supportsMultipleResultSets() false Indicates whether the database supports having multiple ResultSet objects returned from a statement.
supportsMultipleTransactions() false Indicates whether the database supports having multiple transactions open at once.
supportsNonNullableColumns() true Indicates whether the database supports columns that can’t have a NULL value.
supportsMinimumSQLGrammar() true Indicates whether the database supports the minimum SQL grammar.
supportsCoreSQLGrammar() true Indicates whether the database supports the core SQL grammar.
supportsExtendedSQLGrammar() true Indicates whether the database supports the extended SQL grammar.
supportsANSI92EntryLevelSQL() true Indicates whether the database supports the ANSI92 entry-level SQL.
supportsANSI92IntermediateSQL() true Indicates whether the database supports the ANSI92 intermediate SQL.
supportsANSI92FullSQL() true Indicates whether the database supports the ANSI92 full SQL.
supportsIntegrityEnhancementFacility() false Indicates whether the database supports the SQL Integrity Enhancement Facility.
supportsOuterJoins() true Indicates whether the database supports outer joins.
supportsFullOuterJoins() true Indicates whether the database supports full outer joins.
supportsLimitedOuterJoins() true Indicates whether the database supports limited (certain types but not all) outer joins.
getSchemaTerm() "namespace" Retrieves the term used by the database to refer to a schema.
getProcedureTerm() "procedure" Retrieves the term used by the database to refer to a procedure.
getCatalogTerm() "" Retrieves the term used by the database to refer to a catalog.
isCatalogAtStart() false Determines whether the catalog appears at the start of a fully qualified table name.
getCatalogSeparator() "" Retrieves the separator string that separates a catalog from a schema.
supportsSchemasInDataManipulation() true Indicates whether the database supports schemas in data manipulation statements.
supportsSchemasInProcedureCalls() true Indicates whether the database supports schemas in procedure calls.
supportsSchemasInTableDefinitions() true Indicates whether the database supports schemas in table definitions.
supportsSchemasInIndexDefinitions() true Indicates whether the database supports schemas in index definitions.
supportsSchemasInPrivilegeDefinitions() true Indicates whether the database supports schemas in privilege definitions.
supportsCatalogsInDataManipulation() false Indicates whether the database supports catalogs in data manipulation statements.
supportsCatalogsInProcedureCalls() false Indicates whether the database supports catalogs in procedure calls.
supportsCatalogsInTableDefinitions() false Indicates whether the database supports catalogs in table definitions.
supportsCatalogsInIndexDefinitions() false Indicates whether the database supports catalogs in index definitions.
supportsCatalogsInPrivilegeDefinitions() false Indicates whether the database supports catalogs in privilege definitions.
supportsPositionedDelete() false Indicates whether the database supports the SQL DELETE statement with a WHERE clause that is based on a cursor position.
supportsPositionedUpdate() false Indicates whether the database supports the SQL UPDATE statement with a WHERE clause that is based on a cursor position.
supportsSelectForUpdate() false Indicates whether the database supports the SQL SELECT FOR UPDATE statement.
supportsStoredProcedures() false Indicates whether the database supports stored procedure calls.
supportsSubqueriesInComparisons() true Indicates whether the database supports subqueries in comparison expressions.
supportsSubqueriesInExists() true Indicates whether the database supports subqueries in EXISTS expressions.
supportsSubqueriesInIns() true Indicates whether the database supports subqueries in IN statements.
supportsSubqueriesInQuantifieds() false Indicates whether the database supports subqueries in quantified expressions.
supportsCorrelatedSubqueries() true Indicates whether the database supports correlated subqueries.
supportsUnion() true Indicates whether the database supports the SQL UNION clause.
supportsUnionAll() true Indicates whether the database supports the SQL UNION ALL clause.
supportsOpenCursorsAcrossCommit() false Indicates if a cursor remains open after a commit operation.
supportsOpenCursorsAcrossRollback() false Indicates if a cursor remains open after a rollback operation.
supportsOpenStatementsAcrossCommit() false Indicates if a statement remains open after a commit operation.
supportsOpenStatementsAcrossRollback() false Indicates if a statement remains open after a rollback operation.
getMaxBinaryLiteralLength() 0 Retrieves the maximum number of hexadecimal characters a binary literal can have.
getMaxCharLiteralLength() 0 Retrieves the maximum number of characters a character literal can have.
getMaxColumnNameLength() 0 Retrieves the maximum number of characters a column name can have.
getMaxColumnsInGroupBy() 0 Retrieves the maximum number of columns a GROUP BY clause can have.
getMaxColumnsInIndex() 0 Retrieves the maximum number of columns an index can have.
getMaxColumnsInOrderBy() 0 Retrieves the maximum number of columns an ORDER BY clause can have.
getMaxColumnsInSelect() 0 Retrieves the maximum number of columns a SELECT statement can have.
getMaxColumnsInTable() 0 Retrieves the maximum number of columns a table can have.
getMaxConnections() 0 Retrieves the maximum number of active connections the database can support simultaneously.
getMaxCursorNameLength() 0 Retrieves the maximum number of characters a cursor name can have.
getMaxIndexLength() 0 Retrieves the maximum number of bytes an index can have.
getMaxSchemaNameLength() 0 Retrieves the maximum number of characters a schema name can have.
getMaxProcedureNameLength() 0 Retrieves the maximum number of characters a procedure name can have.
getMaxCatalogNameLength() 0 Retrieves the maximum number of characters a catalog name can have.
getMaxRowSize() 0 Retrieves the maximum number of bytes a single row can have.
doesMaxRowSizeIncludeBlobs() false Indicates whether the return value of getMaxRowSize() includes the sizes of BLOB and CLOB columns.
getMaxStatementLength() 0 Retrieves the maximum number of characters a SQL statement can have.
getMaxStatements() 0 Retrieves the maximum number of statements that can be open at one time.
getMaxTableNameLength() 0 Retrieves the maximum number of characters a table name can have.
getMaxTablesInSelect() 0 Retrieves the maximum number of tables allowed in a SELECT statement.
getMaxUserNameLength() 0 Retrieves the maximum number of characters a username can have.
getDefaultTransactionIsolation() Connection.TRANSACTION_READ_COMMITTED Retrieves the default transaction isolation level.
supportsTransactions() true Indicates whether the database supports transactions.
supportsTransactionIsolationLevel(int level) true only for Connection.TRANSACTION_READ_COMMITTED Indicates whether the database supports the specified transaction isolation level.
supportsDataDefinitionAndDataManipulationTransactions() true Indicates if both data definition and data manipulation commands are supported within a transaction.
supportsDataManipulationTransactionsOnly() true Indicates if only data manipulation commands are supported within a transaction.
dataDefinitionCausesTransactionCommit() true Indicates if executing a data definition statement causes an automatic commit.
dataDefinitionIgnoredInTransactions() false Indicates if data definition statements are ignored within transactions.
ownUpdatesAreVisible(int type) false Indicates whether updates made by the current session are visible.
ownDeletesAreVisible(int type) false Indicates whether deletes made by the current session are visible.
ownInsertsAreVisible(int type) false Indicates whether inserts made by the current session are visible.
othersUpdatesAreVisible(int type) false Indicates whether updates made by others are visible.
othersDeletesAreVisible(int type) false Indicates whether deletes made by others are visible.
othersInsertsAreVisible(int type) false Indicates whether inserts made by others are visible.
updatesAreDetected(int i) false Indicates whether the method detects updates.
deletesAreDetected(int i) false Indicates whether the method detects deletes.
insertsAreDetected(int i) false Indicates whether the method detects inserts.
supportsBatchUpdates() true Indicates if the database supports batch updates.
supportsSavepoints() false Indicates whether the database supports savepoints.
supportsNamedParameters() true Indicates if the database supports named parameter markers for calling stored procedures.
supportsMultipleOpenResults() false Indicates if the database supports having multiple ResultSet objects returned from a statement object simultaneously.
supportsGetGeneratedKeys() false Indicates if the database supports the retrieval of auto-generated keys after an insertion operation.
getSQLStateType() DatabaseMetaData.sqlStateSQL Retrieves the type of the SQL state codes returned by SQLException.getSQLState().
locatorsUpdateCopy() true Indicates whether the locators (like Blob, Clob, etc.) retrieved by this connection are updated copies or references.
supportsStatementPooling() false Determines if the database supports the pooling of SQL statements.
getRowIdLifetime() RowIdLifetime.ROWID_UNSUPPORTED Describes the lifetime of a RowId. This is one of the values from the RowIdLifetime enumeration in java.sql.RowIdLifetime.
supportsStoredFunctionsUsingCallSyntax() false Determines if the database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
autoCommitFailureClosesAllResultSets() false Indicates whether a SQLException during autoCommit will close all ResultSet objects that have been opened by the Connection. If true, all such ResultSet objects will be closed. If false, they remain open.
generatedKeyAlwaysReturned() false Determines if a generated key will always be returned if the column’s value is auto-incremented. If true, the generated key is always returned.
© Polypheny GmbH. All Rights Reserved.