query a blob field on db2

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

 

Reply | Threaded
Open this post in threaded view
|

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." <[hidden email]> 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>
 >
 >