RE: Same Table name different Node -> works?

From: Fredrik Liden (flide..ranslate.com)
Date: Thu Mar 10 2005 - 14:49:14 EST

  • Next message: Gentry, Michael \(Contractor\): "RE: Same Table name different Node -> works?"

    Thanks for respoding Michael.

    We have two different applications located on different servers.
    One app has extensive user information and login information that I want
    to use in the second app as well.

    I was thinking of creating a trimmed down version of a user table in the
    second app and synch it with the first one on a periodical basis, back
    and forth.

    My thought was to have one Node pointing to the first app and a second
    Node pointing to the second app. And both containing a table called USER
    in their map, keeping the first Node's USER table read-only (and
    hopefully prevent caching?) and then copy it's user info over to the
    second user table. Calling both tables USER.

    The reason I separate them is because I'm afraid that when user info
    changes in the first app (ouside of Cayenne) the context won't recognize
    the changes.

    I guess the easiest thing would be to just add one character to
    differentiate them :)

    Do you have any advice on a better solution?

    Thanks!

    Fredrik

    -----Original Message-----
    From: Michael Gentry (Yes, I'm a Contractor)
    [mailto:michael_gentr..anniemae.com]
    Sent: Thursday, March 10, 2005 11:29 AM
    To: cayenne-use..bjectstyle.org
    Subject: RE: Same Table name different Node -> works?

    I use the same table/Java name in one of my models, but across separate
    DataDomains (the name is unique in the DataNode). I don't believe you
    can
    duplicate it within the same DataNode, as Cayenne will not know which DB
    connection to use. I would doubt you could duplicate it within two
    separate
    DataNodes under a common DataDomain.

    Can I ask why you are wanting to do this? There might be a better
    solution
    to your problem.

    /dev/mrg

    -----Original Message-----
    From: Fredrik Liden [mailto:flide..ranslate.com]
    Sent: Thursday, March 10, 2005 12:53 PM
    To: cayenne-use..bjectstyle.org
    Subject: Same Table name different Node -> works?

    Hi,

    Is it possible to use the same table name under different Notes?
    Can they be qualified somehow with the Node info?
    I'm trying to find this on the list but can't seem to find the answer.

    Thanks,

    Fredrik

    This archive was generated by hypermail 2.0.0 : Thu Mar 10 2005 - 14:48:31 EST