Managing relationships Permalink to " Managing relationships"

When JPA is used, the entity sub-generator can create relationships between entities.

Presentation Permalink to "Presentation"

Relationships only work when JPA is used. If you choose to use Cassandra they won’t be available. In case you use MongoDB, Couchbase or Neo4j relations have a different semantics, but they are all available to be used. For more information about Couchbase and MongoDB relationships please refer to Embedded Entities for Couchbase and MongoDB.

A relationship works between two entities, and JHipster will generate the code for:

  • Managing this relationship with JPA in the generated entities
  • Creating the correct Liquibase changelog, in order for the relationship to exist in the database
  • Generating the Angular/React front-end so you can manage this relationship graphically in the user interface

JHipster UML and JDL Studio Permalink to "JHipster UML and JDL Studio"

This page describes how to create relationships with JHipster using the standard command-line interface. If you want to create many entities and relationships, you might prefer to use a graphical tool.

In that case, three options are available:

  • JDL Studio, our online tool to create entities and relationships using our domain-specific language.
  • JHipster IDE, a plugin that provides textual editing support of JDL files for popular IDEs.
  • Deprecated: JHipster UML, which allows you to use an UML editor.

You can generate entities with relationships from a JDL file using the jdl sub-generator, by running jhipster jdl your-jdl-file.jh.

Available relationships Permalink to "Available relationships"

As we use JPA, the usual one-to-many, many-to-one, many-to-many and one-to-one relationships are available:

Tip: the User entity

Information about it is located here.

A small warning about entity & relationship generation: in the following examples, you’ll notice that compilation may fail in some cases because destination entities aren’t generated and that’s normal (this warning can be ignored). There are two ways to avoid that:

  • Generate the entities first, then the relationships
  • Use the JDL

A bidirectional one-to-many relationship Permalink to "A bidirectional one-to-many relationship"

Let’s start with two entities, a Owner and a Car. A owner can have many cars, and a car can have only one owner.

So this is a one-to-many relationship (one owner has many cars) on one side, and a many-to-one relationship (many cars have one owner) on the other side:

Owner (1) <-----> (*) Car

Note that after generating the entity, the generator will inform you that some errors occurred while generating the files. That’s normal as the destination entity has not yet been generated, so you can safely ignore this warning.

We will create the Owner first. Here are the relevant JHipster questions for the Owner:

jhipster entity Owner
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Car
? What is the name of the relationship? car
? What is the type of the relationship? one-to-many
? What is the name of this relationship in the other entity? owner

Please note that we selected the default options concerning the names of the relationships.

Now we can generate the Car:

jhipster entity Car
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Owner
? What is the name of the relationship? owner
? What is the type of the relationship? many-to-one
? When you display this relationship with Angular, which field from 'Owner' do you want to use? id

The same can be achieved using the below JDL as well

entity Owner
entity Car

relationship OneToMany {
  Owner{car} to Car{owner}
}

That’s it, you now have a one-to-many relationship between those two entities! On the generated Angular/React client UI you will have a dropdown in Car to select a Owner.

A bidirectional many-to-one relationship Permalink to "A bidirectional many-to-one relationship"

This is equivalent to the bidirectional one-to-many relationship after inversing the sides in the JDL file:

entity Owner
entity Car

relationship ManyToOne {
  Car{owner} to Owner{car}
}

A unidirectional many-to-one relationship Permalink to "A unidirectional many-to-one relationship"

In the previous example we had a bidirectional relationship: from a Car instance you could find its owner, and from a Owner instance you could get all of its cars.

A many-to-one unidirectional relationship means that the cars know their owner, but not the opposite.

Owner (1) <----- (*) Car

You would do that relationship for two reasons:

  • From a business point of view, you only use your entities in this way. So you don’t want to have an API that allows developers to do something which doesn’t make sense.
  • You have a small performance gain when using the Owner entity (as it won’t have to manage the collection of cars).

In that case, you would still create the Owner first, this time with no relationship:

jhipster entity Owner
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? No

And then the Car entity, as in the previous example:

jhipster entity Car
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Owner
? What is the name of the relationship? owner
? What is the type of the relationship? many-to-one
? When you display this relationship with Angular, which field from 'Owner' do you want to use? id

This will work as in the previous example, but you won’t be able to add or remove cars from the Owner entity. On the generated Angular/React client UI you will have a dropdown in Car to select a Owner. This is the corresponding JDL:

entity Owner
entity Car

relationship ManyToOne {
  Car{owner} to Owner
}

A unidirectional one-to-many relationship Permalink to "A unidirectional one-to-many relationship"

A one-to-many unidirectional relationship means that the Owner instance can get its collection of cars, but not the opposite. It is the opposite from the previous example.

Owner (1) -----> (*) Car

This type of relationship is not provided by default in JHipster at the moment, see #1569 for more information.

