Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 1.0.2

Name and version of the database you are using: SQL Server 2000

Hi all,

I am using NHIbernate for sometime. But I have a question, may be rather trivial.

I have a table "person" and table "rights"
there is a many to many relationship between the 2 tables.

I got this part on NHIbernate to work but how could I add a property on the link table

say the link table at the moment is

table(personId, rightId )

I wish to add a property called "isAdmin" making the table definition

table(personId, rightId, isAdmin)

how do I achieve that
??
and how does the nhibernate mapping go for it ??

Hi Friend,

By using hibernate U cant perform the DDL operations like create alter tables.
Bcz that will be done once.
So it is not possible other than insert, update and delete.

-------------------------------------------
dont forget to rate

Thanks For you prompt reply.

I think I might have confused you with my question. The question is not how to put a create table.

I already have these tables created but in many to many mapping how do I add an extra column along with the 2 id columns and how do I map it into my objects ?

Thanks

You can try a bag of components that has a bool (isAdmin) and a many-to-many...Otherwise map the link table as a distinct entity...

Anyhow, you can't still use a list/set of right objects from the person...some intermediate class must be created...

ok..
thanks for the clarification.
I thought of this but just wanted to make sure that I was not ignoring some feature.

Thanks A lot.
Pritesh