There are two options:
1. EJBQL. This supports "compound" results, with each result object
being an Object[], with each array element corresponding to a separate
entity or a scalar.
2. DataRows (mentioned already in this thread). Then each row is a map
that can contain arbitrary data.
Andrus
On Mar 2, 2010, at 11:30 PM, Sudheer wrote:
> Thanks Andrus for the response.
>
> Assume that named query is on more than one table and has columns
> from more
> than one table. In this case we may not be having dataobject defined
> stright
> from tables. So can I create a dataobject that just maps to named
> query?
>
> If my query is fixed, I will keep it in datamap and pass the runtime
> parameter values. But I am more interested in dynamic where condition
> constructed on existing named query. For e.g. Take a case of filter
> on list
> of objects (as mentioned above, object contains columns from mutiple
> tables). After user keys in the filter criteria, I need to constrict a
> dynamic where condition and link to existing named query.
>
> Hope I did not confuse you :)
> --
> View this message in context: http://n3.nabble.com/Direct-mapping-between-Named-query-and-Pojo-tp423239p425390.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>
This archive was generated by hypermail 2.0.0 : Wed Mar 03 2010 - 10:42:59 EST