IBM Support

IZ10808: ADD SUPPORT FOR JAVA 1.5 CHANGES TO BIGDECIMAL IN THE UNIVERSAL JDBC DRIVER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Java(tm) Version 1.5 changed the way that BigDecimal.toString()
    is output.  As a result, changes needed to be made to various
    parts of the Universal JDBC driver to accomodate this change.
    
    One example of this is the following:
    
    String sql = "INSERT INTO t1 values (?)";
    PreparedStatement ps = conn.prepareStatement (sql);
    Double doub = 2700000000000;
    String doubString = String.valueOf(doub);
    ps.setBigDecimal (doubString);
    ps.executeUpdate();
    
    Previously, this would return the following error:
    [ibm][db2][jcc][converters] Overflow occurred
    during numeric data type conversion of "2.7722E+9"
    

Local fix

  • There are two possible workarounds:
    
    1.  Use JDK 1.4 or below
    
    2.  Use the following alternate coding:
    
    String sql = "INSERT INTO t1 values (?)";
    PreparedStatement ps = conn.prepareStatement (sql);
    Double doub = 2700000000000;
    ps.setBigDecimal (doub);
    ps.executeUpdate();
    

Problem summary

  • PORT FOR JAVA 1.5 CHANGES TO BIGDECIMAL IN THE UNIVERSAL JDBC
    DRIVER
    

Problem conclusion

  • Resolved in v9.5 fix pak #1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ10808

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-12-11

  • Closed date

    2008-05-28

  • Last modified date

    2008-05-28

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

    IZ10805

  • 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

  • R950 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 950

Reference #: IZ10808

Modified date: 28 May 2008


Translate this page: