每次插入数据量参考学习:https://www.imooc.com/article/291781
事务@Transactional REQUIRES_NEW的详解参考学习:https://blog.csdn.net/cy_7030/article/details/91802949
spring 事务REQUIRES_NEW不好使参考学习:http://blog.csdn.net/arsenal04/article/details/41007545
我的代码记录:
//DeviceService类中的父方法
@Transactional(propagation = Propagation.REQUIRED,rollbackFor={Exception.class, RuntimeException.class,Error.class})
public void devicedata() {
LOGGER.info("定时任务读取ftp上设备信息文件");
}
//另一个java类(子方法类)
@Transactional(propagation = Propagation.REQUIRES_NEW,rollbackFor={Exception.class, RuntimeException.class,Error.class})
public void taskOneFileDatas(List<String> list)
throws Exception {
LOGGER.info("定时任务读取ftp上设备信息文件插入数据操作");
}
插入数据库异常:com.mysql.jdbc.PacketTooBigException: Packet for query is too large(原因是MySQL的max_allowed_packet设置过小引起的,默认是4M,后来改为20M或者更大)
查看目前配置(mysql命令)
show VARIABLES like '%max_allowed_packet%';
设置max_allowed_packet配置20M(mysql命令)
set global max_allowed_packet = 2*1024*1024*10
异常解决掉了。。。。。