title: Spring Data JPA delete native query throwing exception
body: <p>I have a <code>User</code> entity and a <code>Role</code> entity. The relationship is defined like this:</p>
  
  <pre><code>@OneToMany
  @JoinTable(name="USER_ROLES", inverseJoinColumns=@JoinColumn(name="ROLE_ID"))
  private List&lt;Role&gt; roles = null; 
  </code></pre>
  
  <p>Now, when I delete a role, I need to delete the role from all the users that have that role. Normally you'd do something like this by looking up all the users with this role, removing the role from the list, and saving the user. However, when there could be over a million users, I don't want to be looping over this many entities in the app. So, I'm wanting to use a native query to remove rows from the <code>USER_ROLES</code> join table. I tried adding this to my repository:</p>
  
  <pre><code>@Query(value="DELETE FROM user_roles WHERE role_id = ?1", nativeQuery=true)
  public void deleteRoleFromUsersWithRole(Long roleId);
  </code></pre>
  
  <p>However, when I do this, I see the following in the logs:</p>
  
  <pre><code>[EL Fine]: sql: 2013-11-02 14:27:14.418--ClientSession(707349235)--Connection(2096606500)--Thread(Thread[http-bio-8080-exec-4,5,main])--DELETE FROM user_roles WHERE role_id = ?
     bind =&gt; [1000110139999999953]
  [EL Fine]: sql: 2013-11-02 14:27:14.478--ClientSession(707349235)--Thread(Thread[http-bio-8080-exec-4,5,main])--SELECT 1
  [EL Warning]: 2013-11-02 14:27:14.482--UnitOfWork(1795045370)--Thread(Thread[http-bio-8080-exec-4,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
  Internal Exception: org.postgresql.util.PSQLException: No results were returned by the query.
  Error Code: 0
  Call: DELETE FROM user_roles WHERE role_id = ?
      bind =&gt; [1000110139999999953]
  Query: DataReadQuery(sql="DELETE FROM user_roles WHERE role_id = ?")
  </code></pre>
  
  <p>I don't understand what <code>No results were returned by the query.</code> is saying. The record does get deleted from the database, but this exception is causing everything to blow up.</p>
  
  <p>Can someone please tell me what I'm doing wrong here?</p>