title: Delete item from collection in Hibernate without loading entities
body: <p>I have three tables: </p>
  
  <pre><code>user(id, name), 
  group(id, name), 
  xref_user_group(user_id, group_id)
  </code></pre>
  
  <p>I have Two java classes:</p>
  
  <pre><code>User {
      int id;
      String name;
  }
  
  Group {
      int id;
      String name;
      Set&lt;User&gt; users;
  }
  </code></pre>
  
  <p>Can I delete user from group (and not deleting user) without loading group object in memory. I need some kind of HQL query. Smth like(my imagination):</p>
  
  <pre><code>delete user from Group where user.name = :username
  </code></pre>
  
  <p>I can't add any database or Hibernate cascades. </p>
  
  <p>I need it to be transactional.</p>
  
  <p>If it is not possible to do it via HQL and without loading objects in memory what is the best solution?</p>