Yes, I did not have to move all the Objects to the same Map. Just had to set the DB Schema setting for the DB Entities so that it prefixes with the DB name and MySQL is handling the queries fine now.
Adam
Mike Kienenberger <mkienen..mail.com> wrote:
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.
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
This archive was generated by hypermail 2.0.0 : Wed Jan 23 2008 - 16:31:34 EST