Hi!

I let HibernateTools 3.1.0.beta4 reverse engineer a very simple db model:

table URLS:
urls_pkey
PRIMARY KEY (id)
urls_ukey
UNIQUE (url)

table HTML:
html_ukey
UNIQUE (urlid) // actually nonsense, I added this for HibernateTools but without success
html_fkey
FOREIGN KEY (urlid) REFERENCES urls(id) ON UPDATE CASCADE ON DELETE CASCADE
html_pkey
PRIMARY KEY (urlid)

In both cases urls and html it recognized a one-to-many relationship where it's actually one-to-one (1 url relates to 1 html doc and vice versa):

<set name="htmls" inverse="true">
<key>
<column name="urlid" length="32" not-null="true" unique="true" />
</key>
<one-to-many class="test.Html" />
</set>

Why is this?

BTW it also generated incorrect, non-parsable HBM like

<timestamp name="timestamp" type="timestamp" name="timestamp" />

regarding one-to-one, we just don't support that yet. patches are welcome in jira

regarding <timestamp> generation, please try out the latest nightly build. if that does not help report it in jira