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