Using @modifying with spring r2dbc

Asked Jun 21 '23 at 08:54

Active Jun 21 '23 at 11:50

Viewed 59 times

As I understand you should use @Modifying whenever you write for example update query with @Query annotation, but I've seen many times people don't use that annotation when using R2dbcRepository or CoroutineCrudRepository, so should I use this annotation using reactive stack or no?

Is there a case that I don't have to use @Modifying if I don't really use entity manager and don't use @Entity?

edited Jun 21 '23 at 11:50

asked Jun 21 '23 at 08:54

agingcabbage32

It is only when data is changed, you don't need it when you are selecting data with an `@Query` annotated method. – M. Deinum Jun 21 '23 at 09:27
@M.Deinum I get that, I was wondering about update queries – agingcabbage32 Jun 21 '23 at 09:59
Is there a case that I don't have to use @Modifying if I don't really use entity manager and don't use @Entity? – agingcabbage32 Jun 21 '23 at 11:51
The `@Modifying` is part of Spring Data JPA so I doubt it it useful on anything else. – M. Deinum Jun 21 '23 at 11:55
I use `R2dbcRepository` which is part of `springframework.data.r2dbc`, shouldn't I use `@Modifying` in that case? – agingcabbage32 Jun 21 '23 at 12:02
1

As stated is is part of Spring Data **JPA** not Spring Data **R2DBC**. So the annotation isn't even available to you (unless you are also using JPA in your application). – M. Deinum Jun 21 '23 at 12:06
there is also `@Modyfing` in `springframework.data.r2dbc` – agingcabbage32 Jun 21 '23 at 12:21
Well then use it (and [the javadoc](https://docs.spring.io/spring-data/r2dbc/docs/current/api/org/springframework/data/r2dbc/repository/Modifying.html) explains when to use it and when not). – M. Deinum Jun 21 '23 at 12:31
what's the point of using it if the queries works perfectly fine without it? – agingcabbage32 Jun 21 '23 at 13:13
Because you are probably either without a proper tx context (and thus have auto commit behavior) or have enabled some sort of auto committing. – M. Deinum Jun 21 '23 at 13:16

Using @modifying with spring r2dbc

0 Answers0