ERROR DB Query Reader KNIME 4.0 issue

I get the following error when i run my SQL query in the DB Query Reader node. I noticed it gives the error on reading the string column with NULL value. The UTF-8 encoding is already on. The query worked fine when i used Database Reader in 3.x but it fails in 4.0 version using DB query reader.

ERROR DB Query Reader 0:2 Exception reading data row: [jcc][t4][1065][12306][4.24.92] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
ERROR DB Query Reader 0:2 Execute failed: [jcc][t4][1065][12306][4.24.92] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null

Has anyone experienced this error?

Hi,
can you please provide some more information about your setup. Do you use the same driver with KNIME 3.x and KNIME 4.0? Is this the thin driver or the OCI driver? Where and how did you specify the UTF-8 encoding?
Thanks
Tobias

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.