topic Re: Java Error : "table" cannot be resolved to a type in Talend Studio

Java Error : "table" cannot be resolved to a type

Anonymous — Mon, 23 Oct 2017 14:04:28 GMT

Dear experts,

I have issue with my tPostgresqlRow. I would like to execute this query :

UPDATE fait_vehicule_staging SET accident_id = fait_lieu_staging.accident_id

from fait_lieu_staging

where fait_vehicule_staging.lieu_id = fait_lieu_staging.lieu_id

It works fine in a standard PGAmin for ex but not in Talend. I have this error which i don't understand :

fait_usager_staging cannot be resolved to a type

Thank you for all your answers. Best regards.

ashif2 — Mon, 23 Oct 2017 14:24:04 GMT

Please try the update statement with double quotes like below:

"
UPDATE b SET data = a.data
from a
where a.id = b.id
"

Anonymous — Mon, 23 Oct 2017 15:17:32 GMT

Hello,

Thank you for your answer.

I've tried it and I have no more this error.