« Return to Thread: Inserting geometries using a JDBC PreparedStatement

Re: Inserting geometries using a JDBC PreparedStatement

by Yeroc :: Rate this Message:

Reply to Author | View in Thread

Guido,

Thanks a lot!  That's the one thing I didn't try and when you think about it, should have been the most obvious. :/  The new behavior actually makes more sense than before since calling setString() should automatically put in the appropriate quotes.  The single quotes I was putting into the string were probably being escaped.

Thanks again,
Corey

Guido Lemoine wrote:
Corey,

Apparently, you do no longer need the single quote around the LINESTRING.
I reproduced your problem and found that dropping the single quotes
solves the
problem. I am using 8.0.3/1.0. Curious.

GL

 « Return to Thread: Inserting geometries using a JDBC PreparedStatement