You have two solutions for this:

  • Do a bidirectional mapping, and use it without modification: this is our recommended approach, as it is much simpler
  • Do a bidirectional mapping, and then modify it to transform it into a unidirectional mapping:
    • Remove the “mappedBy” attribute on your @OneToMany annotation
    • Generate the required join table: you can do a mvn liquibase:diff to generate that table, see the documentation about using Liquibase diff

This is not supported with JDL as it isn’t in JHipster.

Two one-to-many relationships on the same two entities Permalink to "Two one-to-many relationships on the same two entities"

For this example, a Person can be the owner of many cars and can also be the driver of many cars:

Person (1) <---owns-----> (*) Car
Person (1) <---drives---> (*) Car

For this we need to use the relationship names, which we have left with their default values in the previous examples.

Generate the Person entity, which has two one-to-many relationships to the Car entity:

jhipster entity Person
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Car
? What is the name of the relationship? ownedCar
? What is the type of the relationship? one-to-many
? What is the name of this relationship in the other entity? owner
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Car
? What is the name of the relationship? drivenCar
? What is the type of the relationship? one-to-many
? What is the name of this relationship in the other entity? driver

Generate the Car entity, which use the same relationship name has was configured in the Person entity:

jhipster entity Car
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Person
? What is the name of the relationship? owner
? What is the type of the relationship? many-to-one
? When you display this relationship with Angular, which field from 'Person' do you want to use? id
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Person
? What is the name of the relationship? driver
? What is the type of the relationship? many-to-one
? When you display this relationship with Angular, which field from 'Person' do you want to use? id

The same can be achieved using the below JDL as well

entity Person
entity Car

relationship OneToMany {
  Person{ownedCar} to Car{owner}
}

relationship OneToMany {
  Person{drivenCar} to Car{driver}
}

A Car can now have a driver and a owner, which are both Person entities. On the generated Angular/React client UI you will dropdowns in Car to select a Person for owner field and driver field.

A many-to-many relationship Permalink to "A many-to-many relationship"

A Driver can drive many cars, but a Car can also have many drivers.

Driver (*) <-----> (*) Car

At the database level, this means we will have a join table between the Driver and the Car tables.

For JPA, one of those two entities will need to manage the relationship: in our case, that would be the Car entity, which will be responsible to add or remove drivers.

Please note that, after generating the entity, the generator will inform you that some errors occurred while generating the files. That’s normal as the destination entity has not yet been generated, so you can safely ignore this warning.

Let us generate the non-owning side of the relationship, the Driver, with a many-to-many relationship:

jhipster entity Driver
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Car
? What is the name of the relationship? car
? What is the type of the relationship? many-to-many
? Is this entity the owner of the relationship? No
? What is the name of this relationship in the other entity? driver

Then generate the Car, with the owning side of the many-to-many relationship:

jhipster entity Car
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Driver
? What is the name of the relationship? driver
? What is the type of the relationship? many-to-many
? Is this entity the owner of the relationship? Yes
? What is the name of this relationship in the other entity? car
? When you display this relationship on client-side, which field from 'Driver' do you want to use? This field will be displayed as a String, so it cannot be a Blob id

The same can be achieved using the below JDL as well

entity Driver
entity Car

relationship ManyToMany {
  Car{driver} to Driver{car}
}

That’s it, you now have a many-to-many relationship between those two entities! On the generated Angular/React client UI you will have a multi-select dropdown in Car to select multiple Driver since Car is the owning side.

A one-to-one relationship Permalink to "A one-to-one relationship"

Following our example, a one-to-one relationship would mean that a Driver can drive only one Car, and a Car can only have one Driver.

Driver (1) <-----> (1) Car

Let us create the non-owning side of the relationship, in our case the Driver:

jhipster entity Driver
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Car
? What is the name of the relationship? car
? What is the type of the relationship? one-to-one
? Is this entity the owner of the relationship? No
? What is the name of this relationship in the other entity? driver

Then generate the Car, which owns the relationship:

jhipster entity Car
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Driver
? What is the name of the relationship? driver
? What is the type of the relationship? one-to-one
? Is this entity the owner of the relationship? Yes
? Do you want to use JPA Derived Identifier - @MapsId? No
? What is the name of this relationship in the other entity? car
? When you display this relationship on client-side, which field from 'Driver' do you want to use? This field will be displayed as a String, so it cannot be a Blob id

The same can be achieved using the below JDL as well

entity Driver
entity Car

relationship OneToOne {
  Car{driver} to Driver{car}
}

That’s it, you now have a one-to-one relationship between those two entities! On the generated Angular/React client UI you will have a dropdown in Car to select a Driver since Car is the owning side.

More information on using one-to-one with JPA Derived Identifiers

A unidirectional one-to-one relationship Permalink to "A unidirectional one-to-one relationship"

