Skip site navigation (1) Skip section navigation (2)

RE: JDBC problem with DELETE

From: Dnesbitt(at)encryptix(dot)com
To: TDwelle(at)xperts(dot)com, 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: JDBC problem with DELETE
Date: 2000-08-01 00:13:44
Message-ID: 19016070071ED411B61300508BAC4B750418D8@exch1etix.encryptix.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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
> > > >
> > 
> 

pgsql-interfaces by date

Next:From: Tim UckunDate: 2000-08-01 02:06:48
Subject: Re: Access and Postgres question.
Previous:From: Lamar OwenDate: 2000-07-31 18:54:44
Subject: Re: PSQL Working, but PGAccess Not Connecting.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group