org.hibernate.StaleStateException 解决方案

异常信息及来源分析

在使用hibernate语句和sql语句执行删除数据时，有时会出现以下异常信息：

[ERROR]: Exception executing batch:

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

[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

此异常信息一般出现在级联删除程序代码中，出现此问题的原因是使用hibernate语句执行删除和sql语句删除状态不一致导致。hibernate在删除数据库中的数据时会率先删除hibernate中的持久化数据（缓存），然后删除数据库中的数据；而执行普通sql语句可以直接删除数据库中的数据。所以要想二者的状态同步，最好统一使用hibernate HQLl或者sql DML。

比如以下代码就会出现上述问题：

       private void delBogInfoByOrderId(String orderId){
		try {
			String hql = SQL_DELETE + SQL_FROM + BaseOrderGoods.REF + SQL_WHERE + "bogOid=?";
			this.baseDao.executeUpdate(hql, new Object[]{orderId});
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	private void delLolInfoByOrderId(String orderId){
		try {
			String hql = SQL_DELETE + SQL_FROM + LogOrderLog.REF + SQL_WHERE + "lolOrder=?";
			this.baseDao.executeUpdate(hql, new Object[]{orderId});
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void delOrdersByIds(String ids){
		String oids[] = ids.split(",");
		List list = new ArrayList();
		
		try {
			for (String id : oids) {
				Object obj = this.baseDao.get(BaseOrderInfo.class, id);
				if(obj != null){
					BaseOrderInfo order = (BaseOrderInfo)obj;
					delLolInfoByOrderId(id);
					delBogInfoByOrderId(id);
					list.add(order);
				}
			}
			
			this.baseDao.deleteAll(list);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

在删除数据时同时使用了不同的方式进行删除！

修改方案

	private void delBogInfoByOrderId(String orderId){
		try {
			String hql = SQL_DELETE + SQL_FROM + BaseOrderGoods.REF + SQL_WHERE + "bogOid=?";
			this.baseDao.executeUpdate(hql, new Object[]{orderId});
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	private void delLolInfoByOrderId(String orderId){
		try {
			String hql = SQL_DELETE + SQL_FROM + LogOrderLog.REF + SQL_WHERE + "lolOrder=?";
			this.baseDao.executeUpdate(hql, new Object[]{orderId});
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	private void delBoiInfoByOrderId(String orderId){
		try {
			String hql = SQL_DELETE + SQL_FROM + BaseOrderInfo.REF + SQL_WHERE + "boiId=?";
			this.baseDao.executeUpdate(hql, new Object[]{orderId});
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void delOrdersByIds(String ids){
		String oids[] = ids.split(",");
		
		try {
			for (String id : oids) {
				Object obj = this.baseDao.get(BaseOrderInfo.class, id);
				if(obj != null){
					delLolInfoByOrderId(id);
					delBogInfoByOrderId(id);
					delBoiInfoByOrderId(id);
				}
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

统一使用sql语句执行级联删除，以上问题得以解决！