Hi
i need help i am new to hibernate


ex:

student_id_card_details--table 1

student_details-- table 2

i want to get all student details and i want one flg for who having id card


what rel/p i can give

how i can retrive


challenge?????????

Thanks & regards

you mean you want a one to one mapping between student and studentID?

how about you lay out the java classes for what you want first?

hi

i solved yesterday prob


pls help me how i can use left join in hibernate
my sql query
:
SELECT student.*,studentIdCard.cardId FROM student LEFT JOIN studentIdCard ON student.cardId = studentIdCard.cardId AND studentIdCard.StudentId = 1 where studentIdCard.year=2005 order by StudentName

this query gave correct result in mysql

i need implement this query in hibernate and spring


pls help me

well it depends on your mapping,
consider something like

select st, stid
from
student st
left outer join st.studentCard as stid
where
stid.studentId = 1 and stid.year = 2005
order by st.studentName