Hello,

once again I have a question about a many-to-many association ;-).

I have an Event-Object, containing an array of Guest-Objects.
Boath are linked by the many-to-many accociaton. I used the many-to-many association as an Event-Objects contains many Guest-Objects and a Guest-Object can participate in many events. All that works fine.

Now I want to query for all Event-Objects, containing a certain guest.
For example I want to query for all events, which contain a guest with the name "Smith".

What do you think is the best way to query for this? Is it possible to get the Event-Object within one query (including sub-queries, joins, ...) or do I have to split the query in several seperate ones (E.g. get all Ids of the guests with the name "Smith", use this Ids to get all ....)?

Thank you for your answers

SunX

Hi,

I still try to query for objects containing a certain object. I can't imagine that there isn't ANY way to solve my problem, but maybe I should try to descibe it more precisely.

I have one object, containing an array of a second object.



And the mapping file for the Event-Object


<array name="Event" table="event_guest" cascade="all">
<key column="eventid"/>
<index column="idx"/>
<many-to-many class="guest" column="guestid" />
</array>



Database Structure


Now I want to query for all events, the guest 'Smith' wants to visit. (In this example only the "Concert" event)

I could query for something like



That works fine :-), but I do not want to spezify the index. I need something indexless like


Yes, that does not work, but does anyone has any idea how to do this.

Your help would be very appriciated

Thank you

SunX

You need to use a JOIN in your HQL:



Hope that helps.

Cheers,

Symon.

that is exactly what I was looking for!

Thank you so much merge_s.rottem

:-)