Database Writer: How to know whether operation was success

KNIME Analytics Platform
1

Hi,

I have database writer and MySQL connector.

For data integrity, I want to run another logic(write another database) only if database writer option was successful. I have searched most of the options in nodes but was unlucky! 

Thanks in advance.

2

Any suggestions?

 

3

I think you need to follow your database writer with a database reader node, and query for the new rows written by the writer. If the query returns no rows, then you know that there was an error. This isn't very satisfying or pretty, but I am unaware of another way to implement this.

4

Thanks for the reply.

Yes, the solution is not pretty... Let me scratch my head for some period to get around some other way !