com.ibm.websphere.rsadapter
Interface JDBCConnectionSpec
All Superinterfaces:
javax.resource.cci.ConnectionSpec, WSConnectionSpec
- public interface JDBCConnectionSpec
- extends WSConnectionSpec
A ConnectionSpec interface provided for JDBC users to specify additional Connection properties on getConnection.
To make use of this functionality, the JDBC application must cast to WSDataSource as follows,
Connection conn = ((WSDataSource) ds).getConnection(jdbcConnectionSpec);
Method Summary
Modifier and Type | Method and Description |
---|---|
|
getTransactionIsolation()
Get the transaction isolation level.
|
|
setTransactionIsolation(int isolationLevel)
Set the transaction isolation level.
|
Methods inherited from interface com.ibm.websphere.rsadapter.WSConnectionSpec |
---|
getCatalog, getHoldability, getPassword, getTypeMap, getUserName, isReadOnly, setCatalog, setHoldability, setPassword, setReadOnly, setTypeMap, setUserName |
Method Detail
getTransactionIsolation
- int getTransactionIsolation()
Get the transaction isolation level.
Returns:
the java.sql.Connection transaction isolation constant for the isolation level.
setTransactionIsolation
- void setTransactionIsolation(int isolationLevel)
Set the transaction isolation level. Any isolation level constant from the java.sql.Connection interface can be used, provided the backend supports it.
If a value of TRANSACTION_NONE is specified, the value specified in the res-ref is used. If this value is also TRANSACTION_NONE or not specified, the WebSphere default isolation level specified in the DataStoreHelper is used.
The WebSphere default values are:- Cloudscape: REPEATABLE READ
- DB2: REPEATABLE READ
- DB2/AS400: REPEATABLE READ
- Informix: REPEATABLE READ
- Microsoft SQL Server: REPEATABLE READ
- Oracle: READ COMMITTED
- Sybase: REPEATABLE READ
- Unsupported databases: READ COMMITTED
Parameters:
isolationLevel
- the isolation level.