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

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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