"Not supported for DML operations" with simple UPDATE query
hibernate, hql, java, spring-mvc, sql
Solution
Check the post hibernate hql ERROR: Not supported for DML operations in the hibernate users forum.
Most likely you called
querySt.list();
for your `UPDATE` query. Instead you should call
querySt.executeUpdate();
Problem
I'm getting the error `Not supported for DML operations` when I use the following HQL... ``` @Query("UPDATE WorkstationEntity w SET w.lastActivity = :timestamp WHERE w.uuid = :uuid") void updateLastActivity(@Param("uuid") String uuid, @Param("timestamp") Timestamp timestamp); ``` What could be causing the issue? It doesn't seem to be a common error given the few results I've found in Google.