You are not mentioning if you use caching or not. For me it looks
like you get your Child records from cache.
Marcin
On 19/05/2006, at 2:09 PM, Jeff de Vries wrote:
> Simplified version: I have a parent table and a child table, where
> the child table has a parent_id column and a status column. I
> change the status in one of the child records and commit the
> change. Later, I ask for the child records for the given parent
> record, but the child record that I get back on which I changed the
> status still has the *old* status instead of the new status. If I
> look at the database, the child record does have the new status
> (and in fact I can see the update and commit as soon as I commit
> the child record change).
>
> Why is the parent still seeing the old child status? An additional
> note is that I'm not using parent.getChildArray() but rather a
> SelectQuery(Child) that matches toParent to the parent I'm
> interested in.
>
> (This is in Cayenne 1.2B2 using PostgreSQL 8.1)
>
> Thanks,
> Jeff
>
-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001 fax +61 2 9550 4001
This archive was generated by hypermail 2.0.0 : Fri May 19 2006 - 03:32:02 EDT