Two entities joined via third entity using @manytomany
SYLIST.java
@ManyToMany( fetch = FetchType.EAGER)
@JoinTable(
name = "`sy-list-member`",
schema="PUB",
joinColumns = {@JoinColumn(name = "`list-id`")},
inverseJoinColumns = {@JoinColumn(name = "`list-member-id-code`")} )
public List<SvFund> getFunds() {
SVFUND.java
@ManyToMany(mappedBy = "funds")
public List<SyList> getMyLists() {
When returning SYLIST hibernate generates this sql:
select funds0_."list-id" as list2_1_, funds0_."list-member-id-code"........
however when attempting to return SVFUND hibernate generates this:
select mylists0_.list-member-id-code as list3_1_, mylists0_.list-id as list2_1_
In essence the escaping of the hyphenated column name works one way but not the other.
Seems a little buggish but can I work around this ??
Any assistance GREATLY appreciated
|