[jira] [Created] (NIFI-4843) ExecuteSQL cannot execute delete without error

["Max Kelada (JIRA)" <ji...@apache.org>]

Max Kelada created NIFI-4843:
--------------------------------

             Summary: ExecuteSQL cannot execute delete without error
                 Key: NIFI-4843
                 URL: https://issues.apache.org/jira/browse/NIFI-4843
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
            Reporter: Max Kelada


I had a scenario in which i wanted to execute a delete statement on one of my tables

the processor works, and deletes what data i needed it to delete. but after every execution it throws and exception that it cannot retrieve data from the ResultSet. i guess that's because it expects data from the db to be returned to it. but in the case of deletion there is none.

why it's a problem is that we cannot determine if the processor is doing it's job properly or not when bulletins are thrown from it. 

so i would greatly appreciate it if you could make the ExecuteSQL processor support delete queries



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)