I am trying to map a complicated schema which has a table that contains several different subtypes but the descriminator on that table is an id into a second table that names the subtype. This schema was made to be very generic so we can have one instance of the schema for each customer and allow each customer's schema to have different subtypes.

table Foo:{id, foo_type_id, ... }

table Foo_Type {foo_type_id, ....}

I tried maping the Foo subtypes using a @DiscriminatorFormula but hibernate seems to choke when it tries to generate the SQL. Is there a way to discriminate a subtype by referencing a different table?


Thank you

I figured it out on my own but I will post the answer here in case anyone else has the same problem.

I wrapped the subselect in the @DiscriminatorFormula annotation with parenthesis.

@Entity
...
@DiscriminatorFormula(
"(select Foo_Type.type from Foo_Type where Foo_Type.foo_type_id = foo_type_id )"
)

by adding the parenthesis, hibernate was able to add the sub select inside the Foo SQL select clause.

select id, foo_type_id, (select Foo_Type.type from Foo_Type where Foo_Type.foo_type_id = foo_type_id ) from ....

Very clever!

Thanks for posting the solution. So many people forget to.