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


Reply via email to