[postgis-users] jdbc PreparedStatement, setString

Markus Schaber schabi at logix-tt.com
Tue Oct 4 09:24:54 PDT 2005


Hi, Christomec,

christomec wrote:

>             suburbQuery.setString(1, "'POINT("+queryPoint.x+"
> "+queryPoint.y+")'");

My Idea, besides removing the comma that strk already mentioned: Drop
the single quotes ' from inside the string (because setstring already
escapes and quotes the string.

Btw, why don't you use the the PostGIS Java classes or JTS?

If they don't fit for your purposes, please tell us, so we might
possibly fix it.

HTH,
Markus



More information about the postgis-users mailing list