kayaknya ini cuma typo doang
applicant= HibernateConnection.session
.createQuery("select applicantId,applicantName, CV.lastEducation, "+
"from Applicant as applicantId "+
"inner join applicantId.Cv as idCv "+
"left outer join idPosition.Vacancy as idPosition")
.list();
-> ralatnya : "... applicantId,applicantName ..." harusnya "...
applicantId,applicantName ..."
pake titik (.) bukan pake koma (,)
-> ralat berikutnya : "... CV.lastEducation, from Applicant as
applicantId ... "
harusnya "... CV.lastEducation from Applicant as applicantId ... "
sebelumnya 'from' harusnya tidak ada koma(,)
-> ada 'CV.lastEducation' tapi alias yang ada 'applicantId.Cv as idCv'
seharusnya, pilih salah satu, antara yg ditulis 'CV...' dan '... as
idCv' harus sama
salah satu aja, 'CV' atau idCv, jangan lupa case-sensitive.
jadi bisa dengan ralat -> idCv.lastEducation
atau -> applicantId.Cv as CV
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();
-> ralatnya : "... Vacancy vacany ..." harusnya "... Vacancy vacancy ..."
'vacancy' yah, bukan 'vacany'
--
syaiful.mukhlis
gtalk:syaiful.mukh...@gmail.com
