Hi,
I am developing My application using CMP EJB2.1 Spec.
In one of my entity bean I am writing followinf
EJB QL in my EJB-SELECT Query:-
-------------------------
SELECT COUNT(userid) FROM OrderMaster as o GROUP BY o.userid
-------------------------
But when I am deploying under my app server (JBOSS4.0.3), I am getting following error:-
========================================
15:05:27,328 INFO [STDOUT] javax.ejb.FinderException: Error compiling ejbql: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "GROUP" at line 1, column 44.
Was expecting one of:
<EOF>
"," ...
15:05:27,328 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:101)
========================================
Where is the problem??
Please help me.
Thank you.
Pras