Hi Edek,
> 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).
glad you found a solution.
>
> BTW, is "distinct" a JPA standard, or is it a
> (common) extention?
Yes, DISTINCT is part of the standard.
>
> When I move to a newer version of glassfish I'try not
> to forget to test it with old query.
Please try the old query in case you switch to a newer glassfish version and let me know whether it makes any difference.
Thanks!
Regards Michael
>
> Thanks for support
> Edek
[Message sent by forum member 'mb124283' (mb124283)]
http://forums.java.net/jive/thread.jspa?messageID=215085