Hi,

I am facing problem with join using hibernate.
My exception is



org.springframework.orm.hibernate3.HibernateQueryException: could not
resolve property: p of:
com.vecna.project.vtrack2.data.persistent.Project [select p.id, p.name.
p.contract_num, p.status, pm.status, pm.accomplishments,
pm.upcoming_tasks, pm.issues, pm.month_of, p.pm from
com.vecna.project.vtrack2.data.persistent.Project p left join
p.pmWeeklyProgress as pm where pm is null or pm.month_of = :monthOf];
nested exception is org.hibernate.QueryException: could not resolve
property: p of: com.vecna.project.vtrack2.data.persistent.Project
[select p.id, p.name. p.contract_num, p.status, pm.status,
pm.accomplishments, pm.upcoming_tasks, pm.issues, pm.month_of, p.pm from
com.vecna.project.vtrack2.data.persistent.Project p left join
p.pmWeeklyProgress as pm where pm is null or pm.month_of = :monthOf]
org.hibernate.QueryException: could not resolve property: p of:
com.vecna.project.vtrack2.data.persistent.Project [select p.id, p.name.
p.contract_num, p.status, pm.status, pm.accomplishments,
pm.upcoming_tasks, pm.issues, pm.month_of, p.pm from
com.vecna.project.vtrack2.data.persistent.Project p left join
p.pmWeeklyProgress as pm where pm is null or pm.month_of = :monthOf]


my query is as follows:

String query =
" select p.id, p.name, p.contract_num, p.status, pm.status,
pm.accomplishments, "+
" pm.upcoming_tasks, pm.issues, pm.month_of, p.pm "+
" from project p left join pm_monthly_summary pm on
p.id=pm.project_id and pm.month_of=?";


any help?

thanks
nagesh