tDBRow Component Returns OK Status but UPDATE Not Applied After Forced Job Termination

[malikhidayat]

Hello Team,

I’m running a Job in Talend Studio that contains many tDBRow components. The job design is roughly as follows:

tDBConnection
tDBRow_1 ---OnComponentOk--> tDBRow_2
tDBClose

In tDBRow_1, there is an UPDATE query on a table.

During execution, I performed a force stop on the job. However, the status of tDBRow_1 is shown as OK. After checking the table, no data was updated (even though the tDBRow_1 component shows OK).
I tried running the same UPDATE query directly in the SQL client, and it successfully updated the data.

What could be the possible cause of this issue, and what is the recommended solution?

Below is the configuration of tDBRow_1:

Basic settings:
- Use an existing connection → Yes
- Schema → Repository
- Die on error → No

Advanced settings:
- Propagate QUERY recordset → No
- Set Query Timeout → No
- Use Prepared Statement → No
- tStatCatcher Statistic → No

Thank you,
Best regards
Malik

[Shicong_Hong]

Hello

In this example, use a tDBCommit instead of tDBClose to commit the change and close the DB connection, check the 'Close connection' checkbox on tDBcommit.

Regards

Shicong