DB2 FOR LUW / DB2FORLUW / 970 - DB2

This issue affects applications utilizing the IBM Data Server 
Driver for JDBC and SQLJ, calling stored procedures with OUT or 
INOUT parameters. 
 
The JDBC CallableStatement.getObject () function call does not 
necessarily return an object type that matches with the data 
type specified on the parameter bind (registerOutParameter) 
operation. 
This may cause the application to fail with a 
java.lang.ClassCastException. 
 
For Out or Inout parameters on CallableStatement, if the 
application registers a type that does not match with the server 
data type, and getObject() is used to retrieve the output, the 
data type of the Java Object returned by the driver will be 
based on the server type instead of the registered type.  A 
java.lang.ClassCastException maybe thrown when customer's 
application trying to cast the Java Object to their expected 
Java Object. 
 
To fix this, the driver will, in future releases return a Java 
Object based on the registered type rather than the server type. 
If a registered type is not supported for the server type, the 
driver will return a Java Object based on the server data type.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 Fix Pack 6                                * 
****************************************************************

Use the getXXX () function call (e.g. getString, getInt, 
getDouble) instead of getObject () to ensure that an object of 
the intended data type is returned.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 9.7 Fix Pack 6

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC81352 
follow-up : 

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

24.01.2012
09.05.2017
09.05.2017

9.7.FP6