Skip to content

Files

Latest commit

078cd0e · Nov 27, 2019

History

History

HibernateSpringBootJoinFormula

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Sep 21, 2019
Nov 27, 2019
Sep 21, 2019

How To Map @ManyToOne Relationship To A SQL Query Via The Hibernate @JoinFormula

Description: This application is an example of mapping the JPA @ManyToOne relationship to a SQL query via the Hibernate @JoinFormula annotation. We start with two entities, Author and Book, involved in a unidirectional @ManyToOne relationship. Each book has a price. While we fetch a book by id (let's call it book A), we want to fetch another book B of the same author whose price is the next smaller price in comparison with book A price.

Key points:

  • fetching the book B is done via @JoinFormula

If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices"If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you.