Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

3.2.6

Oracle 10g


General mapping question.

I have a three tables.

user, customer, employee.

Right now customer inherits from user.
employee inherits from user.


I have three different tables
user has its own id call user_id
customer has its own id call customer_id
employee has its own id call employee_id

I want to have three different mapping files.

how would you map this relationship in hibernate.

customer_id to user_id is one to one.
so is employee_id to user_id.

Hi,
Is this a legacy database schema or you have some ability to make changes to it? Ideally, I would use the Joined Sub Class inheritence strategy in hibernate, and hibernate will take care of building the appropriate queries for me.