JPQL doubt

[Aditya Vasudeva]

in the spec, it clearly says that a path expression in the SELECT clause cannot be composed to get a collection by another path expression. To get a collection, an identification variable must be declared in the FROM clause.

If this is so, then why is the following code correct in one of the enthuware questions:

  
select count(s.presentations) from Student s

where, presentations is a collection field in Student !!


the question is in Test 2 of Enthuware.
please help...

[Vinay Nath]

you can use aggregate functions, coz it results a scalar, Only when the result can be a collection it is a problem.

[Rafael Rocha]

Originally posted by Vinay Nath:
you can use aggregate functions, coz it results a scalar, Only when the result can be a collection it is a problem.

i have same doubt. i always meet that function 'COUNT' don't accept object complex in parameter function agregate.

how is this?
[ July 19, 2008: Message edited by: Rafael Rocha ]