Hibernate nested joined-subclass

[Don Blodgett]

I am trying to get a mapping to work correctly, it is persisting correctly but it is not selecting correctly. My class hierarchy is as follows:

Person
--AffiliatedPerson
----AffiliatedUser
------AffiliatedUserPlayer
--------AffiliatedUserPlayerCoach
------AffiliatedUserCoach
----AffiliatedPlayer
------AffiliatedPlayerCoach
----AffiliatedCoach

When I save the object regardless of what class I save, it is persisted to the database correctly, but when I select an object that is supposed to be, for example, AffiliatedPlayerCoach I instead get an instance of AffiliatedCoach. In the select query, I see the following which looks to me is Hibernate attempting to determine the class to instantiate:

       case 
            when this_4_.person_id is not null then 8 
            when this_3_.person_id is not null then 6 
            when this_2_.person_id is not null then 2 
            when this_1_.person_id is not null then 1 
            when this_.person_id is not null then 0 
        end as clazz_0_ 

By looking at this I can understand that the reason I am getting an instance of AffiliatedCoach instead of AffiliatedPlayerCoach, because the first "when" would be true and so it would return 8 which I assume is being used as the index of all sub-classes in the mapping. I guess my question is, is there any way to have Hibernate use a different case statement for this, or have it check all 8 cases rather than just 5? The way I would see a proper case statement for this situation is as follows:

       case 
            when this_4_.person_id is not null and this_3_.person_id is null and this_2_.person_id is null then 8 
            when this_4_.person_id is not null and this_3_.person_id is not null and this_2_.person_id is null then 7
            when this_4_.person_id is null and this_3_.person_id is not null and this_2_.person_id is null then 6
            when this_4_.person_id is not null and this_3_.person_id is not null and this_2_.person_id is not null then 5
            when this_4_.person_id is null and this_3_.person_id is not null and this_2_.person_id is not null then 4
            when this_4_.person_id is null and this_3_.person_id is null and this_2_.person_id is not null then 3
            when this_2_.person_id is not null then 2 
            when this_1_.person_id is not null then 1 
            when this_.person_id is not null then 0 
        end as clazz_0_ 

Any help is greatly appreciated.

[Don Blodgett]

I managed to figure out a solution to this problem, not one that I particularly like, but it works. I created a sql-query that is basically the same as the query that Hibernate creates, but I replaced the case statement with my own case statement and eliminated a few of the redundant joins and it is working now.