[Example-Lab] Table Per Class Inheritance Strategy in Hibernate 4.3

In the TABLE_PER_CLASS strategy, hibernate will create a separate table for all the classes in an inheritance hierarchy. It is still not normalized completely as inherited columns are repeated in all tables. For instance, Fields inherited from Shape such as id and fillcolor are repeated in all the tables.

In this example, we will create and save three entity classes – Shape, Rectangle and Circle; where Rectangle and Circle extends from Shape.

If you are not following the tutorials in order, refer to the article http://javajee.com/your-first-hibernate-43-program for the basic setup including hibernate configuration file.

 

Configuration file changes

You should replace the user class in the configuration file with Shape, Rectangle and Circle classes as:

<!-- Names the annotated entity class -->

<mapping class="com.javajee.hiberex.dto.Shape"/>

<mapping class="com.javajee.hiberex.dto.Rectangle"/>

<mapping class="com.javajee.hiberex.dto.Circle"/>

Else you will get org.hibernate.MappingException: Unknown entity:…

 

Shape class

The base entity class, shape will have id and fillcolor properties:

@Entity

@Inheritance (strategy = InheritanceType.TABLE_PER_CLASS)

public class Shape {

  @Id @GeneratedValue(strategy=GenerationType.TABLE)

  int shapeId;

  String fillcolor;

 //Getters and setters not shown here; create them manually or generate in eclipse.

}

Since I am using MySQL database, I am need to use @GeneratedValue(strategy=GenerationType.TABLE) for TABLE_PER_CLASS strategy. With other databases, just @GeneratedValue as in SINGLE_TABLE strategy might just work. 

 

Rectangle class

Entity class Rectangle extends from Shape, and have length and breadth properties:

@Entity

public class Rectangle extends Shape{

  long length;

  long breadth;

//Getters and setters not shown here; create them manually or generate in eclipse.

}

This class is same as in SINGLE_TABLE strategy without @DiscriminatorValue annotation.

 

Circle class

Entity class Circle extends from Shape, and has one property radius:

@Entity

public class Circle extends Shape{

  long radius;

//Getters and setters not shown here; create them manually or generate in eclipse.

}

This class is same as in SINGLE_TABLE strategy without @DiscriminatorValue annotation.

 

Test class

Now use the below test class to create objects for these classes, populate data and save them:

public class ShapeTest {

  public static void main(String[] args) {

    Shape s = new Shape();

    s.setFillcolor("Green");

    Rectangle r = new Rectangle();

    r.setBreadth(4);

    r.setLength(6);

    Circle c = new Circle();

    c.setRadius(5);

    Configuration configuration = new Configuration();

    configuration.configure();

    ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
                .applySettings(configuration.getProperties()).build();

    SessionFactory sessionFactory = configuration.buildSessionFactory(serviceRegistry);

    Session session = sessionFactory.openSession();

    session.beginTransaction();

    session.save(s);

    session.save(r);

    session.save(c);

    session.getTransaction().commit();

  }

This class is same as in SINGLE_TABLE strategy.

 

Verifying the results

When you execute the above test class, below queries are executed by hibernate (as seen from the console):

Hibernate: insert into Shape (fillcolor, shapeId) values (?, ?)

Hibernate: insert into Rectangle (fillcolor, breadth, length, shapeId) values (?, ?, ?, ?)

Hibernate: insert into Circle (fillcolor, radius, shapeId) values (?, ?, ?)

 

You can see that hibernate has created one table each for Shape, Rectangle and Circle.  

Also, Shape’s fillcolor and shapeId, which are inherited by all, appears in all the tables.

Things will be more clear, once you see the database snapshot. Just do a select all query (select * from Shape/Rectangle/Circle).

This is better than SINGLE_TABLE as it eliminated irrelevant columns with NULL values, but this can still be normalized using joins.

Tags: 

Quick Notes Finder Tags

Activities (1) advanced java (1) agile (3) App Servers (6) archived notes (2) Arrays (1) Best Practices (12) Best Practices (Design) (3) Best Practices (Java) (7) Best Practices (Java EE) (1) BigData (3) Chars & Encodings (6) coding problems (2) Collections (15) contests (3) Core Java (All) (55) course plan (2) Database (12) Design patterns (8) dev tools (3) downloads (2) eclipse (9) Essentials (1) examples (14) Exception (1) Exceptions (4) Exercise (1) exercises (6) Getting Started (18) Groovy (2) hadoop (4) hibernate (77) hibernate interview questions (6) History (1) Hot book (5) http monitoring (2) Inheritance (4) intellij (1) java 8 notes (4) Java 9 (1) Java Concepts (7) Java Core (9) java ee exercises (1) java ee interview questions (2) Java Elements (16) Java Environment (1) Java Features (4) java interview points (4) java interview questions (4) javajee initiatives (1) javajee thoughts (3) Java Performance (6) Java Programmer 1 (11) Java Programmer 2 (7) Javascript Frameworks (1) Java SE Professional (1) JPA 1 - Module (6) JPA 1 - Modules (1) JSP (1) Legacy Java (1) linked list (3) maven (1) Multithreading (16) NFR (1) No SQL (1) Object Oriented (9) OCPJP (4) OCPWCD (1) OOAD (3) Operators (4) Overloading (2) Overriding (2) Overviews (1) policies (1) programming (1) Quartz Scheduler (1) Quizzes (17) RabbitMQ (1) references (2) restful web service (3) Searching (1) security (10) Servlets (8) Servlets and JSP (31) Site Usage Guidelines (1) Sorting (1) source code management (1) spring (4) spring boot (3) Spring Examples (1) Spring Features (1) spring jpa (1) Stack (1) Streams & IO (3) Strings (11) SW Developer Tools (2) testing (1) troubleshooting (1) user interface (1) vxml (8) web services (1) Web Technologies (1) Web Technology Books (1) youtube (1)