com.ibm.websphere.proxyds.helper
Class DB2AS400ProxyDSDataStoreHelper

java.lang.Object
  extended by com.ibm.websphere.rsadapter.GenericDataStoreHelper
      extended by com.ibm.websphere.rsadapter.DB2DataStoreHelper
          extended by com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
              extended by com.ibm.websphere.proxyds.helper.DB2AS400ProxyDSDataStoreHelper
All Implemented Interfaces:
com.ibm.websphere.rsadapter.DataStoreHelper

public class DB2AS400ProxyDSDataStoreHelper
extends com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

DB2AS400ProxyDSDataStoreHelper is a DataStoreHelper implementation customized for using proxy datasource with DB2 on iSeries. When users use the proxy datasource to connect to datasources from DB2 on iSeries, this DataStore Helper has to be used.

See Also:
DB2AS400DataStoreHelper

Field Summary
 
Fields inherited from class com.ibm.websphere.rsadapter.DB2DataStoreHelper
db2Tc
 
Fields inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
customDefinedWasDefaultIsoLevel, EOLN, genErrorMap, resBundle
 
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, MSSQL_HELPER, ORACLE_10G_HELPER, ORACLE_HELPER, POTENTIAL_DEADLOCK, POTENTIAL_LOST_UPDATE, PROXY_DS_HELPER, SEQUELINK_HELPER, SYBASE_HELPER, SYBASE11_HELPER, TX_REPEATABLE_READ_FORUPDATE, TX_SERIALIZABLE_FORUPDATE, UNDEFINED_HELPER, UNDEFINED_ISOLATOIN_LEVEL, UPDATE_ON_READONLY, WSCONNECTJDBC_HELPER
 
Constructor Summary
DB2AS400ProxyDSDataStoreHelper(java.util.Properties props)
          This DB2AS400ProxyDSDataStoreHelper constructor creates a new DB2AS400ProxyDSDataStoreHelper based on the DataStoreHelper properties provided.
 
Method Summary
 boolean doConnectionCleanup(java.sql.Connection conn)
          This method is used to clean up a connection before it is returned to the connection pool for later reuse.
 
Methods inherited from class com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
doStatementCleanup, isBatchUpdateSupportedWithAccessIntent
 
Methods inherited from class com.ibm.websphere.rsadapter.DB2DataStoreHelper
doConnectionSetup, findMappingClass, getIsolationLevel, getLockType, getPrintWriter, getResultSetConcurrency, getXAExceptionContents, setUserDefinedMap, showLockInfo
 
Methods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanupPerCloseConnection, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getMetaData, getResultSetType, hasLostUpdateOrDeadLockOccurred, isConnectionError, mapException, modifyXAFlag
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

DB2AS400ProxyDSDataStoreHelper

public DB2AS400ProxyDSDataStoreHelper(java.util.Properties props)
This DB2AS400ProxyDSDataStoreHelper constructor creates a new DB2AS400ProxyDSDataStoreHelper based on the DataStoreHelper properties provided. The properties parameter is provided only for future extensibility and is currently unused.

Parameters:
props - DataStoreHelper properties.
Method Detail

doConnectionCleanup

public boolean doConnectionCleanup(java.sql.Connection conn)
                            throws java.sql.SQLException

This method is used to clean up a connection before it is returned to the connection pool for later reuse. WebSphere automatically resets all standard connection properties (fields for which getters and setters are defined on java.sql.Connection). This method may be used to reset other properties proprietary to a specific JDBC driver/database and do whatever else is necessary to prepare the connection for reuse.

A DataStoreHelper is permitted to use the provided connection to create and execute statements for the purpose of cleaning up the connection. Any statements created within the doConnectionCleanup method must be explicitly closed within the doConnectionCleanup method. The doConnectionCleanup method must never close the connection being cleaned up.

If any standard connection properties are modified in this method, a value of true must be returned, indicating to WebSphere that at least one standard connection property was modified. A value of false is returned only if no standard connection properties were modified.

GenericDataStoreHelper does not perform any connection cleanup.

Specified by:
doConnectionCleanup in interface com.ibm.websphere.rsadapter.DataStoreHelper
Overrides:
doConnectionCleanup in class com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Parameters:
conn - the connection to attempt to cleanup.
Returns:
true if any standard connection property was modified, otherwise false.
Throws:
java.sql.SQLException - If an error occurs while cleaning up the connection.
See Also:
Connection