Hibernate Mapping Files and POJOs from DB (Reverse Engineering) doesn't generate Foreign Keys

Question

I did this tutorial, and configured the Hibernate API and the mapping: https://netbeans.org/kb/docs/web/hibernate-webapp.html

(i'm using the JavaDB API with the 'sample' DB not MySQL)

But i have a problem: the generated hbm.xml files dont contain any foreign key mapping. (there are no one-to-many or many-to-one properties)

here is a sample class and mapping file. the RoleID should be a foreign key to the ROLE table ID field.

http://pastebin.com/tGnPTrXx

http://pastebin.com/bq4Q4RTi

im trying to edit the hibernate.reveng.xml file to force creating FK's - something like this:

<table name="USERS">
    <foreign-key constraint-name="ROLE_USER_FK" foreign-table="ROLE">
        <column-ref local-column="roleid" foreign-column="id" /> 
        <many-to-one property="roleid" />
    </foreign-key>
</table>

but it doesnt work.

krstf · Accepted Answer · 2011-11-19 16:41:06Z

1

solved: hibernate.cfg.xml needed the hibernate.default_catalog and hibernate.default_schema property

answered Nov 19, 2011 at 16:41

krstf

6278 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

S.Serem Over a year ago

I have added this to my config file but it does not seem to work for me, though I'm generating from PostgreSql DB.

Collectives™ on Stack Overflow

Hibernate Mapping Files and POJOs from DB (Reverse Engineering) doesn't generate Foreign Keys

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related