Reverse of one-to-one relationships ----------------------------------- Key: HBX-524 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-524 Project: Hibernate Tools Issue Type: Bug Components: reverse-engineer Affects Versions: 3.1beta2 Environment: HIbernate 3.1, Oracle 9i Reporter: Andrea Cattani Hi, I've posted this issue to the forum and got this response from Max, Hibernate Team: "the reveng tools does not detect this as a one-to-one. it probably could, so add a request/patch to jira." The problem I've faced is the following: I have two tables, let's say - table A with column ID (PK) and other fields - table B with column ID (PK) and other fields table B has a foreign key constraint against table A, from column ID to column ID (one-to-one) When I reverese the tables with the HibernateTools I have such a resultant mapping for table B: <class name="B" table="B" schema="SCHEMA"> <id name="id" type="string"> <column name="ID" length="12" /> <generator class="assigned" /> </id> <[b]many-to-one name[/b]="a" class="A" update="false" insert="false" fetch="select"> <column name="ID" length="12" not-null="true" unique="true" /> </many-to-one> .... And this one for table A: <class name="A" table="A" schema="SCHEMA"> <id name="id" type="string"> <column name="ID" length="12" /> <generator class="assigned"/> </id> <set name="b" inverse="true"> <key> <column name="ID" length="12" not-null="true" unique="true" /> </key> <[b]one-to-many[/b] class="B" /> </set> </class> while I was expecting something like: [i]<one-to-one name="a" class="A" constrained="true"/>[/i] in table B, and the same (or nothing) in table A Thank you Andi