Обсуждение: Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe
От
"Johann 'Myrkraverk' Oskarsson"
Дата:
I am unable to reproduce this, with the attached code. I am using PostgreSQL 9.1.0 with the 9.1-901.jdbc4 driver on OpenIndiana. > ---------- Forwarded message ---------- > From: Gary Kenney <gary.kenney@xerox.com> > Date: Thu, Nov 3, 2011 at 4:35 PM > Subject: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax > error on apostrophe > To: pgsql-bugs@postgresql.org > > > > 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 > : > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Johann Oskarsson http://www.2ndquadrant.com/ |[] PostgreSQL Development, 24x7 Support, Training and Services --+-- | Blog: http://my.opera.com/myrkraverk/blog/
Вложения
Due to the fact that this is using a very old driver. jdbc1 has not been part of the driver for a number of years now. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Thu, Nov 3, 2011 at 7:37 PM, Johann 'Myrkraverk' Oskarsson <johann@2ndquadrant.com> wrote: > > I am unable to reproduce this, with the attached code. I am using > PostgreSQL 9.1.0 with the 9.1-901.jdbc4 driver on OpenIndiana. > >> ---------- Forwarded message ---------- >> From: Gary Kenney <gary.kenney@xerox.com> >> Date: Thu, Nov 3, 2011 at 4:35 PM >> Subject: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax >> error on apostrophe >> To: pgsql-bugs@postgresql.org >> >> >> >> 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 >> : >> >> -- >> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-bugs > > -- > Johann Oskarsson http://www.2ndquadrant.com/ |[] > PostgreSQL Development, 24x7 Support, Training and Services --+-- > | > Blog: http://my.opera.com/myrkraverk/blog/ > > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc > >