From f17a48a0e3d7531b240a89755e7b7e7e2248ccb2 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期三, 11 十月 2023 15:15:54 +0800 Subject: [PATCH] fix(quartz): 1.增加超时重试机制2.数据条数不统一时删除拉取到的数据 --- src/main/java/com/integrated/zyyt/service/ZyytService.java | 11 +++-------- 1 files changed, 3 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/integrated/zyyt/service/ZyytService.java b/src/main/java/com/integrated/zyyt/service/ZyytService.java index a6286f0..0cd5983 100644 --- a/src/main/java/com/integrated/zyyt/service/ZyytService.java +++ b/src/main/java/com/integrated/zyyt/service/ZyytService.java @@ -263,7 +263,7 @@ continue; } List<YyztTShkdrb> yyztTShkdrbs = stationInfoList.subList(fromIndex, toIndex); - try { + List<Object[]> insertShkdrbList = new ArrayList<>(); yyztTShkdrbs.forEach(item -> { insertShkdrbList.add(new Object[]{ @@ -317,17 +317,11 @@ batchNo}); }); jdbcTemplate.batchUpdate(batchInsertSql, insertShkdrbList); - } catch (Exception e) { - log.error(e.getMessage()); - //鎵嬪伐鍥炴粴寮傚父 -// TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); - stationInfoService.updateRecord(recordId, 1, 0L, e.getMessage()); - return; - } } } } catch (Exception e) { log.error(e.getMessage()); + jdbcTemplate.update(delSql); stationInfoService.updateRecord(recordId, 1, 0L, e.getMessage()); return; } @@ -430,6 +424,7 @@ log.error(e.getMessage()); //鎵嬪伐鍥炴粴寮傚父 // TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint); + jdbcTemplate.update(delSql); stationInfoService.updateRecord(recordId, 1, 0L, e.getMessage()); return; } -- Gitblit v1.9.1