[jboss-user] [JBoss Tools] - cant get one-to-one reverse engineering to work for me

[Pete Pron]

Pete Pron [http://community.jboss.org/people/pete2k] created the discussion

"cant get one-to-one reverse engineering to work for me"

To view the discussion, visit: http://community.jboss.org/message/559680#559680

--------------------------------------------------------------
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

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

Reply to this message by going to Community
[http://community.jboss.org/message/559680#559680]

Start a new discussion in JBoss Tools at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2128]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100831/820be17d/attachment.html