Hi, I am using EJB 2.1 for my application & using JBOSS 4.0.3 as Application server. Now I am using JBOSS Dynamic QL for "group by" clause as follows:-
------------------------- public Collection ejbHomeSelectInStates(Set states) throws FinderException { StringBuffer jbossQl = new StringBuffer(); jbossQl.append("SELECT g.orderno "); jbossQl.append("FROM OrderMaster g "); jbossQl.append("GROUP BY g.orderno"); Object[] args = states.toArray(new Object[states.size()]); return ejbSelectGeneric(jbossQl.toString(), args); } -------------------------- & I have declared "ejbSelectGeneric" generic method is as follows using XDOCLET:- -------------------------------------------------- * @jboss.query * signature="Collection ejbSelectGeneric(java.lang.String ql, java.lang.Object[] params)" * dynamic="true" --------------------------------------------------- But when I am accessing function "ejbHomeSelectInStates" in my client, I am getting following error:- --------------------------------------------- 19:02:56,281 INFO [STDOUT] javax.ejb.FinderException: Error compiling ejbql: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "GROUP" at line 1, column 36. Was expecting one of: "," ... 19:02:56,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:101) 19:02:56,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:99) 19:02:56,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.invoke(JDBCSelectorBridge.java:70) 19:02:56,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.bridge.EntityBridgeInvocationHandler.invoke(EntityBridgeInvocationHandler.java:91) 19:02:56,281 INFO [STDOUT] at org.jboss.proxy.compiler.Runtime.invoke(Runtime.java:62) 19:02:56,281 INFO [STDOUT] at econify.ordermaster.ejb.OrderMasterCMP$Proxy.ejbSelectGeneric() 19:02:56,281 INFO [STDOUT] at econify.ordermaster.ejb.OrderMasterBean.ejbHomeSelectInStates(OrderMasterBean.java:288) 19:02:56,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 19:02:56,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 19:02:56,281 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ---------------------------------------------- I really got bored now as I am trying to solve this problem since last 15 days. Also I searched on net for same, but I am not getting actual solution for it. PLease help me to solve this problem, as my whole application got stuck due to this. Thank you. Pras View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3970751#3970751 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3970751 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user