> Please try the old query in case you switch to a newer glassfish version and let me know whether it makes any difference.
Exception [TOPLINK-6121] (Oracle TopLink Essentials - 9.1 (Build b33e-beta)): oracle.toplink.essentials.exceptions.QueryException
Exception Description: The query has not been defined correctly, the expression builder is missing. For sub and parallel queries ensure the queries builder is always on the left.
I found the reason was not the "missing" JOIN: count (distinct konto.uid) works (I mean count(distinct konto) generates the error, even with the join - you cannot make distinct <object>, but toplink accepts distict <object>.<primary key>). - count (distinct ksli.konto.uid) also works (without the join).
I do not know what the spec says, but it makes no sense: a count of distinct objects is the same as count of distinct object's primary keys.
Query results seem correct.
Thanks
Edek
[Message sent by forum member 'edek234' (edek234)]
http://forums.java.net/jive/thread.jspa?messageID=215097