Hi
i am using this query but getting error.
StringBuffer selectClause = new StringBuffer(
" select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, ");
selectClause.append(" jswel.businessSector, jswel.occupationTitle, jswel.mainActivities ");
StringBuffer fromClause = new StringBuffer("from CvoJsWorkExperience as jswe ");
fromClause.append(" left join jswe.CvoJsWorkExperienceLingual as jswel ");
StringBuffer onClause = new StringBuffer(" on jswe.id=jswel.cvoJsWorkExperience ");
StringBuffer whereClause = new StringBuffer(" where cvoJobseeker= ");
whereClause.append(id);
please any one modify the query which is work properly.
error messege :
ERROR com.eurodyn.cvo.facade.FacadeException: org.hibernate.QueryException: outer or full join must be followed by path expression [select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, jswel.businessSector, jswel.occupationTitle, jswel.mainActivities from com.eurodyn.euresportal.pojos.CvoJsWorkExperience as jswe inner join fetch CvoJsWorkExperienceLingual as jswel on jswe.id=jswel.cvoJsWorkExperience where cvoJobseeker= 477841]
org.hibernate.QueryException: outer or full join must be followed by path expression [select jswe.employerName, jswe.employerAddress, jswe.startFrom, jswe.endTo, jswe.visible, jswe.sortOrder, jswel.businessSector, jswel.occupationTitle, jswel.mainActivities from com.eurodyn.euresportal.pojos.CvoJsWorkExperience as jswe inner join fetch CvoJsWorkExperienceLingual as jswel on jswe.id=jswel.cvoJsWorkExperience where cvoJobseeker= 477841]