Lob 已关闭.错误代码=-4470，SQLSTATE=null

2022-01-14 00:00:00 db2 jakarta-ee java websphere-commerce

我正在使用 IBM websphere commerce 和 db2，有以下代码

I am using IBM websphere commerce and db2, have following piece of code 

Clob clobVar = null;
if (result.elementAt(3) != null)
    clobVar = (Clob) result.elementAt(3);

if (clobVar == null) {
    infoTable.put("EInfo", "");
} else {
    stringTemp = clobVar.getSubString(1, (int) clobVar.length());
    infoTable.put("EInfo", stringTemp); 
}

代码运行良好，直到

clobVar = (Clob) result.elementAt(3);

但是一旦执行到

stringTemp = clobVar.getSubString(1, (int) clobVar.length());

系统抛出异常

[jcc][10120][11936][4.3.111] 无效操作:Lob 已关闭.ERRORCODE=-4470，SQLSTATE=null

我做错了什么?

如何解决这个问题?

推荐答案

这个问题可以通过在连接url中添加progressiveStreaming=2;参数来解决

This issue can be solved by adding progressiveStreaming=2; argument to the connection url

完整指定的连接 URL 如下所示:

The fully specified Connection URL was to be given as below:

jdbc:db2://localhost:50000/SAMPLE:progressiveStreaming=2;

如果您对该参数有异常，请在其中添加以下内容:

Incase you have exception on that parameter add the following to it:

jdbc:db2://localhost:50000/SAMPLE:driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;

首选db2jcc4.jar

相关文章