IC89901: UNABLE TO INSERT NESTED COMPLEX TYPES WITH NULL VALUES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • The JDBC driver may return an exception when using null values
    inside a nested complex data type (e.g: multiset(row(int,int)).
    
    The driver fails with exceptions similar to:
    
      java.sql.SQLException: No more data to read or write. Verify
    your SQLData class or getSQLTypeName() string.
     at com.informix.util.IfxErrMsg.getSQLException
     at com.informix.jdbc.IfxComplexOutput.getNextType
     at com.informix.jdbc.IfxComplexOutput.writeStruct
     ...
    
    or
    
      java.sql.SQLException: Type requested (row) doesn't match row
    type information (string type) type.
     at com.informix.jdbc.IfxComplex.badTypeException
     at com.informix.jdbc.IfxComplexOutput.verifyType
     ...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Informix JDBC driver all versions                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to version 3.70.JC8 or 4.10.JC2                      *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC89901

  • Reported component name

    IBM JDBC

  • Reported component ID

    5724I3501

  • Reported release

    370

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-29

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

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

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

Fix information

Applicable component levels

  • R350 PSN

       UP

  • R350 PSY

       UP

  • R370 PSN

       UP

  • R370 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Tools
Informix JDBC

Software version:

370

Reference #:

IC89901

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation