From: <glassfish_at_javadesktop.org>
Date: Sat, 28 Apr 2007 17:01:19 PDT

Hello,

I get the error:

Exception [TOPLINK-6121] (Oracle TopLink Essentials - 2006.8 (Build 060830)): 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.

The query is
"SELECT ks.dzien, count (ksli), count(distinct ksli.konto),sum(ksli.timeSpentSeconds) FROM KontaStatsLoginInfo ksli JOIN ksli.owner ks WHERE ks.dzien&gt;=:?1 AND ks.dzien&lt;=:?1 GROUP BY ks.dzien"

or (same result)
"SELECT ksli.owner.dzien count(ksli), count (distinct ksli.konto), sum(ksli.timeSpentSeconds) FROM KontaStatsLoginInfo ksli WHERE ksli.owner.dzien &gt;=?1 AND ksli.owner.dzien &lt;= ?1 GROUP BY ksli.owner.dzien"

or ( also same result )
"SELECT ks.dzien, count (ksli), count(distinct ksli.konto),sum(ksli.timeSpentSeconds) FROM KontaStats ks JOIN ks.loginInfos ksli WHERE ks.dzien&gt;=?1 AND ks.dzien&lt;=?2 GROUP BY ks.dzien"

What is wrong with these queries? How to rewrite them?

Thanks,
Edek
[Message sent by forum member 'edek234' (edek234)]

http://forums.java.net/jive/thread.jspa?messageID=214789