glassfish_at_javadesktop.org a écrit :
> 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>=:?1 AND ks.dzien<=:?1 GROUP BY ks.dzien"
>
hello,
perhaps it is because symbols >= et <= are URL Encoded in your query (
ks.dzien>=:?1 AND ks.dzien<=:?1 )
cyrille
> or (same result)
> "SELECT ksli.owner.dzien count(ksli), count (distinct ksli.konto), sum(ksli.timeSpentSeconds) FROM KontaStatsLoginInfo ksli WHERE ksli.owner.dzien >=?1 AND ksli.owner.dzien <= ?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>=?1 AND ks.dzien<=?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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>
>