A unidirectional one-to-one relationship means that the citizen instance can get its passport, but the passport instance can’t get to its owner.

Citizen (1) -----> (1) Passport

Generate the Passport entity first, without any relationship to its owner:

jhipster entity Passport
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? No

Then, generate the Citizen entity:

jhipster entity Citizen
...
Generating relationships to other entities
? Do you want to add a relationship to another entity? Yes
? What is the name of the other entity? Passport
? What is the name of the relationship? passport
? What is the type of the relationship? one-to-one
? Is this entity the owner of the relationship? Yes
? Do you want to use JPA Derived Identifier - @MapsId? No
? What is the name of this relationship in the other entity? citizen
? When you display this relationship with Angular, which field from 'Passport' do you want to use? id

After doing this, a Citizen possesses a passport, but no Citizen instance is defined in Passport. On the generated Angular/React client UI you will have a dropdown in Citizen to select a Passport since Citizen is the owning side. This is the corresponding JDL:

entity Citizen
entity Passport

relationship OneToOne {
  Citizen{passport} to Passport
}

Using JPA Derived Identifiers(@MapsId) for one-to-one relationship Permalink to "Using JPA Derived Identifiers(@MapsId) for one-to-one relationship"

JPA Derived Identifiers can be used to have the most efficient mapping.

This is the corresponding JDL for previous uni-directional one-to-one example:

entity Citizen
entity Passport

relationship OneToOne {
  Citizen{passport} to @Id Passport
}

This is the corresponding JDL for previous bi-directional one-to-one example:

entity Driver
entity Car

relationship OneToOne {
  Car{driver} to @Id Driver{car}
}

However, based on business requirements, there might be cases where this should be avoided because it has following constraint: Once the id(primary key) is set at owning side, it is not changeable using JPA/Hibernate. You should not change it anyway.

Here are a few suggestions regarding usage:

Use @MapsId when:

  • Dependent - if the owning side (child entity) seems tightly dependent on the non-owning (parent entity).
  • Association value is never meant to be changed - if you are never going to change the id(primary key) of the child entity once it is set.

    For example:

      class User{}
      class Profile{ @OneToOne @MapsId private User user; } // profile is only meant for that user
      class Preferences{ @OneToOne @MapsId private User user; } // preference is only meant for that user
    

    Once a profile or a preference is created for a user, it will never change to refer to another user.

Do not use @MapsId when:

  • Not dependent - If the owning side (child entity) seems not dependent on the non-owning (parent entity)
  • Association value is meant to be changed - if you think that the child entity is going to refer to another parent entity in future.

    For example:

      class Car{ @OneToOne @JoinColumn(name="current_driver_id") Driver currentDriver} // car can be drived by another driver in future
      class Driver{@OneToOne(mappedBy = "currentDriver") Car drivingCar} // driver drives another car in future
    

    Both car and driver association value may change in future.

Note: There is a known issue regarding using @OneToOne with @MapsId and how to avoid it.

Setting fetching data strategy to eager (FetchType.EAGER) Permalink to "Setting fetching data strategy to eager (FetchType.EAGER)"

All the relationships use the default JPA FetchType:

  • OneToMany: LAZY
  • ManyToOne: EAGER
  • ManyToMany: LAZY
  • OneToOne: EAGER

There is a known issue of NPE during JSON deserialization due to eager fetch type. If you would like to set either OneToMany or ManyToMany relationship to FetchType.EAGER, you can use one of the following solutions:

  • Use @JsonInclude(JsonInclude.Include.NON_EMPTY) on the relationship

    For example:

      @OneToMany(mappedBy = "parent", fetch = FetchType.EAGER)
      @JsonInclude(JsonInclude.Include.NON_EMPTY)
      private Set<Child> child = new HashSet<>();
    
  • Return null if the collection is empty when fetching the resource in the backend
  • Using DTO and handle the edge case of empty collection

Embedded Entities for Couchbase and MongoDB Permalink to "Embedded Entities for Couchbase and MongoDB"

Couchbase and MongoDB supports relationships through embedded documents. For more information regarding embedded documents in MongoDB refer to https://docs.mongodb.com/manual/applications/data-models-relationships/ and for Couchbase refer to https://docs.couchbase.com/server/5.1/data-modeling/modeling-relationships.html.

You can define embedded documents simply by using @embedded. For example to define a one-to-one relationship;

entity Country {
  countryName String
}

@embedded
entity Region {
  regionName String
}


relationship OneToOne {
  Country to Region
}

Similarly, for a one-to-many relationship,

entity Country {
  countryName String
}

@embedded
entity Region {
  regionName String
}


relationship OneToMany {
  Country to Region
}

For a many-to-many relationship you can simply use the @embedded keyword in both directions;

@embedded
  entity Country {
  countryName String
}

@embedded
entity Region {
  regionName String
}


relationship ManyToMany {
  Country to Region
}