-
1. Re: table joins using CMP and EJB QL
mlapolla Sep 24, 2002 3:46 PM (in response to mlapolla)BTW, I found much of what I needed in Professional EJB published by WROX but not everything. Does someone know a better reference. I looked up the EJB QL reference on line but a better explanation would be good. More like the WROX book.
Thanks. -
2. Re: table joins using CMP and EJB QL
mlapolla Sep 24, 2002 10:35 PM (in response to mlapolla)The spec is good but now that I have a gotten the EJB QL to work, how do I recover the data.
I am using JBuilder7 and now my EJB QL looks like this:
select object(a) from Account a, SubscriberAccount sa where a.accountid = sa.accountid and sa.subscriberid = ?1
All well and good. But when I get my RemoteInterface back, it does not include the results from the sa table. They getSubscriber() method has no remote interface and when I put one on it, I get an error stating that a client is not allowed to directly access the data form a CMP RDBMS persistence manager.
So, how do I get this Cartesian product back to the client?
Do I have to process it on the server and send it back as a value object? Or a collection of value objects? That seems bogus.
Thanks.