@Query | @Modifying | Spring Data JPA | Spring Boot | Part 2 | Dev2Prod Coding

This video will focus on how to use the @Query, @Modifying annotation in Spring Data JPA to execute update JPQL & with Indexed Parameters and Sorting data using @Query.

GitHub:

In case you like this video please Like, Subscribe & press the bell icon.
Dev2Prod Coding

[yuvrajjadhav]

Nice article. Easy language to explain & rich knowledge base available with the tutor.

[berkaygursu]

for those getting error,
put @Transactional to repository interface

[pradnyanavale]

Hey can you tell me how do we add a new column in an existing table using alter query and what all file changes would be done in that case.

[sigma]

Hello! Do we need to use annotation @Transactional for code?

@Modifying
@Query("update Employee e set e.active = ?1 where e.empId in ?2")
int activeState, List<Long> empIdList);