nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Keith Lim <Keith....@ds-iq.com>
Subject Re: How to call a stored procedure
Date Fri, 10 Jun 2016 17:25:37 GMT
Hi Raymond,


Let's say you have an input flowfile that contains an xml message with a root node <RootMessage>
xml message </RootMessage>


You can use EvaluateXPath to extract out the content of the flowfile into a custom property

Destination = flowfile-attribute

New Property  message = /RootMessage


Next create an instance of ReplaceText processor to replace all the content of the flowfile

Replacement Value = EXEC SP.INSERT_XML(XMLTYPE(${message})


Next create an instance of PutSQL processor and set the JDBC Connection Pool accordingly.
 (Note: make sure the stored proc body does not return a data set via select, currently PutSql
does not support that.)


That should do it.


HTH,

Keith

________________________________
From: ski n <raymondmeester@gmail.com>
Sent: Friday, June 10, 2016 7:05 AM
To: users@nifi.apache.org
Subject: How to call a stored procedure

I want to call a stored procedure as follows:

BEGIN SP.INSERT_XML(XMLTYPE(${message}); END;

I have two questions:

1) I want to use the flowfile content as input parameter. How is this
done with the expression language?
2) Are stored procedures supported by a processor (PutSQL or
ExecuteSQL) without the use of external tools?

Mime
View raw message