topic How to use tDBCommit? in Talend Studio

How to use tDBCommit?

sbytalend — Fri, 15 Nov 2024 22:09:49 GMT

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.

Re: How to use tDBCommit?

Anonymous — Fri, 27 Jan 2023 15:53:16 GMT

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,

Re: How to use tDBCommit?

sbytalend — Mon, 30 Jan 2023 02:52:29 GMT

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?