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