Limiting outer joins in hibernate

[Tom Bigbee]

Supposedly you are supposed to be able to limit the number of outer joins performed on a joined inheritance strategy. I'm trying to make a pattern where I can have an unlimited number of subtype tables

Pages 209-210 of the Book: Java Persistence with Hibernate, specifies that some RDBMs limit the number of tables in the outer joins, it goes on to show you how to do this with an xml mapping file using the <subclass> <join> and <join table> tags

the book then goes on to specify that Java Persistence also supports this mixed inheritance mapping strategy with annotations.

I'm using annotations, and can't seem to limit the outer joins

I've tried @Inheritance(strategy = InheritanceType. ( SINGLE_TABLE and JOINED ) on the SuperClass

I've tried specifying the @Column(table = (on the columns)

I've also tried @Table and SecondaryTable on the SubClasses

@Entity
@DiscriminatorValue("SC 1")
@SecondaryTable(name = "SUB_CLASS_ONE",
        pkJoinColumns = @PrimaryKeyJoinColumn(name = "SUB_CLASS_ONE_ID"))
 
//@Table(name="SUB_CLASS_ONE",catalog = "subclass_test", uniqueConstraints = {})
//@PrimaryKeyJoinColumn(name="SUB_CLASS_ONE_ID")

In both cases the Left out joins are are performed...

    select
        mainclass0_.MAIN_CLASS_ID as MAIN1_0_,
        mainclass0_.MAIN_CLASS_NAME as MAIN2_0_,
        mainclass0_.SUB_CLASS_TYPE as SUB3_0_,
        mainclass0_1_.SUB_CLASS_ONE_ID as SUB1_3_,
        mainclass0_1_.SUB_CLASS_ONE_NAME as SUB2_3_,
        mainclass0_2_.SUB_CLASS_TWO_ID as SUB1_4_,
        mainclass0_2_.SUB_CLASS_TWO_VALUE as SUB2_4_,
        case 
            when mainclass0_1_.SUB_CLASS_ONE_ID is not null then 1 
            when mainclass0_2_.SUB_CLASS_TWO_ID is not null then 2 
            when mainclass0_.MAIN_CLASS_ID is not null then 0 
        end as clazz_ 
    from
        subclass_test.main_class mainclass0_ 
    left outer join
        subclass_test.Sub_Class_One mainclass0_1_ 
            on mainclass0_.MAIN_CLASS_ID=mainclass0_1_.SUB_CLASS_ONE_ID 
    left outer join
        subclass_test.Sub_Class_Two mainclass0_2_ 
            on mainclass0_.MAIN_CLASS_ID=mainclass0_2_.SUB_CLASS_TWO_ID 
    where
        mainclass0_.MAIN_CLASS_ID=?

My question is - How do I limit the outer joins using annotations?

Thanks, in advance for your assistance
[ January 30, 2007: Message edited by: Tom Bigbee ]