|
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
|
|