How to update table with tDBOutput

[Anonymous]

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.

[fdenis]

can you add print screen of your component?

[Anonymous]

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.

insertionupdateupdate

[fdenis · Accepted solution]

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

[Anonymous]

Thanks it's working