Introduction In this tutorial I will show you how to map custom query results into DTO in Spring Data JPA. Situations may occur while you are unable to return the entity object(s) as results from your Spring Data JPA Repository and instead you need to write custom query or native query for your business requirements….

Posted in Spring Boot Spring JPA

How to map Custom Query Results into DTO in Spring Data JPA

Introduction In this example I will show you an example on Spring Boot jQuery AJAX CRUD. CRUD is an acronym for four operations such as Create, Read, Update and Delete. I am going to perform CRUD operations on company details. I will use here MySQL database to store company details information. I will perform each…

Posted in AJAX jQuery Spring Boot Spring JPA

Spring Boot jQuery AJAX CRUD Example

Introduction In this guide we will walk through Spring Boot Data JPA left, right, inner and cross join examples on three tables. In pas we have seen similar example on two tables but I got some requests on how to perform similar joins on three tables. Therefore I am going to show you how to…

Posted in Spring Boot Spring JPA

Spring Boot Data JPA Left, Right, Inner and Cross Join Examples on Three Tables

Introduction We will see here Spring Boot Data JPA CRUD example. CRUD means Create Read Update and Delete operations. We will use in-memory h2 database in order to perform CRUD operations in database. We have other example on Spring Data JPA CRUD example but the application does not use Spring Boot. In this example, we…

Posted in Spring Boot Spring JPA

Spring Boot Data JPA CRUD Example

Introduction In this post you will see how to download file using React JS and Spring Boot. There are situations where you need to download file from server or you need to generate report from database and download it. This example may help you in that situation. Here I will fetch records from database and…

Posted in File Download React JS Spring Boot Spring JPA Spring REST

Download file using React and Spring Boot

Introduction In this post I will show you how to download file using Angular framework and Spring Boot. There are situations when you need to download file from server or you need to generate report from database and download it. This example may help you in such situation. I will build the Spring Boot application…

Posted in Angular File Download Spring Boot Spring JPA Spring REST

Download file using Angular and Spring Boot REST

Introduction In this post you will see an example on HATEOAS driven REST API using Spring Boot. An approach that breaks down the principal elements of a REST approach into three steps are resources, http verbs and hypermedia controls: Without using any mechanism of the web, HTTP is used as a transport system for remote…

Posted in Spring Boot Spring JPA Spring REST

HATEOAS driven REST API using Spring Boot

Introduction This tutorial will show you how to integrate in-memory H2 database with Spring Boot and build using Gradle/Maven tools. You will see here simple Spring Boot Data JPA example with Spring REST API to understand how it works. H2 is in-memory database, so it does not have persistence capability once your Spring Boot application…

Posted in Gradle Spring Boot Spring JPA

Integrate H2 In-memory Database with Spring Boot

Spring Boot Data JPA Joins This tutorial will show you Spring Boot Data JPA Left Right Inner and Cross Join Examples. I will show you how to use this example in Spring Boot application, where you will use Spring Data JPA Repository to query your database tables. I will build the project using both maven…

Posted in Spring Boot Spring JPA

Spring Boot Data JPA Left Right Inner And Cross Join Examples

Introduction Here we will create an example on Spring Data JPA Specification Criteria Query with IN Clause. Spring Data JPA Specification Criteria Query generally used for search functionality on a page where users want to search by giving some inputs or by selecting several dropdown values. In this example we will use how to use…

Posted in Spring Boot Spring JPA Spring REST

Spring Data JPA Specification Criteria Query with IN Clause Example

Introduction File download example using Spring REST Controller will show you how to download a file from any client (browser or any client) and Spring REST service is used as a server side technology for downloading the file. The file may be any type, i.e., such as excel, text, word, pdf etc. Here I will…

Posted in File Download Spring Boot Spring JPA Spring REST

File Download Example using Spring REST Controller

Introduction The tutorial Spring Data JPA Entity Auditing using EntityListeners will show you how you persist the audit log using JPA’s built-in functionality. Spring Data  JPA provides sophisticated support to transparently keep track of who created or changed an entity and at what time. To benefit from this functionality you have to equip your entity classes…

Posted in Spring Boot Spring JPA

Spring Data JPA Entity Auditing using EntityListeners