Originally posted by dhriti joshi:
I guesss select max is not supported by ejbql.
is there any way to do it,like get the entire collection of field and then find max.
please help.
thanks.
From what I know EJB-QL doesn't support max. I remember that I'd seen some ejb-ql extensions a while ago; but these will be vendor specific. What I'd do in this situation is use
jdbc directly to execute select max... statement. Just make sure that you use jdbc connection pool.