Hi Trish,
Trish wrote:
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+")");
You are appending a right-parenthesis ")" to your projectId variable so
if your projectId is 12345, you are feeding 12345) in to your query
parameter.
IOW, the last line of your query string should read:
"where empproj.projectId=?)", projectId);
HTH,
Rob Hills
Waikiki, Western Australia
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
