The following bug has been logged online: Bug reference: 6285 Logged by: Gary Kenney Email address: gary.ken...@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 : -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
