You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Bruno René Santos <br...@holos.pt> on 2011/01/19 11:22:57 UTC

Prefetch on a Raw SQL Query on Cayenne Modeler

Hello all,

I have a query defined on the modeler which is fetched to a known data 
object. Is there any way to perform a join (or prefetch) for another 
data object that I know I will have to access too?

Thanx & Regards
Bruno

Re: Prefetch on a Raw SQL Query on Cayenne Modeler

Posted by Andrus Adamchik <an...@objectstyle.org>.

You can emulate joint prefetching via SQLTemplates. It requires the correct labels for prefetched entity in the result, in the form of relationshipname.COLUMN_NAME. Not sure how practical this is to configure, but the framework has this ability.

Andrus

On Jan 19, 2011, at 12:22 PM, Bruno René Santos wrote:

> Hello all,
> 
> I have a query defined on the modeler which is fetched to a known data object. Is there any way to perform a join (or prefetch) for another data object that I know I will have to access too?
> 
> Thanx & Regards
> Bruno
>