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.MSSQLDataStoreHelper
is used internally by other built-inDataStoreHelper
implementations. Do not subclass this class. Do not configure any DataSources to use thisDataStoreHelper
directly.
Note: This class and its methods can not be called or referenced directly by user applications.SQLException
mappings specific to theMSSQLDataStoreHelper
are the following:Error Code SQL State PortableSQLException
subclass230 StaleConnectionException.class
2627 DuplicateKeyException.class
6002 StaleConnectionException.class
-
-
Field Summary
Fields Modifier and Type Field Description static java.lang.String[]
LOCK_OWNER_TPYES
Deprecated.static java.lang.String[]
LOCK_REQUEST_MODES
Deprecated.static java.lang.String[]
LOCK_REQUEST_STATUSES
Deprecated.static java.lang.String[]
RESOURCE_TYPES
Deprecated.-
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.ThisMSSQLDataStoreHelper
constructor creates a newMSSQLDataStoreHelper
based on theDataStoreHelper
properties provided.
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description java.lang.Class
findMappingClass(java.sql.SQLException e)
Deprecated.This method locates thecom.ibm.websphere.ce.cm.PortableSQLException
subclass corresponding to the specifiedSQLException
, as defined by theMSSQLDataStoreHelper
,GenericDataStoreHelper
, and user-definedSQLException
maps.int
getIsolationLevel(AccessIntent intent)
Deprecated.This method should not be invoked.int
getResultSetConcurrency(AccessIntent intent)
Deprecated.This method should not be invoked.int
getResultSetType(AccessIntent intent)
Deprecated.This method should not be invoked.java.lang.String
showLockInfo(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.ThisMSSQLDataStoreHelper
constructor creates a newMSSQLDataStoreHelper
based on theDataStoreHelper
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
-
findMappingClass
public final java.lang.Class findMappingClass(java.sql.SQLException e)
Deprecated.This method locates the
com.ibm.websphere.ce.cm.PortableSQLException
subclass corresponding to the specifiedSQLException
, as defined by theMSSQLDataStoreHelper
,GenericDataStoreHelper
, and user-definedSQLException
maps. Precedence and related details ofSQLException
mapping are described on theDataStoreHelper.setUserDefinedMap
method.- Overrides:
findMappingClass
in classGenericDataStoreHelper
- Parameters:
e
- TheSQLException
for which to locate acom.ibm.websphere.ce.cm.PortableSQLException
subclass.- Returns:
- The
com.ibm.websphere.ce.cm.PortableSQLException
subclass 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:
getIsolationLevel
in interfaceDataStoreHelper
- Overrides:
getIsolationLevel
in classGenericDataStoreHelper
- Parameters:
intent
- always null in Liberty.- Returns:
- A transaction isolation level appropriate for the specified database.
- Throws:
javax.resource.NotSupportedException
javax.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:
getResultSetType
in interfaceDataStoreHelper
- Overrides:
getResultSetType
in classGenericDataStoreHelper
- Throws:
javax.resource.NotSupportedException
javax.resource.ResourceException
-
getResultSetConcurrency
public int getResultSetConcurrency(AccessIntent intent) throws javax.resource.ResourceException
Deprecated.This method should not be invoked.- Specified by:
getResultSetConcurrency
in interfaceDataStoreHelper
- Overrides:
getResultSetConcurrency
in classGenericDataStoreHelper
- Throws:
javax.resource.NotSupportedException
javax.resource.ResourceException
-
showLockInfo
public final java.lang.String showLockInfo(java.util.Properties props) throws java.lang.Exception
Deprecated.This method returns lock information for Microsoft SQL Server. The
props
parameter 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:
showLockInfo
in 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.
-
-