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.
Please use the ConnectJDBCDataStoreHelper instead.
MSSQLDataStoreHelper is used internally by other built-in
DataStoreHelper implementations. Do not subclass this class. Do not
configure any DataSources to use this DataStoreHelper directly.
Note: This class and its methods can not be called or referenced directly by user applications.
SQLException mappings specific to the MSSQLDataStoreHelper
are the following:
| Error Code | SQL State | PortableSQLException subclass |
|---|---|---|
| 230 | StaleConnectionException.class | |
| 2627 | DuplicateKeyException.class | |
| 6002 | StaleConnectionException.class |
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final String[]Deprecated.static final String[]Deprecated.static final String[]Deprecated.static final String[]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
ConstructorsConstructorDescriptionMSSQLDataStoreHelper(Properties props) Deprecated.ThisMSSQLDataStoreHelperconstructor creates a newMSSQLDataStoreHelperbased on theDataStoreHelperproperties provided. -
Method Summary
Modifier and TypeMethodDescriptionfinal ClassDeprecated.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.final StringshowLockInfo(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 Details
-
RESOURCE_TYPES
Deprecated. -
LOCK_REQUEST_STATUSES
Deprecated. -
LOCK_OWNER_TPYES
Deprecated. -
LOCK_REQUEST_MODES
Deprecated.
-
-
Constructor Details
-
MSSQLDataStoreHelper
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 Details
-
findMappingClass
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
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
Deprecated.This method should not be invoked.- Specified by:
getResultSetTypein interfaceDataStoreHelper- Overrides:
getResultSetTypein classGenericDataStoreHelper- Throws:
javax.resource.NotSupportedExceptionjavax.resource.ResourceException
-
getResultSetConcurrency
Deprecated.This method should not be invoked.- Specified by:
getResultSetConcurrencyin interfaceDataStoreHelper- Overrides:
getResultSetConcurrencyin classGenericDataStoreHelper- Throws:
javax.resource.NotSupportedExceptionjavax.resource.ResourceException
-
showLockInfo
Deprecated.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:
Exception- if an error occurs while collecting the lock information.
-