com.ibm.websphere.rsadapter

Class OracleDataStoreHelper

java.lang.Object

com.ibm.websphere.rsadapter.GenericDataStoreHelper

com.ibm.websphere.rsadapter.OracleDataStoreHelper

All Implemented Interfaces:

DataStoreHelper

Direct Known Subclasses:

Oracle10gDataStoreHelper

Deprecated.

This class will be removed in a future release. Do not use this class. If you have additional requirements on Oracle you should consider subclassing Oracle11gDataStoreHelper.

@Deprecated
public class OracleDataStoreHelper
extends GenericDataStoreHelper

Field Summary

Fields inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper

customDefinedWasDefaultIsoLevel, defaultQueryTimeout, EOLN, genErrorMap, resBundle, tranErrorList

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, INFORMIX_JCC_HELPER, MSSQL_HELPER, ORACLE_10G_HELPER, ORACLE_11G_HELPER, ORACLE_HELPER, POTENTIAL_DEADLOCK, POTENTIAL_LOST_UPDATE, PROXY_DS_HELPER, SEQUELINK_HELPER, SUBJECT, SYBASE_HELPER, SYBASE11_HELPER, TX_REPEATABLE_READ_FORUPDATE, TX_SERIALIZABLE_FORUPDATE, UNDEFINED_HELPER, UNDEFINED_ISOLATOIN_LEVEL, UPDATE_ON_READONLY

Constructor Summary

Constructors

Constructor and Description
OracleDataStoreHelper(java.util.Properties props) Deprecated. Do not use this class.

Method Summary

Methods

Modifier and Type	Method and Description
boolean	doConnectionCleanup(java.sql.Connection conn) Deprecated. Do not use methods in this class.
boolean	doConnectionCleanupWithValidCheck(java.sql.Connection conn) Deprecated.
void	doStatementCleanup(java.sql.PreparedStatement stmt) Deprecated. Do not use methods in this class.
java.lang.Class	findMappingClass(java.sql.SQLException e) Deprecated. Do not use methods in this class.
int	getIsolationLevel(AccessIntent intent) Deprecated. Do not use methods in this class.
int	getLockType(AccessIntent intent) Deprecated. Do not use methods in this class.
int	getResultSetConcurrency(AccessIntent intent) Deprecated. Do not use methods in this class.
java.lang.String	getXAExceptionContents(javax.transaction.xa.XAException xae) Deprecated. Do not use methods in this class.
java.lang.String	hasLostUpdateOrDeadLockOccurred(int isoLevel, boolean loadedForUpdate) Deprecated. Do not use methods in this class.
boolean	isBatchUpdateSupportedWithAccessIntent(AccessIntent accessIntent) Deprecated. Do not use methods in this class.
int	modifyXAFlag(int xaflag) Deprecated. Do not use methods in this class.
java.lang.String	showLockInfo(java.util.Properties props) Deprecated. Do not use methods in this class.

Methods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper

calcPartitionNumber, doConnectionCleanupPerCloseConnection, doConnectionSetup, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getMetaData, getPasswordForUseWithTrustedContextWithAuthentication, getPrintWriter, getResultSetType, isConnectionError, isDuplicateKey, isTransientConnectionError, mapException, setConfig, setUserDefinedMap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OracleDataStoreHelper

@Deprecated
public OracleDataStoreHelper(java.util.Properties props)

Deprecated. Do not use this class.

See Oracle11gDataStoreHelper.

Method Detail

doStatementCleanup

@Deprecated
public void doStatementCleanup(java.sql.PreparedStatement stmt)
                        throws java.sql.SQLException

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

doStatementCleanup in interface DataStoreHelper

Overrides:

doStatementCleanup in class GenericDataStoreHelper

Parameters:

stmt - the PreparedStatement.

Throws:

java.sql.SQLException - if an error occurs cleaning up the statement.

doConnectionCleanup

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

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

doConnectionCleanup in interface DataStoreHelper

Overrides:

doConnectionCleanup in class 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.

doConnectionCleanupWithValidCheck

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

Deprecated.

Specified by:

doConnectionCleanupWithValidCheck in interface DataStoreHelper

Overrides:

doConnectionCleanupWithValidCheck in class GenericDataStoreHelper

Throws:

java.sql.SQLException

findMappingClass

@Deprecated
public java.lang.Class findMappingClass(java.sql.SQLException e)

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Overrides:

