Update fail. Expected one affected row. What does it mean?

[klng]

What does the following exception mean?

org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=SS2APP//2063, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.ejb.EJBException: Update failed. Expected one affected row: rowsAffected=0id=79553824)


Thanks much!
Winston

[aloubyansky]

It's should be either concurrent update using optimistic locking or the row was removed.

[mkierdel]

In practical way.
This exception can be caused by the triggers on the table, which you want to update.
I had that problem on: jboss/tomcat + mssqlServer2K.
It helped when I put 'SET NOCOUNT ON' clause in trigger.

CREATE TRIGGER [ON_INSERT_SOMETHING] ON dbo.kurs
FOR INSERT, UPDATE
AS
SET NOCOUNT ON
....