One-To-Many Relationship with Join Table

by

The typical table for one T1 to many T2 is to have a foreign key on T2 pointing toward T1. The T1_T2 table is usually not needed.

The JPA structure would then be a One-To-Many, possibly two-way.

There could be some arrangements, to make the structure you describe work. You could change T1_T2:

  • add a unique constraint on T2 (so that only one T2 is allowed)

Is that really what you want?

Edited: yes, it is what you want 😉

I doubt you may find many examples on the net. I have no proved solution, but I would try something along these lines:

In Hibernate annotation reference documentation, see “2.2.5.3.2.3. Unidirectional with join table” to get the idea. It looks like:

    @Entity
    public class Trainer {
        @OneToMany
        @JoinTable(
            name="TrainedMonkeys",
            joinColumns = @JoinColumn( name="trainer_id"),
            inverseJoinColumns = @JoinColumn( name="monkey_id")
        )
        public Set<Monkey> getTrainedMonkeys() {
        ...
    }

More Related Contents:

  1. No Persistence provider for EntityManager named
  2. Confusion: @NotNull vs. @Column(nullable = false) with JPA and Hibernate
  3. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  4. When to use EntityManager.find() vs EntityManager.getReference() with JPA
  5. Persistence unit as RESOURCE_LOCAL or JTA?
  6. Correct use of flush() in JPA/Hibernate
  7. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  8. Hibernate: “Field ‘id’ doesn’t have a default value”
  9. Sharing a persistence unit across components in a .ear file
  10. JPA 2 CriteriaQuery, using a limit
  11. PersistenceUnit vs PersistenceContext
  12. What is Persistence Context?
  13. Name attribute in @Entity and @Table
  14. Setting a JPA timestamp column to be generated by the database?
  15. When to use DiscriminatorValue annotation in hibernate
  16. Can someone explain mappedBy in JPA and Hibernate?
  17. When and why JPA entities should implement the Serializable interface?
  18. Spring Boot – Cannot determine embedded database driver class for database type NONE
  19. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  20. Handling soft-deletes with Spring JPA
  21. Getting Database connection in pure JPA setup
  22. Hibernate and no PK
  23. Parameter in like clause JPQL
  24. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  25. Is it possible to dynamically define column names in Hibernate / JPA?
  26. How to use @Transactional with Spring Data?
  27. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  28. JPA Updating Bidirectional Association
  29. How to use JDO persistence manager?
  30. how to make a composite primary key (java persistence annotation)

Leave a Comment