title: Not supported for DML operations with JPA update query
body: <p>This has been asked once before but the solution did not solve the issue. I am creating a JUnit test:</p>
  
  <pre><code> @Test
      @Transactional
      @Modifying
      public void updateMaterialInventory() throws Exception{
  
          // Initialize the database
          materialRepository.saveAndFlush(material);
  
          long id =  material.getId();
          materialRepository.updateMaterialInventory(id,UPDATED_INVENTORY_COUNT);
  
          assertEquals(material.getInventory_count(), UPDATED_INVENTORY_COUNT, 0);
      }
  </code></pre>
  
  <p>The query the above test is calling is:</p>
  
  <pre><code> @Query("UPDATE Material m SET m.inventory_count = ?2 WHERE m.id = ?1")
      void updateMaterialInventory(Long id,int newInventoryAmount);
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>Caused by: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [UPDATE com.htd.domain.Material m SET m.inventory_count = ?2 WHERE m.id = ?1]
      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:318)
      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:369)
      at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
      at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
      at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
      at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
      at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
      ... 55 more
  </code></pre>