Difference Between One-to-Many, Many-to-One and Many-to-Many?

by

Looks like everyone is answering One-to-many vs. Many-to-many:

The difference between One-to-many, Many-to-one and Many-to-Many is:

One-to-many vs Many-to-one is a matter of perspective. Unidirectional vs Bidirectional will not affect the mapping but will make difference on how you can access your data.

  • In Many-to-one the many side will keep reference of the one side. A good example is “A State has Cities”. In this case State is the one side and City is the many side. There will be a column state_id in the table cities.

In unidirectional, Person class will have List<Skill> skills but
Skill will not have Person person. In bidirectional, both
properties are added and it allows you to access a Person given a
skill( i.e. skill.person).

  • In One-to-Many the one side will be our point of reference. For example, “A User has Addresses”. In this case we might have three columns address_1_id, address_2_id and address_3_id or a look up table with multi column unique constraint on user_id
    on address_id.

In unidirectional, a User will have Address address. Bidirectional
will have an additional List<User> users in the Address class.

  • In Many-to-Many members of each party can hold reference to arbitrary number of members of the other party. To achieve this a look up table is used. Example for this is the relationship between doctors and patients. A doctor can have many patients and vice versa.

More Related Contents:

  1. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  2. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  3. Hibernate Annotations – Which is better, field or property access?
  4. How to map calculated properties with JPA and Hibernate
  5. How to print a query string with parameter values when using Hibernate
  6. When and why JPA entities should implement the Serializable interface?
  7. How should equals and hashcode be implemented when using JPA and Hibernate
  8. I found JPA, or alike, don’t encourage DAO pattern
  9. Getting Database connection in pure JPA setup
  10. Hibernate – @ElementCollection – Strange delete/insert behavior
  11. session.connection() deprecated on Hibernate?
  12. Automatic reserved word escaping for Hibernate tables and columns
  13. Location of hibernate.cfg.xml in project?
  14. What’s the use of session.flush() in Hibernate
  15. how to configure hibernate config file for sql server
  16. How to set a default entity property value with Hibernate
  17. mappedBy reference an unknown target entity property
  18. Hibernate use of PostgreSQL sequence does not affect sequence table
  19. Primitive or wrapper for hibernate primary keys
  20. Enum in Hibernate, persisting as an enum
  21. JPA OneToMany and ManyToOne throw: Repeated column in mapping for entity column (should be mapped with insert=”false” update=”false”)
  22. Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)
  23. How to use Hibernate @Any-related annotations?
  24. How to turn off hbm2ddl?
  25. Hibernate triggering constraint violations using orphanRemoval
  26. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. Difference between @GeneratedValue and @GenericGenerator
  30. getting result set into DTO with native SQL Query in Hibernate

Leave a Comment