Trish wrote:
>
> 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=?)]
>
>
> AND
>
> Following error for another query
> getHibernateTemplate().find("from Employee as emp where emp.employeeId in
> " +
> "(select employee from EmployeesProject " +
> "where project=?)", projectId+")");
>
> Data Access Failure:
> IllegalArgumentException occurred calling getter of
> com.arrkgroup.pam.model.Project.projectId; nested exception is
> org.hibernate.PropertyAccessException: IllegalArgumentException occurred
> calling getter of com.arrkgroup.pam.model.Project.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-tp16547740s2369p16558209.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]
