Re: Relationships across databases

From: Juergen Saar (juerge..saar.org)
Date: Thu Jun 21 2007 - 02:05:53 EDT

  • Next message: Øyvind Harboe: "Re: Relationships across databases"

    Cayenne is a Framework that brings one of the best ORM available
    and it would be foolish to implement such a horrible scenarium.

    I think this special problem has to be solved by YOU
    and not by the cayenne-team

    Sorry ...
    --- Juergen ---

    2007/6/20, Øyvind Harboe <oyvind.harbo..ylin.com>:
    >
    > 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 : Thu Jun 21 2007 - 02:06:26 EDT