Hibernate数据delete时容易忽略的问题

[size=medium]在主线程通过hibernate的find查询到数据后，把list里数据分别加入到新的list中，然后给子线程处理，子线程在执行getHibernateTemplate().delete(o)的时候，就可能会出现org.hibernate.StaleStateException。

我觉得这个异常出现的原因和内存回收有关系，在内存回收的时候。在session关闭的时候，这些数据会变成游离态，如果JAVA虚拟机没有进行垃圾回收的话，在执行delete操作时是没问题的。如果内存不够，或者有频繁的其他操作影响垃圾回收了，那在执行delete操作时就会出现这个问题。

另外，如果直接通过new一个object，生成主键之类的数据，直接delete数据，基本上也会出现这个问题。

解决的方法可以是：在每次的delete之前，先根据主键进行查询操作，如果不为null，再进行delete操作。

另外，直接通过sql进行delete操作应该也可以。update,save等操作应该也是同一个问题。


另外欢迎大家提其他的解决方案。 [/size]

Hibernate: delete from PA_THIRDLOG where streamNumber=?           
Hibernate: delete from PA_THIRDLOG where streamNumber=?          
ERROR  - Could not synchronize database state with session                
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1         
    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)       
    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)    
    at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)                 
    at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2525)     
    at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2702)    
    at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:77)        
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)             
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)       
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)       
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)       
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)                 
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)                               
    at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)          
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:420)           
    at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)       
    at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:846)          
    at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:842)  

ERROR  - Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: 

Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1      
org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 

0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; 

expected: 1
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:672)    
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)       
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)          
    at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)      
    at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:846)           
    at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:842)