Class MicrosoftSQLServerDataStoreHelper
- java.lang.Object
-
- com.ibm.websphere.rsadapter.GenericDataStoreHelper
-
- com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper
-
- All Implemented Interfaces:
DataStoreHelper
public class MicrosoftSQLServerDataStoreHelper extends GenericDataStoreHelper
MicrosoftSQLServerDataStoreHelperis provided as an implementation of theDataStoreHelperinterface to enable connectivity to Microsoft SQL Server via the Microsoft SQL Server JDBC Driver. If you have additional requirements with the Microsoft SQL Server JDBC Driver or the Microsoft SQL Server database, you should consider subclassing this implementation.
Note: This class and its methods cannot be called or referenced directly by applications.SQLExceptionmappings specific to theMicrosoftSQLServerDataStoreHelperare 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_TPYESstatic java.lang.String[]LOCK_REQUEST_MODESstatic java.lang.String[]LOCK_REQUEST_STATUSESstatic java.lang.String[]RESOURCE_TYPES-
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 MicrosoftSQLServerDataStoreHelper(java.util.Properties props)ThisMicrosoftSQLServerDataStoreHelperconstructor creates a newMicrosoftSQLServerDataStoreHelperbased on theDataStoreHelperproperties provided.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description voiddoStatementCleanup(java.sql.PreparedStatement stmt)This method cleans up a statement before the statement is returned to the statement cache.intgetIsolationLevel(AccessIntent intent)This method determines the default transaction isolation level.java.lang.StringshowLockInfo(java.util.Properties props)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, findMappingClass, getLockType, getMetaData, getPasswordForUseWithTrustedContextWithAuthentication, getPrintWriter, getResultSetConcurrency, getResultSetType, getXAExceptionContents, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, isConnectionError, isDuplicateKey, isTransientConnectionError, isUnsupported, mapException, modifyXAFlag, setConfig, setUserDefinedMap
-
-
-
-
Field Detail
-
RESOURCE_TYPES
public static final java.lang.String[] RESOURCE_TYPES
-
LOCK_REQUEST_STATUSES
public static final java.lang.String[] LOCK_REQUEST_STATUSES
-
LOCK_OWNER_TPYES
public static final java.lang.String[] LOCK_OWNER_TPYES
-
LOCK_REQUEST_MODES
public static final java.lang.String[] LOCK_REQUEST_MODES
-
-
Constructor Detail
-
MicrosoftSQLServerDataStoreHelper
public MicrosoftSQLServerDataStoreHelper(java.util.Properties props)
ThisMicrosoftSQLServerDataStoreHelperconstructor creates a newMicrosoftSQLServerDataStoreHelperbased 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
-
doStatementCleanup
public void doStatementCleanup(java.sql.PreparedStatement stmt) throws java.sql.SQLExceptionThis method cleans up a statement before the statement is returned to the statement cache. This method is called only for statements that are cached. It is called only if at least one of the following statement properties has changed:
- cursorName
- fetchDirection
- maxFieldSize
- maxRows
- queryTimeout
- responseBuffering
MicrosoftSQLServerDataStoreHelperresets all of the properties listed above.The following operations do not need to be included in the statement cleanup since they are automatically performed by the application server when caching statements,
setFetchSize(0)clearParameters()clearWarnings()
A helper class implementing this method may choose to do additional cleanup for the statement. However, this should never include closing the statement, since the statement is intended to be cached.
- Specified by:
doStatementCleanupin interfaceDataStoreHelper- Overrides:
doStatementCleanupin classGenericDataStoreHelper- Parameters:
stmt- the PreparedStatement.- Throws:
java.sql.SQLException- if an error occurs cleaning up the statement.
-
getIsolationLevel
public int getIsolationLevel(AccessIntent intent) throws javax.resource.ResourceException
This method determines the default transaction isolation level. The default value for this data store helper isConnection.TRANSACTION_REPEATABLE_READ.- Specified by:
getIsolationLevelin interfaceDataStoreHelper- Overrides:
getIsolationLevelin classGenericDataStoreHelper- Parameters:
intent- always null in Liberty.- Returns:
- A transaction isolation level.
- Throws:
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.ExceptionThis 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.
-
-