skip to main content
JDBC support : DatabaseMetaData
  

Try DataDirect Drivers Now

DatabaseMetaData

DatabaseMetaData Methods
Version Introduced
Supported
Comments
boolean autoCommitFailureClosesAllResultSets()
4.0
Yes
 
boolean allProceduresAreCallable()
1.0
Yes
 
boolean allTablesAreSelectable()
1.0
Yes
 
boolean dataDefinitionCausesTransactionCommit()
1.0
Yes
 
boolean dataDefinitionIgnoredInTransactions()
1.0
Yes
 
boolean deletesAreDetected(int)
2.0 Core
Yes
 
boolean doesMaxRowSizeIncludeBlobs()
1.0
Yes
Not supported by the SQL Server and Sybase drivers.
getAttributes(String, String, String, String)
3.0
Yes
The Oracle driver may return results.
All other drivers return an empty result set.
ResultSet getBestRowIdentifier(String, String, String, int, boolean)
1.0
Yes
ResultSet getCatalogs()
1.0
Yes
String getCatalogSeparator()
1.0
Yes
 
String getCatalogTerm()
1.0
Yes
 
String getClientInfoProperties()
4.0
Yes
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce do not support storing or retrieving client information.
ResultSet getColumnPrivileges(String, String, String, String)
1.0
Yes
Not supported by the drivers for Apache Hive, Apache Spark SQL, Impala, Oracle Eloqua, and Oracle Sales Cloud.
ResultSet getColumns(String, String, String, String)
1.0
Yes
 
Connection getConnection()
2.0 Core
Yes
 
ResultSet getCrossReference(String, String, String, String, String, String)
1.0
Yes
ResultSet getFunctions()
4.0
Yes
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce return an empty result set.
Not supported by the drivers for Apache Hive, Apache Spark SQL, or Impala.
ResultSet getFunctionColumns()
4.0
Yes
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce return an empty result set.
Not supported by the drivers for Apache Hive, Apache Spark SQL, or Impala.
int getDatabaseMajorVersion()
3.0
Yes
 
int getDatabaseMinorVersion()
3.0
Yes
 
String getDatabaseProductName()
1.0
Yes
 
String getDatabaseProductVersion()
1.0
Yes
 
int getDefaultTransactionIsolation()
1.0
Yes
 
int getDriverMajorVersion()
1.0
Yes
 
int getDriverMinorVersion()
1.0
Yes
 
String getDriverName()
1.0
Yes
 
String getDriverVersion()
1.0
Yes
 
ResultSet getExportedKeys(String, String, String)
1.0
Yes
 
String getExtraNameCharacters()
1.0
Yes
 
String getIdentifierQuoteString()
1.0
Yes
 
ResultSet getImportedKeys(String, String, String)
1.0
Yes
 
ResultSet getIndexInfo(String, String, String, boolean, boolean)
1.0
Yes
 
int getJDBCMajorVersion()
3.0
Yes
 
int getJDBCMinorVersion()
3.0
Yes
 
int getMaxBinaryLiteralLength()
1.0
Yes
 
int getMaxCatalogNameLength()
1.0
Yes
 
int getMaxCharLiteralLength()
1.0
Yes
 
int getMaxColumnNameLength()
1.0
Yes
 
int getMaxColumnsInGroupBy()
1.0
Yes
 
int getMaxColumnsInIndex()
1.0
Yes
 
int getMaxColumnsInOrderBy()
1.0
Yes
 
int getMaxColumnsInSelect()
1.0
Yes
 
int getMaxColumnsInTable()
1.0
Yes
 
int getMaxConnections()
1.0
Yes
 
int getMaxCursorNameLength()
1.0
Yes
 
int getMaxIndexLength()
1.0
Yes
 
int getMaxProcedureNameLength()
1.0
Yes
 
int getMaxRowSize()
1.0
Yes
 
int getMaxSchemaNameLength()
1.0
Yes
 
int getMaxStatementLength()
1.0
Yes
 
int getMaxStatements()
1.0
Yes
 
int getMaxTableNameLength()
1.0
Yes
 
int getMaxTablesInSelect()
1.0
Yes
 
int getMaxUserNameLength()
1.0
Yes
 
String getNumericFunctions()
1.0
Yes
 
ResultSet getPrimaryKeys(String, String, String)
1.0
Yes
 
