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

From: "Gary Kenney" <gary(dot)kenney(at)xerox(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Date: 2011-11-03 16:35:36
Message-ID: 201111031635.pA3GZaOK009935@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc


The following bug has been logged online:

Bug reference: 6285
Logged by: Gary Kenney
Email address: gary(dot)kenney(at)xerox(dot)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
:

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Fausak 2011-11-03 17:57:03 BUG #6286: Table Partitioning - SQL/MED - interaction broken
Previous Message Heikki Linnakangas 2011-11-03 11:40:38 Re: Issue with passing NULL for function parameter

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2011-11-03 19:19:16 Re: BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Previous Message Craig Ringer 2011-11-03 09:12:13 Re: Trouble setting up ssl cert authentication from java/hibernate