RE: JDBC problem with DELETE
От | Dnesbitt@encryptix.com |
---|---|
Тема | RE: JDBC problem with DELETE |
Дата | |
Msg-id | 19016070071ED411B61300508BAC4B750418D8@exch1etix.encryptix.com обсуждение исходный текст |
Ответ на | JDBC problem with DELETE (Dnesbitt@encryptix.com) |
Список | 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@xperts.com] > Sent: Monday, July 31, 2000 9:13 AM > To: 'Dnesbitt@encryptix.com'; peter@retep.org.uk; > petermount@it.maidstone.gov.uk; pgsql-interfaces@postgresql.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@encryptix.com [mailto:Dnesbitt@encryptix.com] > Sent: Friday, July 28, 2000 10:09 PM > To: peter@retep.org.uk; petermount@it.maidstone.gov.uk; > pgsql-interfaces@postgresql.org > Cc: Dnesbitt@encryptix.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@retep.org.uk] > > Sent: Thursday, July 27, 2000 10:52 AM > > To: Dnesbitt@encryptix.com; petermount@it.maidstone.gov.uk; > > pgsql-interfaces@postgresql.org > > Cc: Dnesbitt@encryptix.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@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 > > > > > > >
В списке pgsql-interfaces по дате отправления: