Connection Methods Version Introduced Supported Comments
void abort(Executor) 4.1 Yes Only the Oracle and SQL Server drivers support this method.
void clearWarnings() 1.0 Yes
void close() 1.0 Yes When a connection is closed while a transaction is still active, that transaction is rolled back.
void commit() 1.0 Yes  
Blob createBlob() 4.0 Yes
Clob createClob() 4.0 Yes
NClob createNClob() 4.0 Yes
createArrayOf(String, Object[]) 4.0 Yes Only the Oracle driver supports this method.
createStruct(String, Object[]) 4.0 Yes Only the Oracle driver supports this method.
SQLXML createSQLXML() 4.0 Yes
Statement createStatement() 1.0 Yes  
Statement createStatement(int, int) 2.0 Core Yes For the Db2 driver, ResultSet.TYPE_SCROLL_SENSITIVE is downgraded to TYPE_SCROLL_INSENSITIVE.

For the Autonomous REST Connector and the drivers for Aha!, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity, be aware that scroll-sensitive result sets are expensive from both a Web service call and a performance perspective. The drivers expend a network round trip for each row that is fetched.
Statement createStatement(int, int, int) 3.0 No With the exception of the Db2 driver, the specified holdability must match the database default holdability. Otherwise, an "unsupported method" exception is thrown.

For the Db2 driver, the method can be called regardless of whether the specified holdability matches the database default holdability.
Struct createStruct(String, Object[]) 1.0 Yes Supported for the Oracle driver only.

All other drivers throw "unsupported method" exception.
boolean getAutoCommit() 1.0 Yes  
String getCatalog() 1.0 Yes The Autonomous REST Connector and the drivers for the listed database systems return an empty string because they do not have the concept of a catalog: Aha!, Amazon Redshift, Apache Cassandra, Apache Hive, Apache Spark SQL, Denodo, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, Greenplum, HubSpot, Jira, Apache Impala, MongoDB, Oracle, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, PostgreSQL, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity.
String getClientInfo() 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity do not support storing or retrieving client information.
String getClientInfo(String) 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity do not support storing or retrieving client information.
int getHoldability() 3.0 Yes  
DatabaseMetaData getMetaData() 1.0 Yes  
int getTransactionIsolation() 1.0 Yes  
Map getTypeMap() 2.0 Core Yes Always returns empty java.util.HashMap.
SQLWarning getWarnings() 1.0 Yes  
boolean isClosed() 1.0 Yes  
boolean isReadOnly() 1.0 Yes  
boolean isValid() 4.0 Yes
boolean isWrapperFor(Class<?> iface) 4.0 Yes
String nativeSQL(String) 1.0 Yes Always returns the same String that was passed in from the application.
CallableStatement prepareCall(String) 1.0 Yes  
CallableStatement prepareCall(String, int, int) 2.0 Core Yes For the Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Db2, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, ResultSet.TYPE_SCROLL_ SENSITIVE is downgraded to TYPE_SCROLL_INSENSITIVE.
CallableStatement prepareCall(String, int, int, int) 3.0 Yes

The Db2 driver allows this method whether or not the specified holdability is the same as the default holdability.

The other drivers throw the exception "Changing the default holdability is not supported" when the specified holdability does not match the default holdability.
PreparedStatement prepareStatement (String) 1.0 Yes  
PreparedStatement prepareStatement (String, int) 3.0 Yes  
PreparedStatement prepareStatement (String, int, int) 2.0 Core Yes For the Db2 driver, ResultSet.TYPE_SCROLL_ SENSITIVE is downgraded to TYPE_SCROLL_INSENSITIVE.

For The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity, be aware that scroll-sensitive result sets are expensive from both a Web service call and a performance perspective. The drivers expend a network round trip for each row that is fetched.
PreparedStatement prepareStatement (String, int, int, int) 3.0 No All drivers throw "unsupported method" exception.
PreparedStatement prepareStatement (String, int[]) 3.0 Yes Supported for the Oracle and SQL Server drivers.

All other drivers throw "unsupported method" exception.
PreparedStatement prepareStatement (String, String []) 3.0 Yes Supported for the SQL Server driver only.

All other drivers throw "unsupported method" exception.
void releaseSavepoint(Savepoint) 3.0 Yes

The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Db2, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity throw an "unsupported method" exception.
void rollback() 1.0 Yes  
void rollback(Savepoint) 3.0 Yes The Db2 driver only supports with Db2 V8.x for i.

The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity throw an "unsupported method" exception.
void setAutoCommit(boolean) 1.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Apache Hive, Apache Spark SQL, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Apache Impala, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity throw "transactions not supported" exception if set to false.
void setCatalog(String) 1.0 Yes The Autonomous REST Connector and the drivers for the listed database systems ignore any value set by the String argument. The corresponding drivers return an empty string because they do not have the concept of a catalog: Aha!, Amazon Redshift, Apache Cassandra, Apache Hive, Apache Spark SQL, Denodo, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, Greenplum, HubSpot, Apache Impala, Jira, MongoDB, Oracle, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, PostgreSQL, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity.
String setClientInfo(Properties) 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity do not support storing or retrieving client information.
String setClientInfo(String, String) 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity do not support storing or retrieving client information.
void setHoldability(int) 3.0 Yes The Db2 driver supports the Holdability parameter value.

For other drivers, the Holdability parameter value is ignored.
void setReadOnly(boolean) 1.0 Yes  
Savepoint setSavepoint() 3.0 Yes

The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Db2 (multiple nested savepoints are supported only for Db2 for Linux/UNIX/Windows), Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity throw an "unsupported method" exception.
Savepoint setSavepoint(String) 3.0 Yes

The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Db2 (multiple nested savepoints are supported only for Db2 for Linux/UNIX/Windows), Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity throw an "unsupported method" exception.
void setTransactionIsolation(int) 1.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Apache Hive, Apache Spark SQL, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Apache Impala, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity ignore any specified transaction isolation level.
void setTypeMap(Map) 2.0 Core Yes The drivers ignore this connection method.
<T> T unwrap(Class<T> iface) 4.0 Yes