IBM Support

IZ46835: AN INDEXOUTOFBOUNDS EXCEPTION MAY OCCUR ACCESSING OUT PARAMETERS RETURNED FROM A STORED PROCEDURE IF STATEMENT CACHE SIZE IS > 0.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An indexOutOfBounds exception may occur accessing out parameters
    returned from a stored procedure.
    
    When the statement cache size is greater than 0, the first time
    the stored procedure is called, you can access the
    returned parameters OK. The exception occurs the second and
    subsequent times.
    
    The parameter that causes the indexOutOfBounds exception is
    either a BLOB, CLOB, DBCLOB, or XML type.
    
    .
    Stack trace:
    12/19/08 13:18:21:530 CST 00000030 SystemErr R java.lang.
    IndexOutOfBoundsException: Index: 1, Size: 1
    at java.util.ArrayList.RangeCheck(ArrayList.java(Inlined
    Compiled Code))
    at java.util.ArrayList.get(ArrayList.java(Compiled Code))
    at com.ibm.db2.jcc.b.d.kb(d.java:1126)
    at com.ibm.db2.jcc.b.d.c(d.java:1161)
    at com.ibm.db2.jcc.c.eb.a(eb.java:757)
    at com.ibm.db2.jcc.c.eb.I(eb.java:1219)
    at com.ibm.db2.jcc.c.mh.getBytes(mh.java:664)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcCallableStatement.getBytes
    (WSJdbcCallableStatement.java:295)
    at com.principal.is.MQUnloadLoadUtil.LoadUnloadSTP.executeMQStp
    (LoadUnloadSTP.java:210)
    

Local fix

  • A temporary solution is to set the statement cache
    size on the datasource to zero.
    

Problem summary

  • Users Affected: All Users
    
    Problem Description:
    ERROR DESCRIPTION:
    
    An indexOutOfBounds exception may occur accessing out parameters
    returned from a stored procedure.
    
    When the statement cache size is greater than 0, the first time
    the stored procedure is called, you can access the
    returned parameters OK. The exception occurs the second and
    subsequent times.
    
    The parameter that causes the indexOutOfBounds exception is
    either a BLOB, CLOB, DBCLOB, or XML type.
    
    .
    Stack trace:
    12/19/08 13:18:21:530 CST 00000030 SystemErr R java.lang.
    IndexOutOfBoundsException: Index: 1, Size: 1
    at java.util.ArrayList.RangeCheck(ArrayList.java(Inlined
    Compiled Code))
    at java.util.ArrayList.get(ArrayList.java(Compiled Code))
    at com.ibm.db2.jcc.b.d.kb(d.java:1126)
    at com.ibm.db2.jcc.b.d.c(d.java:1161)
    at com.ibm.db2.jcc.c.eb.a(eb.java:757)
    at com.ibm.db2.jcc.c.eb.I(eb.java:1219)
    at com.ibm.db2.jcc.c.mh.getBytes(mh.java:664)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcCallableStatement.getBytes
    (WSJdbcCallableStatement.java:295)
    at com.principal.is.MQUnloadLoadUtil.LoadUnloadSTP.executeMQStp
    (LoadUnloadSTP.java:210)
    

Problem conclusion

  • Problem was first fixed in db2 v9.1 Fix Pack 8
    

Temporary fix

  • A temporary solution is to set the statement cache
    size on the datasource to zero.
    

Comments

APAR Information

  • APAR number

    IZ46835

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-18

  • Closed date

    2011-06-17

  • Last modified date

    2011-06-17

  • 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 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R910 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":"910"}]

Document Information

Modified date:
04 October 2021