You need to call context.performQuery NOT performGenericQuery.
On Fri, Jul 15, 2016 at 4:56 AM Harunobu Oyama <[email protected]> wrote:
> Hi,
>
> What is the Cayenne way to execute aggregate functions?
>
> For example, SELECT MAX("reading_id") FROM "reading" ?
>
> I tried passing SQLTemplate containing the SQL written above
> to performGenericQuery method, with no luck. Are we supposed to use JDBC?
> If so, what is the best way to get the JDBC Connection?
>
> Any hint would be appreciated.
>
> thank you,
> nobu
>
