Hi
i 've mapped a many-to-many association between 2 classes (Person and Segment) ; all works fine and the generated sql script is :

create table Person (
idPerson varchar(50) not null,
firstName varchar(30) not null,
primary key (idPerson)
);
create table Segment (
segmentId varchar(50) not null,
name varchar(255) not null,
line_index integer,
primary key (segmentId)
);


create table Person_segment_bridge (
idSegments varchar(50) not null, //references Segment (segmentId);
idPersons varchar(50) not null, //references Person (idPerson);
primary key (idPersons, idSegments)
);
...this generated intermediate table is not related to a java object


I'd like to load all person objects from a query that would look like this in sql :
SELECT * for Person WHERE idPerson in (SELECT idPersons FROM Person_segment_bridge psb WHERE psb.idPersons='p1')

How should i achieve this with hibernate ?

Thanxs for help

1) from Person p where p.id='p1' and exists elements(p.segments)

2) from Person p where p.id='p1' and p.segments.size > 0

Thxs sergeya but nevermind i wrote it bad : the right sql query is :

SELECT * for Person WHERE idPerson in (SELECT idPersons FROM Person_segment_bridge psb WHERE psb.idSegments='p1')

so it first look up all "p1" segments and then select all persons related to this segment.

1) from Person p join p.segments s where s.id='p1'

2) select p from Person p, Segment s where s.id='p1' and p in elements(s.persons)

3) without HQL, using mapping capability:

Segment s = (Segment)session.get(Segment.class, 'p1');

Set<Person> persons = s.getPersons();