Hi,
I found out that count(distinct klsi.konto) generates this problem, and it is possible to fix it with another JOIN klsi.konto ko, and changing count to count (distinct ko.uid). (uid is a primary key).
BTW, is "distinct" a JPA standard, or is it a (common) extention?
When I move to a newer version of glassfish I'try not to forget to test it with old query.
Thanks for support
Edek
[Message sent by forum member 'edek234' (edek234)]
http://forums.java.net/jive/thread.jspa?messageID=214919