Hi everyone,

I'm using the Jboss hibernate tools to reverse engineer an existing database and generating java + hbm.

Currently I'm becoming desperate by trying to resolv an one-to-one mapping. There is always a one-to-many & many-to-one

generated and I don't know what to do.

Its fine for me that the tools are trying to create a one-to-many (it could be) but I'm searching for a way to define this relationship as one-to-one.

First of all:

Its an Oracle 10 Database and Hibernatetools Version: 3.3.0.v20100720-0040-H162-M1

Detect one-to-one associations is turned on.

Here is the relevant SQL:

-----------------------------------------------------------------------------------------

CREATE TABLE EXT_ADDRESS (

        ID NUMBER(22 , 0) NOT NULL,

        ...

        <many attributes>

        ..

        ADDRESS_ID NUMBER(22 , 0) NOT NULL

    );

CREATE TABLE ADDRESS (

        ID NUMBER(22 , 0) NOT NULL,

        ...

        <many attributes>

    );

ALTER TABLE EXT_ADDRESS ADD CONSTRAINT EXT_ADR_PK PRIMARY KEY (ID);

ALTER TABLE ADDRESS ADD CONSTRAINT ADR_PK PRIMARY KEY (ID);

ALTER TABLE EXT_ADDRESS ADD CONSTRAINT EXT_ADR_FK FOREIGN KEY (ADDRESS_ID)

    REFERENCES ADDRESS (ID)

    ON DELETE RESTRICT

    ON UPDATE CASCADE;

-----------------------------------------------------------------------------------------

Here what I already tried to do in my hibernate.reveng.xml:

-----------------------------------------------------------------------------------------

    <table name="EXT_ADDRESS" >

        <column name="ID" type="long"></column>

        <foreign-key constraint-name="EXT_ADR_FK">

            <!-- <many-to-one exclude="true"/>

             <set exclude="true" /> -->

             <one-to-one exclude="false"/>

             <inverse-one-to-one exclude="false"/>

        </foreign-key>

    </table>   

-----------------------------------------------------------------------------------------

This doesn't work and there is always a Set of ExtAddress defined in Address. The table definition and the foreign

key should be correct. If i uncomment the many-to-one and set with exclude true the set is removed.

Any help is highly appreciated. Thanks

Pete