topic Re: data not inserting into locally hosted PSQL even though talend job shows data flown in Talend Studio

data not inserting into locally hosted PSQL even though talend job shows data flown

Tejas1 — Sat, 16 Nov 2024 00:14:35 GMT

A simple job design to load data into locally hosted postgresql

It shows all the 1000 rows flown into table; but when I check into shell I do not see any data- any idea?

tool version: Talend Open Studio 7.3.1

input: csv

output: locally hosted pgsql db table

appreciate any kind of thought/help here.

Re: data not inserting into locally hosted PSQL even though talend job shows data flown

Prakhar1 — Sun, 18 Apr 2021 06:47:54 GMT

on tDBConnection , goto advance settings and select the AutoCommit option.

Re: data not inserting into locally hosted PSQL even though talend job shows data flown

Anonymous — Mon, 19 Apr 2021 04:54:04 GMT

You are using tDBConnection to create the DB connection and use existing DB connection on tDBxxx Component, you should use tDBcommit to commit the changes in the end of job.

Regards

Shong

Re: data not inserting into locally hosted PSQL even though talend job shows data flown

Tejas1 — Wed, 21 Apr 2021 08:08:16 GMT

thanks for the help Prakhar! records committed!