DB2 JDBC SQLJ D / DB2DSDRVR / B10 - DB2

An SQL stored procedure is defined in DB2 for Z/OS which returns 
an array of integers.The procedure is called multiple times from 
a Java program that connect to the DB2 instance via the JCC JDBC 
driver. The program uses a callableStatement object. Before a 
new execution , clearParameters() is called as in the following 
code snippet: 
 
      while (need_looping) 
      { 
          inData = conn.createArrayOf("INTEGER", contents); 
          cstmt.setArray(1, inData); 
          cstmt.registerOutParameter (2, java.sql.Types.ARRAY); 
          cstmt.executeUpdate(); 
 
          Array outData = cstmt.getArray(2); 
          Integer [] outNums = (Integer [])outData.getArray(); 
//data here will be stale on 2nd and subsequent calls 
          cstmt.clearParameters(); 
      } 
 
While the first call will returns correct results, subsequent 
calls will keep returning the same result retrieved from the 
initial call.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using driver below 11.1FP1                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* JCC RETURNS STALE DATA CALLING AN ARRAY STORED PROCEDURE     * 
* AGAINSTDB2 Z/OS                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade tp 11.1FP1                                           * 
****************************************************************

Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

Upgrade tp 11.1FP1

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

09.01.2017
09.01.2017
09.01.2017