IBM Support

IT38907: JDBC THROWS SYSTEM OR INTERNAL ERROR JAVA.LANG.NUMBERFORMATEXCEPTION ON FECTH USING GENBSON()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as user error.

Error description

  • When executing a select statement using genBSON(), Informix JDBC
    will throw a System or internal errorj
    java.lang.NumberFormatException exception.
    
    If I create the following table:
    
    $ cat table.sql
    create table t2(
    c1 int,
    c2 char(10));
    
    insert into t2 values (215, 'Via');
    
    The following select statement returns the data but throws the
    exception:
    
    $ java SimpleSelect
    FAILED: Fetch statement failed: System or internal
    errorjava.lang.NumberFormatException: For input string:
    "{"_id":ObjectId("617c22b242b1a86900000002"),"c1":215,"c2":"Via"
    }"
    >>>End of test.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • This is not a defect so I am returning this.
    

APAR Information

  • APAR number

    IT38907

  • Reported component name

    IBM CSDK

  • Reported component ID

    5724C2381

  • Reported release

    450

  • Status

    CLOSED USE

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-29

  • Closed date

    2022-11-28

  • Last modified date

    2022-11-28

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVT2J","label":"Informix Tools"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"450","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 November 2022