hi i am using
jboss 3.0.0 server and using CMP2.0 Entity bean
I am having difficulty in firing a query with order by clause.The query is listed below
<query>
<query-method>
<method-name>findByEmployeeIDAndDayID</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>
<![CDATA[SELECT OBJECT(w) FROM worklog AS w WHERE w.strEmployeeID = ?1 AND w.strDayID = ?2 ORDER BY w.timeStartTim DESC]]>
</ejb-ql>
</query>
I am getting errors
Need Help