It seems not possible to do the instruction EJB QL select MAX(id) from table.
Do you know if the aggregate functions are supported by Jboss and how it is possible to use these functionalities like MAX, MIN, SUM with JBoss ?
Thank you for your answers.
I think it is not supported in 3.2.1. You can use overwrite declared-sql instead in jbosscmp-jdbc.xml.