Re: query a blob field on db2

[Kaggal, Vinod C.]

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>
>
>

query a blob field on db2

[Kaggal, Vinod C.]

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