Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=vBZIPhAsMPREpmPmLUpP+dvSa+zQBrypgXqyfkOjAr///Pjp7cGTZXP6StLdV/mzQ/9HdboQzOtbl2ZmTGxmp3JRN6YvsV9LjoYzKbCTFazEwbq/F+whML5SrpwFvcFQbvAs6WzSPhqVusP/vvxorTrAafOtOMPK5Z4f1Oeug6s=;
Date: Wed, 23 Jan 2008 08:38:12 -0800 (PST)
From: Adam Yocum <adamyocum@yahoo.com>
Subject: Re: Join over Multiple Database
To: user@cayenne.apache.org
In-Reply-To: <722C5B21-57F1-4F30-B912-537D36866C8C@pvv.ntnu.no>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1441277263-1201106292=:58985"
Content-Transfer-Encoding: 8bit
Message-ID: <912920.58985.qm@web52706.mail.re2.yahoo.com>

--0-1441277263-1201106292=:58985
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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 <halset@pvv.ntnu.no> 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.
--0-1441277263-1201106292=:58985--