topic Re: Calling Postgres function from tDBRow in Talend Studio

Calling Postgres function from tDBRow

EMeany — Sat, 16 Nov 2024 07:35:50 GMT

Hello,

I am having trouble calling a Postgres function from tDBRow.

I can call it successfully from SQL Builder (verified using DBeaver), but the generated query fails to work when used within the tDBRow component.

By 'fails' I mean that the expected results are not observed within my DB (I observe no change). However, the Job itself executes without error.

Any ideas?

Thanks

fdenis — Tue, 25 Sep 2018 08:16:28 GMT

what is your query.
did you check your db connection? is it the same?

EMeany — Wed, 26 Sep 2018 15:27:50 GMT

Thank you for the response fdenis.

It appears that the SQL Builder defaults to auto-commit, whereas the tDBRow's connection (tDBConnection) does not.

After selecting the auto-commit checkbox in tDBConnection's advanced tab, the function call works without issue.

Thanks again for your time.