Spring and Hibernate many to many table relationship error

[A Tham]

I would like to implement this relationship in Java Spring and Hibernate:



In my GnrlOrgChargeCode class, I have:

@OneToMany 
private List <IOrgChargeCodeCond> orgChargeCodeConds;

and in my OrgChargeCodeCond class, I have:

@ManyToOne
private IGnrlOrgChargeCode gnrlOrgChargeCode;
    
@OneToMany
private List <IBillingCondition> billingCondition;

and in my BillingCondition class:

@OneToMany
private List <OrgChargeCodeCond> orgChargeCodeCond;

and in my OrgChargeCodeRule class:

@ManyToOne
private BillingRule billingRule;

and in my BillingRule class:

@OneToMany(mappedBy = "billingRule")
private List<OrgChargeCodeRule> orgChargeCodeRules;

But when I startup Tomcat, I get this error:

Could not determine type for: java.util.Set, at table: ORG_CHARGE_CODE_COND, for columns: [org.hibernate.mapping.Column(billingCondition)]

My query is this:
select from GnrlOrgChargeCode gocc join OrgChargeCodeRule occr join BillingRule br join OrgChargeCodeCond occc join BillingCondition bc where gocc.orgId = ? assuming gocc.orgId is valid and there are rows in gocc.

Please help. thanks.

[Tim Holloway]

Your actual Hibernate JPA query would be quite easy, since all the joins are automatic in JPA.

But you didn't actually define a @ManyToMany relationship on anything there.

I appreciate your attempting to keep the code samples short, but if you could display more of the entity class definitions of GNRL_ORG_CHARGE_CODE, the join table GNRL_CHARGE_CODE_COND and the BILLING_CONDITION class, it would help a lot.

The things I need to see are the class definition line and its annotations, the joining annotations and the class member definitions for those joining annotations.

[Himai Minh]

This thread may be helpful https://stackoverflow.com/questions/6164123/org-hibernate-mappingexception-could-not-determine-type-for-java-util-set

Adding @ElementCollection for the list of billing collection may help.