com.ibm.websphere.rsadapter

Class CloudscapeNetworkServerDataStoreHelper

  1. java.lang.Object
  2. extended bycom.ibm.websphere.rsadapter.GenericDataStoreHelper
  3. extended bycom.ibm.websphere.rsadapter.CloudscapeDataStoreHelper
  4. extended bycom.ibm.websphere.rsadapter.CloudscapeNetworkServerDataStoreHelper
All implemented interfaces:
DataStoreHelper

Deprecated. use com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
  1. public class CloudscapeNetworkServerDataStoreHelper
  2. extends CloudscapeDataStoreHelper
CloudscapeNetworkServerDataStoreHelper is a DataStoreHelper implementation customized for the Cloudscape database when running using the Cloudscape NetworkServer framework. When mapping a SQLException, the SQLException mappings from the CloudscapeNetworkServerDataStoreHelper and CloudscapeDataStoreHelper are searched first, and subsequently, if no match is found, the SQLException mappings from the GenericDataStoreHelper are searched. If you have additional requirements on Cloudscape you should consider subclassing this implementation.
Note: This class and its methods can not be called or referenced directly by user applications.

SQLException mappings specific to the CloudscapeNetworkServerDataStoreHelper are the following:

Error CodeSQL StatePortableSQLException subclass
-4499StaleConnectionException.class
Since:
WAS 5.0.2

Field Summary

Fields inherited from class com.ibm.websphere.rsadapter.CloudscapeDataStoreHelper
db2jErrorMap, db2jTc
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

Constructor and Description
CloudscapeNetworkServerDataStoreHelper(java.util.Properties props)
Deprecated. This CloudscapeNetworkServerDataStoreHelper constructor creates a new CloudscapeNetworkServerDataStoreHelper based on the DataStoreHelper properties provided.

Method Summary

Modifier and Type Method and Description
  1. void
doStatementCleanup(java.sql.PreparedStatement stmt)
Deprecated. This method cleans up a statement before the statement is returned to the statement cache.
Methods inherited from class com.ibm.websphere.rsadapter.CloudscapeDataStoreHelper
findMappingClass, getIsolationLevel, getResultSetConcurrency, setUserDefinedMap, showLockInfo
Methods inherited from class com.ibm.websphere.rsadapter.GenericDataStoreHelper
calcPartitionNumber, doConnectionCleanup, doConnectionCleanupPerCloseConnection, doConnectionSetup, doConnectionSetupPerGetConnection, doConnectionSetupPerTransaction, getLockType, getMetaData, getPasswordForUseWithTrustedContextWithAuthentication, getPrintWriter, getResultSetType, getXAExceptionContents, hasLostUpdateOrDeadLockOccurred, isBatchUpdateSupportedWithAccessIntent, isConnectionError, isDuplicateKey, isTransientConnectionError, mapException, modifyXAFlag
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CloudscapeNetworkServerDataStoreHelper

  1. public CloudscapeNetworkServerDataStoreHelper( java.util.Properties props)
Deprecated.
This CloudscapeNetworkServerDataStoreHelper constructor creates a new CloudscapeNetworkServerDataStoreHelper based on the DataStoreHelper properties provided. All implementations inheriting from a data store helper must supply this same list of properties to their super class by invoking the constructor of their super class with the list of properties.
Parameters:
props - DataStoreHelper properties.

Method Detail

doStatementCleanup

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

This method cleans up a statement before the statement is returned to the statement cache. This method is called only for statements that will be cached. It is called only if at least one of the following statement properties has changed,

  • cursorName
  • fetchDirection
  • maxFieldSize
  • maxRows
  • queryTimeout

CloudscapeDataStoreHelper resets all of the statement properties listed above except for the queryTimeout property.

The following operations do not need to be included in the statement cleanup since they are automatically performed by WebSphere when caching statements,

  • setFetchSize(0)
  • clearParameters()
  • clearWarnings()

A helper class implementing this method may choose to do additional cleanup for the statement. However, this should never include closing the statement, since the statement is intended to be cached.

Specified by:
Overrides:
Parameters:
stmt - the PreparedStatement.
Throws:
java.sql.SQLException - if an error occurs cleaning up the statement.