cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Huss <johnth...@gmail.com>
Subject Re: How to define a raw sql in the datamap.xml file and use it through SQLTemplate
Date Wed, 21 Dec 2016 15:13:36 GMT
I haven't used MappedQuery, which may be a better solution.  But here is
the old-school way to do it.
http://cayenne.apache.org/docs/3.0/namedquery.html

You don't have to fetch DataRows, but be aware that you can only
materialize one type of Entity at a time.  And for performance you should
be sure to fetch ALL the columns of that entity - both of which it looks
like you are already doing.

John


On Wed, Dec 21, 2016 at 8:47 AM Kumar <kumar9885035454@gmail.com> wrote:

> I know setting the below property will solve the problem but i don't want
> DataRows to be return instead i want my persistent entity type.
>
> <property name="cayenne.GenericSelectQuery.fetchingDataRows" value="true"/>
>
> Thanks!
> Kumar
> ‚Äč
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message