Skip to main content
Question

FME Workbench 2007: how to execute sql statements using feature attributes

  • June 14, 2019
  • 2 replies
  • 17 views
dms2
Contributor
Forum|alt.badge.img+11

One of our customers still uses v2007 of FME Workbench and I'm having a bad time trying to do what I find so easy with latter versions.

Workbench help doesn't help much and I can't find examples on the internet so if anyone has a clue on how to do it I'll be very grateful.

I want to use attribute values in sql statements but SQLExecutor transformer in FME v2007 looks too basic and I don't know if it's even possible to do such a thing. The image below shows what I tried and doesn't work at all. I get error: BADNEWS: Database Writer: Commit failed -- [NOTSUPPORTED] commitTransaction not supported by core library

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

david_r
Celebrity
  • david_rCelebrity
  • June 14, 2019

It's not the answer you're looking for, but you should really, really try to convince the client to upgrade. FME 2007 was retired about 7 years ago and is no longer supported by Safe.

As long as the client has a valid maintenance contract, upgrading is eas easy as downloading and installing:

https://www.safe.com/support/support-resources/fme-downloads/

PS: For the problem, try using only a single SQL statement (split it up into two different SQLExecutors) and skip the semi-colon at the end of the statement.

dms2
Contributor
Forum|alt.badge.img+11
  • dms2Contributor
  • Author
  • Contributor
  • June 14, 2019

It's not the answer you're looking for, but you should really, really try to convince the client to upgrade. FME 2007 was retired about 7 years ago and is no longer supported by Safe.

As long as the client has a valid maintenance contract, upgrading is eas easy as downloading and installing:

https://www.safe.com/support/support-resources/fme-downloads/

PS: For the problem, try using only a single SQL statement (split it up into two different SQLExecutors) and skip the semi-colon at the end of the statement.

Unfortunately it's not in my hands to try to convince them.

On the other hand I tried your suggestion and it doesn't work.

Thank you anyway.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.