Hi Andrus,
Am 20.01.10 17:22, schrieb Andrus Adamchik:
Short of writing custom extensions of SelectQuery, yes, EJBQL or
SQLTemplate is the answer.
We are designing a combined SelectQuery / EJBQLQuery that can be created
either via String or using API as a part of 3.1, but in 3.0 this is not
an option.
OK, thanks for your reply! I'm looking forward to 3.1 then :)
Best regards,
Andreas
Andrus
On Jan 20, 2010, at 6:10 PM, Andreas Hartmann wrote:
Hi everyone,
I'm mainly using SelectQuery queries, built using quite a complex
programmatic infrastructure. But now I have the requirement to obtain
the total number of rows (to set the Content-Range header in a REST
service).
So basically I have a SelectQuery which does
SELECT … FROM foo WHERE <whereClause> LIMIT … OFFSET …;
and I need
SELECT count(*) FROM foo WHERE <whereClause>;
Is there a straightforward way to build such a query based on the
SelectQuery's expression? I tried Expression.toEJBQL() but faced a
couple of problems which have already been described on this list
(e.g. the likeIgnoreCase issue).
Do I really have to build a string-based SQL or EJBQL query from scratch?
Thanks a lot for any hints!
Best regards,
Andreas
--
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01
--
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01
