com.ibm.websphere.rsadapter

Class Sybase11DataStoreHelper

  1. java.lang.Object
  2. extended bycom.ibm.websphere.rsadapter.GenericDataStoreHelper
  3. extended bycom.ibm.websphere.rsadapter.SybaseDataStoreHelper
  4. extended bycom.ibm.websphere.rsadapter.Sybase11DataStoreHelper
All implemented interfaces:
DataStoreHelper

  1. public class Sybase11DataStoreHelper
  2. 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

Constructor and Description
Sybase11DataStoreHelper(java.util.Properties props)
This Sybase11DataStoreHelper constructor creates a new Sybase11DataStoreHelper based on the DataStoreHelper properties provided.

Method Summary

Modifier and Type Method and Description
  1. int
getIsolationLevel(AccessIntent aIntent)
This method determines the transaction isolation level based on the specified AccessIntent.
  1. 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
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Sybase11DataStoreHelper

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

  1. public int getIsolationLevel(AccessIntent aIntent)
  2. 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:
Overrides:
Parameters:
aIntent - 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

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