| 
					
						 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 
					
  
						
					 |