[
https://issues.apache.org/jira/browse/NIFI-626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14580783#comment-14580783
]
Mark Payne commented on NIFI-626:
---------------------------------
Toivo,
I pulled in the code and gave it a shot. Cleaned up some code to match the nifi
coding styles a bit (declaring variables as finals, adding {} around
single-statements in for loops, log FlowFile affected in log messages, etc.)
I tried to connect to MySQL, but I got a NullPointerException from the
DBCPService. Going to submit a couple of tickets against that service.
Processor code looks good, but I can't really test without being able to run
against a database that I have setup. So I'll leave this ticket in "patch
submitted" state until the other tickets are resolved so that I can test
appropriately. Will link them as blocking this ticket.
Thanks
-Mark
> ExecuteSQL processor for executing arbitrary SQL queries
> --------------------------------------------------------
>
> Key: NIFI-626
> URL: https://issues.apache.org/jira/browse/NIFI-626
> Project: Apache NiFi
> Issue Type: Sub-task
> Affects Versions: 0.2.0
> Reporter: Toivo Adams
> Assignee: Toivo Adams
> Labels: patch
> Fix For: 0.2.0
>
> Attachments:
> 0001-NIFI-626-Code-cleanup-to-adhere-to-NiFi-coding-style.patch,
> NIFI-626_25may2015.patch, NIFI-626_26may2015.patch, NIFI-626_31may2015.patch
>
>
> For example query can be:
> SELECT * FROM orders WHERE orderId = '${order.id}'
> where ${order.id} is FlowFile attribute.
> Result will serialized using Avro.
> Avro gives as possibility to have query Resultset metadata (column name and
> types) included in FlowFile.
> Also Avro should allow streaming.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
