Databases
StackOverflow2013
Postsdbo
POConstraint violation in Hibernate unidirectional OneToMany mapping with JoinTable and OrderColumn when removing elements
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConstraint violation in Hibernate unidirectional OneToMany mapping with JoinTable and OrderColumn when removing elements
    primarykey
    data
    text
    <p>I have a problem when removing elements from a list mapped as described above. Here is the mapping:</p> <pre> @Entity @Table( name = "foo") class Foo { private List bars; @OneToMany @OrderColumn( name = "order_index" ) @JoinTable( name = "foo_bar_map", joinColumns = @JoinColumn( name = "foo_id" ), inverseJoinColumns = @JoinColumn( name = "bar_id" ) ) @Fetch( FetchMode.SUBSELECT ) public List getBars() { return bars; } } </pre> <p>Inserting Bar-instances and saving the Foo works fine, but when I remove an element from the list and save again, the unique constraint on bar_id in the mapping table is violated. The following SQL-statements are issued by hibernate, and these look quite odd:</p> <pre> LOG: execute : delete from foo_bar_map where foo_id=$1 and order_index=$2 DETAIL: parameters: $1 = '4', $2 = '6' LOG: execute S_5: update foo_bar_map set bar_id=$1 where foo_id=$2 and order_index=$3 DETAIL: parameters: $1 = '88', $2 = '4', $3 = '0' ERROR: duplicate key value violates unique constraint "foo_bar_map_bar_id_key" </pre> <p>The error perfectly makes sense, given the statements generated by Hibernate (there are five items in the list, I remove the first one and Hibernate deletes the mapping row with the LAST index and the tries to updates the remaining ones, starting with the first).</p> <p>What is wrong with the mapping above?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPascal Thivent
    1. UStbk
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConstraint violation in Hibernate unidirectional OneToMany mapping with JoinTable and OrderColumn when removing elements
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POConstraint violation in Hibernate unidirectional OneToMany mapping with JoinTable and OrderColumn when removing elements
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POConstraint violation in Hibernate unidirectional OneToMany mapping with JoinTable and OrderColumn when removing elements
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload