EJB-QL Query List inside Object

Question

I'm attempting to write what should be a simple (I hope) EJB-QL query.

Here are my objects:

public class Room {
     private String name;
     private List<RoomConfiguration> configs;
}

public class RoomConfiguration {
     private Integer capacity;
     private String name;
}

How can I search for rooms with a minimum capacity? A room can have multiple configurations, and each of those configurations has a different capacity.

Is Room.name = RoomConfiguration.name? – Andrey Adamovich Nov 09 '09 at 18:53 — Andrey Adamovich, Nov 09 '09 at 18:53

score 1 · Accepted Answer · answered Nov 09 '09 at 19:18

1

Something like this:

select room, config 
from Room room 
left outer join room.configs config
where config.capacity = (select min(rc.capacity) from RoomConfiguration rc)

answered Nov 09 '09 at 19:18

Andrey Adamovich

20,285
14
94
132

EJB-QL Query List inside Object

1 Answers1