IBM Support

IC76342: ARRAYINDEXOUTOFBOUNDSEXCEPTION ON STATEMENT.COMPLETEEXECUTECALL WHEN CALLING PL/SQL STORED PROCEDURE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Users Affected:
    This problem affects customer using DB2 9.7 in Oracle
    Compatability Mode, using JDBC to call PL/SQL stored procedures.
    
    Error Description:
    If a PL/SQL stored procedure returns one or more cursors in OUT
    parameters, and if one or more of these cursors are returned
    conditionally, the following exception may occur if a cursor is
    not returned:
    
    java.lang.ArrayIndexOutOfBoundsException: <parameter>
        at com.ibm.db2.jcc.am.km.a(km.java:2123)
        at com.ibm.db2.jcc.t4.db.l(db.java:607)
        at com.ibm.db2.jcc.t4.db.k(db.java:333)
        at com.ibm.db2.jcc.t4.db.e(db.java:96)
        at com.ibm.db2.jcc.t4.t.e(t.java:81)
        at com.ibm.db2.jcc.t4.sb.j(sb.java:160)
        at com.ibm.db2.jcc.am.km.hb(km.java:2113)
        at com.ibm.db2.jcc.am.lm.b(lm.java:3589)
        at com.ibm.db2.jcc.am.mm.Yb(mm.java:113)
        at com.ibm.db2.jcc.am.mm.execute(mm.java:96)
        ...
    
    This exception may occur only if the application is using
    application-manages prepared statement cache.
    
    Conclusion:
    
    For a callable Statement, if the procedure name and signature
    match, the application will get the Callable Statement from the
    cache. However, the driver was erroneously treating the
    procedure name, signature and the identifier of the
    previously-returned result set, as matching.
    

Local fix

  • Disabling statement cache should circumvent this problem.
    

Problem summary

  • First fixed in JDBC driver from DB2 9.7 Fix Pack 5 (JCC driver
    version 3.63.75)
    

Problem conclusion

  • Upgrade to JDBC driver from DB2 9.7 Fix Pack 5 (JCC driver
    version 3.63.75)
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76342

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-05-12

  • Closed date

    2017-05-19

  • Last modified date

    2017-05-19

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]

Document Information

Modified date:
18 September 2021