LI71380: THE GETCOLUMNDISPLAYSIZE FOR GRAPHIC TYPE RETURNS NUMBER OF BYTES INSTEAD OF NUMBER OF CHARACTERS ON LEGACY JDBC DRIVER.

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• The Java specification defines
  ResultSetMetaData#getColumnDisplaySize method returns the number
  of characters for given column. However getColumnDisplaySize for
  GRAPHIC type returns number of bytes instead of number of
  characters on Legacy JDBC driver.
  

Local fix

• Please use Universal JDBC Driver (Jcc). The
  getColumnDisplaySize(graphic type) returns number of characters
  on Jcc.
  

Problem summary

• Users affected:
  Users who use CLI-based Legacy JDBC driver.
  .
  Problem Description:
  If this APAR is not applied,
  ResultSetMetaData#getColumnDisplaySize method for GRAPHIC
  columns returns number of bytes instead of number of characters.
  Problem Summary:
  Legacy driver did not take into account that GRAPHIC columns
  contain only double-byte string.
  

Problem conclusion

• First fixed in DB2 Version 9.1, FixPack 5 (s080512)
  

Temporary fix

• Please use DB2 Driver for JDBC and SQLJ (jcc)
  

Comments

APAR Information

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

  LI71379

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

Modules/Macros

• ENG_JDBC
  

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSN

     UP