Relationships across databases

From: Øyvind Harboe (oyvind.harbo..ylin.com)
Date: Wed Jun 20 2007 - 17:07:52 EDT

  • Next message: Mike Kienenberger: "Re: Relationships across databases"

    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
    



    This archive was generated by hypermail 2.0.0 : Wed Jun 20 2007 - 17:08:21 EDT