Hello to all, I have begun to see Hibernate and I am with a situation that I cannot solve.
Let us suppose that I have a User class

and the Description class

For the attributes userType and userStatus would have to define a relation many-to-one to Description.
The problem is that depending that attribute, acceding Description class would have to mapear it to different tables, if the attribute is userType Description would have to mapear to TabUserType and if the attribute is userStatus would have to mapear to TabUserStatus.
They are possible to be made this type of mappings in Hibernate?
I am mistaken in the form in which I am trying to design my classes? Would have to make a subclass specific each attribute to be able to mapear to different tables?
Thanks beforehand for its time.

check out the docs on inheritance. Typically when you have a userType field, in my opinion, it calls for inheritance. Hibernate can easily handle creating different types based on a user field. However, if you are stuck with a particular data model, it may not do quite what you want. Hibernate only uses a "type" field in the db, when there is 1 table, but many subclasses from one table. This results in many nullable fields in the DB, which to me is undersirable. I prefer common fields in common table, extended fields for each subclass in "subclass" tables.

As far as user status, no problem, hibernate can grab that "lookup" from the other table, using <many to one> type of relation from your user to your UserType java class/table.

--James