Setting column aliases ( " , expected in SELECT ...&quo

cagan327 · **Posted:** Wed Dec 29, 2004 11:43 am

Hibernate version: 2.1
Name and version of the database you are using: MySQL 4.0.12

I'm trying to write the following sql in hibernate:

Code:

select count(*) as total , category from tbl_search_tracking group by category order by total

I tried the following:

Code:

select count(*) as total, st.category from SearchTrack st where [condition]
group by st.category order by total

and it generated the following error:

Code:

com.emirca.touch.module.business.model.BusinessManager runPopularSearchReportWARNING: Error running 'search number per portal' , expected in SELECT [select new com.emirca.touch.module.business.model.SearchTrack(count(*) alias tot, st.category) from com.emirca.touch.module.business.model.SearchTrack st  where st.searchDate >= :fromDate and  st.searchDate <= :toDate  and st.portalName = :portal  group by st.category ]

Is setting column aliases not possible in Hibernate?

Thanks,
Cagan

emmanuel · **Posted:** Wed Dec 29, 2004 11:49 am

It is not possible and not needed

cagan327 · **Posted:** Thu Dec 30, 2004 9:17 am

I understand that it's not supported by Hibernate but why 'not needed'?

emmanuel · **Posted:** Thu Dec 30, 2004 11:20 am

I've never seen any use case for it :)
Seriously, the Hibernate PAI are simple enough, there is no need for alias IMO

cagan327 · **Posted:** Thu Dec 30, 2004 11:22 am

Emmanuel,

Given my query, how can I then write in HQL to order by count(*)?

Thanks
Cagan