PreparesStatement.setString() is exactly what I am doing and any
string with an apostrophe throws a syntax exception. I'm very glad to
hear this is supposed to work.
Pseudo code for what I am doing
String s = JTextfield.getText();
send to server
I'm using postgres 8.1.3 with development driver for 8.2 since I was
having problem with driver version 405. Upgrade to JDBC driver did
Thanks for your response.
On 5/16/06, Kris Jurka <books(at)ejurka(dot)com> wrote:
> On Tue, 16 May 2006, Chuck Davis wrote:
> > Does anybody know if there is a plan to make the driver handle java
> > strings appropriately? I have hit a showstopper. If I enter data in
> > a JTextfield with an apostrophe the driver chokes with a syntax error.
> > I don't know how IBM does it but their JDBC driver handles
> > apostrophes without a problem. DB2 has been my main database but I'm
> > evaluating Postgresql on Linux. I can't ask my users to avoid
> > entering data with an apostrophe and I'm too lazy to program around it
> > since I know it can be done otherwise once and for all.
> If you use PreparedStatement.setString, any required quoting/escaping
> should be done for you. If you are building a SQL string yourself than
> you are responsible for escaping it correctly. You haven't said what
> you're doing, but I find it hard to believe that it's postgresql's fault
> or that DB2 has some magic to interpret bad data. Perhaps you could be
> more specific in what your code is doing?
> Kris Jurka
In response to
pgsql-jdbc by date
|Next:||From: A.M.||Date: 2006-05-16 19:05:28|
|Subject: Re: COPY rehashed|
|Previous:||From: Kris Jurka||Date: 2006-05-16 18:46:24|
|Subject: Re: JDBC driver and java strings|