Hello and sorry for my bad english in this message, I don't speak this langage very well ;).
I want to deploy an application which contains CMP
EJBs with finders and no matter what I do I've the
same error :
Depends On Me: org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "2" at line 4, column 43.
Was expecting one of:
In spite of that my request seems good in my ejb-jar.xml
deployment descriptor file :
FROM JBossUser j
WHERE j.portalID = ?1
AND j.organizationID = ?2
I've tested also to put my request into the jbosscmp-jdbc.xml file between some <jboss-ql> marks but it seems conflicts with the ejb-jar declaration, and when my <ejb-ql> (in ejb-jar.xml file) is empty, my ejb-jar dtd is not respected. The other requests are correctly deployed but not this one and I don't know what can be the reason of this mistake.
Thanks for your help if you have some ideas ;).
I had a very similar error, which was caused by invalid SQL within an <ejb-ql> statement. However, it occurred somewhere else in the ejb-jar.xml file, *not* in the class that reported the error in the JBoss log.
You might want to review every <ejb-ql> statement in your entire ejb-jar.xml file, and remove any invalid syntax that appears anywhere. This solved my problem.