Table Per Subclass using Annotation

As we have specified earlier, in case of table per subclass strategy, tables are created as per persistent classes but they are treated using primary and foreign key. So there will not be any duplicate column in the relation.

We need to specify @Inheritance(strategy=InheritanceType.JOINED) in the parent class and @PrimaryKeyJoinColumn annotation in the subclasses.

Let’s see the hierarchy of classes that we are going to map.

table per subclass strategy

The table structure for each table will be as follows:

Table structure for Employee class

table per subclass class

Table structure for Regular_Employee class

table per subclass class

Table structure for Contract_Employee class

table per subclass class

Example of Table per subclass class using Annotation

In this example we are creating the three classes and provide mapping of these classes in the employee.hbm.xml file.

1) Create the Persistent classes

You need to create the persistent classes representing the inheritance. Let’s create the three classes for the above hierarchy:

File: Employee.java

 package com.tutoraspire.mypackage; import javax.persistence.*;  @Entity @Table(name = “employee103”) @Inheritance(strategy=InheritanceType.JOINED)  public class Employee { @Id @GeneratedValue(strategy=GenerationType.AUTO)      @Column(name = “id”) private int id;  @Column(name = “name”) private String name;  //setters and getters }  

File: Regular_Employee.java

 package com.tutoraspire.mypackage;  import javax.persistence.*;  @Entity @Table(name=”regularemployee103″) @PrimaryKeyJoinColumn(name=”ID”) public class Regular_Employee extends Employee{  @Column(name=”salary”) private float salary;  @Column(name=”bonus”) private int bonus;  //setters and getters }  

File: Contract_Employee.java

 package com.tutoraspire.mypackage;  import javax.persistence.*;  @Entity @Table(name=”contractemployee103″) @PrimaryKeyJoinColumn(name=”ID”) public class Contract_Employee extends Employee{  @Column(name=”pay_per_hour”) private float pay_per_hour;  @Column(name=”contract_duration”) private String contract_duration;  //setters and getters } 

2) Add project information and configuration in pom.xml file.

Open pom.xml file and click source. Now, add the below dependencies between <dependencies>….</dependencies> tag.

 <dependency>     <groupId>org.hibernate</groupId>     <artifactId>hibernate-core</artifactId>     <version>5.3.1.Final</version> </dependency>  <dependency>     <groupId>com.oracle</groupId>     <artifactId>ojdbc14</artifactId>     <version>10.2.0.4.0</version> </dependency> 

3)Create the configuration file

Open the hibernate.cgf.xml file, and add an entry of mapping resource like this:

 <mapping class=”com.tutoraspire.mypackage.Employee”/> <mapping class=”com.tutoraspire.mypackage.Contract_Employee”/> <mapping class=”com.tutoraspire.mypackage.Regular_Employee”/> 

Now the configuration file will look like this:

File: hibernate.cfg.xml

 <?xml version=’1.0′ encoding=’UTF-8′?> <!DOCTYPE hibernate-configuration PUBLIC           “-//Hibernate/Hibernate Configuration DTD 5.3//EN”           “http://hibernate.sourceforge.net/hibernate-configuration-5.3.dtd”>  <!– Generated by MyEclipse Hibernate Tools.                   –> <hibernate-configuration>      <session-factory>         <property name=”hbm2ddl.auto”>update</property>         <property name=”dialect”>org.hibernate.dialect.Oracle9Dialect</property>         <property name=”connection.url”>jdbc:oracle:thin:@tutoraspire.com:1521:xe</property>         <property name=”connection.username”>system</property>         <property name=”connection.password”>jtp</property> <property name=”connection.driver_class”>oracle.jdbc.driver.OracleDriver</property>    <mapping class=”com.tutoraspire.mypackage.Employee”/>  <mapping class=”com.tutoraspire.mypackage.Contract_Employee”/>  <mapping class=”com.tutoraspire.mypackage.Regular_Employee”/>     </session-factory>  </hibernate-configuration> 

The hbm2ddl.auto property is defined for creating automatic table in the database.

3) Create the class that stores the persistent object

In this class, we are simply storing the employee objects in the database.

File: StoreData.java

  package com.tutoraspire.mypackage;  import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.boot.Metadata; import org.hibernate.boot.MetadataSources; import org.hibernate.boot.registry.StandardServiceRegistry; import org.hibernate.boot.registry.StandardServiceRegistryBuilder;  public class StoreData {  public static void main(String args[]) { StandardServiceRegistry ssr = new StandardServiceRegistryBuilder().configure(“hibernate.cfg.xml”).build();     Metadata meta = new MetadataSources(ssr).getMetadataBuilder().build();  SessionFactory factory=meta.getSessionFactoryBuilder().build(); Session session=factory.openSession();   Transaction t=session.beginTransaction();              Employee e1=new Employee();       e1.setName(“Gaurav Chawla”);              Regular_Employee e2=new Regular_Employee();       e2.setName(“Vivek Kumar”);       e2.setSalary(50000);       e2.setBonus(5);              Contract_Employee e3=new Contract_Employee();       e3.setName(“Arjun Kumar”);       e3.setPay_per_hour(1000);       e3.setContract_duration(“15 hours”);              session.persist(e1);       session.persist(e2);       session.persist(e3);              t.commit();       session.close();       System.out.println(“success”);   } }  

Download this example (Developed using Eclipse IDE)

Next TopicCollection Mapping

Hibernate Table per subclass using Annotation tutorial example

Table Per Subclass using Annotation

Table structure for Employee class

Table structure for Regular_Employee class

Table structure for Contract_Employee class

Example of Table per subclass class using Annotation

1) Create the Persistent classes

2) Add project information and configuration in pom.xml file.

3)Create the configuration file

3) Create the class that stores the persistent object

Framework7 Tabs

How to add Link in Html

You may also like