com.ibm.websphere.proxyds.helper
Class DB2UniversalProxyDSDataStoreHelper

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

public class DB2UniversalProxyDSDataStoreHelper
extends com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper

DB2UniversalProxyDSDataStoreHelper is a DataStoreHelper implementation customized for using proxy datasource with the DB2 Universal JDBC driver. When users use the proxy datasource to connect to datasources from DB2 Universal JDBC driver, this DataStore Helper has to be used.

See Also:
DB2UniversalDataStoreHelper

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
DB2UniversalProxyDSDataStoreHelper(java.util.Properties props)
          This DB2UniversalProxyDSDataStoreHelper constructor creates a new DB2UniversalProxyDSDataStoreHelper 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.DB2UniversalDataStoreHelper
getDriverType, getPrintWriter, isBatchUpdateSupportedWithAccessIntent
 
Methods inherited from class com.ibm.websphere.rsadapter.DB2DataStoreHelper
doConnectionSetup, doStatementCleanup, findMappingClass, getIsolationLevel, getLockType, 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

DB2UniversalProxyDSDataStoreHelper

public DB2UniversalProxyDSDataStoreHelper(java.util.Properties props)
This DB2UniversalProxyDSDataStoreHelper constructor creates a new DB2UniversalProxyDSDataStoreHelper based on the DataStoreHelper properties provided.

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.GenericDataStoreHelper
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