All,

The project I am currently working on involves the generation of cfg.xml and hbm.xml files from the DB schema. There is one table called p_d_intervals and it describes the available intervals of time. It contains only 4 rows, no foreign keys and an auto-generated primary key.

Then, there is a p_d_log table that contains log entries. This table has a column that is a foreign key referring to the p_d_interval.id.

The problem is that whenever I try to generate the schema. it produces two object links in between the table. Each log entry contains one interval type which refers to the interval of time for the log entry. This is correct. Then, there is a field in the interval type that is a SET containing all log entries of that interval type. This would make sense in reality, but not with our object model. This is an unnecessary waste of space. How do i remove this from my object model without affecting the DB schema????

Please note that this is my first trial at hibernate.

I am using the Bauer/King Java Persistence with Hibernate (Manning). I noticed that in the only real example for reverse engineering, they do not fully demonstrate how to block bi-directional object mapping, because it is a self-referring table. The example FROM THE BOOK is here:



appropriate excerpt from MY reveng.xml:



Thanks for any and all help you may provide.

-Hiren
-EMAIL: hhiranan AT gmail DOT com

PS. I am at work and currently dealing with the issue, so any and all assistance whenever possible is much appreciated. Thanks again.

do like the example and have a foreign-key element with the apropriate name for it and mark is having the set excluded.

OR write a custom reveng strategy that returns false for the method excludeForeignKeyAsCollection

Thanks...
Problem's solved.



-H