RE: JDBC problem with DELETE

Tim,

It is not really "John Doe", but it also does not have any embedded single
quotes. It does, however, have an embedded space character. I don't know
if this has anything to do with it, but it is the only thing I can think of
that is different than line 380 in Peter's example file ImageViewer.java.

Regards,
//Dave

> -----Original Message-----
> From: Dwelle, Timothy [mailto:TDwelle(at)xperts(dot)com]
> Sent: Monday, July 31, 2000 9:13 AM
> To: 'Dnesbitt(at)encryptix(dot)com'; peter(at)retep(dot)org(dot)uk;
> petermount(at)it(dot)maidstone(dot)gov(dot)uk; pgsql-interfaces(at)postgresql(dot)org
> Subject: RE: [INTERFACES] JDBC problem with DELETE
>
>
> Dave,
>
> Um... just thought I'd ask...
>
> Are you really using "John Doe" (as in the email)
> or is that just a dummy placeholder for the real
> names you inserted?
>
> The reason why I ask is that I remember the first
> time I was bit by the ole single quote problem was
> dealing with an 'O'Connor' that, of course, really
> should have been an 'O''Connor'. Thought maybe
> something similar was happening here...
>
> -Tim.
>
>
> -----Original Message-----
> From: Dnesbitt(at)encryptix(dot)com [mailto:Dnesbitt(at)encryptix(dot)com]
> Sent: Friday, July 28, 2000 10:09 PM
> To: peter(at)retep(dot)org(dot)uk; petermount(at)it(dot)maidstone(dot)gov(dot)uk;
> pgsql-interfaces(at)postgresql(dot)org
> Cc: Dnesbitt(at)encryptix(dot)com
> Subject: RE: [INTERFACES] JDBC problem with DELETE
>
>
> Thanks, Peter. Please let me know if you see anything.
>
> I can't see how my Java code could be losing the single
> quotes. It is such
> a simple statement. But then again, I have made obvious
> coding errors that
> I just can't see a time or two in the past. :-)
>
> Why is PreparedStatement the proper safe way? From a coding
> perspective, it
> takes more lines of code and it would seem to also require
> slightly more
> computation as well.
>
> Regards,
> //Dave
>
> > -----Original Message-----
> > From: Peter Mount [mailto:peter(at)retep(dot)org(dot)uk]
> > Sent: Thursday, July 27, 2000 10:52 AM
> > To: Dnesbitt(at)encryptix(dot)com; petermount(at)it(dot)maidstone(dot)gov(dot)uk;
> > pgsql-interfaces(at)postgresql(dot)org
> > Cc: Dnesbitt(at)encryptix(dot)com
> > Subject: Re: [INTERFACES] JDBC problem with DELETE
> >
> >
> > 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(at)retep(dot)org(dot)uk, peter(at)retepdigital(dot)com,
> > me(at)petermount(dot)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(at)encryptix(dot)com>
> > To: <petermount(at)it(dot)maidstone(dot)gov(dot)uk>;
> > <pgsql-interfaces(at)postgresql(dot)org>
> > Cc: <Dnesbitt(at)encryptix(dot)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(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,
> > > > file://Dave
> > > >
> >
>