I am trying to map the standard User-Role relationship. The roles are keep in a table with a roleId. This is a static list of roles. The user can have many roles. I have a join table that tracks the user to his roles. I am using the following mapping on the User object to populate the roles:



This mapping works fine when I query a user. The problem I am having is when I update or create a user an extra update is performed against the Role table even though this table did not change.

Is there any way to eliminate this relationship?

Thanks,
Pete

hi

you have a concept error, you have mapping yours objects thinking in relational model, when you have objects, you have to generate your object model and then map it. you have generate first your data model and then you map it, it's no so fine.

but to solve your problem you can't map your model with many-to-many.

when your relational model is like that

Table1<->relationalManyToMany<->Table2

you have to create then middle object and then map
ObjectTable1 one-to-many MiddleObject
and
ObjectTable2 one-to-many MiddleObject

I hope it help you