Hello:

I am not sure how to map this.

Table A { a(pk) , b ,c}

Table B {d, b (pk)}

Table C{f, b (pk)}


Please let me know if this insufficient information and i will be glad to give more information .

I dont get what you want to do here. Please be more detailed what this should really represent.

My question is how to map the property b of Table A to b of table B and to Table C.

So single property has to mapped to two columns on two different tables??? Pls advice.

You mean some entries in your b column of table A relate to entries of table B and some to table C? If yes, I don't think you can map this, this is a really broken relational model.

This is similar to what I am trying to do. I am using tomcat realm based security and it requires you to have 2 tables each haveing the same userName.(I included userId also so that I can update the userName) I am trying to figure this out and can't find documention on how to do it, unless I didn't understant it.

fields...
userId
userName
password
role

These fields have to be stored in the tables user and userRole

user table has these column.
userId (pk)
userName
password

userRoles table has
userId (pk)
userName
role

I dont know how to map this to the database.
Thanks for any help

Well you should be able to map this one very easily as a parent-child relationships using one-to-many and many-to-one

I am pretty new. All I have done so far is a simple one class one table mapping.

So I would make 2 mapping files? One for each table in the database? then using one-to-many and many-to-one reference the other tables mapping?

This is a one to one relationship. So why whould I use a one-to-many and many-to-one? This is my mapping so far. Would you mind pointing out what I have to change?



The loginId and role have to go into the userRole table along with the generated Primary Key (userId).

Well, if a user can have multiple roles its a one-to-many, otherwise a one-to-one. I suggest you read the according chapters of the docs, or some of the tutorials listed here http://www.hibernate.org/78.html#A3