Hibernate persists lists with start index 1 instead of 0

Question

We use Hibernate to save a list of entities using OrderColumn to maintain their order.

class MyObject {

...

   @OneToMany(mappedBy = "myobject", cascade = {CascadeType.PERSIST, CascadeType.DETACH, CascadeType.MERGE, CascadeType.REFRESH})
   @OrderColumn(name = "index_number")
       private List<sampleElement> sampleElement;
}

When saving the list of elements, the index_number starts with 1 while the documentation suggests it should start from 0. This also causes an issue upon reading because the read list then contains a null element at position 0.

We have looked around quite a bit and are somewhat out of ideas. Any suggestions?

SternK · Accepted Answer · 2020-02-27 09:49:44Z

1

It can be customized by using @ListIndexBase.

Defines the start index value for a list index as stored on the database. This base is subtracted from the incoming database value on reads to determine the List position; it is added to the List position index when writing to the database. By default list indexes are stored starting at zero.

  @OneToMany(mappedBy = "myobject", cascade = {CascadeType.PERSIST, CascadeType.DETACH, CascadeType.MERGE, CascadeType.REFRESH})
  @OrderColumn(name = "index_number")
  @ListIndexBase(1)
  private List<sampleElement> sampleElement;

See also this section of the hibernate documentation.

answered Feb 27, 2020 at 9:49

SternK

13.3k34 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate persists lists with start index 1 instead of 0

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related