Hi Ittay,
Using pessimistic locking (aka SELECT FOR UPDATE) is not supported by
object queries (SelectQuery). I guess the historical reason being a
general philosophy of "DataContext is disconnected and can span
multiple requests". Optimistic locking is a preferred way of doing
things by most users (Cayenne still uses FOR UPDATE internally in
certain cases, like PK generation and BLOB updates, but that's all
hidden from the API).
You can still do "FOR UPDATE" via SQLTemplate query.
Finally, if you have cases where such locking is important, definitely
feel free to open a feature request showing a scenario -
http://objectstyle.org/cayenne/bugs-features.html
Andrus
On Jul 14, 2004, at 4:33 AM, Ittay Dror wrote:
> hi,
>
> is there a way of running select for update queries through cayenne?
>
> thanx,
> ittay
>
> --
> ===================================
> Ittay Dror (ittay..lusters.com)
> User Space Team, R&D
> Qlusters Inc.
> +972-3-6081956 Fax: +972-3-6081841
>
This archive was generated by hypermail 2.0.0 : Wed Jul 14 2004 - 11:16:47 EDT