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

[Tejas1]

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.

[Prakhar1]

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

[Anonymous]

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

[Tejas1]

thanks for the help Prakhar! records committed!