Hallo,

i am wondering if someone could help me with my little mapping problem. I already read the coresponding parts in the reference manual but i could not figure it out.

My mysql database has the following scheme:

productTable (common values for all products and shops)
productType1
productType2
productType3

i will map this to the following classes

product (interface)
shopProduct (customer specific product class, implements product interface)
productType1 (extends shopProduct)
productType2 (extends shopProduct)
productType3 (extends shopproduct)

my problem is that two fields (vendorId, vendorCatId) of the productTypeX tables are common to all products. So this fields are part of the shopProduct class and not of the detail productType classes.

Have you any suggestions how to map this?

Thanks!
Steffen

You might want to read hibernate documentation on the different strategies for handling inheritence.

http://www.hibernate.org/hib_docs/v3/re ... tance.html