You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cayenne.apache.org by Thilko Richter <th...@gmx.de> on 2006/08/23 09:06:35 UTC

Execution order of querys on commit

Hello @ all,

in which order(sorting) the querys are executed on commit? I have some delete/insert statements in a single transaction and it is important, that the delete statements are executed at first.


Thanks in advance.

Regards,

Thilko
-- 


Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

Re: Execution order of querys on commit

Posted by Andrus Adamchik <an...@objectstyle.org>.

Hi Thilko,

Operation sorting algorithm is handled by  
org.objectstyle.cayenne.map.EntitySorter instance. By default this is  
an instance of AshwoodEntitySorter concrete class which does the  
sorting based on object graph dependency analysis. Inserts go first  
in this algorithm. You can provide your own sorter via  
DataNode.setEntitySorter(..).

Andrus

On Aug 23, 2006, at 11:06 AM, Thilko Richter wrote:
> Hello @ all,
>
> in which order(sorting) the querys are executed on commit? I have  
> some delete/insert statements in a single transaction and it is  
> important, that the delete statements are executed at first.
>
>
> Thanks in advance.
>
> Regards,
>
> Thilko