cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Create count(*) query based on SelectQuery
Date Wed, 20 Jan 2010 16:22:54 GMT
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.

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
>
>


Mime
View raw message