Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe - Mailing list pgsql-jdbc

From Johann 'Myrkraverk' Oskarsson
Subject Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Date
Msg-id x639e422wu.fsf@2ndquadrant.com
Whole thread Raw
Responses Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
List pgsql-jdbc
I am unable to reproduce this, with the attached code.  I am using
PostgreSQL 9.1.0 with the 9.1-901.jdbc4 driver on OpenIndiana.

> ---------- Forwarded message ----------
> From: Gary Kenney <gary.kenney@xerox.com>
> Date: Thu, Nov 3, 2011 at 4:35 PM
> Subject: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax
> error on apostrophe
> To: pgsql-bugs@postgresql.org
>
>
>
> The following bug has been logged online:
>
> Bug reference:      6285
> Logged by:          Gary Kenney
> Email address:      gary.kenney@xerox.com
> PostgreSQL version: 9.1.1
> Operating system:   Windows 7
> Description:        PreparedStatement#executeUpdate gets syntax error on
> apostrophe
> Details:
>
> The value that was assigned via PreparedStatement.setString, was "Gary's
> Document".  Note the apostrophe.  Without the apostrophe, there is no error.
>  Stack trace:
>
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
> ava:517)
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
> ava:50)
> 01 Nov 2011 16:29:09 - [Thread[Thread-63,5,main]] -    at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State
> ment.java:273)
> :
> my code
> :
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
   Johann Oskarsson                http://www.2ndquadrant.com/    |[]
   PostgreSQL Development, 24x7 Support, Training and Services  --+--
                                                                  |
   Blog: http://my.opera.com/myrkraverk/blog/

Attachment

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Trouble setting up ssl cert authentication from java/hibernate
Next
From: Dave Cramer
Date:
Subject: Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe