Hibernate Associations And Joins

This is a very good head starter tutorial. In one day you can jump on to hibernate. I have a suggestion that the author should use the same database and tables through out the tutorial. In Criteria and Projection, examples are different from the insurance database

Posted by Salman on Tuesday, 12.2.08 @ 19:50pm | #82296

Can anyone help me with inner joins. I am trying to build a query similar to below

SELECT s from School s, Address a where s.id=a.id

I am trying to fetch all those records from School table which has id number equal to the one in address table. I am trying to use inner jon and i am getting errors

The query I have built is

from School s inner join Address a with s.id=a.id


Please correct me if i am wrong. I have also set the mapping params in the .hbm.xml file

Thanks

Posted by Anuradha on Thursday, 05.8.08 @ 23:26pm | #58958