[hibernate-dev] Upgrading Hibernate Causes null index column for collection error for List

[Amit Shah]

We are trying to upgrade hibernate from version 4.3.5 to 5.4.0. With this
the jpa version also changes from hibernate-jpa-2.1 to jpa-2.2. After the
upgrade we get the following error when using the List<> collection with
@OrderColumn

"javax.persistence.PersistenceException: org.hibernate.HibernateException:
null index column for collection"

It is a unidirectional one-to-mapping with following annotations

@Entity at Table(name = "DS_GENERIC")@PrimaryKeyJoinColumn(name =
"DSG_DS_ID")public class GenericConnection extends
DataSourceConnection {

    @OneToMany(cascade = ALL, orphanRemoval = true, fetch = FetchType.EAGER)
    @JoinColumn(name = "DSC_DS_ID", nullable = false)
    @OrderColumn(name = "DSC_ORDER", updatable = false, insertable = false)
    List<Credentials> credentials = new ArrayList<>();
}
@Entity at Table(name = "DS_CREDENTIALS")public class Credentials {

    @Id
    @GeneratedValue(generator = "uid-generator")
    @Column(name = "DSC_ID", updatable = false)
    private Long id;

    //...}

The below test code fails

//construct the connection object with credentials
entityManager.persist(connection);
entityManager.find(DataSourceConnection.class, id); //this call fails
with the above error

Note that this code worked fine with hibernate 4.3.5 and one workaround
that also works is converting List to Set as below

@OneToMany(cascade = ALL, orphanRemoval = true, fetch =
FetchType.EAGER)@JoinColumn(name = "DSC_DS_ID", nullable =
false)@OrderBy("DSC_ID")Set<Credentials> credentials = new
HashSet<>();

I do not understand the root cause of this failure. Any inputs would be
appreciated.

Thanks.

P.S - I have posted this query on stackoverflow too
<https://stackoverflow.com/questions/54686603/upgrading-hibernate-causes-null-index-column-for-collection-error-for-list>