com.ibm.websphere.proxyds.helper
Class DB2ProxyDSDataStoreHelper

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

public class DB2ProxyDSDataStoreHelper
extends com.ibm.websphere.rsadapter.DB2DataStoreHelper

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

See Also:
DB2DataStoreHelper

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_11G_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
DB2ProxyDSDataStoreHelper(java.util.Properties props)
          This DB2ProxyDSDataStoreHelper constructor creates a new DB2ProxyDSDataStoreHelper 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.DB2DataStoreHelper
doConnectionSetup, doStatementCleanup, findMappingClass, getIsolationLevel, getLockType, getPrintWriter, getResultSetConcurrency, getXAExceptionContents, isBatchUpdateSupportedWithAccessIntent, 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

DB2ProxyDSDataStoreHelper

public DB2ProxyDSDataStoreHelper(java.util.Properties props)
This DB2ProxyDSDataStoreHelper constructor creates a new DB2ProxyDSDataStoreHelper 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.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