IBM Support

PI30983: PRINT DATASOURCE NAME WHEN PRINTING JDBC DRIVER INFO

Fixes are available

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.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
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.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
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.45: Java SDK 1.6 SR16 FP60 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
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • With this defect, a new message is added that would print the
    Datasource name along with the JDBC driver information.
    Currently only the JDBC driver information is printed for a
    getConnection() call as in
    
    [12/5/1415:45:49:881 IST] 00000061 InternalGener I   DSRA8203I:
    Database product name : DB2/LINUXX8664
    [12/5/14 15:45:49:891 IST] 00000061 InternalGener I
    DSRA8204I: Database product version : SQL09057
    [12/5/14 15:45:49:891 IST] 00000061
    InternalGener I   DSRA8205I: JDBC driver name  : IBM Data
    Server Driver for JDBC and SQLJ
    [12/5/14 15:45:49:891 IST]
    00000061 InternalGener I   DSRA8206I: JDBC driver version  :
    4.7.85
    [12/5/14 15:45:49:891 IST] 00000061 InternalGener I
    DSRA8218I: JDBC driver specification level  : 4.0
    
    However with this defect, a new message is added that would
    append the DataSource name as well along with the message.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Print Data source name when printing    *
    *                      JDBC driver information. This will      *
    *                      help easily identify the datasource     *
    *                      that is using the correct JDBC          *
    *                      driver.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    For a getConnection() call, the following jdbc driver
    information was logged
    DSRA8203I: Database product name : DB2/NT
    DSRA8204I: Database product version : SQL09078
    DSRA8205I: JDBC driver name  : IBM DB2 JDBC Universal Driver
    Architecture
    DSRA8206I: JDBC driver version  : 3.64.114
    DSRA8212I: DataStoreHelper name is:
    com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@63f063f0
    DSRA8208I: JDBC driver type  : 4
    This does not provide the datasource information, typically the
    datasource jndiName, hence it is not clear for which datasource
    the jdbc driver information is logged.
    

Problem conclusion

  • Code has been modified to prepend the datasource jndiName
    along with the jdbc driver information. With this fix, a
    message similar to this should be logged.
    DSRA8225I: DataSource JNDI name : jdbc/TestLtcDS
    
    The fix for this APAR is currently targeted for inclusion in
    fix packs 7.0.0.37, 8.0.0.10 and 8.5.5.5.  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

    PI30983

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-12-05

  • Closed date

    2015-02-03

  • Last modified date

    2015-02-03

  • 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

  • R850 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PI30983

Modified date: 03 February 2015