nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kaggal, Vinod C." <Kaggal.Vi...@mayo.edu>
Subject query a blob field on db2
Date Wed, 16 Nov 2016 17:56:27 GMT
Hello!

We have been using nifi successfully for a few things and can attest that this is a great
tool to have in our tool box!

Recently, we were trying to query a blob field from db2 which resulted in an exception.

Any recommendation on how to address this would be appreciated!

Query:
SELECT BLOBTBL.BLOB_CONTENTS FROM CE_BLOB_DECOMP BLOBTBL fetch first 10 rows only with UR


Exception:

ExecuteSQL[id=93bdd730-65ba-4deb-b6a4-78a551916d1d] Unable to execute SQL select query SELECT
BLOBTBL.BLOB_CONTENTS FROM CE_BLOB_DECOMP BLOBTBL fetch first 10 rows only with UR due to
org.apache.nifi.processor.exception.ProcessException: com.ibm.db2.jcc.am.jo: [jcc][t4][1092][11638][3.57.110]
Invalid data conversion: Wrong result column type for requested conversion. ERRORCODE=-4461,
SQLSTATE=42815; routing to failure: org.apache.nifi.processor.exception.ProcessException:
com.ibm.db2.jcc.am.jo: [jcc][t4][1092][11638][3.57.110] Invalid data conversion: Wrong result
column type for requested conversion. ERRORCODE=-4461, SQLSTATE=42815


Thank you!
Vinod


Mime
View raw message