com.ibm.websphere.proxyds.helper
Class OracleProxyDSDataStoreHelper

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

public class OracleProxyDSDataStoreHelper
extends com.ibm.websphere.rsadapter.OracleDataStoreHelper

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

Field Summary
 
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
OracleProxyDSDataStoreHelper(java.util.Properties props)
          This OracleProxyDSDataStoreHelper constructor creates a new OracleProxyDSDataStoreHelper 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.OracleDataStoreHelper
doStatementCleanup, findMappingClass, getIsolationLevel, getLockType, getResultSetConcurrency, getXAExceptionContents, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, modifyXAFlag, showLockInfo
 
Methods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanupPerCloseConnection, doConnectionSetup, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getMetaData, getPrintWriter, getResultSetType, isConnectionError, mapException, setUserDefinedMap
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OracleProxyDSDataStoreHelper

public OracleProxyDSDataStoreHelper(java.util.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(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