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 |