Spring Boot JPA @Query update does not work

Question

I'm using Spring Boot and I'm trying to make a function that updates an attribute using a native query.

This is a part of my interface:

@Modifying(clearAutomatically = true, flushAutomatically = true) // mandatory if native quaries are modying something in the dataBase
@Transactional
@Query("""
    update pojazd 
    set czy_zarchiwizowany = true 
    where id =: selected_id""", nativeQuery = true) 
fun archwizujPojazd(@Param("selected_id") selected_id:Long):Boolean

The function works. It returns true, but it has no effect on the database.

I have browsed through a bunch of similar topics on here with no solution.

It seems like you're not getting an error, but I wouldn't have expected this to work with the extra space in : selected_id. — chrylis -cautiouslyoptimistic-
– chrylis -cautiouslyoptimistic-, Commented Jan 23, 2020 at 3:34

Mark Rotteveel · Accepted Answer · 2024-10-25 11:02:21Z

1

@Modifying(clearAutomatically = true, flushAutomatically = true) 
@Transactional
@Query(value = "update pojazd  set czy_zarchiwizowany = true 
    where id = :selected_id", nativeQuery = true) 
fun archwizujPojazd(@Param(value="selected_id") Long selected_id);

edited Oct 25, 2024 at 11:02

Mark Rotteveel

110k241 gold badges160 silver badges233 bronze badges

answered Jan 23, 2020 at 6:08

Muzaffar Umar

263 bronze badges

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

1 Comment

Filip Machaj Over a year ago

I just had to change that updating function to void.

Collectives™ on Stack Overflow

Spring Boot JPA @Query update does not work

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related