Hibernate collection set column as index

Question

I looked into the documentation (hibernate 4.1) . And I'm kind of confuse, I wish to be able to use the annotation @OrderColumn(name="orders_index") in my set Collection (for design purpose). Right now, I'm actually adding manually a orders_index manually in my PersonnalTaskMacro but it's getting a pain in the * (I need to refactor that...). I came accross the @MapKeyColumn(name="orders_number"), but it's not really what I want. How can I achieve this?

@Entity
@Table(name = "PERS_TASK_MACRO_PARAMETER")
public class PersonnalTaskMacroParameter extends Parameter {

    /* .... */

    @OneToMany(cascade = { CascadeType.ALL } , fetch = FetchType.LAZY)
    @JoinTable(name = "PERS_TASK_MACRO_JOIN", 
    joinColumns = { @JoinColumn(name = "MODULE_PARAMETER_ID") }, 
    inverseJoinColumns = { @JoinColumn(name = "PERS_TASK_MACRO_ID") })
    @ForeignKey(name="FK_PERS_TASK_MACRO_PARAM_ID", inverseName="FK_PERS_TASK_MACRO_ID")
    private Set<PersonnalTaskMacro> personnalTaskMacroSet = new HashSet<PersonnalTaskMacro>();

/* .... */
}

sharakan · Accepted Answer · 2013-02-14 16:59:43Z

1

A Set is not an ordered collection. The documentation you cited points in the right direction: change

Set<PersonnalTaskMacro> personnalTaskMacroSet ...

to

List<PersonnalTaskMacro> personnalTaskMacros ...

You can also use SortedSets to do something similar, but that depends on the sort key being part of the entity that you have a collection of.

answered Feb 14, 2013 at 16:59

sharakan

6,9212 gold badges38 silver badges63 bronze badges

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

1 Comment

sharakan Over a year ago

Happy to help. If you're all set, you should accept the answer, using the green check.

Collectives™ on Stack Overflow

Hibernate collection set column as index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related