topic Re: Having issue with tDBConnection component in Talend Studio

Having issue with tDBConnection component

ALopez1690296959 — Fri, 15 Nov 2024 21:31:16 GMT

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.

Re: Having issue with tDBConnection component

Anonymous — Fri, 04 Aug 2023 00:24:15 GMT

@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.

Re: Having issue with tDBConnection component

Olive09 — Fri, 04 Aug 2023 11:45:23 GMT

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.