RE: JDBC problem with DELETE

Peter,

The sql does work from psql.

I also tried your suggestion about using PreparedStatement and that worked!

Am I doing something wrong with Statement or is it a bug?

Regards,
//Dave

> -----Original Message-----
> From: Peter Mount [mailto:petermount(at)it(dot)maidstone(dot)gov(dot)uk]
> Sent: Wednesday, July 26, 2000 11:48 PM
> To: 'Dnesbitt(at)encryptix(dot)com'; pgsql-interfaces(at)postgresql(dot)org
> Subject: RE: [INTERFACES] JDBC problem with DELETE
>
>
> Does this happen when you run the sql from psql?
>
> How about using PreparedStatement instead of Statement? It
> would then handle
> the quoting correctly (which is what I'm thinking is going
> wrong here).
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone
> Borough Council
>
>
> -----Original Message-----
> From: Dnesbitt(at)encryptix(dot)com [mailto:Dnesbitt(at)encryptix(dot)com]
> Sent: Thursday, July 27, 2000 5:41 AM
> To: pgsql-interfaces(at)postgresql(dot)org
> Cc: Dnesbitt(at)encryptix(dot)com
> Subject: [INTERFACES] JDBC problem with DELETE
>
>
> The following piece of code:
>
> stmt.executeUpdate("delete from friend where name='"+someName+"'");
>
> is returning:
>
> SQLException: java.sql.SQLException: ERROR: Attribute
> 'John Doe' not
> found
>
> where someName is "John Doe".
>
> Any ideas? The row where name='John Doe' is definitely in
> the table and I
> can execute the statement without problems from psql.
>
> Thanks in advance for your help.
>
> Regards,
> //Dave
>