Six Stars

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

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

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

Please try the update statement with double quotes like below: 

 

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

2 REPLIES
Seven Stars

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

Please try the update statement with double quotes like below: 

 

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

Six Stars

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

Hello, 

Thank you for your answer. 

 

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