Spring Boot JPA: @Modifying @Query has no effect

Question

I'm trying to increase performance by executing one request instead of updating each entity. The sql looks right and the call to this method is executed but I see no "update" executed in hibernate log.

@Modifying
@Query("UPDATE Order x SET x.reservedByClient = :value WHERE x.tourId = :id")
public void updateReservationStatus(@Param("value") Boolean value, @Param("id") Long id);

Any hints where to look ?

Arnie Schwarzvogel. just as the solution offered by Dvorog. the anotation "@Transactional" should be added. and you can try to solve the problem by yourself depend on the exeception log, in this case, i bet that you have received the log such as Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query", — Michael
– Michael, Commented Jul 18, 2018 at 7:45

Dimitar Spasovski · Accepted Answer · 2018-07-18 07:36:00Z

2

Modifiying queries should be wrapped in a transaction. Try adding @Transactional to the query.

@Modifying
@Query("UPDATE Order x SET x.reservedByClient = :value WHERE x.tourId = :id")
@Transactional
public void updateReservationStatus(@Param("value") Boolean value, @Param("id") Long id);

edited Jul 18, 2018 at 7:36

answered Jul 17, 2018 at 23:15

Dimitar Spasovski

2,18210 gold badges29 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lova Chittumuri Over a year ago

@Transactional will be used in the service layer. can we use in the repository level . correct me if i am wrong.

Dimitar Spasovski Over a year ago

@Transactional can be used in both layers (service and repository). It depends on what you want to do.

Collectives™ on Stack Overflow

Spring Boot JPA: @Modifying @Query has no effect

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related