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-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 CodeSQL StatePortableSQLException subclass
230StaleConnectionException.class
2627DuplicateKeyException.class
6002StaleConnectionException.class
  • Field Details

    • RESOURCE_TYPES

      public static final String[] RESOURCE_TYPES
      Deprecated.
    • LOCK_REQUEST_STATUSES

      public static final String[] LOCK_REQUEST_STATUSES
      Deprecated.
    • LOCK_OWNER_TPYES

      public static final String[] LOCK_OWNER_TPYES
      Deprecated.
    • LOCK_REQUEST_MODES

      public static final String[] LOCK_REQUEST_MODES
      Deprecated.
  • Constructor Details

    • MSSQLDataStoreHelper

      public MSSQLDataStoreHelper(Properties props)
      Deprecated.
      This MSSQLDataStoreHelper constructor creates a new MSSQLDataStoreHelper 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 Details

    • findMappingClass

      public final Class findMappingClass(SQLException e)
      Deprecated.

      This method locates the com.ibm.websphere.ce.cm.PortableSQLException subclass corresponding to the specified SQLException, as defined by the MSSQLDataStoreHelper, GenericDataStoreHelper, and user-defined SQLException maps. Precedence and related details of SQLException mapping are described on the DataStoreHelper.setUserDefinedMap method.

      Overrides:
      findMappingClass in class GenericDataStoreHelper
      Parameters:
      e - The SQLException for which to locate a com.ibm.websphere.ce.cm.PortableSQLException subclass.
      Returns:
      The com.ibm.websphere.ce.cm.PortableSQLException subclass matching the SQLException, 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 interface DataStoreHelper
      Overrides:
      getIsolationLevel in class GenericDataStoreHelper
      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 interface DataStoreHelper
      Overrides:
      getResultSetType in class GenericDataStoreHelper
      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 interface DataStoreHelper
      Overrides:
      getResultSetConcurrency in class GenericDataStoreHelper
      Throws:
      javax.resource.NotSupportedException
      javax.resource.ResourceException
    • showLockInfo

      public final String showLockInfo(Properties props) throws Exception
      Deprecated.

      This method returns lock information for Microsoft SQL Server. The props parameter can include the following properties:

      1. user - user name that has a DBA authority. If not specified, a default value of "sa" is used.
      2. password - the password corresponding to the user name. If not specified, a default value of "" (empty string) is used.
      3. serverName - the server name where the Microsoft SQL Server database resides.
      4. portNumber - the port where Microsoft SQL Server is listening.
      Overrides:
      showLockInfo in class GenericDataStoreHelper
      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.