users@glassfish.java.net

Java Query Language and aggregation?

From: <glassfish_at_javadesktop.org>
Date: Tue, 27 Mar 2007 07:45:43 PST

why does

em.createQuery("select max(y.id) from RecommendationRecord y")

work
but

em.createQuery("select (max(y.id)+1) from RecommendationRecord y")

does not work??

(This is a sub query, so the computation should be done with jql)

Thanks
    - stephan
[Message sent by forum member 'iceandfire' (iceandfire)]

http://forums.java.net/jive/thread.jspa?messageID=210080