topic Re: Mysql DB update/insert: logging rows on error in Talend Studio

Mysql DB update/insert: logging rows on error

Anonymous — Thu, 06 Aug 2015 10:07:37 GMT

hi all,
I am trying to update/insert in mysql using tmysqlrow from a script file taken as input. the file contains inserts and update instructions.
Is it possible to log into a file the insert or update lines that failed whitout stopping the execution of the script (continue to the next update or insert instruction) ?
it seems that with the tmysqlrow the whole script stop at the first error and whe nusing a reject link to a tlogrow for example it does not display the row that failed (it jst displays the error message) .
thank you for your help
Regards

Re: Mysql DB update/insert: logging rows on error

Anonymous — Wed, 12 Aug 2015 12:59:00 GMT

If you want to log the process you can go to File -> Edit Project Properties -> log4j option and enable the option by enabling the checkbox in log4j tab.
You can uncheck "die on error" check box from tmysqlrow component to make job to go further even there us an error.

Re: Mysql DB update/insert: logging rows on error

Anonymous — Wed, 05 Oct 2016 05:20:06 GMT

Hi Folks,
when we uncheck the die and error option in tsybaseRow or tsybaseoutput the program runs completely skipping failed update/insert
but i wanted to log row into file which is failed to update/insert
can some one tell me how to log that?

Re: Mysql DB update/insert: logging rows on error

Anonymous — Wed, 05 Oct 2016 06:29:49 GMT

You can connect tDie with tsybaseRow or tsybaseoutput with Die on error unchecked. Then you can use tLogcatcher to catch and log the errors.