Hibernate version: 2.0


This is the exception which I am getting
net.sf.hibernate.QueryException: aggregate function expected before ( in SELECT:

Name and version of the database you are using: MS SQL Server 2000

I am trying to use a query which is something like

select * from Employee
where emp_id = ALL(
select distinct(emp_id) from Employee
as a where a.comp_id = :compId
)

I am using the following code to convert the hibernate query to normal
sql query



If any one has come across this error please do help me.
W.r.t to the error should I have a aggregate function in the select clause

Regards
Atul

I've never heard about the ALL operator. Is that something MS specific.

Replace the "= ALL" with the IN operator. I think this is what you want.

all() is standard ANSI SQL.

That is not the problem.

The problem is that the query is not HQL. "select *"???

Read the Hibernate documentation and look at example HQL queries.

Sorry the query is

select emp.emp_name from Employee as emp
where emp.emp_id = ALL(
select distinct(a.emp_id) from Employee
as a where a.comp_id = :compId
)

There is no such function as distinct() in HQL or SQL.

It worked

I just removed the bracket

select emp.emp_name from Employee as emp
where emp.emp_id = ALL(
select distinct a.emp_id from Employee
as a where a.comp_id = :compId
)