cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lachlan Deck <lachlan.d...@gmail.com>
Subject Re: NamedQuery / SQLTemplate keyPath validation
Date Tue, 10 Jun 2008 08:03:47 GMT
On 10/06/2008, at 5:52 PM, Lachlan Deck wrote:

> Hi Andrus,
>
> On 10/06/2008, at 5:37 PM, Andrus Adamchik wrote:
>
>> On Jun 10, 2008, at 10:31 AM, Lachlan Deck wrote:
>>
>>> Perhaps I should describe what I'm actually doing. All I need is a  
>>> way to get a count of a select query (without having to fault in  
>>> all the related objects). So is there a way to trigger that, in  
>>> order to just get a count back, with a SelectQuery without going  
>>> the sqltemplate or namedquery route?
>>
>> I think EJBQL route is the way to go for aggregate object queries.  
>> In fact Expression has 'toEJBQLString' method, but you may not even  
>> care about it.

Actually, I may indeed care... to to tweak your example are you saying  
I could do this...

>> EJBQLQuery countQuery = new EJBQLQuery("SELECT count(a) FROM Artist  
>> a WHERE a.artistName like 'A%'");

Expression expression; // assume exists
EJBQLQuery countQuery = new EJBQLQuery("SELECT count(*) FROM Artist a  
WHERE " + expression.toEJBQLString("a"));

Is that the intention?

with regards,
--

Lachlan Deck


Mime
View raw message