I think @OneToMany annotation does not work at all with @JoinFormula annotation.
I found some old issue https://hibernate.atlassian.net/browse/HHH-9897, but I'm not sure how to interpret it - that is whether it indeed was never supported, or that the specific case in that issue wasn't supported (i.e. with @JoinColumnsOrFormulas).
Having the following entity:
@Entity(name = "Invoice")
public static class Invoice {
@Id
private Long id;
@Column(name = "hierarchy_path")
private String hierarchyPath;
@OneToMany(fetch = FetchType.LAZY)
@JoinFormula(value = "hierarchy_path like id || '/_%'", referencedColumnName = "hierarchy_path")
private Set<Invoice> childInvoices = new HashSet<>();
}
The above mapping does not work. During validation we get exception
java.lang.ClassCastException: org.hibernate.mapping.Formula cannot be cast to org.hibernate.mapping.Column
Adding reverse side of the relationship (@ManyToOne with @JoinFormula) and adding "mappedBy" to @OneToMany does not change anything - still same error. Also it does not matter that in the attached example we have relation from table A to the same table A - I tested it with different tables with same result.
I'll attach a test Test case in a second : https://github . com/hibernate/hibernate-orm/pull/2547 |
|
