|
Connection Methods
|
Version Introduced
|
Supported
|
Comments
|
|
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
|
No
|
The drivers throw an unsupported method exception.
|
|
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 drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, 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 drivers for the listed database systems return an empty string because they do not have the concept of a catalog: Amazon Redshift, Apache Cassandra, Apache Hive, Apache Spark SQL, Greenplum, Impala, MongoDB, Oracle, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, PostgreSQL, and Salesforce.
|
|
String getClientInfo()
|
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.
|
|
String getClientInfo(String)
|
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.
|
|
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 drivers for Apache Cassandra, DB2, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, 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 drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, 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 DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce 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 drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
|
|
void setAutoCommit(boolean)
|
1.0
|
Yes
|
The drivers for Apache Cassandra, Apache Hive, Apache Spark SQL, Impala, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw "transactions not supported" exception if set to false.
|
|
void setCatalog(String)
|
1.0
|
Yes
|
The driver 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: Amazon Redshift, Apache Cassandra, Apache Hive, Apache Spark SQL, Greenplum, Impala, MongoDB, Oracle, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, PostgreSQL, and Salesforce.
|
|
String setClientInfo(Properties)
|
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.
|
|
String setClientInfo(String, String)
|
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.
|
|
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 DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i. In addition, the DB2 driver only supports multiple nested savepoints for DB2 V8.2 and higher for Linux/UNIX/Windows.
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
|
|
Savepoint setSavepoint(String)
|
3.0
|
Yes
|
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i. In addition, the DB2 driver only supports multiple nested savepoints for DB2 V8.2 and higher for Linux/UNIX/Windows.
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
|
|
void setTransactionIsolation(int)
|
1.0
|
Yes
|
The drivers for Apache Cassandra, Apache Hive, Apache Spark SQL, Impala, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce 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
|