IBM Support

PI98542: ERROR IN PRETEST SQL STRING MAY RESULT IN UNHANDLED OPEN CONNECTIONS TO DB SERVER

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • If there's some issue with the preTestSQLString, whenever the
    application requests a connection, an error will be returned
    and application cannot get any valid connection, and there
    might be large number of unhandled open connections to DB
    server established when doing preTest connections.
    

Local fix

  • Correct the SQL error
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server data sources                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: Connection leak after sucessfully       *
    *                      obtaining connection if unable to       *
    *                      initialize it.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    If a connection is sucessfully obtained but an error occurs
    trying to initialize it (for example, if Connection.getSchema
    fails), the connection is leaked.
    

Problem conclusion

  • Code has been updated to trap for errors during initialization
    and ensure that connection are properly closed out, so as to
    avoid connection leaks.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pack 9.0.0.9.  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

    PI98542

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-05-30

  • Closed date

    2018-06-08

  • Last modified date

    2018-06-08

  • 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



Document information

More support for: WebSphere Application Server
General

Software version: 900

Reference #: PI98542

Modified date: 08 June 2018


Translate this page: