Class MicrosoftSQLServerDataStoreHelper
- All Implemented Interfaces:
DataStoreHelper
MicrosoftSQLServerDataStoreHelper is provided as an implementation of
the DataStoreHelper interface 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.
SQLException mappings specific to the
MicrosoftSQLServerDataStoreHelper 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[]static final String[]static final String[]static final String[]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
ConstructorsConstructorDescriptionThisMicrosoftSQLServerDataStoreHelperconstructor creates a newMicrosoftSQLServerDataStoreHelperbased on theDataStoreHelperproperties provided. -
Method Summary
Modifier and TypeMethodDescriptionvoidThis 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.final StringshowLockInfo(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 Details
-
RESOURCE_TYPES
-
LOCK_REQUEST_STATUSES
-
LOCK_OWNER_TPYES
-
LOCK_REQUEST_MODES
-
-
Constructor Details
-
MicrosoftSQLServerDataStoreHelper
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 Details
-
doStatementCleanup
This 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:
SQLException- if an error occurs cleaning up the statement.
-
getIsolationLevel
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
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.
-