findMappingClass in class GenericDataStoreHelper

Parameters:

e - The SQLException for which to locate a com.ibm.websphere.ce.cm.PortableSQLException subclass.

Returns:

The com.ibm.websphere.ce.cm.PortableSQLException subclass matching the SQLException, or null if no match was found.

getIsolationLevel

@Deprecated
public int getIsolationLevel(AccessIntent intent)
                      throws javax.resource.ResourceException

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

getIsolationLevel in interface DataStoreHelper

Overrides:

getIsolationLevel in class GenericDataStoreHelper

Parameters:

intent - An AccessIntent

Returns:

A transaction isolation level appropriate for the specified AccessIntent.

Throws:

javax.resource.ResourceException - If a transaction isolation level cannot be determined from the AccessIntent.

getResultSetConcurrency

@Deprecated
public int getResultSetConcurrency(AccessIntent intent)
                            throws javax.resource.ResourceException

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

getResultSetConcurrency in interface DataStoreHelper

Overrides:

getResultSetConcurrency in class GenericDataStoreHelper

Parameters:

intent - An AccessIntent.

Returns:

A result set concurrency constant defined on java.sql.ResultSet.

Throws:

javax.resource.ResourceException - If a result set concurrency cannot be determined from the AccessIntent.

hasLostUpdateOrDeadLockOccurred

@Deprecated
public java.lang.String hasLostUpdateOrDeadLockOccurred(int isoLevel,
                                                          boolean loadedForUpdate)

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

hasLostUpdateOrDeadLockOccurred in interface DataStoreHelper

Overrides:

hasLostUpdateOrDeadLockOccurred in class GenericDataStoreHelper

Parameters:

isoLevel - the transaction isolation level used.

loadedForUpdate - true if the CMP EntityBean was loaded for update (eg. FOR UPDATE keywords used on SELECT), otherwise false.

Returns:

One of the following

1. DataStoreHelper.POTENTIAL_LOST_UPDATE
2. DataStoreHelper.UPDATE_ON_READONLY
3. DataStoreHelper.POTENTIAL_DEADLOCK

showLockInfo

@Deprecated
public java.lang.String showLockInfo(java.util.Properties props)
                              throws java.lang.Exception

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Overrides:

showLockInfo in class GenericDataStoreHelper

Parameters:

props - properties containing information needed to connect to the database.

Returns:

the lock information.

Throws:

java.lang.Exception - if an error occurs while collecting the lock information.

getLockType

@Deprecated
public int getLockType(AccessIntent intent)

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

getLockType in interface DataStoreHelper

Overrides:

getLockType in class GenericDataStoreHelper

Parameters:

intent - An AccessIntent

Returns:

the lock type constant. Valid values are defined in com.ibm.websphere.rsadapter.WSInteractionSpec:

• LOCKTYPE_SELECT
• LOCKTYPE_SELECT_FOR_UPDATE
• LOCKTYPE_SELECT_FOR_UPDATE_WITH_RS
• LOCKTYPE_SELECT_FOR_UPDATE_WITH_RR

getXAExceptionContents

@Deprecated
public java.lang.String getXAExceptionContents(javax.transaction.xa.XAException xae)

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

getXAExceptionContents in interface DataStoreHelper

Overrides:

getXAExceptionContents in class GenericDataStoreHelper

Parameters:

xae - the XAException.

Returns:

detailed information about the XAException, for inclusion in a WebSphere trace.

modifyXAFlag

@Deprecated
public int modifyXAFlag(int xaflag)

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

modifyXAFlag in interface DataStoreHelper

Overrides:

modifyXAFlag in class GenericDataStoreHelper

Parameters:

xaflag - The XA start flag to modify.

Returns:

The modified XA start flag.

isBatchUpdateSupportedWithAccessIntent

@Deprecated
public boolean isBatchUpdateSupportedWithAccessIntent(AccessIntent accessIntent)

Deprecated. Do not use methods in this class.

See Oracle11gDataStoreHelper.

Specified by:

isBatchUpdateSupportedWithAccessIntent in interface DataStoreHelper

Overrides:

isBatchUpdateSupportedWithAccessIntent in class GenericDataStoreHelper

Parameters:

accessIntent - AccessIntent

Returns:

boolean true if batching is allowed with the given AccessIntent, otherwise false.