Bertrand Delacretaz wrote:
Hi,
I'm using a GROUP BY HAVING query (using addGroupBy and
setHavingCriteria to a QueryByCriteria), and depending on the data I
get an "inner hasNext was false" error.
IIUC the problem is due to the SELECT COUNT [2] query used by OJB to
find out how many objects to retrieve, which in some cases finds more
objects that the main query retrieves, causing the RsIterator to fail
as it believes there are more objects to retrieve but finds the end
of the result set.
The main query does a
GROUP BY A0.DOCUMENT_ID
HAVING count(*) >= 1
Hi:
I think the clausule : [HAVING count(*) >= 1 ] creates unnecessary
processing.
Best Regards,
Antonio Gallardo.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
