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
