Re: Join over Multiple Database

From: Aristedes Maniatis (ar..sh.com.au)
Date: Wed Jan 23 2008 - 00:17:06 EST

  • Next message: Tore Halset: "Re: Join over Multiple Database"

    On 23/01/2008, at 2:15 PM, Adam Yocum wrote:

    > I know that Cayenne will not allow me to do this sort of join even
    > though technically the server can do it if you explicitly name all
    > the tables involved with a database prefix like the above example.
    >
    > Is my best bet to just grab all the ordr_ids using a JDBC resultset
    > writing the query myself, and then create all the CayenneDataObjects
    > using DataObjectUtils.objectForPK(id)?

    SQLtemplate should make your job much easier

    http://cayenne.apache.org/doc/sqltemplate-query.html

    Making Cayenne support what you want natively is more complicated:

    https://issues.apache.org/cayenne/browse/CAY-552

    Ari Maniatis

    -------------------------->
    ish
    http://www.ish.com.au
    Level 1, 30 Wilson Street Newtown 2042 Australia
    phone +61 2 9550 5001 fax +61 2 9550 4001
    GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

    This archive was generated by hypermail 2.0.0 : Wed Jan 23 2008 - 00:17:44 EST