Hi all,

I have a problem with hbms generated from HibernateTools v3.1 beta2;
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.

Is this due to a wrong database design or is this a reverse engineering problem ?

Thank you in advance
Andi

the reveng tools does not detect this as a one-to-one. it probably could, so add a request/patch to jira.

Thank you,

I'll post to Jira.

Andrea