I have a Customer table with a relationship to an EyeColorCode table. The eyeColorCode is maintained on inserts and updates through Sql Server triggers. Both triggers do basically the same check.
Inserts behave as expected but updates aren't working.
However, if I remove the tU_Customer, the update executes successfully? This is, unfortunately, not an option.
I was wondering if there is a setting that I need to flip in order for this to complete successfully?
The error states:
org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[ ... Update failed. Expected one affected row: rowsAffected=0, id=tableid
Looks to be the fault of the trigger. Had some wild variation of sql. Sorry for the claim.