|
Problem IT06524
|
Status: Closed |
Java external routine which retrieves result set via Stored procedure call having cursor may return BugCheckException |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
BugCheckException error occurs when executing a Java external
routine which is retrieving a result set via a stored procedure
call having a cursor output parameter.
Below error is seen:
Stack trace collected from the db2dump:
com.ibm.db2.jcc.am.BugCheckException:
[jcc][t4][1026][12957][4.15.113]
Bug check exception thrown due to an internal JCC error. Please
contact support. Message text: {0} ERRORCODE=-4228,
SQLSTATE=null
at com.ibm.db2.jcc.am.hd.a(hd.java:599)
at com.ibm.db2.jcc.am.hd.a(hd.java:616)
at com.ibm.db2.jcc.am.lc.a(lc.java:2695)
at
com.ibm.db2.jcc.am.CallableStatement.J(CallableStatement.
java:1137)
at com.ibm.db2.jcc.am.CallableStatement.getObject
(CallableStatement.java:1115)
...
db2diag.log will contain full exception as:
2014-12-04-14.50.40.514000-300 I122272F1103 LEVEL:
Warning
PID : 9772 TID : 11420 PROC :
db2fmp64.exe
INSTANCE: ABC NODE : 000 DB :
SAMPLE
APPID : *LOCAL.ABC
HOSTNAME: LOCALHOSTABC
EDUID : 11420
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
DATA #1 : String, 630 bytes
java.sql.SQLException: com.ibm.db2.jcc.am.BugCheckException:
[jcc][t4][1026][129
57][4.15.113] Bug check exception thrown due to an internal JCC
error. Please c
ontact support. Message text: {0} ERRORCODE=-4228,
SQLSTATE=null
at com.ibm.db2.jcc.am.fd.a(fd.java:548)
at com.ibm.db2.jcc.am.fd.a(fd.java:565)
at com.ibm.db2.jcc.am.jc.a(jc.java:2695)
at
com.ibm.db2.jcc.am.CallableStatement.J(CallableStatement.java:11
33)
at
com.ibm.db2.jcc.am.CallableStatement.getObject(CallableStatement
.java
:1111)
at SpServer.outLanguage(SpServer.java:52)
-4228 : PREPARE STATEMENT FAILED
at SpServer.outLanguage(SpServer.java:73)
DATA #2 : Hexdump, 4 bytes
0x0000000010EA9300 : 0000 0000
.... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 FP7 *
**************************************************************** |
| Local Fix: |
Below work around can be adopted:
Replace procedure returning the cursor with a Table UDF
returning the same result set. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.01.2015
20.01.2016
20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
