Re: JDBC Update question (quoted strings)

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: GGattis(at)iTeamOne(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC Update question (quoted strings)
Date: 2004-09-01 03:34:28
Message-ID: 41354344.9010702@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Gerry Gattis wrote:
> I had to make an unexpected adjustment in a query string in order to
> insert a record into a table. I was would like to know if anyone has a
> remedy for this. Here is a short description.
>
> String strInsert = "insert into myTable (lastName) values (?)";
> PreparedStatement stm = conn.prepareCall(strInsert);
> stm.setString(1, "Smith");
> // OK so far
> stm.execute();
> //fails with an error message attribute Smith not found

That sounds like a bug. What driver version are you using?

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-09-01 03:46:07 Re: JDBC Update question (quoted strings)
Previous Message David Wall 2004-09-01 03:15:02 Re: JDBC Update question (quoted strings)