Hibernate relation: one to one (primaryKeyJoin)

1. Database schema

...

2. Entity class:

import javax.persistence.*;
import java.sql.Date;

@Entity
@Table(name = "User")
public class User {

    @Id
    @GeneratedValue
    private Long id;

    @Column(name = "firstName")
    private  String firstName;

    @Column(name = "surName")
    private  String surName;

    @Column(name = "birthDate")
    private Date birthDate;

    @Column (name = "address")
    private  String emailAddress;

    @OneToOne(cascade = {CascadeType.PERSIST})
    @PrimaryKeyJoinColumn
    private UserAdditionalInfo userAdditionalInfo;

    public User() {
    }

//getters and setters

}

import javax.persistence.*;

@Entity
@Table(name = "UserAdditionalInfo")
    public class UserAdditionalInfo {

    @Id
   @Column(name = "userId")
    private Long id;

    @Column
    private int age;

    //0-male, 1-female
    @Column
    private short gender;

    public UserAdditionalInfo() {
    }
//getters and setters

}

3. Hibernate configuration file

Put annotated classes User.java and UserAdditionalInfo.java in to hibernate configuration file and mysql connection details:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
        <!-- Database connection settings -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/test</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="hibernate.show_sql">true</property>

        <property name="hbm2ddl.auto">create-drop</property>

        <mapping class="net.hibernateApp.packt.maven.domain.User"/>
        <mapping class="net.hibernateApp.packt.maven.domain.UserAdditionalInfo"/>
    </session-factory>
</hibernate-configuration>

4. Run

import net.hibernateApp.packt.maven.domain.User;
import net.hibernateApp.packt.maven.domain.UserAdditionalInfo;
import net.hibernateApp.packt.maven.hibernate.HibernateUtils;
import org.hibernate.SessionFactory;
import org.hibernate.Session;

public class Main {

    public static void main(String[] args) {

        User user = new User();
        user.setFirstName("Christopher");
        user.setSurName("Stepniak");
        saveUser(user);

        UserAdditionalInfo userAdditionalInfo = new UserAdditionalInfo();
        userAdditionalInfo.setAge(30);
        userAdditionalInfo.setGender((short) 0);

        User user2 = new User();
        user2.setFirstName("John");
        user2.setSurName("Abram");
        user2.setUserAdditionalInfo(userAdditionalInfo);
        user2 = saveUser(user2);

        userAdditionalInfo.setId(user2.getId());
        saveUserAdditionalInfo(userAdditionalInfo);

        UserAdditionalInfo selecteduserAdditionalInfo = (UserAdditionalInfo)list("UserAdditionalInfo").get(0);

        System.out.println(selecteduserAdditionalInfo.getId());
    }

 private static User saveUser(User user){
        SessionFactory sf;
        sf = HibernateUtils.getSessionFactory();
        Session session = sf.openSession();
        session.beginTransaction();
        Long id = (Long) session.save(user);
        user.setId(id);
        session.getTransaction().commit();
        session.close();
        return user;
    }

    private static List list(String sourceTable) {
        SessionFactory sf = HibernateUtils.getSessionFactory();
        Session session = sf.openSession();
        List objects = session.createQuery("from "+sourceTable).list();
        session.close();
        return objects;
    }
}

 Output: 2


Class net.hibernateApp.packt.maven.hibernate.HibernateUtils is described here:
 Using Hibernate persistence with Maven