Shubham, One more note. While I was typing up the last email, it appears a ticket was created to alter ExecuteSQL to carry out the functionality I think you are looking for. It can be located here: https://issues.apache.org/jira/browse/NIFI-932
On Fri, Sep 4, 2015 at 1:25 PM, Aldrin Piri <[email protected]> wrote: > Shubham, > > ExecuteSQL requires an input flowfile to cause processing to occur. Based > off your message, it sounds like this is the only instance and thus there > is no action occurring. This is certainly unclear on our behalf in terms > of documentation on the processor. By design, this processor would receive > input input and use its attributes in conjunction with expression language > [1] to create "dynamic" queries. > > If you were interested in running a static query, you can use > GenerateFlowFile to provide input and trigger the processor to execute. > > [1] > http://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html > > > > On Fri, Sep 4, 2015 at 7:40 AM, Bryan Bende <[email protected]> wrote: > >> Hi Shubham, >> >> I believe images usually get stripped out of the emails, can you upload >> the >> image somewhere and provide a link? >> >> Generally a processor will transfer data on a relationship, and a >> relationship is connected to another processor, or the relationship can be >> auto-terminated which means the data has reached a point where you don't >> want to do anything else with it. >> For testing, you may want to connect your ExecuteSQL processor to a >> PutFile >> processor that writes to a directory on your local machine, this way you >> can see what is getting produced. Once you know it is working then you can >> reconfigure the flow how you like. >> >> Thanks, >> >> Bryan >> >> On Fri, Sep 4, 2015 at 4:33 AM, Shubham Bansal < >> [email protected]> wrote: >> >> > Hi, >> > >> > I am using ExecuteSQL processor in my flow. Infact , that is the only >> > processor I have added to the flow. I have added DBCPConnectionPool >> service >> > to this processor. I am attaching screenshots for the configuration done >> > for these. There is no error on the connection side but I am not able to >> > fetch any data. Where exactly will this data go ? Please help me with >> this. >> > >> > Thanks, >> > >> > -- >> > >> > >> > >> > *Shubham Bansal*, Software Engineer, >> > >> > 4th Floor, Pioneer Towers, Madhapur, Hyderabad >> > *M: **+91 9059328793 <%2B91%20%C2%A09059328793> * >> > *W: *ww <http://www.whishworks.com/>w.whishworks.com >> > <http://www.whishworks.com/> >> > >> > <http://www.whishworks.com/blog/> <https://twitter.com/WHISHWORKS> >> > <https://www.facebook.com/whishworksit> >> > <https://www.linkedin.com/company/whishworks> >> > >> > The contents of this e-mail are confidential and for the exclusive use >> of >> > the intended recipient. If you receive this e-mail in error please >> delete >> > it from your system immediately and notify us either by e-mail or >> > telephone. You should not copy, forward or otherwise disclose the >> content >> > of the e-mail. The views expressed in this communication may not >> > necessarily be the view held by WHISHWORKS. >> > >
