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
: