[ 
https://issues.apache.org/jira/browse/NIFI-4238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Matt Burgess resolved NIFI-4238.
--------------------------------
    Resolution: Won't Fix

Please feel free to reopen this case as necessary but since it is a driver 
limitation, hopefully it has been fixed in later versions of the driver. I'd 
really rather not hack the solution because non-standard JDBC types should be 
handled by the Database Type value in these processors.

> Error in QueryDatabaseTable (NiFi CDC support): Unable to execute SQL select 
> query due to org.apache.nifi.processor.exception.ProcessException: Error 
> during database query or conversion of records to Avro
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: NIFI-4238
>                 URL: https://issues.apache.org/jira/browse/NIFI-4238
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.3.0
>         Environment: Centos
>            Reporter: Ella
>            Priority: Major
>         Attachments: Error.png, QueryDatabaseTableError.png, 
> config_file_1.png, config_file_2.png, config_file_3.png, diagram.png
>
>
> Hi Guys,
> I should retrieve only the new added records from the DB2 database to a file 
> by NiFi's CDC feature--QueryDatabaseTable processor; however, I have 
> encountered the Error during executing my dataflow scenario. I have 
> respectfully attached the snapshot of Error as well as the dataflow; I would 
> really appreciate if someone helped me after all.
> Thanks a lot.
> Sincerely,
> Ella



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to