0 Replies Latest reply on Apr 24, 2003 3:27 PM by brettconnor

    jboss-ql parse problem - what am I doing wrong?

    brettconnor

      I'm missing something silly here, I get parse errors with a simple piece of jboss-ql almost identical to the example in the doc:

      org.jboss.deployment.DeploymentException: Error compiling JBossQL statement
      'SELECT OBJECT(o) FROM Phases AS o WHERE o.phaseClass
      = ?1 ORDER BY o.seq';
      - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at line 1, column 56.
      Was expecting one of:
      <IDENTIFICATION_VARIABLE> ...
      <ENTITY_VALUED_PARAMETER> ...
      <ENTITY_VALUED_PATH> ...

      I've tried all forms I can think of for the var - what is the syntax I should be using?
      I am trying to use jboss-ql because I want to order the result, otherwise this works fine for ejbql.

      The relevant part of jbosscmp-jdbc is:


      <query-method>
      <method-name>findForClass</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <jboss-ql>[CDATA[SELECT OBJECT(o) FROM Phases AS o WHERE o.phaseClass = ?1 ORDER BY o.seq]]</jboss-ql>


      Thanks for any help you can give.
      Brett