Skip to main content
Question

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

dms2
Contributor
Forum|alt.badge.img+11
  • dms2Contributor
  • Contributor

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

 

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
david_r wrote:

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.

Reply


Helpful Members This Week

Community Stats

31,378
Posts
119,013
Replies
39,009
Members

Latest FME

Terms & ConditionsCookie settings

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
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.