Class 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 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.
        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 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 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.
      • 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:

        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:
        java.lang.Exception - if an error occurs while collecting the lock information.