why I am getting error as unexpected token

user_17283165 0
Viewed 173

I am trying to update employee salary by using this query. Why I am getting unexpected token:near line 1 in JPA Query error.


 @Query("update employee set sal=  sal + 2000  where salary < :sal")
 void updateEmployeeSalary(@Param("sal") Long sal)

And this is my service method


 List<Employee> updateSalary(Long sal){
   repo.updateEmployeeSalary(sal);
   return repo.findAll();
 }
spring-boot hibernate spring java
3 Answers

You need the @Modifying annotation:

@Modifying
@Query("update employee set sal=  sal + 2000  where salary < :sal")
 void updateEmployeeSalary(@Param("sal") Long sal)
user_7834120

If you want to perform Update and Delete operation in Spring Boot JPA operation you want to declare @Modifying annotation

Why declare @Modifying annotation -> To enhance the @Query annotation to execute not only SELECT queries but also INSERT, UPDATE, DELETE, and even DDL queries

What if we forget to declare @Modifiying annotation -> Compiler throw exception InvalidDataAccessApiUsageException means query is not supported for DML operations.

clearAutomatically=true defines whether we should clear the underlying persistence context after executing the modifying query

Modified Repository:

@Modifying(clearAutomatically=true)
@query("update Employee set salary = salary + 2000 where salary< :sal")
user_134666890

I think you need to write a query like this

@Modifying
@query("update Employee e set e.salary = e.salary+2000 where e.salary< :sal")
user_171670300
Related