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