This tutorial will teach you how to create a JPA Native SQL Query to only select information from specific columns. You can find many more Spring Data JPA-related tutorials on this site. Some of the most popular tutorials are: One-to-One Mapping Hibernate/JPA Using Spring Boot and MySQL One-to-Many Mapping Hibernate/JPA Using Spring Boot and MySQL…
Read More Select Specific Columns with JPA Native QueryThis short Spring Data JPA tutorial will teach you 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 SQL…
Read More How to Use LIKE % Expression in JPA SQL QueryIn this tutorial, I will share how to make the Spring Boot application display Hibernate SQL Queries. If you are learning about Hibernate, you might also be interested in the following tutorials: One-to-One Mapping Hibernate/JPA Using Spring Boot and MySQL One-to-Many Mapping Hibernate/JPA Using Spring Boot and MySQL Many-to-Many Relationship in Spring Boot Rest +JPA…
Read More Show Hibernate SQL Query in Spring BootThis 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 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 the 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…
Read More SQL Query with JPQL in a Spring Data JPA ProjectThis 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 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