Dear All,
I am new to Hibernate and I'm currently writing an application using version 3.x. I have an existing databse to work against and so I'm modelling my POJOs against these tables.

What I need to do is run an HQL query to return a Role object. This role object in turn contains a number of Participation objects which I want returning in a collection object (I've written the code for that in my Role object). What I can't get is how to map the Role and Participation objects in the configuration file. Am I along the right lines of using the <set> tag?
The SQL that I'm trying to emulate is this:

select * from Role , Participation where Role.ID = Participation.RoleID

Thanks in advance

Angus

Exactly right.
You should really consider reading the relevant section of the (easy to read) manual since it is the FIRST question everyone asks when using Hibernate - not a dig, but really, it would save you time!

You are correct though.



Then a Set is a good way to model this in the mappings.

If you model it as a lazy association, your hql would be

Once you've done this, if it doesn't work, post your mappings, java files and error stack trace and people will offer very detailed help.

Exactly right.
You should really consider reading the relevant section of the (easy to read) manual since it is the FIRST question everyone asks when using Hibernate - not a dig, but really, it would save you time!

You are correct though.



Then a Set is a good way to model this in the mappings.

If you model it as a lazy association, your hql would be

Once you've done this, if it doesn't work, post your mappings, java files and error stack trace and people will offer very detailed help.