com.ibm.db2.jcc.am.SqlException:[jcc][10120][11936][4.14.88]Invalidoperation:Lob
程序员文章站
2022-05-11 12:35:13
this issue can be solved by adding?progressiveStreaming=2;?argument to the connection url...
this issue can be solved by adding?progressiveStreaming=2;?argument to the connection url
The fully specified Connection URL is to be given as below:
jdbc:db2://localhost:50000/SAMPLE:progressiveStreaming=2;
In case you have exception on that parameter add the following to it or add any one or combinations of these parameters to fix it:
jdbc:db2://localhost:50000/SAMPLE:driverType=4;fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;progresssiveLocators=2;
db2数据库转储，原数据库导出sql，在新数据库执行即可。