org.hibernate.hql.ast.QuerySyntaxException: Invalid path?

[Philippe Desrosiers]

I'm trying to determine the size of a relational set in HQL like so:

select ucp.channel from UserChannelPermission as ucp where ucp.user.login = :login and (ucp.canRead + ucp.canModify + ucp.canApprove + ucp.canRemove + ucp.canGrant >0) and ch.groups.size = 0

I'm gussing the syntax is wrong or something, because Hibernate is throwing this at me:

org.springframework.orm.hibernate3.HibernateQueryException: Invalid path: 'ch.groups.size' [select ucp.channel from com.foo.avp.model.UserChannelPermission as ucp where ucp.user.login = :login and (ucp.canRead + ucp.canModify + ucp.canApprove + ucp.canRemove + ucp.canGrant >0) and ch.groups.size = 0]; 
nested exception is org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'ch.groups.size' [select ucp.channel from com.foo.avp.model.UserChannelPermission as ucp where ucp.user.login = :login and (ucp.canRead + ucp.canModify + ucp.canApprove + ucp.canRemove + ucp.canGrant >0) and ch.groups.size = 0]
	org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:657)
	org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
	org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
	org.springframework.orm.hibernate3.HibernateTemplate.findByNamedParam(HibernateTemplate.java:947)
	com.foo.avp.dao.impl.ChannelDaoImpl.getOrphans(ChannelDaoImpl.java:41)
	com.foo.avp.view.filters.AdminSessionFilter.doFilter(AdminSessionFilter.java:156)
	com.foo.common.web.BaseFilter.doFilter(BaseFilter.java:44)

Can anyone tell me what I'm doing wrong?

[Philippe Desrosiers]

Holy crap I'm dumb. Nevermind.

[Philippe Desrosiers]

Well, dumb I may be, but it seems this issue has reared it's head again. I am once again receiving the "Invalid Path" exception, but this time the HQL looks good to me...

org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'r.enabled' [select distinct sc from com.foo.entities.RoutingRule rr inner join rr.shortcode sc where r.enabled = true and r.application is not null]

Any ideas? Am I doing something wrong here?

[Philippe Desrosiers]

heheh. Once again. I'm dumb (in case there was any doubt). The RoutingRule alias was "rr", not "r".

Pays to re-read your code once in a while.

[Rohit Mehta]

:-) very small thing - i encountered it as well ..

what was surprising that I was getting result even in case of exception ....