reg QueryException: could not resolve property

[Barry Van]

Hi

any one help on this issues QueryException: could not resolve property


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 whereClause = new StringBuffer(" where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= ");
whereClause.append(id);


ERROR com.eurodyn.cvo.facade.FacadeException: org.hibernate.QueryException: could not resolve property: CvoJsWorkExperienceLingual of: com.eurodyn.euresportal.pojos.CvoJsWorkExperience [ 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 left join jswe.CvoJsWorkExperienceLingual as jswel where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= 477841]
org.hibernate.QueryException: could not resolve property: CvoJsWorkExperienceLingual of: com.eurodyn.euresportal.pojos.CvoJsWorkExperience [ 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 left join jswe.CvoJsWorkExperienceLingual as jswel where jswe.id=jswel.cvoJsWorkExperience and jswe.cvoJobseeker= 477841]
at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(Ljava.lang.String;)V(AbstractPropertyMapping.java:43)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(Ljava.lang.String;)Lorg.hibernate.type.Type;(AbstractPropertyMapping.java:37)
at org.hibernate.persister.entity.BasicEntityPersister.toType(Ljava.lang.String;)Lorg.hibernate.type.Type;(BasicEntityPersister.java:1094)
at org.hibernate.hql.classic.PathExpressionParser.getPropertyType()Lorg.hibernate.type.Type;(PathExpressionParser.java:268)
at org.hibernate.hql.classic.FromPathExpressionParser.end(Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(FromPathExpressionParser.java:12)
at org.hibernate.hql.classic.ParserHelper.parse(Lorg.hibernate.hql.classic.Parser;Ljava.lang.String;Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(ParserHelper.java:29)
at org.hibernate.hql.classic.FromParser.token(Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(FromParser.java:197)
at org.hibernate.hql.classic.ClauseParser.token(Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(ClauseParser.java:86)
at org.hibernate.hql.classic.PreprocessingParser.token(Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(PreprocessingParser.java:108)
at org.hibernate.hql.classic.ParserHelper.parse(Lorg.hibernate.hql.classic.Parser;Ljava.lang.String;Ljava.lang.String;Lorg.hibernate.hql.classic.QueryTranslatorImpl;)V(ParserHelper.java:28)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile()V(QueryTranslatorImpl.java:176)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(Ljava.util.Map;Z)V(QueryTranslatorImpl.java:152)
at org.hibernate.impl.SessionFactoryImpl.getQuery(Ljava.lang.String;ZLjava.util.Map;)[Lorg.hibernate.hql.QueryTranslator;(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(Ljava.lang.String;Z)[Lorg.hibernate.hql.QueryTranslator;(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.list(Ljava.lang.String;Lorg.hibernate.engine.QueryParameters;)Ljava.util.List;(SessionImpl.java:834)
at org.hibernate.impl.QueryImpl.list()Ljava.util.List;(QueryImpl.java:74)
at com.eurodyn.cvo.dao.hibernate.HibernateJobseekerDataDAO.getJobseekerWorkExp(Ljava.lang.Long;)Ljava.util.List;(HibernateJobseekerDataDAO.java:949)
at com.eurodyn.cvo.facade.JobseekerDataFacade.getWorkExperience(Ljava.lang.Integer;Ljava.lang.String;)Ljava.util.List;(JobseekerDataFacade.java:5396)
at com.eurodyn.cvo.delegates.JobseekerDataDelegate.getWorkExperience(Ljava.lang.Integer;Ljava.lang.String;)Lcom.eurodyn.cvo.medusa.dto.DTO;(JobseekerDataDelegate.java:289)
at com.eurodyn.cvo.web.actions.WorkExperienceAction.getWorkExperience(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(WorkExperienceAction.java:42)
at jrockit.reflect.NativeMethodInvoker.invoke0(Ljava.lang.Object;ILjava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at jrockit.reflect.NativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Optimized Method)
at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Optimized Method)
at org.apache.struts.actions.DispatchAction.dispatchMethod(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Ljava.lang.String;)Lorg.apache.struts.action.ActionForward;(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(DispatchAction.java:194)
at org.apache.struts.action.RequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(RequestProcessor.java:419)
at com.eurodyn.cvo.web.CVORequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(CVORequestProcessor.java:55)
at org.apache.struts.action.RequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(RequestProcessor.java:224)
at com.eurodyn.cvo.web.CVORequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(CVORequestProcessor.java:49)
at org.apache.struts.action.ActionServlet.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:414)

[Mark Uppeteer]

left join jswe.CvoJsWorkExperienceLingual as jswel ");

shouldn't that be

left join jswe.cvoJsWorkExperienceLingual as jswel ");


(and if you are on java 5 you better use StringBuilder, (its faster but not thread safe).)