IBM Support

PM39845: CLASSNOTFOUNDEXCEPTION FOR ORACLE11GDATASTOREHELPER

Fixes are available

7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21
8.0.0.2: WebSphere Application Server V8.0 Fix Pack 2
8.0.0.3: WebSphere Application Server V8.0 Fix Pack 3
7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23
8.0.0.4: WebSphere Application Server V8.0 Fix Pack 4
7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25
8.0.0.5: WebSphere Application Server V8.0 Fix Pack 5
7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
8.0.0.6: WebSphere Application Server V8.0 Fix Pack 6
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
8.0.0.7: WebSphere Application Server V8.0 Fix Pack 7
8.0.0.8: WebSphere Application Server V8.0 Fix Pack 8
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
8.0.0.9: WebSphere Application Server V8.0 Fix Pack 9
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
8.0.0.10: WebSphere Application Server V8.0 Fix Pack 10
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
7.0.0.21: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere
7.0.0.23: Java SDK 1.6 SR10 FP1 Cumulative Fix for WebSphere
7.0.0.25: Java SDK 1.6 SR11 Cumulative Fix for WebSphere Application Server
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Even after configuring the datasource to use
    
    Oracle11gDataStoreHelper for Oracle 11g JDBC driver, the
    SystemOut.log contains the following warning message due to a
    ClassNotFoundException that can be noticed in the FFDC logs.
    
    [3/24/11 13:38:01:414 EDT] 00000017 InternalOracl W DSRA7041W:
    You must use the Oracle11gDataStoreHelper class or a subclass of
    that data store helper when you configure a data source to use
    this JDBC driver: Oracle 11g JDBC driver
    
    [3/24/11 13:38:01:416 EDT] FFDC
    Exception:java.lang.ClassNotFoundException
    SourceId:com.ibm.ws.rsadapter.AdapterUtil.isInstance
    ProbeId:1804
    java.lang.ClassNotFoundException:
    com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
    at java.lang.Class.forNameImpl(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at com.ibm.ws.rsadapter.AdapterUtil.isInstance
      (AdapterUtil.java:2415)
    at com.ibm.ws.rsadapter.spi.InternalOracleDataStoreHelper
       .gatherAndDisplayMetaDataInfo
       (InternalOracleDataStoreHelper.java:658)
    at com.ibm.ws.rsadapter.spi.WSRdbDataSource
       .postGetConnectionHandling(WSRdbDataSource.java:2536)
    at com.ibm.ws.rsadapter.spi.WSRdbDataSource
       .getConnection(WSRdbDataSource.java:2481)
    at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl
       .createManagedConnection
       (WSManagedConnectionFactoryImpl.java:1606)
    
    
    This happens to Oracle helper class only.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V7.0 and V8.0                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Incorrect warning message "DSRA7041W"   *
    *                      is printed in the logs due to           *
    *                      ClassNotFoundException                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When there are getConnection() requests during the server
    startup, for postGetConnectionHandling we attempt to determine
    whether the right external datastore helper class has been
    configured for the Oracle 11g datasource. We attempt to load
    the class Oracle11gDataStoreHelper using the current thread
    context classloader and it is here we get the
    ClassNotFoundException.  Due to this exception we print an
    incorrect warning message. "DSRA7041W: You must use the
    Oracle11gDataStoreHelper class..."
    

Problem conclusion

  • WebSphere database connectivity code has been updated to
    resolve the ClassNotFoundException.
    The fix for this APAR is currently targeted for inclusion in
    fix packs 7.0.0.21 & 8.0.0.2.  Please refer to the Recommended
    Updates page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM39845

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-24

  • Closed date

    2011-08-02

  • Last modified date

    2011-08-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R700 PSY

       UP

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
27 October 2021