From: Peter Mount <peter@retep.org.uk>
To: Dnesbitt@encryptix.com
To: petermount@it.maidstone.gov.uk
To: pgsql-interfaces@postgresql.org
Cc: Dnesbitt@encryptix.com
Subject: Re: JDBC problem with DELETE
Date: Thu, 27 Jul 2000 18:51:59 +0100
Message-ID: <000101bff854$8027da60$072629d4@retep.org.uk> (raw)
References: <19016070071ED411B61300508BAC4B750418BF@exch1etix.encryptix.com>
I'm not sure, but it might be loosing the quote somewhere.
The proper safe way is to use PreparedStatement. I'll try it here just to
make sure it isn't a bug though.
Peter
--
Peter T Mount peter@retep.org.uk, peter@retepdigital.com, me@petermount.com
Homepage: http://www.retep.org.uk Contact details @ http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF generator: http://www.retep.org.uk/pdf/
----- Original Message -----
From: <Dnesbitt@encryptix.com>
To: <petermount@it.maidstone.gov.uk>; <pgsql-interfaces@postgresql.org>
Cc: <Dnesbitt@encryptix.com>
Sent: Thursday, July 27, 2000 5:55 PM
Subject: RE: [INTERFACES] 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,
> file://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,
> > file://Dave
> >
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: peter@retep.org.uk, Dnesbitt@encryptix.com, petermount@it.maidstone.gov.uk
Subject: Re: JDBC problem with DELETE
In-Reply-To: <000101bff854$8027da60$072629d4@retep.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox