jpa

Java Persistence API (JPA) is a Java application programming interface specification that describes the management of relational data in applications using Java Platform, Standard Edition and Java Platform, Enterprise Edition. It provides an object-relational mapping (ORM) facility for the Java language, allowing developers to interact with databases through the use of Java objects. JPA allows developers to easily persist and query data in a database, providing a simple and standardized approach to data persistence and management.

All Niche Things about using JPA

Title	Description
Custom Sequences	Implements CustomSequence Generation like ORD000001 Uses Custom Repository instead of OOTB spring data repository Logging SQL Statements using DataSourceProxy Connections Acquiring Optimization using LazyConnectionDataSourceProxy
Entity Auditing using envers	Version History and Auditing of db using spring data envers based on Hibernate Envers Track who changed what and when Revert or compare entity versions over time
Multiple DataSources	Connects to both PostgreSQL and MySQL databases Uses Liquibase for Postgres and Flyway for MySQL migrations Demonstrates data merging from multiple sources
Hibernate 2nd Level Cache	Implements Redis-based second-level caching Reduces database round-trips for frequently accessed data Demonstrates caching of entities and collections
JNDI Sample	Demonstrates JNDI usage with embedded Tomcat Uses Hikari DataSource for connection pooling
JPA JOOQ Sample	Combines JPA and JOOQ in a blog post management system Demonstrates complex entity relationships (posts, comments, tags) Shows both JPA and JOOQ-based data access patterns
JPA Locks	Demonstrates transaction isolation levels Shows different propagation behaviors Handles concurrent data access scenarios
Keyset Pagination	Implements efficient pagination for large datasets Includes implementations using: Spring Data JPA Window functions Blaze Persistence for dynamic queries
MultiTenancy	Implements multiple multi-tenancy strategies: Partition-based (Discriminator) Schema-based Database-based Multi-DataSource with mixed strategies
Read Replica PostgreSQL	Implements read/write splitting with PostgreSQL Routes reads to replica and writes to primary Uses LazyConnectionDataSourceProxy for runtime routing