cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <>
Subject Re: Aggregate function
Date Fri, 15 Jul 2016 14:49:31 GMT
Hi Nobu,

I have an AggregateUtils that I use:

Here is an example of code using AggregateUtils:

To use it for your example would be something like this:

SelectQuery query = new SelectQuery(Reading.class);
BigDecimal max = AggregateUtils.max(dataContext, query,

On a side note, I'm guessing "reading_id" is your primary key?  If so, why
are you trying to get the maximum value for it?  Is the primary key/id not
being generated by the database?


On Fri, Jul 15, 2016 at 5:56 AM, Harunobu Oyama <> 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

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