select this_.candidateId as candidat2_28_0_, this_.networkId as networkId28_0_, this_.remove as remove28_0_ from NetworkCandidates this_ where network2_.networkId=? and candidate3_.candidateId=?

select this_.candidateId as candidat2_28_0_, this_.networkId as networkId28_0_, this_.remove as remove28_0_ from NetworkCandidates this_ where this_.networkId=? and this_.candidateId=?

@Entity
@Table
@AssociationOverrides({
   @AssociationOverride(name = "pk.network",
      joinColumns = @JoinColumn(name = "networkId")),
   @AssociationOverride(name = "pk.candidate",
      joinColumns = @JoinColumn(name = "candidateId"))
})
public class NetworkCandidateLink implements Serializable{

   private NetworkCandidateLinkId pk = new NetworkCandidateLinkId();
   
   private boolean remove=false;

   public NetworkCandidateLink(){}
   
   public NetworkCandidateLink(Network network, NetworkCandidate candidate){
      pk.setCandidate(candidate);
      pk.setNetwork(network);
   }
   
   @EmbeddedId
   public NetworkCandidateLinkId getPk() {
      return pk;
   }

   public void setPk(NetworkCandidateLinkId pk) {
      this.pk = pk;
   }
}

@Embeddable
public class NetworkCandidateLinkId implements Serializable{
   private Network network;
   private NetworkCandidate candidate;
   
   @ManyToOne(optional=false)
   public NetworkCandidate getCandidate() {
      return candidate;
   }

   public void setCandidate(NetworkCandidate candidate) {
      this.candidate = candidate;
   }

   @ManyToOne(cascade=CascadeType.MERGE,optional=false)
   public Network getNetwork() {
      return network;
   }

   public void setNetwork(Network network) {
      this.network = network;
   }
}

@Entity
@Table
public class Network implements Serializable{
   
   private Long id;
   private Set<NetworkCandidateLink> candidates;
   
   @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="pk.network")
   @Fetch(FetchMode.SELECT)
   public Set<NetworkCandidateLink> getCandidates() {
      return candidates;
   }
}

@Entity
@Table
public class NetworkCandidate implements Serializable {

   private Long id;
   private List<NetworkCandidateLink> networks;

   @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="pk.candidate")
   public List<NetworkCandidateLink> getNetworks() {
      return networks;
   }
}

public NetworkCandidateLink getCandidate(Long networkId, Long candidateId){
   return (NetworkCandidateLink) this.getSessionFactory().getCurrentSession().createCriteria(NetworkCandidateLink.class)
   .createAlias("pk", "pk")
   .createAlias("pk.network", "network")
   .createAlias("pk.candidate", "candidate")
   .add(Restrictions.eq("network.id", networkId))
   .add(Restrictions.eq("candidate.id", candidateId))
   .uniqueResult();
}