[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.


More information about the postgis-users mailing list