Having issue with tDBConnection component

[ALopez1690296959]

Running into an issue when running a job with the tDBConnection component when the job includes an INSERT or UPDATE query. When the job is run, the UPDATE or INSERT query does not actually update or insert the data into the database table.

I am not seeing any errors in talend and when I run the same query in the database console it works as intended.

Any help is appreciated.

[Anonymous]

@Anthony Lopez​ , don't forget to use a tDBCommit to commit the changes in the end of job if you use an existing DB connection created by tDBConnection.

[Olive09]

You can double-check the syntax and parameters of the UPDATE or INSERT query. It's possible that there may be a typo or issue in the query. And Make sure there are no constraints or triggers in the database table that prevent the data from being updated or inserted. You can go on official site.