skip to main content
JDBC Support : Supported Functionality : Connection
  
Connection
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 Salesforce driver, be aware that scroll-sensitive result sets are expensive from both a Web service call and a performance perspective. The driver expends a network round trip for each row that is fetched.
Statement createStatement(int, int, int)
3.0
No
Throws "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
Because Oracle, PostgreSQL, Apache Hive, Greenplum, and Salesforce do not have the concept of a catalog, these drivers return an empty string.
String getClientInfo()
4.0
Yes
The Salesforce driver does not support storing or retrieving client information. Refer to "Advanced Features" in the DataDirect Connect Series for JDBC User’s Guide for more information.
String getClientInfo(String)
4.0
Yes
The Salesforce driver does not support storing or retrieving client information. Refer to "Advanced Features" in the DataDirect Connect Series for JDBC User’s Guide for more 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 DB2 and Salesforce drivers, ResultSet.TYPE_SCROLL_ SENSITIVE is downgraded to TYPE_SCROLL_INSENSITIVE.
CallableStatement prepareCall(String, int, int, int)
3.0
No
Throws "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 Salesforce driver, be aware that scroll-sensitive result sets are expensive from both a Web service call and a performance perspective. The driver expends 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 Salesforce driver throws "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 Salesforce driver throws "unsupported method" exception.
void setAutoCommit(boolean)
1.0
Yes
The drivers for Apache Hive and Salesforce throw "transactions not supported" exception if set to false. Refer to "TransactionModeBehavior" in the corresponding driver section of the DataDirect Connect Series for JDBC User’s Guide for more information.
void setCatalog(String)
1.0
Yes
Because Oracle, PostgreSQL, Apache Hive, Greenplum, and Salesforce do not have the concept of a catalog, these drivers ignore any value set by the String argument.
String setClientInfo(Properties)
4.0
Yes
The Salesforce driver does not support storing or retrieving client information. Refer to "Advanced Features" in the DataDirect Connect Series for JDBC User’s Guide for more information.
String setClientInfo(String, String)
4.0
Yes
The Salesforce driver does not support storing or retrieving client information. Refer to "Advanced Features" in the DataDirect Connect Series for JDBC User’s Guide for more 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 Salesforce driver throws "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 Salesforce driver throws "unsupported method" exception.
void setTransactionIsolation(int)
1.0
Yes
The drivers fo Apache Hive 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