aspose file tools*
The moose likes Object Relational Mapping and the fly likes Hibernate tool code generation org.hibernate.MappingException: Foreign key Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate tool code generation org.hibernate.MappingException: Foreign key" Watch "Hibernate tool code generation org.hibernate.MappingException: Foreign key" New topic
Author

Hibernate tool code generation org.hibernate.MappingException: Foreign key

Sven Beckmann
Greenhorn

Joined: May 06, 2010
Posts: 6
Hi,

I am working on some school project and have been trying to get my pojos, daos and mapping.xml documents generated.
I get some of my classes generated but others not.
When I select the option "Reverse Engineer from JDBC Connection" I get an Error Message:



I have been working with the Hibernate tools before and had no problems. Does anyone have an idea?

Thanks in advance.

I am using MySQL 5.1 with InnoDB. Here is my SQL:
Joe carco
Ranch Hand

Joined: Apr 14, 2009
Posts: 82
from what I gather is that tResearch has a composite primary key and your only referencing a part of it in the foreign key in tStudent.
Try referencing the entire composite key of tResearch in your foreign key in tStudent
Sven Beckmann
Greenhorn

Joined: May 06, 2010
Posts: 6
Hey,

but there are no composite keys in tReseach, just simple foreign key constraints.
Joe carco
Ranch Hand

Joined: Apr 14, 2009
Posts: 82
are you sure? check your sql code, youre using composite PK's in almost all of youre tables:

(line 155)

some of the primary keys in your tables ARE foreign keys
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate tool code generation org.hibernate.MappingException: Foreign key