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 Re: query a blob field on db2
Date Wed, 16 Nov 2016 22:35:27 GMT
This has been resolved, thanks to this post: 
https://community.hortonworks.com/questions/66883/nifi-cannot-handle-db2-blob-data-sends-wrong-resul.html

On 2016-11-16 11:56 (-0600), "Kaggal, Vinod C." <K...@mayo.edu> wrote:
 > 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