Re: Re: persistent.delete() ?

Vince:

Custom where clause should do the job! Just use
setCustomWhereClause(String) before calling delete...

Mike

On Tue, 2004-08-24 at 15:03, Vince Bono wrote:
> Steve, Mike,
> 
> I see some "customWhereClause" code in
> svc-persist-default/src/java/org/keel/services/persist/defaultpersist/Defaul
> tPersistent.java
> 
>         sqlCommand.append("DELETE FROM ");
>         sqlCommand.append(myMetaData.getTableName());
>         if (customWhereClause != null) {
>             sqlCommand.append(customWhereClause);
>         } else {
>             sqlCommand.append(buildWhereClauseBuffer(false));
>         }
> 
> 
> 
> Or would using svc-query-jdbc  be the better solution ?
> 
> 
> Vince
> 
> 
> 
> "Stephen Davidson" <[email protected]> wrote in
> message news:[email protected]
> > Hi Mike.
> >
> > I do object to the Database overhead that your suggestion would entail.
> >
> > Vince, if you send me a patch, I will be happy to apply it (after some
> > general testing, and making sure it does not break any Unit tests, of
> > course).  Or, if you want to open a Feature Request on SourceForge and
> > assign it to me, I will tackle it when I get a few minutes (probably
> > later this week).
> >
> > Regards,
> > Steve
> >
> > Michael Nash wrote:
> >
> > >Vince:
> > >
> > >delete is key-based, not criteria-based, so the only way (I can think
> > >of) to do what you want would be as follows:
> > >
> > >p.setField("id1", id1);
> > >p.retrieve();
> > >p.delete()
> > >
> > >then
> > >
> > >p.setField("id2", id2)
> > >p.retrieve()
> > >p.delete
> > >
> > >Of course you can do this in a loop, if there are lots of ids you want
> > >to delete...
> > >
> > >Mike
> > >
> > >On Mon, 2004-08-23 at 10:02, Vince Bono wrote:
> > >
> > >
> > >>I have a question with persists.delete()
> > >>I have a table - myTable
> > >>id1, id2, field1, field2 ... fieldn
> > >>
> > >>The  id fields are not unique.
> > >>I want to delete all rows where   id1=val1 and id2=val2
> > >>if I set
> > >>p.setField("id1", id1);
> > >>p.setField("id2", id2);
> > >>p.delete();       // will generate the command      DELETE FROM myTable;
> > >>and delete all records
> > >>p.deleteAll();    //  will not generate any  "DELETE" command
> > >>
> > >>prefixing with p.query()  doesnt appear to work either
> > >>any suggestions ?
> > >>
> > >>Thanks,
> > >>
> > >>
> > >
> > >_______________________________________________
> > >User mailing list
> > >[email protected]
> > >http://lists.keelframework.org/listinfo.cgi/user-keelframework.org
> > >
> > >
> > >
> >
> >
> > -- 
> > Java/J2EE Developer/Integrator
> > Stephen Davidson and Associates, Inc.
> > Chair, Dallas/FortWorth J2EE Sig
> > 214-724-7741
> 
> 
> 
> _______________________________________________
> User mailing list
> [email protected]
> http://lists.keelframework.org/listinfo.cgi/user-keelframework.org