cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Kienenberger" <>
Subject Re: Join over Multiple Database
Date Wed, 23 Jan 2008 17:27:14 GMT
I have multiple databases, organized by DataMaps all in the same data
domain.  As long as the Oracle permissions are set up correctly, and
the schema name is specified, then there's no issues with queries or
updates across multiple databases in the same DataContext commit.

It's not a requirement to have the tables in the same Map, only the same Domain.

On 1/23/08, Adam Yocum <> wrote:
> Hi Tore,
>   Thanks, that did it.  now all my queries include the database name in the call and
the relationships across databases seem to work.  Of course if I ever split the DBs up over
different servers their might be trouble, but that's not going to happen so this is great.
>   thanks again!
>   Adam
> Tore Halset <> wrote:
>   On Jan 23, 2008, at 4:15 , 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.
> I though it should be possible to use the DbEntity schema for the
> "database prefix" and then have all the DbEntities in the same map.
> Have you tried it?
> - Tore.
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

View raw message