ResultSet getProcedureColumns(String, String, String, String)
1.0
Yes
For the drivers for Oracle Service Cloud, and Salesforce, SchemaName and ProcedureName must be explicit values; they cannot be patterns.
The drivers for Apache Cassandra and MongoDB return an empty result set.
Not supported for the drivers for Apache Hive, Apache Spark SQL, or Impala.
ResultSet getProcedures(String, String, String)
1.0
Yes
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, and Oracle Sales Cloud return an empty result set.
Not supported for the drivers for Apache Hive, Apache Spark SQL, or Impala.
String getProcedureTerm()
1.0
Yes
 
int getResultSetHoldability()
3.0
Yes
 
ResultSet getSchemas()
1.0
Yes
 
ResultSet getSchemas(catalog, pattern)
4.0
Yes
 
String getSchemaTerm()
1.0
Yes
 
String getSearchStringEscape()
1.0
Yes
 
String getSQLKeywords()
1.0
Yes
 
int getSQLStateType()
3.0
Yes
 
String getStringFunctions()
1.0
Yes
 
ResultSet getSuperTables(String, String, String)
3.0
Yes
Returns an empty result set.
ResultSet getSuperTypes(String, String, String)
3.0
Yes
Returns an empty result set.
String getSystemFunctions()
1.0
Yes
ResultSet getTablePrivileges(String, String, String)
1.0
Yes
Not supported for the drivers for Apache Hive, Apache Spark SQL, Impala, Oracle Eloqua, and Oracle Sales Cloud.
ResultSet getTables(String, String, String, String [])
1.0
Yes
 
ResultSet getTableTypes()
1.0
Yes
 
String getTimeDateFunctions()
1.0
Yes
 
ResultSet getTypeInfo()
1.0
Yes
 
ResultSet getUDTs(String, String, String, int [])
2.0 Core
Yes
Supported for Oracle only.
String getURL()
1.0
Yes
 
String getUserName()
1.0
Yes
 
ResultSet getVersionColumns(String, String, String)
1.0
Yes
 
boolean insertsAreDetected(int)
2.0 Core
Yes
 
boolean isCatalogAtStart()
1.0
Yes
 
boolean isReadOnly()
1.0
Yes
 
boolean isWrapperFor(Class<?> iface)
4.0
Yes
 
boolean locatorsUpdateCopy()
3.0
Yes
 
boolean nullPlusNonNullIsNull()
1.0
Yes
 
boolean nullsAreSortedAtEnd()
1.0
Yes
 
boolean nullsAreSortedAtStart()
1.0
Yes
 
boolean nullsAreSortedHigh()
1.0
Yes
 
boolean nullsAreSortedLow()
1.0
Yes
 
boolean othersDeletesAreVisible(int)
2.0 Core
Yes
 
boolean othersInsertsAreVisible(int)
2.0 Core
Yes
 
boolean othersUpdatesAreVisible(int)
2.0 Core
Yes
 
boolean ownDeletesAreVisible(int)
2.0 Core
Yes
 
boolean ownInsertsAreVisible(int)
2.0 Core
Yes
 
boolean ownUpdatesAreVisible(int)
2.0 Core
Yes
 
boolean storesLowerCaseIdentifiers()
1.0
Yes
 
boolean storesLowerCaseQuotedIdentifiers()
1.0
Yes
 
boolean storesMixedCaseIdentifiers()
1.0
Yes
 
boolean storesMixedCaseQuotedIdentifiers()
1.0
Yes
 
boolean storesUpperCaseIdentifiers()
1.0
Yes
 
boolean storesUpperCaseQuotedIdentifiers()
1.0
Yes
 
boolean supportsAlterTableWithAddColumn()
1.0
Yes
 
boolean supportsAlterTableWithDropColumn()
1.0
Yes
 
boolean supportsANSI92EntryLevelSQL()
1.0
Yes
 
boolean supportsANSI92FullSQL()
1.0
Yes
 
boolean supportsANSI92IntermediateSQL()
1.0
Yes
 
boolean supportsBatchUpdates()
2.0 Core
Yes
 
boolean supportsCatalogsInDataManipulation()
1.0
Yes
 
boolean supportsCatalogsInIndexDefinitions()
1.0
Yes
 
boolean supportsCatalogsInPrivilegeDefinitions()
1.0
Yes
 
