my table structure


table
person
columns
name
type (FK person_types)


assuming the PK etc are all there


type column is a foreign key from person_types table

person_types
id
alias
description


data for person_types
1 , customer,A customer
2 ,employee , An employer


data for person
mi, 1
mi1, 2


can I have hibernate inheritance for this table structure ? if so please help how can I ?

Please tell me if it is possible or not please let me know Please hibernate gurus, please help me.

Let me get this straight. You have a table called PERSON which has the columns: NAME, TYPE and a table called PERSON_TYPE which has the columns: ID, ALIAS, DESCRIPTION.

I assume there are corresponding objects. You should post the mapping files for those! In any case, I think you are saying that each Person has a reference to PersonType through the column TYPE which is a foreign key to the primary key in PERSON_TYPE.

If this is all true there is no inheritance and no need for a discriminator. A discriminator is used only if you have more than one class in a class hierarchy mapped to the same table.

If you haven't written your mapping files then post the java code for the two classes.

Hope this helps. Don't forget to rate if this is useful.