How to use tDBCommit?

[sbytalend]

Hi everyone!

I'm still in the grey area about knowing how to use tDBCommit component?

Sometimes I used it after tDBRow, but sometimes it also needed after tDBOutput (the results of the query isn't appear if not used it).

Or maybe it depend by the query, maybe if we use INSERT, SELECT, or the another?

Please help enlighten me on this.

[Anonymous]

Hi,

Thank you for reaching out!

tDBCommit serves as an entry point for the following databases. To configure this component, select a type of database from the Database list and click Apply on its Basic settings view. 

Here is an example where it was used to commit data upon transaction and close the database connection.: https://help.talend.com/r/en-US/8.0/mysql/tmysqlconnection-tmysqlinput-tlogrow-arranging-data-flow-for-parent-job-standard-component-add

Best,

[sbytalend]

Hi @Yussef Saleh​ thank you for your reply. I've seen your article, but still not clear about it. So, it should use only at the end of the job? Or should use after each tDBInput, tDBOutput, and tDBRow?