PSQLEXCEPTION：意外错误代码“ 55000&”。从数据源“ FEDSER”接收。关联的文本和标记是“此ResultSet已关闭”。

本文介绍了PSQLEXCEPTION：意外错误代码“ 55000&”。从数据源“ FEDSER”接收。关联的文本和标记是“此ResultSet已关闭”。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试通过InfoSphere Federation Server从db2到PostgreSQL表进行差异数据加载。

I am trying to do the differential data load from db2 to PostgreSQL table through InfoSphere Federation Server.

按照以下步骤操作并得到提示：

Followed below steps and got the expeption:

SQL1822N意外错误代码从数据源 FEDSER收到55000。 关联的文本和标记是此ResultSet已关闭。。

SQL1822N Unexpected error code "55000" received from data source "FEDSER". Associated text and tokens are "This ResultSet is closed.".

请找到我遵循的以下步骤：

Please find the below steps which I followed:

create wrapper jdbc DB20000I The SQL command completed successfully. CREATE SERVER FEDSER TYPE JDBC VERSION '12' WRAPPER JDBC OPTIONS( ADD DRIVER_PACKAGE 'E:\Sandhya\postgresql-8.1-415.jdbc3.jar', URL 'jdbc:postgresql://localhost:5432/SCOPEDB', DRIVER_CLASS 'org.postgresql.Driver', DB2_IUD_ENABLE 'Y', db2_char_blankpadded_comparison 'Y', db2_varchar_blankpadded_comparison 'Y', VARCHAR_NO_TRAILING_BLANKS 'Y', JDBC_LOG 'Y') DB20000I The SQL command completed successfully. CREATE USER MAPPING FOR SANAGARW SERVER FEDSER OPTIONS (REMOTE_AUTHID 'postgres',REMOTE_PASSWORD '*****') DB20000I The SQL command completed successfully SELECT COUNT(*) FROM "SCOPE".EMPLOYEE SQL1822N Unexpected error code "55000" received from data source "FEDSER". Associated text and tokens are "This ResultSet is closed.".

我正在使用Postgres版本12，Java版本 1.8.0_241

I am using Postgres version 12, Java version "1.8.0_241"

请帮助我解决此问题。

Please help me to resolve this issue. or once connection get created then I can only create the nickname.

推荐答案

考虑使用Db2 11.5而不是淘汰的InfoSphere Federation Server的支持日期2017-09-30 https：// www .ibm / support / lifecycle /＃/ search？q = InfoSphere％20Federation％20Server

Consider using Db2 11.5 instead of InfoSphere Federation Server which went out of support 2017-09-30 www.ibm/support/lifecycle/#/search?q=InfoSphere%20Federation%20Server

Db2 11.5在所有Db2中都包括对PostgreSQL联合的内置支持版本，包括Db2社区版

Db2 11.5 includes inbuilt support for PostgreSQL federation in all Db2 editions including Db2 Community Edition

www.ibm/support/pages/data-source-support-matrix-federation-bundled-db2-luw-v115