Spring

@Transactional in Spring Data JPA | Transactions is a database concept (not specific to Spring Boot). It has two operations:- When Transactions are required? For Every non-select operation transactions are required. Transactions are not required for select operations. Here we have two functions/operations / commands:- Buffers are part of RAM only. MySQL Queries: In the […]

Query Method in Spring Data JPA | findBy is an abstract method that derives a query at runtime based on details in the method name. What is the difference between findBy and @Query? @Query works for SQL databases only but supports both SELECT and non-SELECT operations. In @Query custom/manual query must be given and it

Working With JOINS in Spring Data JPA | Before seeing JOINS in Spring Data JPA, let us see in short how JOIN works in SQL. SQL Joins SQL Joins:- Joins are used to fetch data [SELECT] from multiple tables [2 or more tables]using a single query [one SQL query]. Consider the given depttab and emptab

Association Mapping in Spring Data JPA | We will discuss one-to-one, one-to-many, many-to-one, and many-to-many association mappings through examples. Multiplicity: Connecting multiple tables using primary-key & foreign-key concepts. One table’s primary key is taken as another table’s foreign key. There are 4 types of Multiplicity:- All these are used best on requirement but one-to-many and

HQL/JPQL in Spring Data JPA | Repository interfaces have provided pre-defined methods to do database operations like findAll(), save(), deleteById(), etc. We can also define our query using the concept of “Custom Query”. This can be implemented using:- Here we will see defining custom query using @Query. Also see:- Custom query method (findBy). The HQL/JPQL

JpaRepository in Spring Data JPA | JpaRepository internally extends PaginingAndSortingRpository and CrudRepository. Therefore, CRUD operations and PageAndSort are also available in JpaRepository. It also has JPA concepts like Date and Time, Lobs(BLOB, CLOB), Collection Mapping, ASSOCIATION MAPPING, JOINS, COMPONENT MAPPING, etc. In JpaRepository we can define custom queries using one of the following approaches:- In

PagingAndSortingRepository In Spring Data JPA | The PagingAndSortingRepository has two methods for pagination and sorting. It does not implement CrudRepository. In SQL, order by columns [ASC|DESC] fetches data in Sorting order. Example:- To do sorting, an enum Direction is provided that has two possible values:- ASC, and DESC. The default value is ASC. This enum

Search Specification | Criteria API in Spring Boot | Criteria API helps us to create dynamic queries. Let us start with the project setup. Create a Spring starter project with the following dependencies:- Spring Web, Lombok, MySQL Driver, and Spring Data JPA. See the complete code on GitHub. In application.properties:- Entity Classes:- Repository:- Controller:- After