Hi guru, we are trying to create a domain model with a not normalized database
Data from the same entity are scattered among different table, this is due to a bad specifie of er.
For example we have an employee table, and empl_detatails1, empl_details2 table an so on.
From a java point of view we would like to solve this proble and we would like to have only one object emp with all attributes from employee table, and empl_detatails1 and so on.
As far as I Know I can specify only one table in metadata xml configuration file.
Any Idea?
Thanks in advance
Marco

Why not having corresponding model for the employee?

employee, employee.details1, employee.details2
(e.g. other entities for empl_details1, and empl_details2 etc...)

You can have the details lazy loaded, you could safe selects if you don't need them always. You will have the data structured.

Regards,
Pavol

we think that the domain model must be free from relation database schema. Of course we can follow database schema structure but, as an execise, we are wondering if we can really choose or if, because of hibernate limitations, we have a limitated freedom.
Your idea is good, but is the only one?
In other word using composition I can avoid an hibernate limitation ( for every domain object only one table). isn't it?.
Thanks
Marco

See

http://www.jdocs.com/javaee/5.0.0/javax ... Table.html

Hope it helps,
Pavol

Yes! very usefull. Exactly what we are looking for!
Thank!
Marco