Package com.ibm.websphere.rsadapter
Class DB2UniversalDataStoreHelper
java.lang.Object
com.ibm.websphere.rsadapter.GenericDataStoreHelper
com.ibm.websphere.rsadapter.DB2DataStoreHelper
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
- All Implemented Interfaces:
DataStoreHelper
- Direct Known Subclasses:
InformixJccDataStoreHelper
DB2UniversalDataStoreHelper is a DataStoreHelper implementation
customized for the DB2 Universal JDBC driver.
When mapping a SQLException, the SQLException mappings from the
DB2UniversalDataStoreHelper are searched first. If no match is found, the
SQLException mappings from the DB2DataStoreHelper
are searched. If still no match is found, the SQLException mappings from the
GenericDataStoreHelper are searched.
If you have additional requirements on DB2 you should consider subclassing this
implementation.
Note: This class and its methods can not be called or referenced directly by user applications.
SQLException mappings specific to the DB2UniversalDataStoreHelper
are the following:
| Error Code | SQL State | PortableSQLException subclass |
|---|---|---|
| -4498 | StaleConnectionException.class | |
| -4499 | StaleConnectionException.class | |
| -1776 | StaleConnectionException.class |
-
Field Summary
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
ConstructorsConstructorDescriptionThisDB2UniversalDataStoreHelperconstructor creates a newDB2UniversalDataStoreHelperbased on theDataStoreHelperproperties provided. -
Method Summary
Modifier and TypeMethodDescriptionvoidThis method cleans up a statement before the statement is returned to the statement cache.final intThis method returns the driverType which is defined for the DB2 Universal JDBC driver.This method is used to obtain the log writer to set on theDataSourcewhen database logging is enabled (for example:WAS.database=all=enabled).Methods inherited from class com.ibm.websphere.rsadapter.DB2DataStoreHelper
doConnectionSetup, findMappingClass, getIsolationLevel, getLockType, getXAExceptionContents, setUserDefinedMap, showLockInfoMethods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanup, doConnectionCleanupPerCloseConnection, doConnectionCleanupWithValidCheck, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getMetaData, getPasswordForUseWithTrustedContextWithAuthentication, getResultSetConcurrency, getResultSetType, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, isConnectionError, isDuplicateKey, isTransientConnectionError, isUnsupported, mapException, modifyXAFlag, setConfig
-
Constructor Details
-
DB2UniversalDataStoreHelper
ThisDB2UniversalDataStoreHelperconstructor creates a newDB2UniversalDataStoreHelperbased 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
-
getPrintWriter
This method is used to obtain the log writer to set on theDataSourcewhen database logging is enabled (for example:WAS.database=all=enabled). By default, null is returned and ajava.io.PrintWriterinstance created by WebSphere is used. You can override this method to return a differentjava.io.PrintWriterinstance instead of the default.- Specified by:
getPrintWriterin interfaceDataStoreHelper- Overrides:
getPrintWriterin classDB2DataStoreHelper- Returns:
java.io.PrintWriter.
-
getDriverType
public final int getDriverType()This method returns the driverType which is defined for the DB2 Universal JDBC driver.- Returns:
- driverType - possible value : 2 , 4
-
doStatementCleanup
This method cleans up a statement before the statement is returned to the statement cache. This method is called only for statements being cached. It is called when at least one of the following statement properties has changed,
- cursorName
- fetchDirection
- maxFieldSize
- maxRows
- queryTimeout
DB2DataStoreHelperresets all of the statement properties listed aboveThe following operations do not need to be included in the statement cleanup since they are automatically performed by WebSphere when caching statements:
setFetchSize(0)clearParameters()clearWarnings()
A helper class implementing this method can choose to do additional cleanup for the statement. However, this must never include closing the statement, since the statement is intended to be cached.
- Specified by:
doStatementCleanupin interfaceDataStoreHelper- Overrides:
doStatementCleanupin classDB2DataStoreHelper- Parameters:
stmt- the PreparedStatement.- Throws:
SQLException- if an error occurs cleaning up the statement.
-