hibernate单做删除和新增都没问题，一但一起操作就报Lock wait timeout exceeded;try restarting transact

qq_29591235 2017-12-05 05:26:39

realSave方法中有
if(EmptyUtils.isEmpty(putIn.getCode())){
if(putIn.getUpdate() == 0){
putIn.setUpdate(2);//执行一次
//先删除后插入
deleteEntity(session,putIn.getTableName(),putIn.getFkId(),null);
}
}
和
session.beginTransaction();
session.save(obj);
session.getTransaction().commit();
deleteEntity方法代码为
private void deleteEntity(Session session,String tableName,String forkIdColumn,Long forkId) {
session.beginTransaction();

realDeleteEntity(tableName,forkIdColumn,forkId);
session.getTransaction().commit();

}
realDeleteEntity方法代码为
private void realDeleteEntity(String tableName,String forkIdColumn,Long forkId) {
String sql = "";
if(null != forkId && !"".equals(forkId)){
sql = "delete from " + tableName + " where " + forkIdColumn + "=" + forkId;
}else {
sql = "delete from " + tableName;
}
try {
this.createSQLQuery(sql).executeUpdate();
} catch (HibernateException e) {
logger.error(ExceptionUtils.getStackTrace(e));

}
}

现在的问题是当只运行新增或者删除时都好用，当先删除后新增时就会报错，
Hibernate: delete from B_LANGUAGE
Hibernate: select NEXTVAL('SEQ_SYSTEM')
Hibernate: insert into b_language (create_author, create_date, is_display, lang_cnml, lang_code, lang_enname, lang_extendname, lang_name, lang_number, last_modifyauthor, last_modifydate, order_no, remark, status, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2017-12-05 16:57:58,576 [http-bio-8080-exec-8] WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1205, SQLState: 41000
2017-12-05 16:57:58,576 [http-bio-8080-exec-8] ERROR [org.hibernate.util.JDBCExceptionReporter] - Lock wait timeout exceeded; try restarting transaction
2017-12-05 16:57:58,583 [http-bio-8080-exec-8] ERROR [org.hibernate.event.def.AbstractFlushingEventListener] - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
..................................
麻烦大神给点建议谢谢了

...全文