1 Reply Latest reply on May 26, 2006 7:49 PM by g king

    CMP not playing nicely with tU_table on MS SQL Server

    g king Newbie

      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