search

wolfgangbrandl / db2_fdw

PostgreSQL DB2 Data Wrapper
Other
21 stars 13 forks source link

Query to foreign table fails with ERROR: error fetching result: OCILobRead failed to read LOB chunk #29

Open jkopip opened 4 years ago

jkopip commented 4 years ago

Hi Wolfgang,

We have setup db2_fdw on our Postgres 11.8 server (Linux x86_64 centos 7.7) using a 11.5.4 version of the DB2 client.

In this case we are connecting to DB2 LUW and we were able to create the foreign server and foreign table without issue.

However, when attempting to query the foreign table with clob data ,we received error:

SQL ERROR [HV00L]: ERROR: error fetching result: OCILobRead failed to read LOB chunk Detail: SQLSTATE = 42601 SQLCODE = -104 line=1585 file=db2_utils.c [IBM][OCI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "OCTETS" was found following "? as clob(2147483647". Expected tokens may include: "". SQLSTATE=42601

Here is our server information: SELECT DB2_diag('mtest'); db2_fdw 1.0devel, PostgreSQL 11.8, DB2 client 11.5.4.0.0, DB2 server 09.07.0011

SELECT DB2_diag(); db2_fdw 1.0devel, PostgreSQL 11.8, DB2 client 11.5.4.0.0, DB2INSTANCE=postgres, DB2_HOME=/home/postgres/sqllib, DB2LIB=/home/postgres/sqllib/lib

db2_fdw version : db2_fdw-3.0.2

I tested. Any table with CLOB field will report this error.

Can you help me please?

Thanks!

wolfgangbrandl commented 4 years ago

Hi

What is the size of the CLOB. There is alimit in the db2 OCI interface which could lead to that rror.

jkopip notifications@github.com hat am 12. August 2020 um 11:14 geschrieben:

Hi Wolfgang,

We have setup db2_fdw on our Postgres 11.8 server (Linux x86_64 centos 7.7) using a 11.5.4 version of the DB2 client.

In this case we are connecting to DB2 LUW and we were able to create the foreign server and foreign table without issue.

However, when attempting to query the foreign table with clob data ,we received error:

SQL ERROR [HV00L]: ERROR: error fetching result: OCILobRead failed to read LOB chunk
Detail: SQLSTATE = 42601 SQLCODE = -104
line=1585
file=db2_utils.c
[IBM][OCI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "OCTETS" was found following "? as clob(2147483647". Expected tokens may include: "". SQLSTATE=42601

Here is our server information:
SELECT DB2_diag('mtest');
db2_fdw 1.0devel, PostgreSQL 11.8, DB2 client 11.5.4.0.0, DB2 server 09.07.0011

SELECT DB2_diag();
db2_fdw 1.0devel, PostgreSQL 11.8, DB2 client 11.5.4.0.0, DB2INSTANCE=postgres, DB2_HOME=/home/postgres/sqllib, DB2LIB=/home/postgres/sqllib/lib

db2_fdw version : db2_fdw-3.0.2

I tested. Any table with CLOB field will report this error.

Can you help me please?

Thanks!

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub https://github.com/wolfgangbrandl/db2_fdw/issues/29 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMUXO3ASVEZ26O3GYAWWPDSAJMO5ANCNFSM4P4L7DPQ .

mfg.

Ing. Wolfgang Brandl

Mobil: +43 660 7132911