Hibernate version: 3.0.4

Name and version of the database you are using: Oracle 10g

Not sure how/why this works the way it works, but I think there has to be a simple solution within hibernate.

There are 3 objects involved:
- User
- Asset
- VideoAsset (joined-subclass of Asset)

All Asset objects are owned by a User.


I would like to have sets of the concrete subclasses into User.



But the above doesnt work because it looks for user_id in the Video_Asset table. In fact, when I use the above mapping with hibernate DB auto-gen, it creates a column user_id in the table Video_Asset. Then User.getVideoAssets() only returns those assets that have the Video_Assets.user_id set. (And saving a Video_Asset sets the user_id in the Asset table.

Something like:



But really, I would think that it would automatically look in the parent class for the key. *sigh*

Thoughts? Thank you.

I found several posts on this problem and haven't seen any answers. I am also facing the same exact issue where the <key/> in a collection always maps to the derived class table even when the foreign key is actually in the base class. It seems to me that the easy fix would be to allow specifying the table name to use for the foreign key. A nicer way would be to automatically determine which table the key is in through reflection.

I have eventually gotten around the problem by creating view tables for my subclasses that mimic the "table per concrete class" approach (or at least whichever additional colmns I need to access) and then mapping my hibernate file to the View for the subclass, with the duplicated parent column rows either not mapped in the mapping file (for collection sorts it's not necessary) or listed with insert/update=false.

I still actually have the underlying tables set up as a "table per subclass" approach which is how I want my data organized in the event that I remove the hibernate layer.

If anyone wants me to elaborate I can, but I am just trying it now so maybe I will run into more issues down the road. =)