IBM Support

IT26612: A REFERENCE TO A STALE JDBC CONNECTION IN THE CONNECTION POOL ISNOT BEING RESET

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

  • A long running JDBC Connection in the JDBC Connection Pool has
    been dereferenced, but the JDBC transaction handler has not
    cleaned it out correctly.
    
    The JDBC transaction handler is returning a null
    java.sql.Connection
    
    object to the getJDBCType4Connection() API call in a Java
    Compute node.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of App Connect Enterprise version 11 and IBM
    Integration Bus version 10 using JDBC Type 4 Connections
    
    
    Platforms affected:
    MultiPlatform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    For long running connections, where a JDBC connection has been
    invalidated due to idle processing it is possible for the Java
    API call <span style="background-color:rgb(255, 255,
    255)">getJDBCType4Connection() </span> to return a null
    connection. This may result in a NullPointerException in user
    Java Code.
    

Problem conclusion

  • The <span style="background-color:rgb(255, 255,
    255)">getJDBCType4Connection() </span>function no longer returns
    a null connection under these circumstances.
    
    ---------------------------------------------------------------
    The fix is targeted for delivery in the following PTFs:
    
    Version    Maintenance Level
    v10.0      10.0.0.23
    v11.0      11.0.0.12
    
    The latest available maintenance can be obtained from:
    http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
    
    If the maintenance level is not yet available,information on
    its planned availability can be found on:
    http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
    ---------------------------------------------------------------
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26612

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0540

  • Reported release

    A00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-25

  • Closed date

    2021-03-23

  • Last modified date

    2021-03-23

  • 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

    INTEGRATION BUS

  • Fixed component ID

    5724J0540

Applicable component levels

[{"Line of Business":{"code":"LOB36","label":"IBM Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0"}]

Document Information

Modified date:
24 March 2021