public class Merchant {
public enum Service {
A,
B,
C,
D,
E,
F,
}

@CollectionOfElements(fetch=FetchType.LAZY)
@JoinTable(name = "Merchant_Service",
joinColumns = {@JoinColumn(name = "mId")})
@Column(name="service", nullable=false, columnDefinition="smallint(2)")
@Enumerated(value=EnumType.ORDINAL)
public Set<Service> getServices() {
return services;
}

}

Every merchant provides a set of Service, such as {A, B, D}, {A, D, F}, etc.

Using Criteria API:
Query: return all Merchants that provide service A and D, ie, their services containing subset {A, D}.

Restrictions.contains(propertyName, collectionValue).

The criteria API does not provide such method.

Thanks for help.
Dave

Check out this little tutorial on the topic for some insight into the Hibernate Criteria API:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi

Hi Cameron,
Thanks for reply. I looked at the article, but it did not talk about the HOW-TO for "the set containment".
If you can help me, it would be great.

Thanks,
dave

Hi.

you can use the feature of criterias, which allows you to navigate associations using createAlias() or createCriteria(). Check
https://hibernate.bluemars.net/hib_docs ... teria.html, the second example.

I have answered similar question in this topic, so try ty check out my answer at:

viewtopic.php?f=1&t=999756

Hope it helps.
stue