Re: JDBC Update question (quoted strings) - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC Update question (quoted strings)
Date
Msg-id 41354344.9010702@opencloud.com
Whole thread Raw
In response to JDBC Update question (quoted strings)  (Gerry Gattis <GGattis@iTeamOne.com>)
List 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

pgsql-jdbc by date:

Previous
From: "David Wall"
Date:
Subject: Re: JDBC Update question (quoted strings)
Next
From: Oliver Jowett
Date:
Subject: Re: JDBC Update question (quoted strings)