posted 12 years ago
Getting this error when i run a JPA query on a view , the query is as follows
SELECT t0.qcd, t0.qcnt, t0.qdsc, t0.qsum FROM viewname t0 WHERE ROWNUM <= 20 GROUP BY t0.qcnt, t0.qdsc, t0.qsum, t0.qcd
actually the query runs fine in SQL developer but fails in JPA entity