Skip to main content
  • EN

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

 

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.

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


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie 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.