How can I create a SetJoin in JPA if there is no Set in my member element?

Question

Im using JPA 2.0, Hibernate 4.1.0.Final and MySQL 5.5.37. I have the following objects

@Entity
@Table(name = "user_subscription",
    uniqueConstraints = { @UniqueConstraint(columnNames = { "USER_ID", "SUBSCRIPTION_ID" }) }
)
public class UserSubscription
{

    @Id
    @Column(name = "ID")
    @GeneratedValue(generator = "uuid-strategy")
    private String id;

    @ManyToOne
    @JoinColumn(name = "USER_ID", nullable = false, updatable = true)
    private User user;

    @ManyToOne
    @JoinColumn(name = "SUBSCRIPTION_ID", nullable = false, updatable = true)
    private Subscription subscription;

and

@Entity
@Table(name = "Subscription")
public class Subscription implements Serializable 
{

    @Id
    @Column(name = "ID")
    @GeneratedValue(generator = "uuid-strategy")
    private String id;

    @OneToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "PRODUCT_ID")
    @NotNull
    private Product product;

Without changing entities, how do I create a JPA CriteriaBuilder query in which I search for user objects that do not have a specific subscription object "A" but have other subscription objects that match the same product as the entity "A" ,? I tried this to no avail ...

public List<User> findUsersWithSubscriptions(Subscription Subscription)
{
    final List<User> results = new ArrayList<User>();
    final CriteriaBuilder builder = m_entityManager.getCriteriaBuilder();
    final CriteriaQuery<UserSubscription> criteria = builder.createQuery(UserSubscription.class);
    final Root<UserSubscription> root = criteria.from(UserSubscription.class);

    Join<UserSubscription, Subscription> SubscriptionRoot = root.join(UserSubscription_.subscription);

    criteria.select(root).where(builder.equal(root.get(UserSubscription_.Subscription).get(Subscription_.product),subscription.getProduct()),
                                builder.notEqual(root.get(UserSubscription_.subscription), subscription));

I thought that if I could create SetJoin from user -> subscription objects, I could say something like "not.in", but Im not sure how to do this given the limitations.

Edit: This is SQL created by Vlad Post:

SELECT user1_.id AS id97_,      user1_.creator_id AS CREATOR15_97_,      user1_.dob AS DOB97_,      user1_.enabled AS ENABLED97_,      user1_.expiration AS EXPIRATION97_,      user1_.first_name AS first5_97_,      user1_.grade_id AS GRADE16_97_,      user1_.incorrect_logins AS INCORRECT6_97_,      user1_.last_name AS last7_97_,      user1_.middle_name AS middle8_97_,      user1_.organization_id AS organiz17_97_,      user1_.password AS password97_,      user1_.reset_state AS RESET10_97_,      user1_.salutation AS salutation97_,      user1_.temporary_password AS 12_97_,      user1_.url AS url97_,      user1_.user_demographic_info_id AS USER18_97_,      user1_.user_name AS user14_97_ FROM sb_user_subscription subscription0_      INNER JOIN sb_user user1_              ON subscription0_.user_id = user1_.id      INNER JOIN cb_subscription subscription2_              ON subscription0_.subscription_id = subscription2_.id      INNER JOIN sb_product product3_              ON subscription2_.product_id = product3_.id                  product3_.id =?                 AND subscription2_.id < > ?

Answer 1

:

final CriteriaBuilder builder = m_entityManager.getCriteriaBuilder();
final CriteriaQuery<User> criteria = builder.createQuery(User.class);
final Root<UserSubscription> root = criteria.from(UserSubscription.class);

Join<UserSubscription, User> userJoin = root.join(UserSubscription_.user);
Join<UserSubscription, Subscription> subscriptionJoin = root.join(UserSubscription_.subscription);
Join<Subscription, Product> productJoin = subscriptionJoin.join(Subscription_.product);

criteria
    .select(userJoin)
    .where(cb.and(
         builder.equal(productJoin, subscription.getProduct()),
         builder.notEqual(subscriptionJoin, subscription)
);
return entityManager.createQuery(criteria).getResultList();

, " " , .

SQL, :

"A", , "A"