Package com.ibm.websphere.rsadapter
Class MSSQLDataStoreHelper
- java.lang.Object
-
- com.ibm.websphere.rsadapter.GenericDataStoreHelper
-
- com.ibm.websphere.rsadapter.MSSQLDataStoreHelper
-
- All Implemented Interfaces:
DataStoreHelper
@Deprecated public class MSSQLDataStoreHelper extends GenericDataStoreHelper
Deprecated.Please use the ConnectJDBCDataStoreHelper instead.MSSQLDataStoreHelperis used internally by other built-inDataStoreHelperimplementations. Do not subclass this class. Do not configure any DataSources to use thisDataStoreHelperdirectly.
Note: This class and its methods can not be called or referenced directly by user applications.SQLExceptionmappings specific to theMSSQLDataStoreHelperare the following:Error Code SQL State PortableSQLExceptionsubclass230 StaleConnectionException.class2627 DuplicateKeyException.class6002 StaleConnectionException.class
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.String[]LOCK_OWNER_TPYESDeprecated.static java.lang.String[]LOCK_REQUEST_MODESDeprecated.static java.lang.String[]LOCK_REQUEST_STATUSESDeprecated.static java.lang.String[]RESOURCE_TYPESDeprecated.-
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
Constructors Constructor Description MSSQLDataStoreHelper(java.util.Properties props)Deprecated.ThisMSSQLDataStoreHelperconstructor creates a newMSSQLDataStoreHelperbased on theDataStoreHelperproperties provided.
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description java.lang.ClassfindMappingClass(java.sql.SQLException e)Deprecated.This method locates thecom.ibm.websphere.ce.cm.PortableSQLExceptionsubclass corresponding to the specifiedSQLException, as defined by theMSSQLDataStoreHelper,GenericDataStoreHelper, and user-definedSQLExceptionmaps.intgetIsolationLevel(AccessIntent intent)Deprecated.This method should not be invoked.intgetResultSetConcurrency(AccessIntent intent)Deprecated.This method should not be invoked.intgetResultSetType(AccessIntent intent)Deprecated.This method should not be invoked.java.lang.StringshowLockInfo(java.util.Properties props)Deprecated.This method returns lock information for Microsoft SQL Server.-
Methods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanup, doConnectionCleanupPerCloseConnection, doConnectionCleanupWithValidCheck, doConnectionSetup, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, doStatementCleanup, getLockType, getMetaData, getPasswordForUseWithTrustedContextWithAuthentication, getPrintWriter, getXAExceptionContents, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, isConnectionError, isDuplicateKey, isTransientConnectionError, isUnsupported, mapException, modifyXAFlag, setConfig, setUserDefinedMap
-
-
-
-
Field Detail
-
RESOURCE_TYPES
public static final java.lang.String[] RESOURCE_TYPES
Deprecated.
-
LOCK_REQUEST_STATUSES
public static final java.lang.String[] LOCK_REQUEST_STATUSES
Deprecated.
-
LOCK_OWNER_TPYES
public static final java.lang.String[] LOCK_OWNER_TPYES
Deprecated.
-
LOCK_REQUEST_MODES
public static final java.lang.String[] LOCK_REQUEST_MODES
Deprecated.
-
-
Constructor Detail
-
MSSQLDataStoreHelper
public MSSQLDataStoreHelper(java.util.Properties props)
Deprecated.ThisMSSQLDataStoreHelperconstructor creates a newMSSQLDataStoreHelperbased on theDataStoreHelperproperties 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-DataStoreHelperproperties.
-
-
Method Detail
-
findMappingClass
public final java.lang.Class findMappingClass(java.sql.SQLException e)
Deprecated.This method locates the
com.ibm.websphere.ce.cm.PortableSQLExceptionsubclass corresponding to the specifiedSQLException, as defined by theMSSQLDataStoreHelper,GenericDataStoreHelper, and user-definedSQLExceptionmaps. Precedence and related details ofSQLExceptionmapping are described on theDataStoreHelper.setUserDefinedMapmethod.- Overrides:
findMappingClassin classGenericDataStoreHelper- Parameters:
e- TheSQLExceptionfor which to locate acom.ibm.websphere.ce.cm.PortableSQLExceptionsubclass.- Returns:
- The
com.ibm.websphere.ce.cm.PortableSQLExceptionsubclass matching theSQLException, or null if no match was found.
-
getIsolationLevel
public int getIsolationLevel(AccessIntent intent) throws javax.resource.ResourceException
Deprecated.This method should not be invoked.- Specified by:
getIsolationLevelin interfaceDataStoreHelper- Overrides:
getIsolationLevelin classGenericDataStoreHelper- Parameters:
intent- always null in Liberty.- Returns:
- A transaction isolation level appropriate for the specified database.
- Throws:
javax.resource.NotSupportedExceptionjavax.resource.ResourceException- If a transaction isolation level cannot be determined.
-
getResultSetType
public int getResultSetType(AccessIntent intent) throws javax.resource.ResourceException
Deprecated.This method should not be invoked.- Specified by:
getResultSetTypein interfaceDataStoreHelper- Overrides:
getResultSetTypein classGenericDataStoreHelper- Throws:
javax.resource.NotSupportedExceptionjavax.resource.ResourceException
-
getResultSetConcurrency
public int getResultSetConcurrency(AccessIntent intent) throws javax.resource.ResourceException
Deprecated.This method should not be invoked.- Specified by:
getResultSetConcurrencyin interfaceDataStoreHelper- Overrides:
getResultSetConcurrencyin classGenericDataStoreHelper- Throws:
javax.resource.NotSupportedExceptionjavax.resource.ResourceException
-
showLockInfo
public final java.lang.String showLockInfo(java.util.Properties props) throws java.lang.ExceptionDeprecated.This method returns lock information for Microsoft SQL Server. The
propsparameter can include the following properties:- user - user name that has a DBA authority. If not specified, a default value of "sa" is used.
- password - the password corresponding to the user name. If not specified, a default value of "" (empty string) is used.
- serverName - the server name where the Microsoft SQL Server database resides.
- portNumber - the port where Microsoft SQL Server is listening.
- Overrides:
showLockInfoin classGenericDataStoreHelper- Parameters:
props- properties containing information needed to connect to the database.- Returns:
- the lock information.
- Throws:
java.lang.Exception- if an error occurs while collecting the lock information.
-
-