Ya, terima kasih atas linknya.
On 1/12/09, mRt ITnewbies wrote:
>
> Dari pada capek-2x ngetik HQL buat testing, knp query ga di test dulu om ?
> Cobain dulu deh dari HQL Editor :) , btw NB 6.5 udah support loh HQL
> editor coba cek disini[1]
>
> [1] http://www.netbeans.org/kb/docs/java/hibernate-
Dari pada capek-2x ngetik HQL buat testing, knp query ga di test dulu om ?
Cobain dulu deh dari HQL Editor :) , btw NB 6.5 udah support loh HQL
editor coba cek disini[1]
[1] http://www.netbeans.org/kb/docs/java/hibernate-java-se.html
2009/1/11 imam baihaqi :
> Applicant (1-N) Cv
> Cv (1-N) Vacanc
dg table :
t_applicant
id_applicant
applicant_name
error:
> org.hibernate.QueryException: could not resolve property: Cv of:
> mst.hrd.hibernate.model.annotation.Applicant [select
> idApplicant.applicantName, CV.lastEducation, Vacancy.description from
> mst.hrd.hibernate.model.annotation.Applicant
Saya sdh coba spt ini masih error,
klw hql spt ini
applicant=HibernateConnection.session
.createQuery("select idApplicant.applicantName, "+
"CV.lastEducation, "+
"Vacancy.description "+
"from Applicant as idApplicant "+
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 : "... applican
Applicant (1-N) Cv
Cv (1-N) Vacancy
- untuk t_cv misalnya, kan ada colom id_applicant, itu di pojonya kok
dlm bentuk long idApplicant?
bukannya
class Cv {
Long id;
Applicant applicant;
Set vacancySet;
}
trs di hbm.xml-nya set lazy = 'false' untuk attribut applicant sama
vacancies, jd di hql-nya t
ceritanya nih ambil dari 3 tabel yg terhubung gt kan? sharusnya sih
bisa, dan sederhana,
query salman:
select applicant.idApplicant, applicant.applicantName,
cv.lastEducation, vacancy.description
from Applicant applicant, Cv cv, Vacancy vacany
where applicant.idApplicant=cv.idApplicant and cv.va
7 matches
Mail list logo