BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe - Mailing list pgsql-bugs

From Gary Kenney
Subject BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Date
Msg-id 201111031635.pA3GZaOK009935@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
List pgsql-bugs
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
:

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Issue with passing NULL for function parameter
Next
From: Tom Lane
Date:
Subject: Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe