|
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 will 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 Salesforce and Oracle Service Cloud, 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
|
The drivers throw an "unsupported method" exception.
|
|
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: Oracle, PostgreSQL, Apache Hive, Impala, Greenplum, Salesforce, Oracle Service Cloud, MongoDB, and Amazon Redshift.
|
|
String getClientInfo()
|
4.0
|
Yes
|
The drivers for Salesforce, Oracle Service Cloud, and MongoDB do not support storing or retrieving client information.
|
|
String getClientInfo(String)
|
4.0
|
Yes
|
The drivers for Salesforce, Oracle Service Cloud, and MongoDB 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 DB2, Salesforce, Oracle Service Cloud, and MongoDB, ResultSet.TYPE_SCROLL_ SENSITIVE is downgraded to TYPE_SCROLL_INSENSITIVE.
|
|
CallableStatement prepareCall(String, int, int, int)
|
3.0
|
No
|
The drivers throw "unsupported method" exception.
|
|
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 Salesforce, Oracle Service Cloud, and MongoDB, 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 Salesforce, Oracle Service Cloud, and MongoDB 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 and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
The drivers for Salesforce, Oracle Service Cloud, and MongoDB throw an "unsupported method" exception.
|
|
void setAutoCommit(boolean)
|
1.0
|
Yes
|
The drivers for Apache Hive, Impala, Salesforce, Oracle Service Cloud, and MongoDB 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: Oracle, PostgreSQL, Apache Hive, Impala, Greenplum, Salesforce, Oracle Service Cloud, MongoDB, and Amazon Redshift.
|
|
String setClientInfo(Properties)
|
4.0
|
Yes
|
The drivers for Salesforce, Oracle Service Cloud, and MongoDB do not support storing or retrieving client information.
|
|
String setClientInfo(String, String)
|
4.0
|
Yes
|
The drivers for Salesforce, Oracle Service Cloud, and MongoDB do not support storing or retrieving client information.
|
|
void setHoldability(int)
|
3.0
|
Yes
|
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 Salesforce, Oracle Service Cloud, and MongoDB 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 Salesforce, Oracle Service Cloud, and MongoDB throw an "unsupported method" exception.
|
|
void setTransactionIsolation(int)
|
1.0
|
Yes
|
The drivers for Apache Hive, Impala, Salesforce, Oracle Service Cloud, and MongoDB 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
|