In this tutorial, you will learn how to call stored procedures in a Spring Boot RESTful API project that uses Spring Data JPA. Using a stored procedure to execute parts of the application logic in the database is a widely used approach in huge, data-heavy applications. A stored procedure is a group of predefined SQL…
Read More Calling a Stored Procedure in Spring Boot REST with JPAIn this tutorial, you will learn how to use specification and predicate in Spring Data JPA using the Spring Boot RESTful API project. Spring Data JPA Specifications allow us to create dynamic database queries by using the JPA Criteria API. It defines a specification as a predicate over an entity. Spring has a wrapper around…
Read More Specification & Predicate: Advance Search and Filtering in JPAIn this short tutorial, you will learn how to rollback a database change using @Transactional annotation in your RESTful Web Service built with Spring MVC and JPA. Rollback with @Transactional Annotation Sometimes if an error takes place in our RESTful Web Service we want to rollback the changes made. For changes to be rolled back…
Read More Rollback Using @Transactional in Spring with JPAIn 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 blog post, I am going to share with you how to configure Spring Data JPA in a Jersey 2 Container Deployable Web App. Spring Data JPA makes it much easier and more convenient to persist and read data from the database and when I needed to tie together Spring Data JPA and Jersey 2 Web…
Read More Configure Spring Data JPA in Jersey 2 JAX-RS AppWith this blog post, I am going to share what I needed to do to make JPA work in my Jersey 2 Web Services App. I have created my Jersey 2 app using the following maven snippet: mvn archetype:generate -DarchetypeGroupId=org.glassfish.jersey.archetypes \ -DarchetypeArtifactId=jersey-quickstart-webapp -DarchetypeVersion=2.26 I then opened pom.xml and added a few new dependencies which I…
Read More Configuring JPA in Jersey 2 Web AppCreate a Servlet Container deployable Jersey web application Create new Jersey web application using Maven. The project created with the below jersey-quickstart-webapp archetype can be built and deployed to a servlet container like for example Apache Tomcat. mvn archetype:generate -DarchetypeGroupId=org.glassfish.jersey.archetypes \ -DarchetypeArtifactId=jersey-quickstart-webapp -DarchetypeVersion=2.26 POM.XML Dependency to Support JSON To support JSON in your Jersey Web App add…
Read More RESTful Web Services with Jersey and Spring Data JPA – Cheat SheetEnter your email and stay on top of things,