Hi All,

I am in the process of migrating a piece of Java code to use Hibernate version 3.

I have a peculiar problem.


I want to map a table to two different classes for selected fields. i.e.




Both JobCommon and Repair class need to be mapped to the specific fields in table Repair as shown above.

Is it possible to do that in Hibernate? I have searched around and found that you can map 1 class to multiple tables but not vice-versa.

Please can anyone share some insights on how to approach this problem?

Thanks

You will need to define or add a descriminator column in the table, and use the sub-class mapping.

http://www.hibernate.org/hib_docs/v3/reference/en/html/inheritance.html
This part of the documentation is applicable for you :)

Hello Matt,

The classes which I have described are not sub classes of each other but 2 concrete classes. I am not sure how sub-class inheritance can be applied here.

Please could you give me an example mapping? :-)

Thanks for your support!

Thanks,
Suraj

Hello, I am sorry I misunderstood your first post.

I think, what you want to do is impossible with Hibernate. Perhaps a more experienced user can help you :)

You could create a common superclass and use the inheritance mapping.

Another idea would be to create views for each class and map to them instead of the table, but I am not sure if this works. Never worked with views and Hibernate.