ORM Tools with Java

What Is ORM and Why Use It Object-Relational Mapping (ORM) is a technique that lets you interact with a relational database using objects instead of writing SQL by hand. Java ...

JDBC vs ORM: The Pain Points To appreciate what an ORM does, it helps to see what manual data access looks like. JDBC (Java Database Connectivity) is the low-level API that Java ...

JPA and Hibernate Basics JPA (Java Persistence API) is the standard specification for object-relational mapping in Java. Hibernate is the most popular implementation of that ...

Entity Lifecycle and States JPA entities go through distinct states during their lifetime. Understanding these states is critical for writing correct persistence code, especially ...

One-to-One and One-to-Many Relationships Real-world data is relational. Users have addresses, authors have books, orders have items. JPA provides annotations to map these ...

Many-to-Many Relationships and Join Tables in JPA In relational databases, a many-to-many relationship occurs when rows in one table can be linked to many rows in another, and ...

Embedded Types, Enums and Collections in JPA JPA entities do not have to consist only of simple fields like String and Long . You can embed value objects directly into a table, ...

Spring Data JPA Repositories - CRUD Without Boilerplate Writing CRUD operations for every entity is repetitive work. Spring Data JPA solves this with the Repository abstraction. ...

Derived Query Methods - Queries From Method Names Spring Data JPA can parse the name of a repository method and generate the SQL query for you automatically. Instead of writing ...

JPQL vs Native SQL Queries - When to Use Which When derived query methods are not enough and you need more control, JPA gives you two options: JPQL (Java Persistence Query ...

Criteria API and Spring Data Specifications - Type-Safe Queries HQL and JPQL are powerful but still rely on string-based queries. If you misspell a column name or use the wrong ...

Transactions, Dirty Checking and Flush in JPA JPA does not send SQL to the database the moment you call a setter. It waits, tracks changes, and sends them at the right moment. ...

Lazy vs Eager Loading - When to Load What When an entity has relationships to other entities, the ORM must decide when to load the related data. Loading everything upfront wastes ...

Fetch Strategies - JOIN FETCH, Graphs and Batch Fetching Lazy loading prevents unnecessary queries, but sometimes you need the related data in the same request. Hibernate provides ...

Caching Strategies - First Level and Second Level Caches Every database call has overhead - network latency, SQL parsing, result set mapping. Caching stores frequently accessed ...

Optimistic vs Pessimistic Locking - Concurrency Without Corruption When two users try to update the same row at the same time, one update silently overwrites the other. This is ...

Pagination, Sorting and Projections in Spring Data JPA Most production screens display data in pages. You would never load ten thousand rows into memory just to show ten on ...

Schema Generation, Migrations and MySQL Integration JPA can generate your database schema from entity annotations at application startup. This is convenient during development but ...

Auditing, Soft Deletes and Versioning in JPA Knowing who changed a record and when is a common requirement in regulated industries. JPA provides built-in auditing with ...

Common ORM Pitfalls and Production Best Practices ORM frameworks like Hibernate are powerful but can quietly destroy performance if used carelessly. The N+1 query problem, missing ...