Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC65770 Status: Closed

THE GETCOLUMNTYPE METHOD RETURNS WRONG DATATYPE VALUE FOR COLUMNS DEFINED
WITH USER DEFINED DISTINCT DATATYPES.

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
Abstract: 
----------- 
The getColumnType method returns wrong datatype value for 
columns defined with user defined distinct datatypes. 
 
Problem description 
------------------------ 
The getColumnType API when used against a user-defined distinct 
datatype, returns wrong type rather than the correct base 
datatype value. The following error is received: 
 
ERROR ->[IBM][JDBC Driver] CLI0606E  The returned value from a 
column is incompatible with the data type corresponding to the 
get*** method. SQLSTATE=22005 
 
The SQL_ATTR_RETURN_USER_DEFINED_TYPES attribute is set to 
SQL_TRUE, so the descriptor field SQL_DESC_TYPE will no longer 
return the "base" SQL type of the UDT, that is, the SQL type 
that the UDT is based on. 
 
Rootcause for this problem: 
--------------------------------- 
The issue which is causing the error "CLI0606E - InCompatible 
datatype" is due to SQL_ATTR_RETURN_USER_DEFINED_TYPES is set to 
TRUE in JDBC code, which should not be set as it would not 
return the base datatype value. 
 
When the SQL_ATTR_RETURN_USER_DEFINED_TYPES attribute is set to 
SQL_TRUE, the descriptor field SQL_DESC_TYPE will no longer 
return the "base" SQL type of the UDT, that is, the SQL type 
that the UDT is based on or transforms to. 
 
Please refer: 
( 
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.i 
bm.db2.luw.apdv.cli.doc/doc/c0007960.html ) 
 
Environment 
--------------- 
This issue can be reproduced on Linux and AIX platforms. It 
occurs both in DB2 v8, v91 and v95 builds. But not consistently 
reproducible and happens when using both JDK version 1.4.0 and 
1.4.2. 
 
Diagnostic information 
--------------------------- 
The JDBC trace which shows the error as follows, 
 
jdbc.app.DB2ResultSetTrace -> getObject( 1 ) (2007-7-27 
13:25:36.423) 
| Statement handle = 1:1 
| jdbc.app.DB2ResultSetTrace -> getColType( 1, true ) (2007-7-27 
13:25:36.423) 
| | Statement handle = 1:1 
| | jdbc.app.DB2ResultSetTrace -> getColType( 1, true ) 
(2007-07-27 13:25:36.423) 
| | | 10: sqlType = -450 
| | | jdbc.app.DB2ResultSetMetaDataTrace -> getColumnType(1) 
(2007-7-27 13:25:36.424) 
| | | | Statement handle = 1:1 
| | | | 30: DB2ColType = -450 
| | | | 30: DB2ColBaseTypeNotAdjusted = -450 
| | | | Return value = -450 
| | | jdbc.app.DB2ResultSetMetaDataTrace <- getColumnType - Time 
Elapsed = 0.0 (2007-7-27 13:25:36.424) 
| | | 20: sqlType = -450 
| | | 20: returnLen = 15 
| | jdbc.app.DB2ResultSetTrace <- getColType() returns -450 
[Time Elapsed = 0.0020] (2007-07-27 13:25:36.424) 
| jdbc.app.DB2ResultSetTrace <- getColType - Time Elapsed = 
0.0010 (2007-7-27 13:25:36.424) 
| jdbc.app.DB2ResultSetTrace -> getObject( 1, -450 ) (2007-7-27 
13:25:36.424) 
| | Statement handle = 1:1 
| | jdbc.app.DB2ResultSetTrace -> getObject( 1, -450, -1 ) 
(2007-7-27 13:25:36.425) 
| | | Statement handle = 1:1 
| | | jdbc.DB2Exception -> DB2Exception() (2007-07-27 
13:25:36.425) 
| | | | 10: SQLError = [IBM][JDBC Driver] CLI0606E  The returned 
value from a column is incompatible with the data type 
corresponding to the get*** method. SQLSTATE=22005 
| | | |     SQLState = 22005 
| | | |     SQLNativeCode = -99999 
| | | jdbc.DB2Exception <- DB2Exception() [Time Elapsed = 0.0] 
(2007-07-27 13:25:36.425) 
| | jdbc.app.DB2ResultSetTrace <- getObject - Time Elapsed = 0.0 
(2007-7-27 13:25:36.425) 
| jdbc.app.DB2ResultSetTrace <- getObject - Time Elapsed = 0.0 
(2007-7-27 13:25:36.425) 
jdbc.app.DB2ResultSetTrace <- getObject - Time Elapsed = 0.0020 
(2007-7-27 13:25:36.425)
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* JDBC Application Users                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.1 FP9 or Newer                              * 
****************************************************************
Local Fix:
No workaround available
available fix packs:
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

Solution
Problem First Fixed in DB2 Version 9.1 Fix Pack 9
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
21.01.2010
12.07.2012
12.07.2012
Problem solved at the following versions (IBM BugInfos)
9.1.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.