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 Salesforce, Oracle Service Cloud, and MongoDB do not support storing or retrieving client information.

ResultSet getColumnPrivileges(String, String, String, String)

1.0

Yes

Not supported by the driver for Impala or Apache Hive.

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 Salesforce, Oracle Service Cloud, and MongoDB return an empty result set.

Not supported by the driver for Impala or Apache Hive.

ResultSet getFunctionColumns()

4.0

Yes

The drivers for Salesforce, Oracle Service Cloud, and MongoDB return an empty result set.

Not supported by the driver for Impala or Apache Hive.

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 Salesforce and Oracle Service Cloud, SchemaName and ProcedureName must be explicit values; they cannot be patterns.

The MongoDB driver returns an empty result set.

Not supported for the driver for Impala or Apache Hive.

ResultSet getProcedures(String, String, String)

1.0

Yes

Not supported for the driver for Impala or Apache Hive. 

The MongoDB driver returns an empty result set.

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 driver for Impala or Apache Hive. 

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