0 Replies Latest reply on Jul 22, 2003 2:46 PM by Fernando Matias Valadao

    EJB-QL Error

    Fernando Matias Valadao Newbie

      I've been to deploy a CMP to JBoss with no sucess. In WAS 5.0 Test environment, everything works just fine.
      When I deploy the CMP to JBoss, I get this error message:

      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'select object(o) from Pe
      rgunta o where o.codPai = ?1 and o.codVersaoPai = ?2'; - nested throwable: (org.jboss.ejb.plugins.cm
      p.ejbql.ParseException: Encountered "o.codPai" at line 1, column 42.
      Was expecting one of:
      "NOT" ...
      "(" ...
      <COLLECTION_VALUED_PATH> ...
      <STRING_VALUED_PATH> ...
      "CONCAT" ...
      "SUBSTRING" ...
      <BOOLEAN_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      <ENTITY_VALUED_PATH> ...
      <IDENTIFICATION_VARIABLE> ...
      <NUMERIC_VALUED_PATH> ...
      "LENGTH" ...
      "LOCATE" ...
      "ABS" ...
      "SQRT" ...
      "+" ...
      "-" ...
      <INTEGER_LITERAL> ...
      <FLOATING_POINT_LITERAL> ...
      <NUMERIC_VALUED_PARAMETER> ...
      )

      The method declaration is:


      <query-method>
      <method-name>findAllChildrenByTopKey</method-name>
      <method-params>
      <method-param>double</method-param>
      <method-param>double</method-param>
      </method-params>
      </query-method>
      <ejb-ql><![CDATA[select object(o) from Pergunta o where o.codPai = ?1 and o.codVersaoPai = ?2]]></ejb-ql>


      I was taking a look at some answers to problems similar like this, but none of them could help me.