0 Replies Latest reply on Jul 9, 2003 7:36 AM by Dzidas

    order by bool type

    Dzidas Newbie

      Hello,
      I have CMP bean and I declare follow expression in jbosscmp-jdbc.xml:
      <jboss-ql>
      <![CDATA[SELECT DISTINCT OBJECT(l) FROM UserEjb as c,
      IN(c.groups) o, IN(o.clients) l
      where l.id = ?1 and c.id = ?2
      order by l.top

      ]]>
      </jboss-ql>
      where l.top is bool type.
      When I deploy, I get this error:
      state: FAILED
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Error compiling ejbql;
      - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountere
      d "l.top" at line 4, column 44.
      Was expecting one of:
      <NUMERIC_VALUED_PATH> ...
      <STRING_VALUED_PATH> ...
      <DATETIME_VALUED_PATH> ...
      )]

      Can't I order by bool type?
      Thanks for your help,
      kafka