IBM WebSphere Extended Deployment (XD)TM
Release 6.0

com.ibm.websphere.proxyds.helper
OracleProxyDSDataStoreHelper

java.lang.Object

  |
  +--com.ibm.websphere.rsadapter.GenericDataStoreHelper

        |
        +--com.ibm.websphere.rsadapter.OracleDataStoreHelper

              |
              +--      com.ibm.websphere.proxyds.helper.OracleProxyDSDataStoreHelper



OracleProxyDSDataStoreHelper is a DataStoreHelper implementation customized for using proxy datasource with Oracle databases. When users use the proxy datasource to connect to Oracle datasources, this DataStore Helper has to be used.
See Also:
     OracleDataStoreHelper


Inherited Fields

Fields inherited from com.ibm.websphere.rsadapter.GenericDataStoreHelper
customDefinedWasDefaultIsoLevel, EOLN, genErrorMap, resBundle
Fields inherited from 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, 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
OracleProxyDSDataStoreHelper(java.util.Properties)
           This OracleProxyDSDataStoreHelper constructor creates a new OracleProxyDSDataStoreHelper based on the DataStoreHelper properties provided.


Method Summary
public  booleandoConnectionCleanup(java.sql.Connection)
          

This method is used to clean up a connection before it is returned to the connection pool for later reuse.

Inherited Methods

Methods inherited from com.ibm.websphere.rsadapter.OracleDataStoreHelper
doStatementCleanup, findMappingClass, getIsolationLevel, getLockType, getResultSetConcurrency, getXAExceptionContents, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, modifyXAFlag, showLockInfo
Methods inherited from com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanupPerCloseConnection, doConnectionSetup, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getMetaData, getPrintWriter, getResultSetType, isConnectionError, mapException, setUserDefinedMap
Methods inherited from java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OracleProxyDSDataStoreHelper

public OracleProxyDSDataStoreHelper( Properties props)
This OracleProxyDSDataStoreHelper constructor creates a new OracleProxyDSDataStoreHelper 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(Connection conn)

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.


See Also:
     Connection
Parameters:
    conn - the connection to attempt to cleanup.


Returns:
     true if any standard connection property was modified, otherwise false.


Throws:
SQLException


IBM WebSphere Extended Deployment (XD)TM
Release 6.0