You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by Tony Giaccone <tg...@gmail.com> on 2013/07/26 22:22:34 UTC

Two datanodes

I want to split my tables across two databases. Is it possible to model
relationships between the two domains? For example, assume I have
authentication and authorization data in one database, and domain data in
the second.

I want to link the users to the data in the domain. I want to create
relationships between the user and the domain data. To be more explicit,
imagine I have users in one database, and the orders that user has made in
a second database.

How do I model this using the modeler? Is it even possible?



Tony Giaccone

Re: Two datanodes

Posted by John Huss <jo...@gmail.com>.
You can have multiple DataMaps and DataNodes within the same cayenne
project (.xml file).  And the DataMaps can have relationships that cross
from one to the other and that reference different DataNodes.  You don't
need to put these in separate files (DataDomains) and you shouldn't unless
you really need to.

Just add another DataMap and DataNode and go to town.



On Fri, Jul 26, 2013 at 3:22 PM, Tony Giaccone <tg...@gmail.com> wrote:

> I want to split my tables across two databases. Is it possible to model
> relationships between the two domains? For example, assume I have
> authentication and authorization data in one database, and domain data in
> the second.
>
> I want to link the users to the data in the domain. I want to create
> relationships between the user and the domain data. To be more explicit,
> imagine I have users in one database, and the orders that user has made in
> a second database.
>
> How do I model this using the modeler? Is it even possible?
>
>
>
> Tony Giaccone
>