I need an query example to do something like this

SELECT taskno, count(taskno) from ACTIVITY group by taskno order by taskno

Where ACTIVITY has a composite id in a ACTIVITYPK java class that is made up of these three properties: userid, date & taskno

How do I tell Hibernate that taskno is a property of ACTIVITYPK?

Here is the trace log:
[9/29/04 11:45:41:699 EDT] 15f7df77 EvaluationDAO I com.test.dao.hibernate.EvaluationDAOHibernate get all activities:
[9/29/04 11:45:41:761 EDT] 15f7df77 DispatcherSer E org.springframework.web.servlet.DispatcherServlet Could not complete request
[9/29/04 11:45:41:777 EDT] 15f7df77 DispatcherSer E org.springframework.web.servlet.DispatcherServlet TRAS0014I: The following exception was logged org.springframework.orm.hibernate.HibernateQueryException: undefined alias: taskNo [select taskNo, count(taskNo) from com.test.model.Activity group by taskNo order by taskNo]; nested exception is net.sf.hibernate.QueryException: undefined alias: taskNo [select taskNo, count(taskNo), from com.test.model.Activity group by taskNo order by taskNo]
net.sf.hibernate.QueryException: undefined alias: taskNo [select taskNo, count(taskNo) from com.test.model.Activity group by taskNo order by taskNo]

Assuming ACTIVITY has a taskno property then you need to do this..



Every property must have the object alias qualified in front of it. It isn't like SQLServer which will work it out for you if possible.

The problem is taskno is not a property of ACTIVITY. taskno is a property of ACTIVITYPK which is a composite id for ACTIVITY.

Nevermind, I got it working. Just have to quality every property with the corresponding object alias.