PostgresSQL - ST_GeomFromGeoJSON

[NMangaba_TAP]

HI, 

I have a simple insert into statement i'm trying to execute using PostgresSQL. In other tools the statement works as expected, however when using the PostgresRow component it flags an error 'delete token on error'

INSERT INTO xx.xxx (geom, grid, verificationstatus, submitter)
VALUES ((ST_SetSRID(ST_GeomFromGeoJSON('{"type":"LineString","coordinates":[[-4.5346101,50.8679411],[-4.5327421,50.8675484],[-4.5316245,50.8672181],[-4.5310114,50.8670082]]}'), 4326)),
77222, 1, 'TapTest2')

we need to overcome this as soon as possible. 

Thans

[Anonymous]

Hello,

For compilation problems, Syntax error on tokens, delete these tokens, does the java code show error?

To find which one , open your job and looks at the code ; on the right border you sould have a "red pointer" , click on it and you got the mistake. Propably a String parameters in a field without quote.

Best regards

Sabrina

[Anonymous]

Hi,

    In your SQL, you are having double quotes and due to this reason, the Talend component may not be able to identify the right SQL. Could you please add escape characters to the double quotes used within your SQL?

This will make sure that the SQL statement is closed correctly.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved