com.ibm.websphere.rsadapter

Interface JDBCConnectionSpec

All Superinterfaces:
javax.resource.cci.ConnectionSpec, WSConnectionSpec

  1. public interface JDBCConnectionSpec
  2. 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
  1. int
getTransactionIsolation()
Get the transaction isolation level.
  1. 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

  1. int getTransactionIsolation()
Get the transaction isolation level.
Returns:
the java.sql.Connection transaction isolation constant for the isolation level.

setTransactionIsolation

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