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

29,729
Posts
112,949
Replies
37,371
Members
Terms & ConditionsCookie settings