PSQLEXCEPTION：意外错误代码“ 55000&”。从数据源“ FEDSER”接收。关联的文本和标记是“此ResultSet已关闭”。 [英] PSQLEXCEPTION: Unexpected error code "55000" received from data source "FEDSER". Associated text and tokens are "This ResultSet is closed."

问题描述

我正在尝试通过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.com / 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 https://www.ibm.com/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

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

这篇关于PSQLEXCEPTION：意外错误代码“ 55000&”。从数据源“ FEDSER”接收。关联的文本和标记是“此ResultSet已关闭”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！