SQL:SELECT ev.* FROM event ev INNER JOIN person_event pe_ev ON pe_ev.id_event = ev.id AND pe_ev.id_person = :idDerPerson
Auf die Schnelle:
[HQL]SELECT e
FROM Event e
JOIN e.persons p
WHERE p.id = :idDerPerson[/HQL]
final List list = session.createQuery("SELECT e FROM Event e JOIN e.Person p WHERE
p.id = :personId").setString("personId", Long.toString(personId)).list();
<hibernate-mapping package="org.hibernate.tutorial.domain">
<class name="Event" table="EVENTS">
<id column="EVENT_ID" name="id">
<generator class="increment"/>
</id>
<property column="EVENT_DATE" name="date" type="timestamp"/>
<property name="title"/>
<set inverse="true" name="participants" table="PERSON_EVENT">
<key column="EVENT_ID"/>
<many-to-many class="Person" column="PERSON_ID"/>
</set>
</class>
</hibernate-mapping>
<hibernate-mapping package="org.hibernate.tutorial.domain">
<class name="Person" table="PERSON">
<id column="PERSON_ID" name="id">
<generator class="increment"/>
</id>
<property name="age"/>
<property name="firstname"/>
<property name="lastname"/>
<set cascade="all-delete-orphan" name="events" table="PERSON_EVENT">
<key column="PERSON_ID"/>
<many-to-many class="Event" column="EVENT_ID"/>
</set>
</class>
</hibernate-mapping>
Wie schaut denn deine Event Klasse aus? Evtl.
[HQL]SELECT e
FROM Event e
JOIN e.participants p
WHERE p.id = :idDerPerson[/HQL]
Halleluja, so funktionierts, mühsam ernährt sich das Eichhörnchen,
ich seh mich schon im Urlaub mit einem Hibernate- Buch herumlaufen, das wäre nicht das schlechteste
besten dank für deine Hilfe!!