异常信息及来源分析
在使用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语句执行级联删除,以上问题得以解决!