[postgis-users] Inserting geometries using a JDBC PreparedStatement

[Guido Lemoine]

So, did you remove the single ' quotes? I had to revise the code that used
an old JDBC driver (requiring the ' quote) to the new 8.x driver where the
use of the quote causes an error. Obviously a JDBC driver problem then.
On the "back-end" you still need the quote, i.e. when using psql. It's nice
that the new driver takes care of the quotes, but not really consistent. I
would expect the SQL statements in my Java code to be more or less the
same as in psql.

GL

Yeroc wrote:

>Markus,
>
>I tried it with both the jdbc driver I had been using previously as well as
>the new one bundled with v8.1.4.  There was no difference in behavior
>between the two drivers.  The difference appears to be in the backend.  
>
>The code is identical.  I took my existing code and just re-ran it against
>the new database.  As you say, now that I think about it, it's a wonder that
>it ever worked.  There must have been a bug (or feature? ;) in the backend
>that caused it to work before.
>
>Thanks for your reply.
>Corey
>
>
>  
>