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.