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
:
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 |
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 |