hibernate异常 org.hibernate.StaleObjectStateException: Row was updated or deleted

hibernate异常:Row was updated or deleted by another transaction

 

 

异常：获取持久化对象时无异常，更新时出现异常

ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect)

 

 

异常分析及注意事项：

主键对应数据库表中的ID字段,其值由oracle sequence生成， 而timestamp属性,对应的是数据库的TIMESTAMP字段,并且这个属性在mapping中定义为<version>属性， 这样,就会出现两点要注意的地方 

a.数据库中的这个timestamp的字段一定要有值,并且是日期值,否则当hibernate更新这个字段没有值的那条记录时, 会出现如下错误 
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.mytophome.admin.domain.MthCity#1] 

b. 在更新MthCity中的值到数据库中,也就是更新一条记录时,一定不能调用方法人工设置timestamp属性的值,也就是下面的语句不能出现 mthCity.setTimeStamp(new Date()); 否则也会引起hibernate的出错.