cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Relationships across databases
Date Mon, 25 Jun 2007 08:34:48 GMT
I think the limitation has been mostly explained by others in this  
thread. So let me try to summarize:

        [works] Saving of related objects.
        [works] Resolving a relationship.
[doesn't work] Doing a query on relationship source qualified on some  
criteria applied to the target objects.

Andrus


On Jun 21, 2007, at 12:07 AM, Øyvind Harboe wrote:
> In the link below it says that relationships does not work across
> databases "as it will require Cayenne to do in memory cartesian
> product processing".
>
> What does this qualifier mean? Does it mean that it is possible to
> enable this, but it would take a lot of memory? That this feature was
> considered, but rejected as it would have not worked in all cases?
>
> For the cases that we need this, there is no problem for Cayenne to
> have both tables completely in memory (always < 1000 records) so I'm
> not concerned about CPU processing power or memory consumption.
>
> Has any work been done on supporting this?
>
>
>
> We've got a real database (Derby) that has relationships to other
> existing datbases(MS Access/FoxPro databases). We can't move the
> existing databases into Derby due to bug-by-bug compatibility
> problems.
>
> http://cwiki.apache.org/CAY/multiple-databases-example.html
>
> -- 
> Øyvind Harboe
> http://www.zylin.com - eCos ARM & FPGA  developer kit
>


Mime
View raw message