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
This archive was generated by hypermail 2.0.0 : Wed Jan 20 2010 - 12:35:53 EST