I am using MySQL as db, and want to make a bean that has a primary key that references the primary key of another bean through a one - one relationship.

How can I make the primary key in one table also be a foreign key? Is this possible using JBoss?

I have tried to make the relationship (cmr-field-name) name be the same as the cmp field name, and setting the field to be the primary key, but JBoss doesn't let me do that.

If anyone else has done this, please help.

Thanks
Olve