org.hibernate.exception.ConstraintViolationException thorws when I try to update a parent CDT with an ID = 0

shupingz over 6 years ago

Hi,

I am encountered a weird situation: I got a CDT1 with muti CDT2 as a child object, I can use writeToDataStoreEntity smart service to insert/update CDT1 successfully unless update an existing row with an ID = 0, I've test ID = 1, 2, 3 even -1, all updated successfully, I also can update CDT2 with an ID = 0, but got ConstraintViolationException when update CDT1 with ID = 0, anyone got any idea?

Discussion posts and replies are publicly visible

0 shupingz over 6 years ago

Urgent, waiting online.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jose Cavazos over 6 years ago in reply to shupingz

Do you have a value for the id 0 in your parent CDT? My guess is that it can't find your ID = 0 That's why it's throwing you an error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shupingz over 6 years ago in reply to Jose Cavazos

I did have a parent CDT with id 0, actually, it should not throw this error even if there is no id 0, it should do an "insert" when no existing id found, and do an "update" otherwise. I tried to delete existing value and rerun the smart service, always success the first time(insert), and fails after that(update) :(
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel