topic PostgresSQL - ST_GeomFromGeoJSON in Talend Studio

PostgresSQL - ST_GeomFromGeoJSON

NMangaba_TAP — Mon, 11 Nov 2019 17:47:57 GMT

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

Re: PostgresSQL - ST_GeomFromGeoJSON

Anonymous — Wed, 27 Nov 2019 08:31:38 GMT

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

Re: PostgresSQL - ST_GeomFromGeoJSON

Anonymous — Wed, 27 Nov 2019 15:28:18 GMT

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