db2set DB2_RESTRICT_DDF=TRUE

最新推荐文章于 2023-03-18 23:48:48 发布

原创最新推荐文章于 2023-03-18 23:48:48 发布 · 8.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#db2set #DB2_RESTRICT_DDF

DB2 专栏收录该内容

33 篇文章

订阅专栏

本文分析了com.ibm.db2.jcc.am.SqlException错误的具体原因，该错误提示操作无效：已关闭resultset。通过堆栈跟踪详细说明了问题发生的上下文，并提出了两种解决方案：一是调整JDBC驱动的progressiveStreaming属性值；二是在服务端执行特定命令并重启数据库。

com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][3.63.123] 操作无效：已关闭 result set。 ERRORCODE=-4470, SQLSTATE=null
at com.ibm.db2.jcc.am.fd.a(fd.java:663)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:103)
at com.ibm.db2.jcc.am.vn.Db(vn.java:4528)
at com.ibm.db2.jcc.am.vn.r(vn.java:1822)
at com.ibm.db2.jcc.am.vn.getMetaData(vn.java:1814)
at org.pentaho.di.core.database.Database.getOneRow(Database.java:3505)
at org.pentaho.di.repository.Repository.getIDWithValue(Repository.java:1093)
at org.pentaho.di.repository.Repository.getTransformationID(Repository.java:952)
at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2472)
at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2442)
at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495)
at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89)
at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5679)
at org.pentaho.di.ui.spoon.Spoon.handleStartOptions(Spoon.java:5532)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5555)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412)
ERROR 20-08 23:04:20,066 - Transformation 1 - A database error occured reading a transformation from the repository
org.pentaho.di.core.exception.KettleException:
This file doesn't exist : Transformation 1

解决方法为：设置JDBC驱动的progressiveStreaming属性值为2或在服务端执行“db2set DB2_RESTRICT_DDF=TRUE”命令并重启数据库。