Hello, I have a cMP Bean, but I cannot deploy it because I have this error on my query : org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(a) FROM TsaGed a where a.tsaver='0' and a.tsavis='01' and a.tsatbl = ?1 order by a.tsarga'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "order" at line 1, column 87. Was expecting one of:
"AND" ... "OR" ... )
I think, it doesn't understand order by. So what to do ? Is there any way to do this ? Shall I have to upgrade EJB-DL ? What is the solution ?
PS : I have the same error when I want to do a.tsavis like '%1%', it doesn't understand like.