How to update table with tDBOutput

Four Stars

How to update table with tDBOutput

Hello,

 

I tried to update data from a postgreSQl database using tDBOutput method and I have a mistake when I run the job.

L'élément du batch 0 UPDATE "public"."places" SET "expiration_date" = 2015-12-31 00:00:00.000000 +01:00:00 WHERE "null" = FRREGI_72 a été annulé. Appeler getNextException pour en connaître la cause.
caused by: ERROR: column "null" does not exist

Can you help me please.


Accepted Solutions
Eleven Stars

Re: How to update table with tDBOutput

first link tdbCommit_1 with a "on subjob Ok" link.

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Eleven Stars

Re: How to update table with tDBOutput

can you add print screen of your component?

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: How to update table with tDBOutput

I think I may have a problem with the connection. Because when I restarted the job few hours later it's worked but today I have the same mistake for an insertion.

Capture_Schema_Insertion.PNGinsertionCapture_schema_MAJ.PNGupdateCapture_job_MAJ.PNGupdate

Eleven Stars

Re: How to update table with tDBOutput

first link tdbCommit_1 with a "on subjob Ok" link.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: How to update table with tDBOutput

Thanks it's working

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch