DB2 - Problem description
Problem IC81921 | Status: Closed |
ERROR COULD OCCUR WHEN USING CHAR ARRAY IN EXTERNAL JAVA ROUTINE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
When running an external Java routine that uses CHAR array or CHAR array for bit data as a parameter, sqlcode -1131 or -4302 could be returned. SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503 SQL4302N Procedure or user-defined function "xxxx.xxxx", specific name "SQLxxxxxxxxxxxxx" aborted with an exception "Incompatible base type for array". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * When running an external Java routine that uses CHAR array * * or * * CHAR array for bit data as a parameter, sqlcode -1131 or * * -4302 * * could be returned. * * * * SQL1131N DARI (Stored Procedure) process has been * * terminated * * abnormally. * * SQLSTATE=38503 * * * * SQL4302N Procedure or user-defined function "xxxx.xxxx", * * specific name * * "SQLxxxxxxxxxxxxx" aborted with an exception "Incompatible * * base * * type for * * array". * **************************************************************** * RECOMMENDATION: * * See local fix or upgrade to DB2 LUW version 9.5 fixpack 10. * **************************************************************** | |
Local Fix: | |
switching to VARCHAR could avoid the problem | |
Solution | |
Problem is first fixed in DB2 LUW version 9.5 fixpack 10. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC82073 IC84510 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.03.2012 29.01.2013 29.01.2013 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.10 |