IBM Support

IC69458: JCC DRIVER HANGS IN INFINITE LOOP

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • An application using the JDBC/JCC driver will hang when calling
    the streaming methods:
    
    PreparedStatement.getCharacterStream(int, Reader)
    OR
    PreparedStatement.setCharacterStream(int, Reader, -1)
    
    A javacore from the hanging application may be similar to the
    function stack below:
    
    java.lang.Thread.State: RUNNABLE
    at
    java.nio.charset.CharsetEncoder.encode(CharsetEncoder.java:544)
    at com.ibm.db2.jcc.t4.ib.a(ib.java:257)
    at com.ibm.db2.jcc.t4.lb.a(lb.java:1635)
    at com.ibm.db2.jcc.t4.lb.a(lb.java:181)
    at com.ibm.db2.jcc.t4.vb.a(vb.java:175)
    
    
    This issue is not affected by CPU load and occurs when streaming
    is used for large CLOBs.  For example if MY_DATA was a string
    longer than 16,390 characters this issue can be easily
    reproduced.
    
    private static String MY_DATA;
    
    PreparedStatement.setCharacterStream(2, new
    StringReader(MY_DATA));
    

Local fix

  • Use PreparedStatement.setCharacterStream(int, Read, length) or
    PreparedStatement.getCharacterStream(int, Read, length) which
    specifies the length of the data.
    

Problem summary

  • See ERROR DESCRIPTION.
    

Problem conclusion

  • First fixed with JDBC driver included with v9.5 Fixpack 7.  This
    is a client side fix.
    

Temporary fix

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    IC69458

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-24

  • Closed date

    2012-02-24

  • Last modified date

    2012-02-24

  • APAR is sysrouted FROM one or more of the following:

    IC69344

  • 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

  • R950 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.5

Reference #: IC69458

Modified date: 24 February 2012