Ok, but then shouldn't I be using DeleteBatchQuery? I remember reading
on the mailing list a while back that it should be used instead of
DeleteQuery. The problem with DeleteBatchQuery is that its Javadoc isn't
clear to me; I'm not sure how to use it.
Gili
Cris Daniluk wrote:
> http://objectstyle.org/cayenne/api/cayenne/index.html
>
> I can't think of a single reason not to have DeleteQuery in your
> Cayenne toolbox. SQLTemplate may be more appropriate for what you're
> doing (I have no idea), but DeleteQuery is definitely an affective way
> to delete bulk data while preserving the integrity of the object graph
>
> Cris
>
> On 9/5/05, Gili <cowwo..bs.darktech.org> wrote:
>
>> I believe Andrus mentioned I should only be using the standard three
>>types of queries (there are no guarantees if I use anything else) and
>>DeleteQuery wasn't one of them.
>>
>> The method you mention in this and the previous email seem to require
>>the operation to occur on the application-end. For performance reasons,
>>I really would prefer running all of this directly on the server.
>>
>>Gili
>>
>>Cris Daniluk wrote:
>>
>>>I would store a separate collection of the objects you deleted, then
>>>invalidate them from the cache. Even still though, I'm not sure that
>>>this would catch all relationships and whatnot (it will probably just
>>>reset relationships back to hollow).
>>>
>>>Couldn't you just use DeleteQuery?
>>>
>>>Cris
>>>
>>>On 9/4/05, Gili <cowwo..bs.darktech.org> wrote:
>>>
>>>
>>>>Hi,
>>>>
>>>> http://www.objectstyle.org/cayenne/userguide/fetch/sqltemplate.html
>>>>mentions that ObjectStore might be inconsistent after a SQLTemplate, but
>>>>what are we supposed to do then? In Hibernate one would invoke
>>>>session.flush() which forces the synchronization of all cached objects
>>>>with the DB. Does Cayenne have an equivilent method?
>>>>
>>>> I want to be able to bulk-delete objects using SQLTemplate (as opposed
>>>>to using a SelectQuery) for performance reasons and then update the
>>>>cache so I can continue within the same data context.
>>>>
>>>>Gili
>>>>--
>>>>http://www.desktopbeautifier.com/
>>>>
>>>
>>>
>>--
>>http://www.desktopbeautifier.com/
>>
>
>
-- http://www.desktopbeautifier.com/
This archive was generated by hypermail 2.0.0 : Mon Sep 05 2005 - 17:20:18 EDT