Hibernate Community • View topic - multile columns for count hql alternative

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

multile columns for count hql alternative

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

pcguy

Post subject: multile columns for count hql alternative

Posted: Sun Mar 14, 2010 3:09 pm

Newbie

Joined: Sun Mar 14, 2010 2:58 pm
Posts: 2

Hi,
I am trying to write hql for the following sql:
select (distinct item1, item2) from Test
but get an error
Caused by: org.hibernate.hql.ast.QuerySyntaxException: expecting CLOSE, found ',' near line 1, column 32 [select count(distinct o.item1, o.item2) from Test o where o.id = :el1]

Elsewhere on this forum I saw that hql doesn't support multiple columns for count, is this still the case and if so is the a preferred alternative solution without falling back to native sql?

Thank you.

Top

pcguy

Post subject: Re: multile columns for count hql alternative

Posted: Tue Nov 16, 2010 10:09 pm