Hi,
I am having problem using formula...
I have somthing like this....
<property name="deptName" formula="(select dept.deptName from DepartmentDTO dept where dept.empId=empId)"/>
where deptName is a field which belongs to EmployeeDTO and i have to get the deptName from the DepartmentDTO based on the empId...i am getting a problem like java.lang.ClassCastException :org.hibernate.mapping.Formula....why is it so?my deptName in EmployeeDTO and DepartmentDTO both are String type........actually the Employee table has a primary key which is composite id (combination of empId and deptId)..can anyone help me out why am i getting this....i think this should work fine........is the problem coz of the composite id..?i am usinh hibernate3..
Thanking u in advance....

have you noticed that formula is pure SQL?

Thanks,
Actually even when i used pure sql select statements it didnt work...i think sice the property i am using is in a composite-element i think formula doesnt work within the composite element or component?am i right..?