ManyToMany mapping with a JoinTable having extra fields - Ho

[sreeraaman]

Hi All,

I have two tables viz. Client and Employee and a JoinTable Client_Employee having two fields client_id and Employee_id which are foreign keys to the Client and Employee table respectively. However, if I want to have an additional field in the JoinTable like Emp_No, how to handle this in ejb3?

[yilmaz_]

i am not sure but you may have to create another entitybean.

[waynebaylor]

i agree, you should try mapping the relationship to another entity: Client <-->RelationshipEntity<-->Employee