In this short Spring Data JPA tutorial, you will learn how to create a JPA Native SQL Query to select specific columns only. JPA Native SQL Query to Select Specific Columns Below is an example of JPA Native Query that selects from a database table called Users only two columns: first_name and, last_name @Query(value=”select first_name,…
Read More Select Specific Columns with JPA Native QueryIn this short Spring Data JPA tutorial, you will learn how to use the LIKE % expression in a Native SQL Query. When using advanced SQL LIKE expression the % sign in the SQL query would represent zero, one or multiple characters. Let’s have a look at the Native JPA SQL Query that uses advanced…
Read More How to Use LIKE % Expression in JPA SQL QueryIn this short Spring Boot tutorial, I am going to share with you how to make Spring Boot app show Hibernate SQL Queries. Enable Hibernate SQL Queries Logging To show hibernate SQL queries in Spring Boot log file you will need to update the application.properties file with the following details: logging.level.org.hibernate.SQL=debug Show SQL Values Additionally,…
Read More Show Hibernate SQL Query in Spring BootIn this short Spring Data JPA tutorial, you will learn 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 SQL…
Read More Spring Data JPA Native UPDATE SQL QueryIn this tutorial, you will learn how to run an SQL query in your project which uses Spring Data JPA Query Methods. You will learn how to annotate Spring Data JPA Query method so that you can use it to perform a custom SQL query to SELECT, UPDATE or DELETE a record from a database. …
Read More SQL Query with JPQL in a Spring Data JPA ProjectIn this tutorial on Spring Data JPA, I am going to share with 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 but sometimes, even though we have…
Read More Spring Data JPA Native SQL QueryIn this tutorial on Rest Assured, I am going to share with you how to create a test case which sends HTTP Get Request and includes two Query String Request Parameters. Let’s assume we need to test a RESTful Web Service Endpoint which returns a list of users. The URL to our RESTful Web Service…
Read More Rest Assured HTTP Request with Query Parameters