Skip to main content
Archived

Better database transaction support

Related products:FME Form
  • September 12, 2017
  • 1 reply
  • 21 views
fmelizard
Safer
Forum|alt.badge.img+22

It might be nice if FME had improved database transaction support.

Here are some ideas:

  • Continue with the load if a record fails to insert and is rejected?
  • Ensure that child-parent records are written inside the same transaction.
  • Share a transaction between the FeatureWriter and the SQLExecutor.
  • In the FeatureWriter, output features (via rejected port) that failed to commit, but also continue to write the remaining data.
  • Control when transactions are shared between SQLExecutors and writers.

I wonder what others think is important?

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.

1 reply

fmelizard
Safer
Forum|alt.badge.img+22
  • fmelizardSafer
  • Author
  • Safer
  • September 12, 2017
Safe PR#26247

 

 

Community Stats

32,712
Posts
124,113
Replies
41,186
Members
Terms & ConditionsAccessibility 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.