topic tdboutput doesn't update the database (sql server) in Talend Studio

tdboutput doesn't update the database (sql server)

r1691402258 — Fri, 15 Nov 2024 21:30:57 GMT

Hi there

I'm using tdbouput to update and insert to the database. but, the database doesn't update after the run

and I can see the output using tLogRow and it's correct output but didn't insert to the DB

can anyone figure out where is the problem?

thank you.

anselmopeixoto — Tue, 08 Aug 2023 01:13:11 GMT

Hello @r r

Since you're using a tDBConnection and a tDBClose, I assume those tDBOutput components are linked to tDBConnection.

If that's the case, you'll probably need to add a tDBCommit component after the main subJob to persist the transaction on the database.

Another option would be enabling auto commit on tDBConnection advanced settings.