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@it.maidstone.gov.uk]
> Sent: Wednesday, July 26, 2000 11:48 PM
> To: 'Dnesbitt@encryptix.com'; pgsql-interfaces@postgresql.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@encryptix.com [mailto:Dnesbitt@encryptix.com]
> Sent: Thursday, July 27, 2000 5:41 AM
> To: pgsql-interfaces@postgresql.org
> Cc: Dnesbitt@encryptix.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
>