Bidirectional One-To-One Relationship with Join Tables in Hibernate

In bidirectional association, we will have navigation in both direction, i.e, both side of the association will have the reference to the other side. The both side of the association will implement one of the collection interfaces, if it has the reference to the other entity.

In one to one relationship, one source object can have relationship with only one target object. Let’s consider CD and Artist. So one CD can be written by one Artist or an Artist can write only one CD. So we will create two tables CD and Artist in the database and we will see how one-to-one relationship works step by step.

Now we will apply one-to-one relationship. So only one CD can be written by only one Artist.

A bidirectional one-to-one association on a join table is possible, but extremely unusual.

Step 1. Create tables

Create table – cd

 

Create table – artist

 

Create table – cdartist

 

Step 2. Create a java project in any Java based IDE and configure for hibernate jars.

Step 3. Create hibernate reverse engineering and configuration file.

 

 

Step 4. Create hibernate utility class which creates singleton SessionFactory from which Session object will be created.

 

Step 5. Create mapping xml file and POJO for artist table. Look at the xml file, we have <many-to-one /> with constraint unique=”true” inside <join/> which makes sure that one-to-one relationship with join tables and only one CD can be written by one Artist.

 

Step 6. Create mapping xml file and POJO for cd table.

 

 

Step 7. Now we will create a main class for testing one-to-one using join tables.

 

Step 8. Run the main class and see the output as shown below. While we save value for artist, the below values are stored into the database tables.

inserted data into artist table

inserted data into cd table

inserted data into cdartist table

Console Output

That’s all. Thanks for your reading.

Soumitra

Software Professional, I am passionate to work on web/enterprise application. For more information please go to about me. You can follow on Twitter. You can be a friend on Facebook or Google Plus or Linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.