JPA/Hibernate Inheritance Mapping Strategies Explained

Java is inherently an object-oriented language. Databases are relational in nature. JPA/Hibernate support Inheritance strategies. These allow mapping Java class hierarchies to database tables. In this article, I will be covering inheritance strategies supported by JPA/Hibernate.

Introduction

JPA/Hibernate support 4 inheritance strategies, Single Table, Joined, Table Per Sub-class and MappedSuperClass. In this article, I will be covering each inheritance strategy and how it works.

Sample Code

Consider the following class diagram:

Inheritance_strategies_class_diagram
Inheritance_strategies_class_diagram

 

Here Person is a super class. It has two sub-classes, Employee and Customer. Let us see how each of these strategies work for the above class hierarchy.

Single Table

This strategy is also known as table per hierarchy. In this strategy, JPA creates a single table corresponding to all the classes in the inheritance hierarchy. This table has columns corresponding to the fields in all the classes in the hierarchy.  So in this example, the table will have columns corresponding to the fields in Person, Employee and Customer classes.

Each record uses only a subset of the columns corresponding to the underlying entity that it represents and sets a null value for the other columns. So an Employee record will only use the columns name, emailId, department, salary. It will have null values for customerType and companyName fields.

In addition, JPA adds an additional column to the table. This is known as the discriminator column. This differentiates between the records.

So for the class structure above, JPA creates the following table:

/Inheritancemapping-SingleTable

Joined

In this strategy, JPA creates separate tables corresponding to each class in the inheritance hierarchy. The table corresponding to the base class has columns corresponding to the fields in the base class. So here, the Person table will have fields corresponding to name and emailId.

The tables corresponding to the sub classes has columns corresponding to the fields in the sub classes. So here the Employee table has fields corresponding to the department and salary. The Customer table will have fields corresponding to companyName and customerType,

For a base class record, JPA stores all the data in the base class table. For a sub-class record, JPA stores the common fields in the base class table and the individual fields in the sub-class tables.

So for the class structure above, JPA creates the following table structure:

Inheritancemapping-Joined

Table Per Sub-Class

In this strategy, JPA creates separate tables corresponding to each class in the inheritance hierarchy.

The table corresponding to the base class has columns corresponding to the fields in the base class. So here, the Person table will have fields corresponding to name and emailId.

The tables corresponding to the sub classes have columns corresponding to the fields base class well as fields in the sub classes. So here the Employee table has fields corresponding to name, emailId, department and salary. The Customer table will have fields corresponding to name, emailId, companyName and customerType,

For any entity, JPA stores data in the corresponding table.

So for the class structure above, JPA creates the following table structure:

Inheritancemapping-TablePerClass

MappedSuperClass

In this strategy, JPA creates separate tables corresponding to each sub-class in the inheritance hierarchy. The sub class tables have columns corresponding to the fields base class well as fields in the sub classes.

This is similar to table per sub-class except that superclass is not an entity and there is no table corresponding to the superclass. So in this case, JPA does not create a table corresponding to the Person class, it only creates tables corresponding to Employee and Customer.

The Employee table has fields corresponding to name, emailId, department and salary. The Customer table will have fields corresponding to name, emailId, companyName and customerType.

So for the class structure above, JPA creates the following table structure:

Inheritancemapping-MappedSuperClass

 

I will be demonstrating how to implement each of these strategies in subsequent articles.

Edit

Further Learning

Master JPA and Hibernate with Spring Boot
Spring Data JPA with Hibernate
Hibernate and JPA Fundamentals

Conclusion

So in this article, we saw the JPA/Hibernate inheritance mapping strategies. We understood the Single Table, Joined, Table per class and MappedSuperClass hierarchies and the table structures that they create.

Comments

Post a Comment

Popular posts from this blog

How to use logging in SpringBoot with code samples

Image
In this article, we will learn how to use logging in SpringBoot. Introduction There are several Java logging frameworks like logback, log4j, and so on. Spring Boot supports out-of-the-box support for logback. Let us learn how to use logging in SpringBoot with logback. Step 1 – Create a New Maven Project Create a new Maven project. (Refer to  this  blog post). This will create a project in Eclipse as follows:   Step 2 – Add the Spring Boot Dependencies Add the spring-boot-starter-web dependency to the pom.xml . So, the pom.xml should look as follows: <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.learnjava</groupId> <artifactId>learnjava-springboot-logging-example</artifactId> <version>0.0.1-SNAPSHOT&
Read more

Python While Loop with code samples

Much like a Java while loop, you can use a Python while loop to repeatedly execute a block of code as long as a condition is true. In this article, we will learn more about the Python while loop. Python While loop Syntax A while loop in Python has the following syntax: while <condition>: loop body The while keyword is followed by a condition. If the condition evaluates to true, the body of the loop is executed. Once the body of the loop is completed, the condition is checked again and this is repeated until the condition evaluates to false at which point the loop is exited. While loop Sample Code The following code demonstrates how you can use the while loop: num=10counter=1total=0while counter<=num: total += counter counter+=1print("sum of first 10 numbers is",total) This code adds the numbers from 1 to 10 and prints the sum. It uses a while loop to iterate from 1 to 10. The while loop checks the condition counter <= num and if so adds the current value of count
Read more

How to convert a List to a Set

In this blog post ,I will be showing you how you can convert a List to a Set. Consider the following code snippet: public class ListToSetDemo {public static void main(String[] args) {List<Integer> list = Arrays.asList(5,3,11,15,9);//Method 1Set<Integer> set = new HashSet<Integer>(list);System.out.println("Set is "+set);//method 2Set<Integer> set2 = new HashSet<Integer>();set2.addAll(list);System.out.println("Set is "+set2);}} This code demonstrates two ways to convert a List to a Set. Method 1 Here, we are creating a new HashSet . We are invoking the constructor that accepts a Collection object. Here, we are passing in the input list to this constructor.   Method 2 Here again, we are creating a new HashSet . However, we are using the default constructor. We are then invoking the addAll method and passing in the input list.   When you run this code, it will print the following output: Set is [3, 5, 9, 11, 15]Set is [3, 5, 9, 11, 15] No
Read more