Skip to main content
Archived

Using binding of named parameters in SqlExecutor/SqlCreator

Related products:Transformers
danilo_fme
  • danilo_fme
    danilo_fme

nordpil
Supporter

Just for clarification - this is not about fme workspace parameters, rather about SQL named parameters.

Named parameters provides better security against SQL injection, improved query plan caching, ensures proper type handling among other things. Another advantage is that it makes it easier to just copy/paste the sql-code from a sql editor (like ADS, Dbeaver etc) where one would be provided with prompts to fill in the parameters.

It would be amazing if one just name a sql paramter the same as an attribute in the feature, and it would be picked up that way… !

<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

PierreAtSafe
Safer
Forum|alt.badge.img+1
NewOpen

PierreAtSafe
Safer
Forum|alt.badge.img+1
Idea merged into:

All the votes from this idea have been transferred.

andreaatsafe
Safer
Forum|alt.badge.img+12
OpenArchived

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings