Hibernate version:2.1.2

I am using Projection select clause but I am having trouble to retrieve a collection. For example, class A has a Set of class B:

class A {

.......

Set b;
public Set getB() {
return b;
}

pulbic void setB(Set b) {
this.b = b;
}

If I do:

select a.id, a.name, a.b from A a where a.id = 123

It gives error:

net.sf.hibernate.QueryException: expecting 'elements' or 'indices' after: id [

Please help!

RTM, but try:

select a.id, a.name, elements(a.b) from A a where a.id = 123