Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Connection Object

  • Last Updated: May 12, 2026
  • 2 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

 Connection Method  Version Introduced  Supported  Comments
void clearWarnings () 1.0 Yes
void close () 1.0 Yes When a connection is closed while there is an active transaction, 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 Throws “unsupported method” exception.
createStruct(String, Object[]) 4.0 No Throws “unsupported method” exception.
SQLXML createSQLXML() 4.0 Yes  
SQLWarning getWarnings () 1.0 Yes
Statement createStatement () 1.0 Yes
Statement createStatement (int, int) 2.0 Core Yes The supported values for resultSetConcurrency depend on the data store you are connected to.
Statement createStatement (int, int, int) 3.0 No OpenAccess SDK only supports fixed Holdability values per RDBMS
boolean getAutoCommit () 1.0 Yes  
String getCatalog () 1.0 Yes Support is database-specific.
String getClientInfo() 4.0 Yes  
String getClientInfo(String) 4.0 Yes  
int getHoldability () 3.0 Yes OpenAccess SDK only supports fixed Holdability values per RDBMS
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 same String as passed in.
CallableStatement prepareCall (String) 1.0 Yes  
CallableStatement prepareCall (String, int, int) 2.0 Core Yes The supported values for resultSetConcurrency depend on the data store you are connected to.
CallableStatement prepareCall (String, int, int, int) 3.0 No OpenAccess SDK only supports fixed Holdability values per RDBMS.
PreparedStatement prepareStatement (String) 1.0 Yes  
PreparedStatement prepareStatement (String, int) 3.0 No Throws “unsupported method” exception.
PreparedStatement prepareStatement (String, int[]) 3.0 No Throws “unsupported method” exception.
PreparedStatement prepareStatement (String, int, int) 2.0 Core Yes The supported values for resultSetType and resultSetConcurrency depend on the data store you are connected to.
PreparedStatement prepareStatement (String, int, int, int) 3.0 No OpenAccess SDK only supports fixed Holdability values per RDBMS.
PreparedStatement prepareStatement (String, String []) 3.0 No Throws “unsupported method” exception.
void releaseSavepoint (Savepoint) 3.0 Yes  
void rollback () 1.0 Yes  
void rollback (Savepoint) 3.0 Yes  
void setAutoCommit (boolean) 1.0 Yes  
void setCatalog (String) 1.0 Yes Switching of catalogs is supported if the OpenAccess SDK Server supports it.
String setClientInfo(Properties) 4.0 Yes  
String setClientInfo(String, String) 4.0 Yes  
void setHoldability (int) 3.0 No OpenAccess SDK only supports fixed Holdability values per RDBMS.
void setReadOnly (boolean) 1.0 Yes  
void setSavepoint () 3.0 Yes  
void setSavepoint (String) 3.0 Yes  
void setTransactionIsolation (int) 1.0 Yes  
void setTypeMap (Map) 2.0 Core Yes Ignored.
<T> T unwrap(Class<T> iface) 4.0 Yes  
TitleResults for “How to create a CRG?”Also Available inAlert