[code="java"]
@Override
public void batchInsert(List list, Class<? extends SqlMapper> mapper) {
sessionTemplate = new SqlSessionTemplate(sqlSessionFactory, ExecutorType.BATCH);
//SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH,false);
for(T vo : list){
sessionTemplate.getMapper(mapper).insert(vo);
}
//session.commit();
}
[/code]
service层的代码
[code="java"]
//删除角色菜单权限
roleMenuDao.delete(list.get(0).getRoleId());
//删除角色操作权限
rolePermissionsDao.deleteByRoleId(map);
//添加角色菜单权限
roleMenuServ.batchCreate(list, RoleMenuMapper.class);
[/code]
mybatis3 批量操作是报 Cannot change the ExecutorType when there is an existing transaction 异常
如果给roleMenuServ.batchCreate方法做为一个新的事物处理
[code="java"]
PROPAGATION_REQUIRES_NEW,-Exception
[/code]
报Lock wait timeout exceeded; try restarting transaction异常
请问怎么解决?