truck... not getting idea how to implement this?
Thanks,
Sampath Uppula.
-Original Message-
From: Aristedes Maniatis [mailto:a...@maniatis.org]
Sent: Friday, December 14, 2012 3:50 PM
To: user@cayenne.apache.org
Subject: Re: Problem in fetching the data from multiple tables with
relations
On 13/12/12 7:32pm, Sampath Uppula wrote:
Please look at the following solution... I had implemented for similar scenario.
In the below code, I am able to fetch all the data from the relationships tables. But the
problem is I am forced to hardcode the return types (List List ...).
Because of tha
ansaction_detail tt
> WHERE um.ID = ua.USER_ID
> AND ta.USER_ID = um.ID
> AND ta.TASK_TRANSACTION_ID = tt.ID
> AND um.ID = 112;
> 2. how to read the data from the result set or List?
>
> Appreciate your help.
>
> Thanks,
> Sampath Uppula
>
&g
Sent: Thursday, December 13, 2012 2:50 AM
To: user@cayenne.apache.org
Subject: Re: Problem in fetching the data from multiple tables with
relationships.
I'm not really sure what your question is. Cayenne will fetch all of the
fields that are modeled and turn them into objects. And you can add
p
from the result set or List?
Appreciate your help.
Thanks,
Sampath Uppula
-Original Message-
From: John Huss [mailto:johnth...@gmail.com]
Sent: Thursday, December 13, 2012 2:50 AM
To: user@cayenne.apache.org
Subject: Re: Problem in fetching the data from multiple tables with
I'm not really sure what your question is. Cayenne will fetch all of the
fields that are modeled and turn them into objects. And you can add
prefetching paths to your SelectQuery to pre-fetch the related objects,
otherwise they will be loaded when accessed. If you want to write your own
SQL and
