How to check availability of one set in another?

[Dmitriy Kastikovich]

Hi!

I have unidirection manyToMany:

@Entity
public class Market {
....
@ManyToMany(cascade = {CascadeType.PERSIST})
public List<Day> days = new ArrayList<Day>();
....

From another side I have a List<Day> workingDays and how can I get all Markets, where list of days contains all from workingDays?

Thanks.

[James Sutherland]

What do you mean by,

"another side I have a List<Day> workingDaysÈ

What is workingDays an attribute of? Or is it an argument?

In general an ALL OF type of query will used a NOT EXISTS and a sub-SELECT,

i.e.

Select m from Market m join m.days d where not exists (Select d2 from Day d2 where d2 <> d and d2 in :workingDays)