Hi,

I'm using Hibernate Tools (nightly build 3.4.0) to reverse engineer my Database. Overall, it works smoothly, but I'm having trouble when trying to Map a Secondary Table to my Entities. I'll explain myself better:

I have a principal Table called ORDER_PART and a secondary Table called ORDER_PART_DETAIL that I use to persist optional data such as Files and Images. So, I'd like Hibernate Tools to generate a single Entity concerning this two tables, relying on the @SecondaryTable technique.

For example:



Is it posible to tell Hibernate Tools to generate this kind of relationship?

Maybe, some manual configuration on reveng.xml?

Thanks in advance.

Anybody?

If I read the Hibernate book right, @SecondaryTable is a JPA-only option.
I think Hibernate Tools is using the .hbm.xml data model, so I guess it's not available.

(This is supported by the fact that the HT Ant task sources do not contain SecondaryTable anywhere, not in Java and not in the template.)

In the book, I have seen this construction:
inside the <class> element.

I'd activate .hbm.xml generation, modify the generated .hbm.xml to use the above idiom, then re-generate and see if the <join> survives.
If yes, you have a chance of finding the appropriate options for reveng.xml; if no, you can stop worrying and start looking for an alternative design.

Joachim,

Finally, I've found out that this design technique (the Secondary table) is quite irrelevant in my particular case, as I tried to use it to insert the heavy fields (Clob and Blob) into a separate table, in order to fine tune my Database schema partitioning and backup routines.
So far, I've discovered that Oracle automatically creates another fisical table to store this kind of content, even if the final users don't notice it, as Oracle just shows the logical representation as a unique table.

Thank you so much anyway.