I got my ejbSelect running well now but running in trouble with the ejb ql syntax now.
I have a entity bean called OccurrenceBean that has an relation to a topic bean and to a document bean .
Now o wish to find the 10 topics of a given document that have that have the most association to other documents.
"SELECT DISTINCT t.topic.uniqueSequence FROM Occurrence t where t.document.uniqueSequence = ?1"
1.) How to something like LIMIT 0,10
2.) how to order the result with a sub query like "Order by (Select count(t.document.uniqueSequence) FROM Occurrence"?
Thanks for any hints Stefan
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user