IBM WebSphere Application ServerTM
Release 8

com.ibm.websphere.rsadapter
Class Sybase11DataStoreHelper

java.lang.Object
  extended by com.ibm.websphere.rsadapter.GenericDataStoreHelper
      extended by com.ibm.websphere.rsadapter.SybaseDataStoreHelper
          extended by com.ibm.websphere.rsadapter.Sybase11DataStoreHelper
All Implemented Interfaces:
DataStoreHelper

public class Sybase11DataStoreHelper
extends SybaseDataStoreHelper

Sybase11DataStoreHelper is a DataStoreHelper implementation customized for Sybase 11.9.2. It allows for plugging in function specific to Sybase 11.9.2. When mapping a SQLException, the SQLException mappings from the SybaseDataStoreHelper are searched first, and subsequently, if no match is found, the SQLException mappings from the GenericDataStoreHelper are searched. If you have additional requirements on Sybase 11.9.2, you should consider subclassing this implementation.
Note: This class and its methods can not be called or referenced directly by user applications.

Since:
WAS 5.0.1

Field Summary
 
Fields inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
customDefinedWasDefaultIsoLevel, defaultQueryTimeout, EOLN, genErrorMap, resBundle, tranErrorList
 
Fields inherited from interface com.ibm.websphere.rsadapter.DataStoreHelper
CLOUDSCAPE_HELPER, CLOUDSCAPE_NETWORK_SERVER_HELPER, CONNECTJDBC_HELPER, CUSTOM_HELPER, DATADIRECT_HELPER, DB2_390_HELPER, DB2_390_LOCAL_HELPER, DB2_400_HELPER, DB2_HELPER, DB2_UNIVERSAL_HELPER, DERBY_HELPER, DERBY_NETWORK_SERVER_HELPER, FIRST_TIME_CALLED, GENERIC_HELPER, INFORMIX_HELPER, INFORMIX_JCC_HELPER, MSSQL_HELPER, ORACLE_10G_HELPER, ORACLE_11G_HELPER, ORACLE_HELPER, POTENTIAL_DEADLOCK, POTENTIAL_LOST_UPDATE, PROXY_DS_HELPER, SEQUELINK_HELPER, SUBJECT, SYBASE_HELPER, SYBASE11_HELPER, TX_REPEATABLE_READ_FORUPDATE, TX_SERIALIZABLE_FORUPDATE, UNDEFINED_HELPER, UNDEFINED_ISOLATOIN_LEVEL, UPDATE_ON_READONLY
 
Constructor Summary
Sybase11DataStoreHelper(java.util.Properties props)
          This Sybase11DataStoreHelper constructor creates a new Sybase11DataStoreHelper based on the DataStoreHelper properties provided.
 
Method Summary
 int getIsolationLevel(AccessIntent aIntent)
          This method determines the transaction isolation level based on the specified AccessIntent.
 int getLockType(AccessIntent intent)
          This method returns a lock type constant based on the update hint value of the specified AccessIntent.
 
Methods inherited from class com.ibm.websphere.rsadapter.SybaseDataStoreHelper
doConnectionCleanup, doConnectionSetup, doStatementCleanup, findMappingClass, getPrintWriter, setUserDefinedMap, showLockInfo
 
Methods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanupPerCloseConnection, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getMetaData, getPasswordForUseWithTrustedContextWithAuthentication, getResultSetConcurrency, getResultSetType, getXAExceptionContents, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, isConnectionError, isDuplicateKey, isTransientConnectionError, mapException, modifyXAFlag, setConfig
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Sybase11DataStoreHelper

public Sybase11DataStoreHelper(java.util.Properties props)
This Sybase11DataStoreHelper constructor creates a new Sybase11DataStoreHelper based on the DataStoreHelper properties provided. All implementations inheriting from a data store helper must supply this same list of properties to their super class by invoking the constructor of their super class with the list of properties.

Parameters:
props - DataStoreHelper properties.
Method Detail

getIsolationLevel

public int getIsolationLevel(AccessIntent aIntent)
                      throws javax.resource.ResourceException
This method determines the transaction isolation level based on the specified AccessIntent. If the AccessIntent parameter is null, a default value should be returned that is appropriate for the database backend.

For Sybase 11, java.sql.Connection.TRANSACTION_READ_COMMITTED is returned in all cases, except when the AccessIntent is AccessIntent.PESSIMISTIC_UPDATE_LOCK_HINT_EXCLUSIVE, in which case java.sql.Connection.TRANSACTION_SERIALIZABLE is returned.

Specified by:
getIsolationLevel in interface DataStoreHelper
Overrides:
getIsolationLevel in class SybaseDataStoreHelper
Parameters:
intent - An AccessIntent
Returns:
A transaction isolation level appropriate for the specified AccessIntent.
Throws:
javax.resource.ResourceException - If a transaction isolation level cannot be determined from the AccessIntent.
See Also:
AccessIntent, Connection

getLockType

public int getLockType(AccessIntent intent)

This method returns a lock type constant based on the update hint value of the specified AccessIntent. The lock type is used by the persistence manager to determine which locking hints are used on a SELECT statement.

Specified by:
getLockType in interface DataStoreHelper
Overrides:
getLockType in class GenericDataStoreHelper
Parameters:
intent - An AccessIntent
Returns:
the lock type constant. Valid values are defined in com.ibm.websphere.rsadapter.WSInteractionSpec:
  • LOCKTYPE_SELECT
  • LOCKTYPE_SELECT_FOR_UPDATE
See Also:
AccessIntent, WSInteractionSpec

IBM WebSphere Application ServerTM
Release 8