On Nov 26, 2003, at 3:57 AM, Bill Burke wrote:
Yes, but in EJB QL/JBOSS QL you can only select one item, so group by is useless.
I forgot to add a unique primary key to the example below. Which is what you typically select on.
Aaaaanyway, if you think GROUP BY is useless, how would I do the query that I posted earlier? Select *all* records and then filter in my session facade? That would be pretty lame as it is really a DB job.
Most app server vendors solved this by either adding GROUP BY as a EJB-QL extension or allowing real SQL in ejbSelect methods. JBoss has neither so I am not sure how to solve this at the moment.
S.
------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
