Skip site navigation (1) Skip section navigation (2)

Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gary Kenney" <gary(dot)kenney(at)xerox(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Date: 2011-11-03 19:19:16
Message-ID: 7360.1320347956@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbc
"Gary Kenney" <gary(dot)kenney(at)xerox(dot)com> writes:
> Description:        PreparedStatement#executeUpdate gets syntax error on
> apostrophe

> The value that was assigned via PreparedStatement.setString, was "Gary's
> Document".  Note the apostrophe.  Without the apostrophe, there is no error.

Right offhand I would guess that you are using an old JDBC driver that
isn't prepared for standard_conforming_strings to be turned on.

If that isn't it, I'd suggest asking for help on the pgsql-jdbc mailing
list; I'm not sure how many of those guys read pgsql-bugs.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-11-03 21:07:25
Subject: Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken
Previous:From: Greg FausakDate: 2011-11-03 17:57:03
Subject: BUG #6286: Table Partitioning - SQL/MED - interaction broken

pgsql-jdbc by date

Next:From: Johann 'Myrkraverk' OskarssonDate: 2011-11-03 23:37:37
Subject: Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Previous:From: Gary KenneyDate: 2011-11-03 16:35:36
Subject: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group