JR32319: JCC DRIVER DISPLAYS WARNING EXECUTING AN SQL STATEMENT AGAINST A TABLE CONTAINING A DECIMAL COLUMN ON DB2 FOR Z/OS V9

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 following warning may be displayed:
  
  [ibm][db2][jcc][10253][10853] Specified type does not match
  described type. Using described type.
  
  This will happen when API calls such as setInt(), setLong(),
  setString(), or any other compatible type to decimal against a
  decimal column were used on the prepared statement.
  
  This problem is only exhibited in the JCC driver shipped with
  DB2 LUW v9.1 against a DB2 for z/OS v9 database.  This problem
  does not occur in the JCC driver from DB2 LUW v9.5
  
  This following shows an example of the warning. The warning will
  occur on the second execution.
  
  Statement stmt = con.createStatement();
  stmt.executeUpdate("create table foo (a int, b
  decimal(30,10))");
  PreparedStatement pstmt1 = con.prepareStatement("select * from
  final
  table (insert into foo values (?,?))");
  pstmt1.setInt(1, 3);
  pstmt1.setLong(2, 6);
  ResultSet rs1 = pstmt1.executeQuery();
  SQLWarning ws = pstmt1.getWarnings();
  pstmt1.setInt(1, 4);
  pstmt1.setLong(2, 8);
  ResultSet rs = pstmt1.executeQuery();
  ws = pstmt1.getWarnings();
  if (ws != null)
    System.out.println("Warning = " + ws.getMessage());
  

Local fix

• This problem only occurs with JDK 1.5 and above.  As a
  workaround, JDK 1.4 can be used.
  

Problem summary

• JCC DRIVER DISPLAYS WARNING EXECUTING AN SQL STATEMENT AGAINST A
  TABLE CONTAINING A DECIMAL COLUMN ON DB2 FOR Z/OS V9
  

Problem conclusion

• First fixed in DB2 UDB Version 9.1, FixPak 8
  JCC driver version 3.8.56 and higher
  

Temporary fix

• This problem only occurs with JDK 1.5 and above.  As a
  workaround, JDK 1.4 can be used.
  

Comments

APAR Information

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

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

Fix information

• Fixed component name

  DB2 CUE ISERIES

• Fixed component ID

  5724M1501

Applicable component levels

• R910 PSN

     UP