saya sdh coba spt ini
applicant= (List<Applicant>) HibernateConnection.session
.createQuery("select
applicant.idApplicant, "+
"applicant.applicantName,
"+
"cv.lastEducation,
"+
"vacancy.description
"+
"from
Applicant applicant, "+
"Cv
cv, "+
"Vacancy
vacany "+
"where
applicant.idApplicant=cv.idApplicant "+
"
and cv.vacancy=vacancy.idPosition")
.list();
tetapi masih error
2008-10-30 12:33:23,359 [AWT-EventQueue-0] ERROR org.hibernate.hql.PARSER
Invalid path: 'vacancy.description'
2008-10-30 12:33:23,359 [AWT-EventQueue-0] ERROR org.hibernate.hql.PARSER
Invalid path: 'vacancy.idPosition'
2008-10-30 12:33:23,375 [AWT-EventQueue-0] ERROR org.hibernate.hql.PARSER
right-hand operand of a binary operator was null
org.hibernate.hql.ast.QuerySyntaxException: Invalid path:
'vacancy.description' [select applicant.idApplicant,
applicant.applicantName, cv.lastEducation, vacancy.description from
mst.hrd.hibernate.model.annotation.Applicant applicant,
mst.hrd.hibernate.model.annotation.Cv cv,
mst.hrd.hibernate.model.annotation.Vacancy vacany where
applicant.idApplicant=cv.idApplicant and cv.vacancy=vacancy.idPosition ]
at
org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at
org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at
org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at
org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:235)
apakah ada yg salah degan pembuatan model/relasinya
