Hi
I am using Hibernate3
I have a table named "users" with columns :
Id_user int
username varchar
password varchar

the id_user is primary key and incremental, but there is another table named "roles"
I want to relation two table with column "username" but Hibernate use my primary key to join two table. how can I join two table with another column in a table, i dont want to join with primary key column.

my mapping in user.hbm.xml is:
.....
<set name="roles" lazy="false" inverse="false" table="role">
<key column="userName" />
<one-to-many class="com.project.conf.value.Role" />
</set>
.....
<there is a Set in class User>

hibernate use id_user to join table users with roles

pls help me....

thank u in advance

see description fro many-to-one and one-to-many in documentation - yuo can specify column property in association

No u cant do this bcaz as I said my column is not a primary key.
the <one-to-many> only use primary key to join two tables , I want using another field of the table

It is recommended, but you can make relation in hibernate without primary or foreign key

try, you can do it

ok I tried before and if u know how to do this plz help me and if not, plz dont waste my time with your reply.

Hello,
I think you can use property-ref attribute of the key to point to the property you want to use in join condition.

Hi

I used property-ref as following

<set name="roles" lazy="false" inverse="false" table="role">
<key property-ref="userName" />
<one-to-many class="com.project.conf.value.Role" />
</set>


but it seems that hibernate use "userName" of class "com.project.conf.value.Role" to join with userId of the user table but I want to use userName of user table and join it with userName of Role table

Hi

Try this

<set name="roles" lazy="false" inverse="false" table="role">
<key column="userName" property-ref="userName" />
<one-to-many class="com.project.conf.value.Role" />
</set>

Aswin