On 23/01/2008, at 2:15 PM, 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.
Is my best bet to just grab all the ordr_ids using a JDBC resultset
writing the query myself, and then create all the CayenneDataObjects
using DataObjectUtils.objectForPK(id)?
SQLtemplate should make your job much easier
http://cayenne.apache.org/doc/sqltemplate-query.html
Making Cayenne support what you want natively is more complicated:
https://issues.apache.org/cayenne/browse/CAY-552
Ari Maniatis
-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001 fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
