Skip to main content
Solved

catch error in sql-statement run in the SQLExecutor

  • June 19, 2024
  • 2 replies
  • 47 views

vki
Contributor
Forum|alt.badge.img+7

In an sql_executer I run an sql-statement that updates a table, but does not output any features. If there is an error in this update, an error message appears in the log file, but the translation as a whole is successful. 
How can I intercept this error so that the translation aborts if there is an error?

 

Best answer by nielsgerrits

One way to do this is using the LogMessageStreamer but there are probably better ways to do this, like write the script in a way to output a feature when there are errors.

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

nielsgerrits
VIP
Forum|alt.badge.img+62
  • Best Answer
  • June 19, 2024

One way to do this is using the LogMessageStreamer but there are probably better ways to do this, like write the script in a way to output a feature when there are errors.


vki
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • June 19, 2024

Thanks a lot. It works perfectly! I didn’t know this transformer.