JDBCConnectionSpec (IBM WebSphere Application Server, Release 8.5)

Skip navigation links

IBM WebSphere Application Server^TM
Release 8.5

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

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

Methods
Modifier and Type	Method and Description
`int`	`getTransactionIsolation()` Get the transaction isolation level.
`void`	`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.