boolean supportsCatalogsInProcedureCalls()
1.0
Yes
 
boolean supportsCatalogsInTableDefinitions()
1.0
Yes
 
boolean supportsColumnAliasing()
1.0
Yes
 
boolean supportsConvert()
1.0
Yes
 
boolean supportsConvert(int, int)
1.0
Yes
 
boolean supportsCoreSQLGrammar()
1.0
Yes
 
boolean supportsCorrelatedSubqueries()
1.0
Yes
 
boolean supportsDataDefinitionAndData ManipulationTransactions()
1.0
Yes
 
boolean supportsDataManipulationTransactionsOnly()
1.0
Yes
 
boolean supportsDifferentTableCorrelationNames()
1.0
Yes
 
boolean supportsExpressionsInOrderBy()
1.0
Yes
 
boolean supportsExtendedSQLGrammar()
1.0
Yes
 
boolean supportsFullOuterJoins()
1.0
Yes
 
boolean supportsGetGeneratedKeys()
3.0
Yes
 
boolean supportsGroupBy()
1.0
Yes
 
boolean supportsGroupByBeyondSelect()
1.0
Yes
 
boolean supportsGroupByUnrelated()
1.0
Yes
 
boolean supportsIntegrityEnhancementFacility()
1.0
Yes
 
boolean supportsLikeEscapeClause()
1.0
Yes
 
boolean supportsLimitedOuterJoins()
1.0
Yes
 
boolean supportsMinimumSQLGrammar()
1.0
Yes
 
boolean supportsMixedCaseIdentifiers()
1.0
Yes
 
boolean supportsMixedCaseQuotedIdentifiers()
1.0
Yes
 
boolean supportsMultipleOpenResults()
3.0
Yes
 
boolean supportsMultipleResultSets()
1.0
Yes
 
boolean supportsMultipleTransactions()
1.0
Yes
 
boolean supportsNamedParameters()
3.0
Yes
 
boolean supportsNonNullableColumns()
1.0
Yes
 
boolean supportsOpenCursorsAcrossCommit()
1.0
Yes
 
boolean supportsOpenCursorsAcrossRollback()
1.0
Yes
 
boolean supportsOpenStatementsAcrossCommit()
1.0
Yes
 
boolean supportsOpenStatementsAcrossRollback()
1.0
Yes
 
boolean supportsOrderByUnrelated()
1.0
Yes
 
boolean supportsOuterJoins()
1.0
Yes
 
boolean supportsPositionedDelete()
1.0
Yes
 
boolean supportsPositionedUpdate()
1.0
Yes
 
boolean supportsResultSetConcurrency(int, int)
2.0 Core
Yes
 
boolean supportsResultSetHoldability(int)
3.0
Yes
 
boolean supportsResultSetType(int)
2.0 Core
Yes
 
boolean supportsSavePoints()
3.0
Yes
 
boolean supportsSchemasInDataManipulation()
1.0
Yes
 
boolean supportsSchemasInIndexDefinitions()
1.0
Yes
 
boolean supportsSchemasInPrivilegeDefinitions()
1.0
Yes
 
boolean supportsSchemasInProcedureCalls()
1.0
Yes
 
boolean supportsSchemasInTableDefinitions()
1.0
Yes
 
boolean supportsSelectForUpdate()
1.0
Yes
 
boolean supportsStoredFunctionsUsingCallSyntax()
4.0
Yes
 
boolean supportsStoredProcedures()
1.0
Yes
 
boolean supportsSubqueriesInComparisons()
1.0
Yes
 
boolean supportsSubqueriesInExists()
1.0
Yes
 
boolean supportsSubqueriesInIns()
1.0
Yes
 
boolean supportsSubqueriesInQuantifieds()
1.0
Yes
 
boolean supportsTableCorrelationNames()
1.0
Yes
 
boolean supportsTransactionIsolationLevel(int)
1.0
Yes
 
boolean supportsTransactions()
1.0
Yes
 
boolean supportsUnion()
1.0
Yes
 
boolean supportsUnionAll()
1.0
Yes
 
<T> T unwrap(Class<T> iface)
4.0
Yes
 
boolean updatesAreDetected(int)
2.0 Core
Yes
 
boolean usesLocalFilePerTable()
1.0
Yes
 
boolean usesLocalFiles()
1.0
Yes