Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:[/b] 2.1

[b]Full stack trace of any exception that occurs:[/b]
Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) when committing a delete

[b]Name and version of the database you are using:[/b] MSSQL 2000,
I-Net Opta driver

[b]The generated SQL (show_sql=true):[/b]
2005-05-09 16:23:27,562 [main] DEBUG net.sf.hibernate.SQL - delete from RP_Voc_Rehab where voc_rehab_id=? and modified_ts=?


We do not have this issue with other databases (DB2 UDB7.2) but with MSSQL and the I-Net opta driver, the delete on a cascade doesn't return "1" for one row deleted (instead it returns the result from the last delete query caused by cascade that was issued).

This causes hibernate to recognize a failure (because exactly one row should have been deleted.) This appears to be a driver failure - can anyone confirm that?

Thanks,
Jenica Humphreys
MountainView Software