Solved: Java Error : "table" cannot be resolved to a type - Qlik Community

Anonymous · ‎2017-10-23

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 · ‎2017-10-23

Please try the update statement with double quotes like below:

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

ashif2 · ‎2017-10-23

Please try the update statement with double quotes like below:

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

Anonymous · ‎2017-10-23

Hello,

Thank you for your answer.

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

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