Hibernate version:2.17c

Name and version of the database you are using:My 4.0SQL

Hello,

I have two tables:

Table Users
-------------------
int UserID (PK)
int UserTypeID Not Null (FK)
Users primaryUser;
USers orginalUser;


Table UserTypes
-------------------
int UserTypeID (PK)


Subclass of Users:(discriminator UserTypeID)
Doctors when UserTypeID = 1
Patients when UserTypeID = 2


Mapping file:



Class Files:



My truble is:
Because of userTypeID is a discriminator (#1) used for sub class, then in <many-to-one> (#2)of "userTypes", I have to set "insert" and "update" to be false, but the "UserTypeID" must be non-null, so how can I insert a Users record in database?

every time when I new Users() and try to make it persistence, I got exception
--Duplicate key or integrity constraint violation message from server: "Cannot add or update a child row: a foreign key constraint fails"

Thanks a lot for any help.

I'm having trouble understanding what you're trying to achieve here, but it looks very strange.

But, it would seem that the problem you're encountering is that your Users class isn't abstract, and you only have a discriminator defined for the subclasses... so when you instantiate a Users object and try to save it, Hibernate won't put anything in the UserTypeID column because it's not a Doctor or Patient.

Thanks for reply.

Let be clear my trouble abit clear.

The table Users has a froeign key UserTypeID from table UserTypes,


The mapping class Users has two sub class (Doctors and Patients), in order to handle this inheritance using table-per-class-hierarchy strategy , I have to set a discriminator (which is UserTypesID). Because the discriminator is also the foreign key from another table, in mapping file I need to set <many-to-one ... insert="false" update = "false">, which means I can not insert or update this column.

But when I initialiate a new Users object, we will also need to set the "UserTypeID", then conflicet happen.

I am not sure whether my understanding is correct, but now I can not saveOrUpdate(Users) into persistence.

Hope i make it clearer than before.

Thanks.

Unfortunately that hasn't made it much clearer to me. It still seems you are trying to instantiate a Users object. Can you post the actual code?