Hello,


I’m having some serious problems with the Hibernate reverse engineering process. I’ve tried the process with PostgreSQL and Mysql and both result in the same error.

I defined a DB in the EA then proceeded to its code generation. I have no problem using the script to create the DB in either the Database systems.

But when I try to generate the code with reverse engineer I get the same error code:



org.hibernate.MappingException: An association from the table restriction refers to an unmapped class: TargetReportingdata



Hibernate version: 3.2.0GA

Mapping documents: The tables i am having problems with are:

CREATE TABLE target_reportingdata
(
targetdef_id INTEGER NOT NULL,
reportingdatadef_id INTEGER NOT NULL,
PRIMARY KEY (targetdef_id, reportingdatadef_id),
KEY (reportingdatadef_id),
KEY (targetdef_id)
)
;

and

CREATE TABLE restriction
(
id INTEGER NOT NULL,
targetdef_id INTEGER NOT NULL,
reportingdatadef_id INTEGER NOT NULL,
restrictiontype_id INTEGER NOT NULL,
restriction_value INTEGER NOT NULL,
description VARCHAR(100),
eventdef_id INTEGER NOT NULL,
PRIMARY KEY (id),
KEY (eventdef_id),
KEY (restrictiontype_id),
KEY (targetdef_id, reportingdatadef_id)
)
;

ALTER TABLE restriction ADD CONSTRAINT FK_restriction_target_reportingdata
FOREIGN KEY (targetdef_id, reportingdatadef_id) REFERENCES target_reportingdata (targetdef_id, reportingdatadef_id)
;


Full stack trace of any exception that occurs: org.hibernate.MappingException: An association from the table restriction refers to an unmapped class: TargetReportingdata
at org.hibernate.cfg.Configuration.secondPassCompileForeignKeys(Configuration.java:1252)
at org.hibernate.cfg.JDBCMetaDataConfiguration.secondPassCompileForeignKeys(JDBCMetaDataConfiguration.java:33)
at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1170)
at org.hibernate.cfg.Configuration.buildMappings(Configuration.java:1115)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate$2.execute(CodeGenerationLaunchDelegate.java:322)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:88)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate.buildConfiguration(CodeGenerationLaunchDelegate.java:288)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate.runExporters(CodeGenerationLaunchDelegate.java:219)
at org.hibernate.eclipse.launch.CodeGenerationLaunchDelegate.launch(CodeGenerationLaunchDelegate.java:134)
at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:766)
at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:608)
at org.eclipse.debug.internal.ui.DebugUIPlugin.buildAndLaunch(DebugUIPlugin.java:899)
at org.eclipse.debug.internal.ui.DebugUIPlugin$7.run(DebugUIPlugin.java:1102)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)


Name and version of the database you are using: PostgreSQL 8.2 and Mysql 5.0

Thanks in advance for a reply,
Hspoupas

Just to clarify some questions some people ask me when they first read my problem.

I have the DB created, i then create the cfg in eclipse and the console configuration as annotations and i have all the tables there.
When i try to reverse engineer to generate the DAO, Domain Code and cfg, i get the exception i referred.

I would be very grateful if someone can identify and solve the problem here.



I have found my problem and know what i need to do, sorry for the trouble.
You can delete this post.

Please do share ?

Alright. The problem was that the table Target_ReportingData, that was the result of the exception, wasn't being mapped since it was an associative table(the result of the normalization of a N-M relation), hence the exception.

The ER will be modified due to to other reasons so now i know i can't try to relate those tables that way.

but if you used reverse engineering this should not throw an exception...did you write some hbm.xml files your self or ?

no, didn't write anything, just followed the instructions i mentioned in my second post.
My Hibernate Code Generation has the Detect many-to-many tables option selected of course, otherwise there wouldn't be much interest in the code generated.

open an issue in jira with the minmal schema that makes this fail and i'll look into it.

Is this still an issue? And what is the issue tracking number??

I know this is an old thread, but I am having the same issue with PostgreSQL 9.2 and hibernatetools 4.0.0.RC1.

Any hints?

Thanks in advance!

{{{{{{ This post is so great and nice }}}}}}}}

I know this is an old thread, but I am having the same issue with PostgreSQL 9.2 and hibernatetools 4.0.0.RC1.