IBM Support

IZ07562: BLOB.GETBYTES(1,0) THROWS SQLEXCEPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the specified position is greater than the length of the
    BLOB, the JCC driver should return a byte array containing up
    to length bytes rather than throw a SQLException.
    Stacktrace:
    com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10152][10176]
    Invalid position 1 or length 0.
           at com.ibm.db2.jcc.b.rc.getBytes(rc.java:116)
           at TestJCCDriver.main(TestJCCDriver.java:87)
    Problem exists in DB2 LUW V9 FP2, FP3, FP4 and V9.5.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All Users of the DB2 Universal JDBC Driver
    ****************************************************************
    PROBLEM DESCRIPTION:
    See Error Description
    ****************************************************************
    RECOMMENDATION:
    Upgrade to DB2 LUW V9 FP5 / V9.5 FP1
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 LUW V9 FP5 / V9.5 FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ07562

  • 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

    2007-10-29

  • Closed date

    2008-06-18

  • Last modified date

    2008-06-18

  • 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 PSN

       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:
03 October 2021