0 Replies Latest reply on Jul 12, 2006 1:34 PM by Matthew Whearty

    @ManyToMany mapping with additional columns for ordering

    Matthew Whearty Newbie

      I have run into the following situation with a manytomany relationship:

      table A:
      int apk
      ...
      ...

      table B:
      int bpk
      ...
      ...

      table A_B:
      int apk
      int bpk
      int sequenceId

      where the sequenceId in the mapping table is used to order the children of type B for a parent A (B can have more than one parent, so the sequence id cant be in table B) how would i map this relationship with EJB3 annotations?