Re: persistent.delete() ?

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