From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | "Johann 'Myrkraverk' Oskarsson" <johann(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>, gary(dot)kenney(at)xerox(dot)com |
Subject: | Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe |
Date: | 2011-11-04 10:31:20 |
Message-ID: | CADK3HHKWriyptJK2uEJuDZHDEgXyz4EKWZEzhAJJqJ=i7P431A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-jdbc |
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(at)2ndquadrant(dot)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(dot)kenney(at)xerox(dot)com>
>> Date: Thu, Nov 3, 2011 at 4:35 PM
>> Subject: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax
>> error on apostrophe
>> To: pgsql-bugs(at)postgresql(dot)org
>>
>>
>>
>> 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
>> :
>>
>> --
>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-11-04 10:46:37 | Re: tsearch prefix searching doesn't work when last char of prefix is accent char |
Previous Message | Pavel Stehule | 2011-11-04 09:42:31 | tsearch prefix searching doesn't work when last char of prefix is accent char |
From | Date | Subject | |
---|---|---|---|
Next Message | Johann 'Myrkraverk' Oskarsson | 2011-11-05 07:27:42 | Re: Fwd: Re: [BUGS] BUG #6253: JDBC driver: getIndexInfo() returns quotes around quoted column names |
Previous Message | Johann 'Myrkraverk' Oskarsson | 2011-11-03 23:37:37 | Re: Fwd: [BUGS] BUG #6285: PreparedStatement#executeUpdate gets syntax error on apostrophe |