@Modifying

This short Spring Data JPA tutorial will teach you how to write a Native UPDATE SQL query. Let’s assume you need to run the following SQL query: update users u set u.EMAIL_VERIFICATION_STATUS = ‘true’ where u.USER_ID = ‘5JwQBHd1mL73XEg8S2e2w4ITn9gOW4’ I assume you will not want to hardcode the values of EMAIL_VERIFICATION_STATUS and USER_ID into an SQL…

Read More Spring Data JPA Native UPDATE SQL Query

This tutorial will teach you how to use the @Query annotation to run custom SQL queries. Spring Data JPA provides us with many ready-to-use query methods which allow us to perform basic CRUD(Create, Read, Update and Delete) operations. However, sometimes, even though we have this ready-to-use Query method, we still need to run a custom…

Read More Spring Data JPA Native SQL Query