Help with EJBQL

[raja05]

Im struck trying to figure out a EJB-QL for a CMR which has a self reference to the sametable. The table structure is

empId integer,
name string,
age integer,
managerId integer references empId

How can i write a finder that will get me the list of employees for a manager?

Help!!!

TIA
Raj

[raja05]

Figured it out. I wasnt passing in the correct class for the managerID param in the ejb finder.