Hi,
Following error found while using following query
getHibernateTemplate().find("from Employee as emp where emp.employeeId in "
+
"(select empproj.employeeId from
EmployeesProject as empproj " +
"where empproj.projectId=?)", projectId+")");
Data Access Failure Error:
could not resolve property: employeeId of:
com.arrkgroup.pam.model.EmployeesProject [from
com.arrkgroup.pam.model.Employee as emp where emp.employeeId in (select
empproj.employeeId from com.arrkgroup.pam.model.EmployeesProject as empproj
where empproj.projectId=?)]; nested exception is
org.hibernate.QueryException: could not resolve property: employeeId of:
com.arrkgroup.pam.model.EmployeesProject [from
com.arrkgroup.pam.model.Employee as emp where emp.employeeId in (select
empproj.employeeId from com.arrkgroup.pam.model.EmployeesProject as empproj
where empproj.projectId=?)]
Kindly guide me on how to refer the id Fields of the reference tables in to
the query.
Regards
Trish
--
View this message in context:
http://www.nabble.com/Help-needed-for-Many-to-Many-relation-tp16547740s2369p16557808.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]