I want to query the max value of the column number (Long=BIGINT) in
table incident .
I did manage to get this via raw sql using SqlSelectQuery "SELECT
MAX(number) FROM Incident"
However would like to get the max value on the object query level.
I want something like this:
Expression exp=ExpressionFactory.unaryExp(Expression.MAX,
IncidentImpl.NUMBER_PROPERTY );
SelectQuery query = new SelectQuery(IncidentImpl.class,exp);
List data = ctx_.performQuery(query);
The above gives the following exception
[java] Caused by: org.postgresql.util.PSQLException: ERROR: invalid
input syntax for type boolean: "number"
[java] at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
(number is a Long on obj level - a BIGINT on DB level - getter and
setter are working- the raw max query is working to)
Does anyone know how to query the max value on an object level ?
The following thread dealt with the same problem, but the proposed
solution was a raw sql query:
http://www.objectstyle.org/cayenne/lists/cayenne-user/2003/09/0062.html
This archive was generated by hypermail 2.0.0 : Wed Feb 04 2004 - 09:57:04 EST