IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR32319

  • Reported component name

    DB2 CUE ISERIES

  • Reported component ID

    5724M1501

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-11

  • Closed date

    2009-10-16

  • Last modified date

    2009-10-16

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021