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
 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, getPassword, getTypeMap, getUserName, isReadOnly, setCatalog, setPassword, setReadOnly, setTypeMap, setUserName
 

Method Detail

getTransactionIsolation

public int getTransactionIsolation()
Get the transaction isolation level.

Returns:
the java.sql.Connection transaction isolation constant for the isolation level.

setTransactionIsolation

public 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
  • MSSQLServer/ConnectJDBC: REPEATABLE READ
  • MSSQLServer/SequeLink: REPEATABLE READ
  • Oracle: READ COMMITTED
  • Sybase: REPEATABLE READ
  • Unsupported databases: READ COMMITTED

Parameters:
isolationLevel - the isolation level.

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.