Hello, good day. Could you please help me.
I have a table. And 3 fields in it.
id,
name,
surname
name and surname are Composite key.
Application can add, delete, update records in this table.
I added 2 fields in this table - timeCreated, timeDeleted. And when I'll to delete, I need just set timeDeleted for this record, but not to delete it !
But I have a problem - ConstraintViolationException. Because when I set timeDeleted I can not to set the same record in this table.
For example:
I added a new record

then I'll delete it. Result:

Then, I want to add the same name and surname. But I can not, because composite key by name and surname will throw to me ConstraintViolationException.

How can I resolve this problem ?

Hi,
as I understood you are trying to inserting a new record for the same name and surname,
thats why its giving error.
you can update record (null value with deletion time)

asitjaiswal, thank you for answer.
I know reason of error. But I need to insert new record with the same name and surname. And first field should me mark as deleted.
How can I come over composite key for records, which mark as deleted ?